OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » TNS PROBLEMS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS PROBLEMS [message #67133]

Mon, 17 November 2003 15:40

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

Report message to a moderator

Re: TNS PROBLEMS [message #67135 is a reply to message #67133]

Tue, 18 November 2003 05:15

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please post the exact error messages u get when u connect and tnsping.
without it, we cannot guess what is happening in your end.
to startwith,
comment all the entries in  the sqlnet.ora and try again.

Report message to a moderator

Re: TNS PROBLEMS [message #67136 is a reply to message #67135]

Tue, 18 November 2003 10:10

minimulti
Messages: 5
Registered: November 2003

Junior Member

pulling my hair out for a week (this isn't my machine) -- turns out "zone alarm" is installed and it wouldn't accept the upgraded version of the listener because it has a different name (version). so just took it out of the list of programs to restrict and everything works great. whew.. thanks,

d

Report message to a moderator

Previous Topic:	Listener with two networks
Next Topic:	TNS cud not resolve service name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 14:10:46 CDT 2024