Please post back here the contents of SQLNET.ORA file for both the 9 & 10
tree
On 9/13/06, Stephen Andert <andert@xxxxxxxxx > 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@xxxxxxxxxxxxxxx > 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > *On Behalf Of *Stephen Andert
> > *Sent:* Wednesday, September 13, 2006 5:36 PM
> > *To:* oracle-l@xxxxxxxxxxxxx
> > *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."
>
