Re: sqldba -> svrmgrl -> ??

The only way to connect as SYS in 9i is to use CONNECT SYS/your_SYS_password AS SYSDBA e.g.

SQL> REM database is down
SQL> connect sys/change_on_install
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Warning: You are no longer connected to ORACLE. SQL> connect sys/change_on_install as sysdba Connected to an idle instance.

SQL> REM Database is up
SQL> connect sys/change_on_install
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper

SQL> connect sys/change_on_install as sysdba Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"Stan Brown" <stanb_at_panix.com> wrote in message
news:9qfcli$304$1_at_panix2.panix.com...


> In <3BCB13B5.50879015_at_richard-schneider.de> Uwe Schneider

<uwe_at_richard-schneider.de> writes:


>

> >Stan Brown wrote:

> >>

> >> Ok, first (at least for me) there was sqldba, that was suplanted by

svrmgr


> >> (line mode, and GUI).

> >>

> >> This wekend I installde 9i on Linux. I can't find any of thes. What's

the


> >> new, new DB admin tool called?

> >>

>

> >sqlplus

>

> UH, Oh. Not the answer I wanted :-(

>

> The reason that I was looking ofr it is that I can't seem to get conected

> as "sys" using sqlplus, and with sqldba, I could have done a "conect

> internal" and checkd things like that accounts password.

>

> See my other post for the error number I'm fetting.

>

> Any idea how to figure out why this is not working?

>

> --

> "They that would give up essential liberty for temporary safety deserve

> neither liberty nor safety."

> -- Benjamin Franklin