oracle 9i client server connetctivity.

2002-09-27 Thread Ravi Narwade
hi everybody i have installed oracle 9i as server on redhat 7.3 its working properly and also i nstalled oracle 9i as client on redhat 7.3 on another machine, the net assistant configuration shows the connectivity between server and client is successful. but wnen i am goint to try login from

Re: oracle 9i client server connetctivity.

2002-09-27 Thread Willem van der Walt[EMAIL PROTECTED]
what does the listener status tell you about the activity of the listener and what does the listener log say? Use lsnrctl status to check. Can you connect from the server itself to: sqlplus scott/tiger@test1 On Fri, 27 Sep 2002, Ravi Narwade wrote: hi everybody i have installed oracle 9i as

Re: oracle 9i client server connetctivity.

2002-09-27 Thread Ravi Narwade
thanks Willem i tried sqlplus scott/tiger@test1 on server but it doesnt work and gives adn error ORA-12154: TNS:could not resolve service name when i tried to reconfigute the listener configuration by using the netca it says Listener start failed. Listener may already be running so what i

Re: oracle 9i client server connetctivity.

2002-09-27 Thread Willem van der Walt[EMAIL PROTECTED]
You need to check that the tnsnames.ora file on both the server and client machines contains an entry for test1. First run the command lsnrctl status from the user that installed oracle. It should show you if the listener is running. If it is running, and you have a correct tnsnames.ora on the