Re: problem starting sqlpus - ??

You need to start the instance to which you are trying to connect. This is going to require a privileged account connection in either svrmgrl or sqlplus, for example:

CONNECT sys/change_on_install AS SYSDBA
STARTUP PFILE=<full path to your init.ora file>

You ought to be using SQL*Plus instead of SVRMGRL anyway - server manager is disappearing in the next release (9i) and has been replaced with added features in SQL*Plus in 8i.

If you still have issues with this, post again and say which OS you're using.

JR

On Sun, 03 Feb 2002 14:27:00 GMT, Cecil D'Souza <ceecil_at_hotmail.com> wrote:

>Hi,
>
>I have finally managed to install Oracle 8i 8.1.6 successfully - no
>errors and everything worked well. I created the database and although
>it took years, it was finally created.
>
>Then the documentation asked me to install the patchset for 8.1.6 rel 2.
>
>(patchset 8.1.6.2.1)
>
>I downloaded the patchset and installed it correctly. It even said
>successful.
>Then I rebooted the machine for the install to take effect and now it
>does not work.
>
># Svrmgl and that comes up with the SVRMGL>
># lsnrctl and that works properly as well..
>
># sqlplus - asks for username and password and then says oracle not
>available ORA-01034
>
>Would you know why this has happened?.
>Probably, Should I execute catalog.sql and catproc.sql?.
>I still would not be able to do that unless SQLPLUS comes up!!.
>
>Your help is appreciated.
>
>
>Thanks
>
>Cecil
>
Received on Sun Feb 03 2002 - 10:24:45 CST