Re: ORA-09352 OracleService(SID) has not started

From: cmilner <cmilner_at_connect.com.au>
Date: Thu, 13 May 1999 10:45:39 +1000
Message-ID: <373A20B3.9CEB14DD@connect.com.au>

Just a quick thought...

Do you need to recreate a new service for the new service????

Marc Mazerolle wrote:
>
> Hi 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 Wed May 12 1999 - 19:45:39 CDT