I have an oracle 11g server installed on my computer with Windows 7. I have to install this server from a remote machine. The remote machine is a 64-bit system with Ubuntu 12.10. To access the server, I installed the instant Oracle client and configured eveything.
ORACLE_HOME, TNS_ADMIN, PATH, LD_LIBRARY_PATH are all set and point to the correct locations.
My tnsname.ora file:
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ravi)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.xxx.com) ) )
My sqlnet.ora file
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
My tnslistener on the server is up and running.
LSNRCTL> services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "orcl.xxx.com" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:221 refused:0 state:ready LOCAL SERVER Service "orclXDB.xxx.com" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER <machine: ravi, pid: 4844> (ADDRESS=(PROTOCOL=tcp)(HOST=ravi.xxx.com)(PORT=49239)) The command completed successfully
Even after setting all these parameters, Im will not be able to connect to the server.
When I issue the sqlplus user1@orcl command, I get
ravi@ubuntu :~/app/ravi/product/11.2.0/dbhome_1/bin$ sqlplus user1@orcl SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 25 01:17:01 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter password: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
I saw all these messages,
Sqlplus registration error when using bash variables: SP2-0306: Invalid option
ora-12154 failed to solve ... with oracle instant client
and enter many other messages, but none of them solves my problem.
Help Request
Thanks at Advance