Re: ORA-12545 Error

Hi Sean,

Do you have more than one oracle product installed on the same machine? If this is the case then you probably have multiple tnsnames.ora files. Check the oracle home to see if you have a directory called network, and/or a directory called net80. You probably have both. Both these directories contain a submenu called admin, which contain a tnsnames.ora file. If so, then keep these two in sync... That should work. If you want to keep only one copy you could make a new entry in the windows registry under the HKEY_LOCAL_MACHINE/software/oracle, called TNS_ADMIN. In there you put the path to one of the tnsnames.ora files. If you work on a unix/linux machine create an environmont variable called TNS_ADMIN, which contains the path. Personally I don't ever use easy config anymore. It's much easier and quicker to modify it by hand. Easy config also doesn't offer the possibility to connect to the database on a different port than 1521 (default). So if you install the database and configure the listener to listen to another port e.g. 1525, you can't use easy config anyway...

HTH, Bastiaan Schaap
Oracle web development
Desyde BV - Baarn
http://www.desyde.nl/
tel. +31 35 5411711

Sean <dolans_at_my-deja.com> wrote in message news:8kapvg$cur$1_at_nnrp1.deja.com...
> Please help. Oracle 8i. Trying to connect with just little ol' SQL
> Plus on another machine. I have created a connect thing with SQL Easy
> Config of FOO and the proper IP Address and the Database instance of
> ORACLE.MYCOMPANY.COM
>
> I can successfully TNSPING it from the client to the server, but if I
> try to go into SQL Plus, I get a ORA-12545 error. Why?
>
> If I create AN EXACT match on the server itself and pull up SQL Plus, I
> can get it to connect with FOO alias.
>
> I did a LSNRCTL STAT and see that it is up and running. Any help would
> be appreciated.
>
> Thanks,
> Sean
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 10 2000 - 00:00:00 CDT