Re: Connection problems

From: Van Messner <messner1_at_NOSPAMbestweb.net>
Date: Sat, 6 Nov 2004 16:41:37 -0500
Message-ID: <10oqhgcjcrtoc75@corp.supernews.com>

Two very quick things to check...

Is your version of OEM using the same tnsnames.ora as your version of SQL*Plus or do you have multiple tnsnames files on your computer? If multiple, do they all contain the connection information you need?

Is your net service name qualified? OEM might be able to connect if the net service name is mydb where SQL*Plus connecting from the same computer could require mdyb.mydomain.com.

Past that you'd have to supply a lot more information with your question.

"Cynthia" <cynthia.karanicolas_at_replicon.com> wrote in message news:1310f6b3.0411051343.86ccd26_at_posting.google.com...
> Hello,
>
> I would like to know if someone can help me out with a little problem
> I have.
> I can connect to my database through the Oracle Enterprise Manager but
> I can't connect through the SQL*Plus. Any ideas on what may be going
> on? what am I doing wrong?... my tnsnames.ora is correct, I checked it
> already and it looks fine.
>
> Can somebody help me?
>
> Thanks
> Cynthia
Received on Sat Nov 06 2004 - 15:41:37 CST