odds are its the TNSNAMES.ORA file that SQLPLUS is using. Its using the wrong one. This is a guess, but a good one.


go to your oracle home If you have more than one Oracle home(oracle home is your oracle directory) doa search in both. Here is what you do to find out which one works.

1. Search for sqlnet.ora rename all of them to sqlnet.old so that its not used. try to connect with sqlplus. If this doesnt work do the following.

2. search for tnsnames.ora go through the tnsnames.ora one by one. Rename to tnsnames.old then connect with DBA studio. When you finally cannot connect and get errors, this will tell you that that is the correct tnsnames.ora

then rename that tnsnames back to tnsnames.ora and rename all the others to tnsnames.old

try to connect with sqlplus

3. if that doesnt work. go to environment variables, add a variable called TNS_ADMIN, set it equal to the directory with the tnsnames.ora that is working.

if those dont work post again.
>
> From: "Nelson, Paula" <Paula.[Email Address Removed] Date: 2003/04/30 Wed AM 09:15:59 EDT
> To: "'[Email Address Removed] <[Email Address Removed]
> "LazyDBA.com Discussion"
> <[Email Address Removed] Subject: RE: New DBA needs help! Errors 12154, 12560, and 12514
>
> I have a static IP. DBA Studio can start but sqlplus cannot..
>

Oracle LazyDBA home page