DATABASE CONNECTION

[eml2raghu]

I just installed the PL/SQL Developer. Can any one help me in connecting to a database which is hosted on a different system like this 111.111.111.111

Thanks in advance

 

[yzsind]

I don't understand your meaning.
do you have two databases?

what is the meaning of

 

[eml2raghu]

Oracle is installed on a diffferent system. I have to connect to it. How?
I have connected in DreamCoder using TCP/IP.
Machine name : 171.220.110.102
Instanece : Raghu
Port : 1521
but how to do this in PL/SQL Developer

 

[Marco Kalter]

You will need to use the Oracle Net Configuration Assistant (a standard Oracle utility) to define a local service name for the remote databases you want to access from your Oracle Client.

 

[eml2raghu]

Hi,
I dont have Oracle installed in my system. All i have is only PL/SQL developer. I have to connect to the database from that tool.

 

[Paul Ljungqvist]

You have to install the Oracle client to be able to connect to an Oracle database.
It is free, and available fromhttp://technet.oracle.com

 

[eml2raghu]

Hi, Its fine, but i dont have persmission to install it in my system(office). Is there any other way to connect without installing it ?
But i am able to connect to DB from dreamcoder.

 

[Marco Kalter]

The minimal requirement is the Oracle Instant Client. It can be used without an actual "installation", so it does not require many privileges. Just copy some files and set the ORACLE_HOME and TNS_ADMIN environment variables.

 

[eml2raghu]

Sorry to bother you, can you please tell me clearly what needs to be downloaded and where the changes has to be done ?

 

[eml2raghu]

Sorry to bother you, can you please tell me clearly what needs to be downloaded and where the changes has to be done ?

 

[NK]

Hi,
I dont have Oracle installed in my system. All i have is only PL/SQL developer. I have to connect to the database from that tool.

I would check if you have the basic components to connect to your database instance from your development machine. Seehttp://www.orafaq.com/wiki/Tnsping

That has to work first.
(It establishes if you have a valid Oracle setup there)