exp script

[sh5490]

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

[Ivan Krastev]

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

regards,
ivan

[Yogeeraj_1]

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

[Yogeeraj_1]

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

[VK2COT]

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

[Jeeshan]

Hi Ahamad

add this in your script

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

ORACLE_SID=abcd; export ORACLE_SID

[sh5490]

hi ashan/yoograj

thanks for u inputs
putting ORACLE_SID entry & - switch

the script works

thanks

ahamad

[Yogeeraj_1]

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

[Jeeshan]

Hi ahamad

Good to hear from you.

Ygeeraj

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

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