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@xxxxxxxxx> wrote:

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." >




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

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

Other related posts: