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\sqln
et.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\tn
snames.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\li
stener.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

[ Post a follow-up to this message ]

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@mail.webservertalk.com> wrote in message news:<mavi.12z3lg@mail.webserver
talk.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

[ Post a follow-up to this message ]