Hi,
I have different scenerios here and getting error in few, Help me to identify the problem in 2 and 3 scenerios.
Oracle DB Server is 11.2.0.3.0 in RHEL 6 server
Oracle Client is 11.2.0.1 in another RHEL 6 server
Trying to connect DB Server from Oracle Client
In Oracle Client server I use the following export variables
export ORACLE_HOME=/opt/oracle/product/11.2.0/client_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=kdb
tnsping kdb is ok
Scenerio 1: Able to connect
$ sqlplus system@kdb/dbora
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 29 09:51:14 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Scenerio 2: Not able to connect (oracle_sid is exported)
$ sqlplus system/dbora
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 29 09:52:40 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Scenerio 3: Not able to connect (oracle_sid is exported)
$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 29 09:54:50 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
I need this to work since I need to connect through an application.
Thanks in advance,
Rao.