Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
When I logon as Oracle Apps user, SID not set
- Thread starter Tison
- Start date
SantaMufasa
Technical User
Tison,
I'm a git puzzled. This is the "Oracle 9i Forum"; are you really using a 9i database? Oracle doesn't use/distribute "svrmgrl" with 9i, so I'm wondering how you connected using svrmgrl to your correct database.
Also, are you able to run "svrmgrl" as the "Oracle Apps user"? That is not a good thing. That means that your "Oracle Apps user" is a member of the DBA group on your server. If you are connecting, instead, as some other (DBA) user to get svrmgrl to work, then that explains a lot. If that is the case, notice that when you connect as the DBA, do an "echo $ORACLE_SID" and you'll notice that there is the correct value in that system variable. If you want the same behaviour for your "Oracle Apps user", then you must either "source" the proper variables or find the login script that runs for "Oracle Apps user" upon connection and ensure that $ORACLE_SID (and $ORACLE_HOME), are properly set.
Yes, you may also do manual "set ORACLE_SID..." and "set ORACLE_HOME..." commands to ensure you have proper variables set for your "Oracle Apps user".
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 16:42 (12Feb04) UTC (aka "GMT" and "Zulu"
, 09:42 (12Feb04) Mountain Time)
I'm a git puzzled. This is the "Oracle 9i Forum"; are you really using a 9i database? Oracle doesn't use/distribute "svrmgrl" with 9i, so I'm wondering how you connected using svrmgrl to your correct database.
Also, are you able to run "svrmgrl" as the "Oracle Apps user"? That is not a good thing. That means that your "Oracle Apps user" is a member of the DBA group on your server. If you are connecting, instead, as some other (DBA) user to get svrmgrl to work, then that explains a lot. If that is the case, notice that when you connect as the DBA, do an "echo $ORACLE_SID" and you'll notice that there is the correct value in that system variable. If you want the same behaviour for your "Oracle Apps user", then you must either "source" the proper variables or find the login script that runs for "Oracle Apps user" upon connection and ensure that $ORACLE_SID (and $ORACLE_HOME), are properly set.
Yes, you may also do manual "set ORACLE_SID..." and "set ORACLE_HOME..." commands to ensure you have proper variables set for your "Oracle Apps user".
Mufasa(aka Dave of Sandy, Utah, USA @ 16:42 (12Feb04) UTC (aka "GMT" and "Zulu"
, 09:42 (12Feb04) Mountain Time)- Status
Similar threads
- Locked
- Question
- Locked
- Question
