Hi all, I have 2 pcs networked. 1

[mcowen]

Hi all,

I have 2 pcs networked. Win98 on one and the other win2000. Oracle 8.1.7 is on win2000 and I have 8.1.5 on the other. Now Oracle 815 on the win98 machine can connect to Oracle 817 on the win2000 machine but not the other way around..!

The connection that works is using TCP/IP and was easy to set up thanks to Net8. But why not the other way round?? Its set the same as the one that works but the protocol stack support on the listener is Net8 clients (this right?) I keep getting error ORA-12541: TNS:no listener.

Tnks for any help.
Matt

 

[rcurva]

Check if the listener on your NT server is started. Try,

lsnrctl stat

If not, start the listener;

lsnrctl start

After starting, try to tnsping from 2k to NT.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[mcowen]

This did not work. This is from the log on my win98 (called FIFI). the win2k machine is called GREG.

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=GREG)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=GREG)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNSrotocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 49: Unknown error

 

[mcowen]

OK, i see what is wrong. The host name in the listener was wrong should have been FIFI instead of GREG.

Now though when I try to connect from fifi to greg...
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=greg)(PORT=1521))
TNS-12537: TNS:connection closed

 

[rcurva]

But you said initially, 98 can connect to 2K (FIFI to GREG). How come it is not connecting now?

But i guess both listeners are up now right?

Have you tried tnsping? Can you reach the DB in GREG from FIFI and vise-versa?

If not, configure your tnsnames properly. Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War