Re: Question re SQLPlus
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 2 Jul 2002 13:11:27 +0100
Message-ID: <3d21986f$0$225$ed9e5944_at_reading.news.pipex.net>
Date: Tue, 2 Jul 2002 13:11:27 +0100
Message-ID: <3d21986f$0$225$ed9e5944_at_reading.news.pipex.net>
You will need a 9i client if you want a supported environment and the minimum version that I have found works is 8.1.7. It may be worth noting that the 9i release 2 client doesn't talk very well (read at all in the case of sqlplus) to 7.3.4 databases.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Mike Coldewey" <No_Spam4m_coldewey_at_hotmail.com> wrote in message news:afqg1a$e2m_at_dispatch.concentric.net...Received on Tue Jul 02 2002 - 14:11:27 CEST
> Thanks for the info - yes, it's Oracle 8.
> Mike
> "TurkBear" <jgreco1_at_mn.rr.com> wrote in message
> news:afc1iuc0r1t5si101ksgpu1vtvq936oeem_at_4ax.com...
> >
> > Be aware that that combination is not supported ( unless it is 9i on XP
> Professional, you neglected to provide that info)..
> > [ it looks like a 8.0.x version, very old)
> > Check where the environment variable ORACLE_HOME is 'pointing'...
> > ( It should be a system environment variable so any user can read it)
> > The PATH is not used to find the message files, just the BIN ( and
maybe
> some Java-related ) directories, ORACLE_HOME
> > controls the location for other stuff - like tnsnames.ora and all the
> message files - they are referenced as subdirectories
> > of ORACLE_HOME..
> >
> >
> >
> > ..
> >
> >
> > "Mike Coldewey" <No_Spam4m_coldewey_at_hotmail.com> wrote:
> >
> > >A client has upgraded their OS to XP from 95. The Oracle Forms
> application
> > >works OK. But SQL Plus doesn't; it comes up with a message that it
"can't
> > >find SP1<lang>.msb". The file "sp1us.msb" is in the \PLUS80 directory,
> but
> > >when I add that directory to the path, there is no change in behavior.
> How
> > >can I point to this, or what config file do I need to tweak?
> > >
> > >TIW,
> > >Mike
> > >
> >
> >
> >
> > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
> ==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> =-----
> >