On Apr 24, 4:15 pm, GS <G..._at_GS.com> wrote:
> GS wrote:
> > My oracle_home is set correctly.
>
> > Last think yesterday I installed 10G client on my (windows
> > xp)workstation for testing, putting it in a new oracle home etc. now
> > this morning I can't connect to the local 9i db and I'm not sure why. I
> > took the new 10G home out of the path so my sqlplus starts properly, put
> > the oracle_home back to the 9i home (it was now blank after the 10g
> > clinet install) and oracle_sid is set to local db sid as always.
> > Whenever I try to connect to the local db I am now getting error
> > messages along with the "No message file for product=RDBMS
> > facility=ORA". One of the messages is 01031 (insufficient priveleges)
> > and I have no idea why as I'm using the "connect sys/pass as sysdba"
> > like I always do to connect to the idle instance and start it up (we had
> > a power outage and all workstations rebooted)
>
> > The 10G client install did something that caused everything to go south,
> > but I'm stymied at what exactly is causing me not to be able to connect.
> > I can connect to remote db's ok, just not the local one. (For some
> > reason on this machine only the service auto starts, not the database so
> > I always log in as sysdba and issue a startup command.)
>
> follow up - good old windows reboot cured the "no message" message, but
> for some strange reason I could NOT get to the idle instance to start it
> up no matter what, so I deleted the service with oradim and recreated it
> with the -intpwd option and I was able to get back in and start it up.
>
> Still not sure what went wrong and why though..- Hide quoted text -
>
> - Show quoted text -
Did it impact the environment so the 10g client home is before the
other home in the path?
Received on Wed Apr 25 2007 - 21:29:04 CDT
