OraFAQ Forum: Unix » Unable to use ORAENV

Home » Infrastructure » Unix » Unable to use ORAENV_ASK in shell script (Oracle 9.2.0.6.0 on HP-UX B.11.23)

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

Unable to use ORAENV_ASK in shell script [message #433130]

Mon, 30 November 2009 05:23

chetanaZ
Messages: 132
Registered: October 2009
Location: UK

Senior Member

Hi,

I am trying to set ORACLE environement (SID, HOME) in a shell script but I am getting an error

I am trying to set it it shell as following (example script)

#!/usr/bin/ksh
export $ORACLE_SID=DB01
ORAENV_ASK=NO
. /usr/local/bin/oraenv
ORAENV_ASK=YES

sqlplus -s system/<pwd> << eof >/u04/scripts/logs/arch_curr.log
alter system archivelog current;
eof
exit

I am getting following error

/u04/scripts/arch_curr.sh[4]: dbhome:  not found
ORACLE_HOME = [] ? /u04/scripts/arch_curr.sh[7]: sqlplus:  not found

I have checked the /etc/oratab as well and DB01 has proper entry init alongwith ORACLE_HOME

what could be the issue?

Thanks and Regards,
Chetana

Report message to a moderator

Re: Unable to use ORAENV_ASK in shell script [message #433131 is a reply to message #433130]

Mon, 30 November 2009 05:33

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

Senior Member
Account Moderator

Does dbhome exist in /usr/local/bin?
Have you /usr/local/bin in your default path?

Regards
Michel

[Updated on: Mon, 30 November 2009 05:33]

Report message to a moderator

Re: Unable to use ORAENV_ASK in shell script [message #433135 is a reply to message #433130]

Mon, 30 November 2009 05:39

chetanaZ
Messages: 132
Registered: October 2009
Location: UK

Senior Member

Thanks Michel

Yes, dbhome exists as following

oracle@dev2:/home/oracle $ls -ltr /usr/local/bin
total 48
-rwxr-xr-x   1 oracle     sys           2417 Jun  8  2007 dbhome
-rwxr-xr-x   1 oracle     sys           2316 Jun  8  2007 coraenv
-rwxr-xr-x   1 oracle     sys           2559 Jun 13  2007 oraenv

oracle@dev2:/home/oracle $ls -ltr /usr/local/bin/dbhome
-rwxr-xr-x   1 oracle     sys           2417 Jun  8  2007 /usr/local/bin/dbhome
oracle@dev2:/home/oracle $

Regards,
Chetana

P.S. sorry I wasn't sure about which (section of ) forum I will raise this quetsion to and thanks for moving it to appropriate one

Report message to a moderator

Re: Unable to use ORAENV_ASK in shell script [message #433139 is a reply to message #433135]

Mon, 30 November 2009 05:55

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

Senior Member
Account Moderator

Is /usr/local/bin in your PATH variable?

Regards
Michel

Report message to a moderator

Re: Unable to use ORAENV_ASK in shell script [message #433153 is a reply to message #433130]

Mon, 30 November 2009 06:25

chetanaZ
Messages: 132
Registered: October 2009
Location: UK

Senior Member

Superb!!

The /usr/local/bin wasn't in the PATH variable

After adding it in shell script as following it is working fine now

export ORACLE_SID=SY2KU2
export PATH=$PATH:/usr/local/bin
ORAENV_ASK=NO
. /usr/local/bin/oraenv
ORAENV_ASK=YES

Many Thanks Michel... It was a great help!!

Regards,
Chetana

Report message to a moderator

Previous Topic:	Shell script issue while finding files
Next Topic:	Shell script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 11:26:27 CST 2025