| TNS Listener [message #100828] |
Mon, 17 November 2003 14:20  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
