Login Credential setup issue

[Vikas]

Hi
Recently I installed pl/sql Developer 12. I am not able to connect to database on cloud. I do not have TNS entry or Oracle or Oracle Client installed in my machine. Database is on Could server.

I have
USER Name : xyz
Password : CPa55w0rdS
host name : 192.168.20.20
port: 1521
SID: ORP
Oracle Server : ogr.cloud.abc.com

With Oracle SQL DEVELOPER i am able to connect using the above information.

Regards
VG

 

[Marco Kalter]

If you do not have a TNS entry then perhaps you can use the EZCONNECT naming method? It uses the following format:

host[ort]/database

The default port number is 1521, in which case it can be omitted:

host/database

See also:
http://www.orafaq.com/wiki/EZCONNECT

Note that this still requires an Oracle Client installation, and that EZCONNECT needs to be enabled in the SQLNET.ORA file.

 

[Vikas]

Hi Marco

Not getting from EZCONNECT. Please provide more input.
Where i will mention this details in PL/SQL Developer tool.

I opened the PL/SQL Developer and opened the SQL Window and did the same as per EZCONNECT link, but not connecting.

CONNECT xyz/CPa55w0rdS@ogr.cloud.abc.com:1521/ORP

USER Name : xyz
Password : CPa55w0rdS
host name : ogr.cloud.abc.com
port: 1521
SID: ORP

Please provide more input

Regards
VG

 

[Marco Kalter]

You can go to Session > Logon on the Ribbon or Quick Access Toolbar, and enter the user name in the "Username" field, the password in the "Password" field, and host[ort]/database in the "Database" field.

Again, note that this still requires that you have installed the Oracle Client software.