OraFAQ Forum: Server Administration » Calling exp from a shell script throws ora-01034

Home » RDBMS Server » Server Administration » Calling exp from a shell script throws ora-01034

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calling exp from a shell script throws ora-01034 [message #661374]

Thu, 16 March 2017 05:51

degalavenu
Messages: 1
Registered: March 2017

Junior Member

getting the error where running schedule in linux os

Subject: Cron <root@localhost> su - oracle /home/oracle/DIALYBACKUP/backup.sh
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>

standard in must be a tty

Export: Release 9.2.0.4.0 - Production on Thu Mar 16 15:15:01 2017

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

EXP-00056: ORACLE error 1034 encountered
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
EXP-00005: all allowable logon attempts failed
EXP-00000: Export terminated unsuccessfully

--v2G9j1fg030947.1489657501/localhost.localdomain--

Report message to a moderator

Re: Calling exp from a shell script throws ora-01034 [message #661376 is a reply to message #661374]

Thu, 16 March 2017 06:38

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I've split your message off from the topic you hijacked, and given it what I hope is a helpful title.

Before anyione can help you to debug your script, you dop need to show the script. Be sure to enclose it in [code] tags.

Report message to a moderator

Re: Calling exp from a shell script throws ora-01034 [message #661377 is a reply to message #661374]

Thu, 16 March 2017 07:24

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Your database instance is not started.

Report message to a moderator

Re: Calling exp from a shell script throws ora-01034 [message #661381 is a reply to message #661377]

Thu, 16 March 2017 08:08

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

Or your ORACLE_SID environment variable isn't set properly.

Report message to a moderator

Previous Topic:	Oracle12 client
Next Topic:	DBA Service Contract

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 16:27:55 CST 2024