I'm trying to export a database content to a dump file, so I'm doing the following:
[root@serverId TEST]# ps -ef|grep pmon|grep -v grep oracle 25371 1 0 Sep29 ? 00:02:22 ora_pmon_SIDPA [root@serverId TEST]# echo $ORACLE_HOME /home/oracle/product/10.2.0 [root@serverId TEST]# echo $ORACLE_SID SIDPA [root@serverId TEST]# echo $PATH /home/oracle/product/10.2.0/bin:/home/oracle/product/10.2.0//bin::/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/cca/CCA_SRV:/root/bin [root@serverId TEST]# exp userId@//serverId:1521/SIDPA FILE=dumpuserId.dmp LOG=dumpuserId.LOG OWNER=userId Export: Release 10.2.0.3.0 - Production on Wed Oct 21 09:10:56 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Password: EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified EXP-00000: Export terminated unsuccessfully [root@serverId TEST]#
As you can see I already set the env vars $ORACLE_HOME and $ORACLE_SID as far as I understand correctly. I also set the PATH, so I think it should work but unfortunately, I does not.
Any comments about what to try will be welcomed.
Thanks in advance!