ORA-09352 OracleService(SID) has not started - Solved

Minh,

You are absolutly rigth. ORACLE_SID in the registry was pointing to the old instance name ORCL. ORADIM73 was almost perfect.... almost.

I guess this is why we will always have steady jobs on Oracle... ;-)

Thanks for all your replies,

Marc Mazerolle
InforMaze Technologies

Minh Tran wrote:

> Try,set ORACLE_SID=TESTshutdown database using svrmgr23startup
> databse. If this works, you will need to change default ORACLE_SID in
> registry database to TEST.I guess it is set to ORCL at the moment. or
> set ORACLE_SID=TEST everytime you want to acess database. Minh
>
> -----Original Message-----
> From: Marc Mazerolle <informaze_at_sympatico.ca>
> Newsgroups: comp.databases.oracle.server
> To: oracle list <oracle_at_telelists.com>
> Date: Thursday, 13 May 1999 11:03
> Subject: ORA-09352 OracleService(SID) has not startedHi all,
>
> I have decided to try changing my SID name and database
> blocksize by re-creating my DB from scratch. Here are the
> steps i did :
>
>
> * With ORADIM73, i deleted my initial ORCL instance
> * Changed my initORCL.ora for blocksize.
> * Rename initORCL.ora to initTEST.ora
> * With ORADIM73, i created my new instance TEST
> * Changed my listener.ora for the new sid.
> * Restarted the listener.
>
> Now, when i try to logon with either SQL*Plus or svrmgr23, i
> get the following error :
>
> ERROR: ORA-09352: OracleService(SID) has not been started
>
> But if i go into my services, they are all started. Even if
> i stop all services and restart them, i still get this
> error.
>
> God i miss my Unix box......
>
> Thanks in advance for all your great responses,
>
>
>
Received on Thu May 13 1999 - 08:22:20 CDT