Home » RDBMS Server » Server Administration » why can't I link to oracle7.3 in win2000,but can link in win98?
why can't I link to oracle7.3 in win2000,but can link in win98? [message #49766] Thu, 07 February 2002 21:01 Go to next message
wq
Messages: 3
Registered: February 2002
Junior Member
hello,everyone.I have a question:
a oracle 7.3 run on hp-unix10.2,
I can link to it in win98 by net8 easy config,
but can't link to in in win2000,
why?how can i do?

in win2000,the error message is :

ORA-12541: TNS:no listener

Report message to a moderator

Re: why can't I link to oracle7.3 in win2000,but can link in win98? [message #49768 is a reply to message #49766] Thu, 07 February 2002 22:59 Go to previous messageGo to next message
wq
Messages: 3
Registered: February 2002
Junior Member
the enviorment is :

client1£ºwin2000 profession:oracle 8.0.5
net8 easy config:

client2£ºwin98 :oracle 7.3
net easy config:

server£ºhpunix10.2
oracle 7.3.2.3

the client2 can link to server,but client 1 can't.
why?

Report message to a moderator

Re: why can't I link to oracle7.3 in win2000,but can link in win98? [message #49777 is a reply to message #49766] Fri, 08 February 2002 11:49 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
What do you get when you tnsping it? Verify the listener is running on the target host. Check your local tnsnames and sqlnet ora files to ensure they are correct. Very port settings.

Report message to a moderator

Re: why can't I link to oracle7.3 in win2000,but can link in win98? [message #49791 is a reply to message #49777] Sat, 09 February 2002 14:09 Go to previous messageGo to next message
wq
Messages: 3
Registered: February 2002
Junior Member
thank you ,Grant
I use tnsping,the error message is :
TNS-12541 TNS:no listener

but I can link to it in a oracle7.3 client.

what should i do
if i want to link to the oracle server7.3 by use a oracle8 client?
should do sth special?

Report message to a moderator

Re: why can't I link to oracle7.3 in win2000,but can link in win98? [message #49813 is a reply to message #49791] Mon, 11 February 2002 08:50 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Have you compared the sqlnet and tnsnames ora files with the client that works. Try moving the tnsnames and sqlnet files to a backup directory on the 2000 client and copy the files from the w98 client to the 2000 client. What does your sqlnet.log say on the 2000 client?

Report message to a moderator

Previous Topic: Re: urgent...how do i know which user has dropped a table from the database
Next Topic: Re: Migration Workbench 1.4.1 MS Access Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 10:51:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.