server mgr/ internal to be discontiued

[nk]

hi,

I understand that server mgr and internal user would be discontinued by oracle, soon. I know that one would be expected to use sqlplus and sysdba user, instead. Right?

How would this work? say to startup an instance or to log-on to an idle instance? Can you explain in greater detail ?

thank you,
nk

[jmodic]

Yes, it is no longer supported (meaning svrmgrl it is no longer available/alloved) starting with first release of 9i. Anything you could do with svrmgrl can allready be done using SQL*Plus from 8i onward.

Instead of using "meta account" INTERNAL you should use (allready now with 8i) nomal account that have been granted SYSOPER/SYSDBA privilege. Check the documentation for details.

[santoshym]

Hi,

True it is allready a feature available with Oracle 8i and server manager wont be available with 9i.To invoke or start an Instance from sqlplus you have to use the following commands

sqlplus /nolog

connect internal

startup

Hope this helped

Regards

[nk]

thank you,
but I guess even internal (user) would not be available.

so, if I was one of the dba gp users and the database had been set up for OS authentication; then to have internal privileges I would log-in as
SQL> connect / as sysdba

Agree or disagree.

I am confused>> is "internal" a user or a privilege?
I queried dba_users & I don't find user - internal. Can you explain *%? Why do we internal in the first place ?

nk

[pando]

internal is a user equivalent to SYS with SYSDBA privileges

[santoshym]

Hi

True If you connect as Internal it is infact sys user.If you connect as internal and if there is no database it will surely connect you to an Idle Instance.

Regards