Database Networking (MOSC)

MOSC Banner

Error on sqlplus direct connection

edited Nov 22, 2018 7:20PM in Database Networking (MOSC) 14 comments

Using an 11.2 client, I run this statement, and it works just fine.

sqlplus jcook@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = auohsitutxd01-vip.oracleoutsourcing.com)(PORT = 10110)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pitu1o)))

Using a 12.2 connection, I run the same statement, and it gets this:

-bash: syntax error near unexpected token `('

One suggestion was to make the direct connect string on string like this, but I got the same error.

sqlplus jcook@\"(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = auohsitutxd01-vip.oracleoutsourcing.com)(PORT = 10110)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pitu1o)))\"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center