OraFAQ Forum: Unix » oraenv script prompts for values when ORAENV

Home » Infrastructure » Unix » oraenv script prompts for values when ORAENV_ASK set to no

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

oraenv script prompts for values when ORAENV_ASK set to no [message #629126]

Wed, 03 December 2014 10:56

11gOP
Messages: 18
Registered: November 2014

Junior Member

When I put a reference to the oraenv script in a user's profile script the user gets prompted for a SID and ORACLE_HOME every time even when I set these before calling the script and set ORAENV_ASK=NO.

Here are the lines I've added:

export ORACLE_HOME=/opt/oracle/app/oracle/product/11.2.0/dbhome_1/
export PATH=$PATH:$ORACLE_HOME/bin
export ORAENV_ASK=NO
export ORACLE_SID=DB1
. /usr/local/bin/oraenv

What am I missing here?

[Updated on: Wed, 03 December 2014 10:57]

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629128 is a reply to message #629126]

Wed, 03 December 2014 11:00

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What are the contents of /usr/local/bin/oraenv?

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629129 is a reply to message #629126]

Wed, 03 December 2014 11:03

11gOP
Messages: 18
Registered: November 2014

Junior Member

I've not modified the contents, I've attached the file here for reference.

Attachment: oraenv.txt
(Size: 4.92KB, Downloaded 3861 times)

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629130 is a reply to message #629129]

Wed, 03 December 2014 11:10

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What do the following commands return?

$ echo $SHELL
$ ps
$ whoami

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629134 is a reply to message #629126]

Wed, 03 December 2014 11:43

11gOP
Messages: 18
Registered: November 2014

Junior Member

-bash-4.2$ echo $SHELL
/usr/bin/bash
-bash-4.2$
-bash-4.2$ ps
     PID    TTY  TIME CMD
 6684872  pts/1  0:00 ps
 7667962  pts/1  0:00 -bash
-bash-4.2$
-bash-4.2$ whoami
<username here>
-bash-4.2$

I'm not running this as the oracle user and the user isn't an administrative user.

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629180 is a reply to message #629134]

Thu, 04 December 2014 03:20

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Is DB1 running on the same server? What does this show you?

$ cat /etc/oratab
$ ps -eaf | grep pmon

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629208 is a reply to message #629126]

Thu, 04 December 2014 07:48

11gOP
Messages: 18
Registered: November 2014

Junior Member

oratab is empty as I've not got around to creating any databases yet.
pmon returned this before I started the listener:

# ps -eaf | grep pmon
    root 8716496 8650802   0 13:41:10  pts/1  0:00 grep pmon
#

but nothing after.

What exactly does the oraenv script do that I can't do with less hassle with some export statements? Is it necessary to have it in the login scripts for all the users?

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629210 is a reply to message #629208]

Thu, 04 December 2014 07:56

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

oratab is empty as I've not got around to creating any databases yet.

That's why it is prompting you for info. oraenv reads /etc/oratab for details of the database specified as ORACLE_SID.
oraenv

It is not necessary to have it in user profiles and, you're right, the same could be achieved manually. But then, so could most things scripts do Wink

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629212 is a reply to message #629210]

Thu, 04 December 2014 08:11

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

More about oraenv from Oracle.

Report message to a moderator

Re: oraenv script prompts for values when ORAENV_ASK set to no [message #629213 is a reply to message #629212]

Thu, 04 December 2014 08:13

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

Senior Member
Account Moderator

... and do not use "root" for your test and to use Oracle. Use a normal account.

Report message to a moderator

Previous Topic:	setting passwords for configuration assistant accounts
Next Topic:	Send file in the email attachment using shell script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:16:09 CST 2024