- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: exp script
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2008 11:25 PM
тАО04-16-2008 11:25 PM
exp script
#
# 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2008 11:40 PM
тАО04-16-2008 11:40 PM
Re: exp script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2008 11:42 PM
тАО04-16-2008 11:42 PM
Re: exp script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2008 11:43 PM
тАО04-16-2008 11:43 PM
Re: exp script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2008 11:43 PM
тАО04-16-2008 11:43 PM
Re: exp script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2008 11:47 PM
тАО04-16-2008 11:47 PM
Re: exp script
add this in your script
ORACLE_HOME=/u01/app/oracle/OraHome_1; export ORACLE_HOME
ORACLE_SID=abcd; export ORACLE_SID
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-17-2008 12:27 AM
тАО04-17-2008 12:27 AM
Re: exp script
thanks for u inputs
putting ORACLE_SID entry & - switch
the script works
thanks
ahamad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-17-2008 12:38 AM
тАО04-17-2008 12:38 AM
Re: exp script
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-17-2008 12:43 AM
тАО04-17-2008 12:43 AM
Re: exp script
Good to hear from you.
Ygeeraj
I just skip but thnx for the su - oracle pointing.
BTW, where's the bunny Ahamad?? :)