topic Re: exp script in Operating System - HP-UX

exp script

sh5490 — Thu, 17 Apr 2008 06:25:51 GMT

ORACLE_HOME=/u01/app/oracle/OraHome_1
#
# oracle owner at your site.
exp_script

PATH=${PATH}:$ORACLE_HOME/bin
export ORACLE_HOME PATH
su oracle -c "exp system/redhat file='/archivelog/backup/itoslive.dmp' consistent=y owner='itoslive' statistics=none log='/archivelog/backup/itoslive.log'"
echo "connected as `id` user"
$ls -l exp_script.sh

permission
-rwxr-x--- 1 root dba 313 Apr 17 12:49 exp_script.sh

output
$./exp_script.sh

Export: Release 10.2.0.3.0 - Production on Thu Apr 17 12:52:53 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: ORACLE error 12162 encountered
ORA-12162: TNS:net service name is incorrectly specified
EXP-00000: Export terminated unsuccessfully
connected as uid=0(root) gid=3(sys) groups=0(root),1(other),2(bin),4(adm),5(daemon),6(mail),7(lp),20(users) user

this script fails
pls provide inputs

thanks

ahamad

Re: exp script

Ivan Krastev — Thu, 17 Apr 2008 06:40:42 GMT

Check your ORACLE_SID - http://www.dba-oracle.com/t_ora_12162_tns_net_service_name.htm

regards,
ivan

Re: exp script

Yogeeraj_1 — Thu, 17 Apr 2008 06:42:09 GMT

hi Ahamad,

did you try to run the EXP command as the Oracle user"

exp system/redhat file='/archivelog/backup/itoslive.dmp' consistent=y owner='itoslive' statistics=none log='/archivelog/backup/itoslive.log

any errors?

revert!

kind regards
yogeeraj

Re: exp script

Yogeeraj_1 — Thu, 17 Apr 2008 06:43:30 GMT

hi again

try also:
su - oracle -c "exp system/redhat file='/archivelog/backup/itoslive.dmp' consistent=y owner='itoslive' statistics=none log='/archivelog/backup/itoslive.log'"

NB. not just "su oracle" but "su - oracle"

revert!

kind regards
yogeeraj

Re: exp script

VK2COT — Thu, 17 Apr 2008 06:43:38 GMT

Hello,

From Oracle error codes:

ORA-12162: TNS:net service name is
incorrectly specified

Cause: The connect descriptor corresponding to
the net service name in TNSNAMES.ORA or in the
directory server (Oracle Internet Directory) is
incorrectly specified.

Action: If using local naming make sure there
are no syntax errors in the corresponding
connect descriptor in the TNSNAMES.ORA file. If
using directory naming check the information
provided through the administration used for
directory naming.

Cheers,

VK2COT

Re: exp script

Jeeshan — Thu, 17 Apr 2008 06:47:16 GMT

Hi Ahamad

add this in your script

ORACLE_HOME=/u01/app/oracle/OraHome_1; export ORACLE_HOME

ORACLE_SID=abcd; export ORACLE_SID

Re: exp script

sh5490 — Thu, 17 Apr 2008 07:27:43 GMT

hi ashan/yoograj

thanks for u inputs
putting ORACLE_SID entry & - switch

the script works

thanks

ahamad

Re: exp script

Yogeeraj_1 — Thu, 17 Apr 2008 07:38:04 GMT

hi,

Thats good news. Hope you are NOT using this script as your primary backup and that you have RMAN configured for daily backups.

all the best

kind regards
yogeerah

Re: exp script

Jeeshan — Thu, 17 Apr 2008 07:43:02 GMT

Hi ahamad

Good to hear from you.

Ygeeraj

I just skip but thnx for the su - oracle pointing.

BTW, where's the bunny Ahamad?? :)