SQLPlus install on RedHat
835980Feb 1 2011 — edited Feb 2 2011Hey 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.