error 0131-insufficient privileges

[sthiriveed]

Hi :
I have multiple instances on a unix server.
oracle_sid's are ONE and NBS
when I invoke svrmgrl and connect internal it defaults gets connected to NBS instance. Thats fine. But I want to connect to ONE and when i say connect internal@one it asks for password and then it says insufficient privileges.. why??

[sthiriveed]

Check it out..

[pwoneill]

try changing your oracle_sid to one instead of using the @one.

if you have an error number you can check it out yourself on technet or useing oerr.

[sthiriveed]

My database sid is ONE
My connect string is ::
connect internal@one

Error 1031 is Insufficient privileges??

What can be a higher privilege than internal and I am logging in as Oracle user in the unix box..

Thanx

[pwoneill]

if your SID is already one don't use the @one or it tries to make a remote connection instead of using the os authentication. just use connect internal.

[sthiriveed]

Thank you, but I have more than one instance on the same server.. and default it goes to a nbs database, which is OK, but being unable to connect internal to the desired instance is important right.. Thx..
Ps: Please read my thread at the starting..

[pwoneill]

post a log of what you're doing if you have to.

set your ORACLE_SID to NBS
start svrmgrl
connect internal

you should connect

change your ORACLE_SID to ONE
start svrmgrl
connect internal

you should connect.

don't connect internal@one, or connect internal@nbs. just plain old connect internal

[pwoneill]

when i say change your ORACLE_SID i mean change your environment variable. i think you are missing this step.

[omegamark]

ORACLE_SID=one
export ORACLE_SID
echo $ORACLE_SID
IF it shows as one then
svrmgrl
connect internal
select * from v$database;
then ....