Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLPlus install on RedHat

835980Feb 1 2011 — edited Feb 2 2011
Hey team,

I have scoured Google in search for a simple install doc and to no avail I cannot find a complete doc to help me in this.

I have a RedHat Linux server that I need to install SQLPLUS on so our develeopers can connect to our Oracle database.

I downloaded 2 RPM's from the Oracle site and installed them

oracle-instantclient11.2-basic-11.2.0.2.0.x86_64
oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64

However am running into connecitivty issues

at first i was running into ORA-12162: TNS:net service name is incorrectly specified

So then I added the ENV variable
export ORACLE_SID=orcl

Now I am getting a ORA-12545: Connect failed because target host or object does not exist

I can telnet to the Oracle servers on Port 1521

My Tnsnames.ora file should be set up correctly because I got the connection strings from my Develeopers.


VCQ5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vcq5)
)
)
VCQ7 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vcq7)
)
)

Anyone have a step by step guide on installing SQLPlus on RedHat? I don't need a full blown install of Oracle on my develoepment server, just the bare minimum to connect and run querrys.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2011
Added on Feb 1 2011
3 comments
7,996 views