I'm trying to connect to an oracle 12c database from a remote machine, but it fails with two errors.

sqlplus "user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host="

SQL*Plus: Release
ORA-01017: invalid username/password; logon denied

Enter user-name: user
Enter password:  (pass)
ORA-12545: Connect failed because target host or object does not exist

On the connecting machine I can do:

$ tnsping server12

TNS Ping Utility for Linux: Version
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora12)))
OK (0 msec)

So there seems to be connectivity.

If I run the same sqlplus command on the DB server, I get

$ sqlplus "user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host="

SQL*Plus: Release 

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production

The TNS on the connecting machine says

server12 =
     (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))
    (SID = ora12)

I can also connect from SQLDeveloper using Basic Connection Type and hostname = and port 1521 and SID=ora12.

Any ideas on how to make it connect?

  • 1
    Change the first one to use SERVICE_NAME instead of SID. Also lsnrctl status on the server is always a good indication of what you're currently able to connect to
    – Philᵀᴹ
    Commented May 17, 2018 at 10:18
  • 2
    Oh, wait. You're trying to connect from an Oracle 9.2 SQL Plus?! Nope
    – Philᵀᴹ
    Commented May 17, 2018 at 10:20

1 Answer 1


You can't connect from a 9.2.0 SQL*Plus to a version or Oracle Database.

It was never a supported option as displayed in the Interoperability Support Situation matrix chart in an Oracle Support Note.1 (Oracle Support Login required to read the Oracle Document.)

A SQL*Plus 9.2.0 client was only able to connect to 11.2.0 server or lower.

The lowest supported version of SQL*Plus that could connect to an version of Oracle Database would be an 11.2.0.x client.

1 Oracle: Note 207303.1

Reference: oracle 9i client connecting to oracle 12c server (Stackoverflow.com)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.