Re: Use SQL*Plus 10g to connect to 9i databases

10g sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) 9i sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) Thanks

On 9/13/06, sol beach <sol.beach_at_gmail.com> wrote:
>
> Please post back here the contents of SQLNET.ORA file for both the 9 & 10
> tree
>
>
> On 9/13/06, Stephen Andert <andert_at_gmail.com > wrote:
> >
> > Mark,
> >
> > If I use SQL*Plus for Windows version 9, it works. I copied the
> > tnsnamed.ora from the Ora9 HOME to the Ora10 HOME, so the connect info
> > should be the same.
> >
> > DB and listener are up.
> >
> > Thanks for any thoughts.
> >
> > Stephen
> >
> > On 9/13/06, Bobak, Mark <Mark.Bobak_at_il.proquest.com > wrote:
> > >
> > > Stephen,
> > >
> > >
> > > The error means that you've connected to a listener at the host/port
> > > specified in your connect string, but the listener you've connected to
> > > doesn't recognize the value of SERVICE_NAME specified in the connect
> > > string.
> > > On the database server, where the listener is running, if you do a
> > > 'lsnrctl services', is the service you're trying to connect to listed
> > > there? Also on the database server, what if you connect to the
> > > database with "/ as sysdba", and do 'alter system register;"? Then try the
> > > lsnrctl command again, is the service listed? Did that fix the
> > > problem? If not, are there multiple listeners on that database server?
> > > Maybe you're connecting to the wrong one, and it doesn't support that
> > > service?
> > >
> > >
> > > Hope that helps,
> > >
> > > -Mark
> > >
> > >
> > > *--*
> > > *Mark J. Bobak*
> > > *Senior Oracle Architect*
> > > *ProQuest Information & Learning*
> > >
> > > "A human being should be able to change a diaper, plan an invasion,
> > > butcher a hog, conn a ship, design a building, write a sonnet, balance
> > > accounts, build a wall, set a bone, comfort the dying, take orders, give
> > > orders, cooperate, act alone, solve equations, analyze a new problem, pitch
> > > manure, program a computer, cook a tasty meal, fight efficiently, die
> > > gallantly. Specialization is for insects." --Robert A. Heinlein
> > >
> > >
> > >
> > > ------------------------------
> > > *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> > > *On Behalf Of *Stephen Andert
> > > *Sent:* Wednesday, September 13, 2006 5:36 PM
> > > *To:* oracle-l_at_freelists.org
> > > *Subject:* Use SQL*Plus 10g to connect to 9i databases
> > >
> > >
> > > SQL*Plus 10.2.0.1 is installed on my laptop and I want to use it to
> > > connect to as many databases as I can. (mainly 9i variants) I have updated
> > > the tnsnames.ora in the 10g home to contain all the entries, and when
> > > I use the command-line tnsping, it resolves the names, but when I use 10G
> > > SQL*Plus for Windows, it tells me
> > >
> > >
> > > ERROR:
> > > ORA-12514: TNS:listener does not currently know of service requested
> > > in connect
> > > descriptor
> > >
> > > SP2-0640: Not connected
> > > What am I missing?
> > >
> > > Bonus points if you can tell me how to connect 10g EM Database Control
> > > to other databases (i.e. especially 9i)
> > > TIA
> > > --
> > > Stephen Andert
> > > http://spaces.msn.com/andert-news/
> > >
> > > Aesop - "After all is said and done, more is said than done."
> > >
> >
> >
> >
> > --
> > Stephen Andert
> > http://spaces.msn.com/andert-news/
> >
> > Aesop - "After all is said and done, more is said than done."
> >
>
>

-- 
Stephen Andert
http://spaces.msn.com/andert-news/

Aesop - "After all is said and done, more is said than done."

--
http://www.freelists.org/webpage/oracle-l