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
]
ueblo.edu cc:
Sent by: Subject: Permissions error
[EMAIL PROTECTED
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: Permissions error
Hi All
I get this error when I try to log into sqlplus from my DEC ALPHA machine through a telnet session.
Enter user-name: testid
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07320: smsget: shmat error when trying to attach sga.
DEC OSF/1
-From: Bartolo, David
[mailto:[EMAIL PROTECTED] Sent: Tuesday,
September 02, 2003 5:19 PMTo: Multiple recipients of list
ORACLE-LSubject: Permissions error
Hi All
I get this error when I try to log into sqlplus
from my DEC ALPHA machine through a telnet session.
Enter user