Connecting to Oracle

The Oracle client should be installed on the machine that will access the Oracle server. If the aim is to access the server only for applications then Oracle client will suffice, however for administration and management duties additional admin packages also need to be installed.

The Oracle client should be installed on the machine that will access the Oracle server. If the aim is to access the server only for applications then Oracle client will suffice, however for administration and management duties additional admin packages also need to be installed.

Oracle Database 12c Release 1 can be downloaded from this page.

Connecting to Oracle

Toad connection

Toad connection

Toad connection

SQL Developer connection

SQL Developer connection

SQL Developer connection

SQL Developer connection

SQL Developer connection

The contents of tnsnames.ora

“ASM” is only an alias and any other name could be given in its place. To avoid confusion, the server and the host should share the same name

Note: To resolve the client machines name asm.ora.local

We need to get a response similar as the above lines. If you encounter any issues with name resolution

1. Enter the following line in C:WindowsSystem32driversetchosts

192.168.13.132 asm.ora.local asm

2. Alternatively tsnames.ora should be changed to include HOST = 192.168.13.132

Verifying the changes on the client machine:

If the listener is inactive or there are network access issues with port 1521:

Connecting to SQLPlus through the command prompt.