Re: another ORA-12154 :(

Marc,

How many oracle homes you have, if you have more than one home then it is possible that you might be hitting some other home's TNS files.

Now if you have only one home plase make sure that you have only one tnsnames.ora file on the system.

Another thing do not use wordpade or MS-word for editing the files. becasue they can put some hidden characters in the file, which oracle does not like.
So try edit file in notepad.

hope this helps!!!!

Regards

Faheem

mavi <mavi.12z3lg_at_mail.webservertalk.com> wrote in message news:<mavi.12z3lg_at_mail.webservertalk.com>...
> Hello to everyone,
>
> I've the old ORA-12154 Problem. I've read through all the articles
> regarding that problem and tried the recommended solutions, but none
> worked.
>
> I'm running Oracle 9.2.0.1.0 on a win2003-Server.
>
> srv-name: srvlei05
> sid stwl
>
> Here are my sqlnet.ora, tnsnames.ora and listener.ora
>
> # SQLNET.ORA Network Configuration File:
> D:\oracle\oraswl\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.PREFERRED_SERVERS =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
> )
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> #NAME.DEFAULT_ZONE = world
> #
> #NAMES.DEFAULT_DOMAIN = world
>
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>
> ***********************************************
>
> # TNSNAMES.ORA Network Configuration File:
> D:\oracle\oraswl\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> STWL_SRVLEI05 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = stwl)
> (SERVER = DEDICATED)
> )
> )
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = MODOSE)
> (PRESENTATION = http://HRService)
> )
> )
>
> ####################################
> # Date..........: Mon Mar 10 10:33:18 CET 2003
> ####################################
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> ************************************************
>
> # LISTENER.ORA Network Configuration File:
> D:\oracle\oraswl\NETWORK\ADMIN\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = stwl)
> (ORACLE_HOME = D:\oracle\oraswl\network\admin)
> (SID_NAME = stwl)
> )
> )
>
>
>
> I really would appreciate any help.
>
> Thank you in advance!
>
> Marc
Received on Fri Mar 12 2004 - 16:20:41 CET