Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!64.233.178.134.MISMATCH!postnews.google.com!o40g2000prh.googlegroups.com!not-for-mail
From: EscVector <Junk@webthere.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: What is exact cause of "No message file for product=RDBMS"
Date: 25 Apr 2007 14:02:25 -0700
Organization: http://groups.google.com
Lines: 32
Message-ID: <1177534945.613354.198180@o40g2000prh.googlegroups.com>
References: <RkoXh.17874$VF5.2243@edtnps82>
NNTP-Posting-Host: 72.165.244.50
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1177534956 8935 127.0.0.1 (25 Apr 2007 21:02:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 25 Apr 2007 21:02:36 +0000 (UTC)
In-Reply-To: <RkoXh.17874$VF5.2243@edtnps82>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: o40g2000prh.googlegroups.com; posting-host=72.165.244.50;
   posting-account=YZW96w0AAABjQaJtmc4mPml4qWWrMr8V
Xref: news.f.de.plusline.net comp.databases.oracle.server:196904

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