Skip to Main Content

Oracle Database Discussions

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 login confussion

npcraoJan 28 2014 — edited Feb 3 2014

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2014
Added on Jan 28 2014
11 comments
305 views