The different account wil lnot have it's Oracle environment set up properly.
Check out the .profile on the account that works and the one that does not.
One will set up an Oracle_home and Oracle_sid variable, the other will not.
If it is not in the .profile then look at any other script that is
John,
If the OS is Dec Alpha OpenVMS.
In the user environment execute the $ORACLE_HOME[.util]orauser.com to
properly set the Oracle logicals for the user. A SHOW LOGICAL will
display what you have set now.
Ron
[EMAIL PROTECTED] 09/03/03 04:34AM
The different account wil lnot have it's Oracle
Are you sure you have the ORACLE_SID set ... or it may be set to something
different. Make sure it is set to the right db you are trying to connect.
Murali.
Well spotted Ron. I had not realised it was a VMS box
Either way the principle is correct - set up the environment first
John
-Original Message-
Sent: 03 September 2003 13:25
To: Multiple recipients of list ORACLE-L
John,
If the OS is Dec Alpha OpenVMS.
In the user environment
Title: Message
Was
'root.sh' runsuccessfully? This should set the SUID/GID (set-UID and GID)
on the 'oracle' executable...
$ ls
-l $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 oracle dba 33734776 Jul 9 13:19
/u01/c4prdb/8.1.7/bin/oracle
If
this is what you see (i.e. rwxr-x---x), then login as