Question [message #70069] |
Mon, 08 April 2002 06:19 |
akli
Messages: 2 Registered: April 2002
|
Junior Member |
|
|
I have installed Oracle personal edition in my windows 98 computer. The database work good. But I have a problem when i try to connect with SQLPLUS in a remote database. I check my tnsnames.ora, and this one is good. So I would to know how can I configure my computer to be able to work with my local database and to work with the remote database.
PS: When check the net8 configuration, he start my local database and doesn't find my remote databse although my tnsnames is good.
I need quickly an answer thank you very much.
|
|
|
Re: Question [message #70072 is a reply to message #70069] |
Mon, 08 April 2002 08:58 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
use NET * configuration asssistent or directly edit the tnsnames.ora.
u need to give the Hostname,database_name,port number etc.
use tnsping to check the connectivity from your local machne to the remote database(Pinging to database).
it should work fine.
:)
|
|
|