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

Cynthia wrote:

> 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

No version number?
No operating system?
No error message?
No listener.ora?
No sqlnet.ora?
No tnsnames.ora?
No indication of whether from client or on the server?

Sorry my crystal ball is broken and my taro cards need to be shuffled.
I'd shuffle the cards but I have a single malt in my hand.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

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@replicon.com> wrote in message
news:1310f6b3.0411051343.86ccd26@posting.google.co m...
> 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

In article <1310f6b3.0411051343.86ccd26@posting.google.com> cynthia.karanicolas@replicon.com (Cynthia) wrote:
>
>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.

How can you be certain you cannot connect through the sqlplus?

>Can somebody help me?

Natural time machines do exist.

>Thanks

Will have a look?

--
Lady Chatterly

"Hey! Didn't realise you post on Michael Jackson's discussion group,
too!!!! Wow! At lease that site has 1500 posts compaired to about 198
or so , here!" -- Judy