Re: What is exact cause of "No message file for product=RDBMS"

On Apr 24, 10:18 am, GS <G..._at_GS.com> 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.)

#1 make sure the %PATH% set to 9i_HOME; 9i_HOME\bin in the first entries if you need 9i to work.
#2 Take out any %ORACLE_HOME% variables from the environmental variables [winkey-pause]
#3 As long as you didn't wipe out your 9i binaries, you should be ok.

If your 9i paths are set, ORA_DBA group is setup and sqlnet authentication is NTS, you should have no problem. Also, don't use SqlPlus GUI. Use the cmd version. Received on Wed Apr 25 2007 - 16:02:25 CDT