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

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

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