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

huhhhhhh

When i deleted the ORCL instance, the "OracleServiceORCL" entries were removed automatically. When i created the new TEST instance, the "OracleServiceTEST" entries were also created automatically.

I guess ORADIM73 does all of that.

cmilner wrote:

> 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:57:01 CDT