Home » RDBMS Server » Server Administration » Calling exp from a shell script throws ora-01034
Calling exp from a shell script throws ora-01034 [message #661374] Thu, 16 March 2017 05:51 Go to next message
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--

Re: Calling exp from a shell script throws ora-01034 [message #661376 is a reply to message #661374] Thu, 16 March 2017 06:38 Go to previous messageGo to next message
John Watson
Messages: 7220
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.

Re: Calling exp from a shell script throws ora-01034 [message #661377 is a reply to message #661374] Thu, 16 March 2017 07:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Calling exp from a shell script throws ora-01034 [message #661381 is a reply to message #661377] Thu, 16 March 2017 08:08 Go to previous message
cookiemonster
Messages: 12992
Registered: September 2008
Location: Rainy Manchester
Senior Member
Or your ORACLE_SID environment variable isn't set properly.
Previous Topic: Oracle12 client
Next Topic: DBA Service Contract
Goto Forum:
  


Current Time: Sun Jan 21 03:49:40 CST 2018

Total time taken to generate the page: 0.02459 seconds