Home » Infrastructure » Windows » TNS Listener
TNS Listener [message #100828] Mon, 17 November 2003 14:20 Go to next message
minimulti
Messages: 5
Registered: November 2003
Junior Member
I have an Oracle 9.2.0.2 client and server running on my win2k machine. Everything works OK on the surface -- my application works, i can connect to the database, etc.

Then, i upgrade to 9.2.0.4 and my Listener no longer works. I can not even connect to the database -- no tnsping, nothing. I have tried quite a few things from editing the tnsnames, sqlnet, and listener files to changing the permissions of all the files in ora_home with no result... here are my sqlnet, tnsnames, and listener files: ("avera" is the name of my application)

# SQLNET.ORA Network Configuration File: C:Averaoracleora92NETWORKADMINsqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = avera
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

______________________________________

# TNSNAMES.ORA Network Configuration File: C:Averaoracleora92networkadmintnsnames.ora
# Generated by Oracle configuration tools.

WHITEPAS.AVERA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = whitepass1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = whitepas.avera)
)
)

INST1_HTTP.WHITEPASS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WHITEPASS1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

_______________________________________

# LISTENER.ORA Network Configuration File: C:Averaoracleora92networkadminlistener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = whitepass1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:Averaoracleora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = whitepas.avera)
(ORACLE_HOME = C:Averaoracleora92)
(SID_NAME = whitepas)
)
)

Any help will be greatly appreciated. thank you very much,

d
Re: TNS Listener [message #100840 is a reply to message #100828] Mon, 15 December 2003 00:04 Go to previous message
badri
Messages: 7
Registered: October 2001
Junior Member
hi,
Since its a W2K environ, you may want to do the following :
1. Check if the correct services are up (started) . Its possible that both old and new (conflicting) versions are active .
2. Check the Oracle_Home its pointing to .

You can also post any error messages that you encounter. Also check for the Sqlnet.log .

Cheers
Badri
Previous Topic: Re: solution for JREW error on Pentium 4 installations
Next Topic: Windows Server 2003 and Client 9i - IT WORKS !
Goto Forum:
  


Current Time: Thu Mar 28 09:42:43 CDT 2024