Oracle Database connection via SQLPLUS

Question

I am trying to connect to my Oracle database from SQLPlus, but I'm not able to connect.

I have Oracle client(10g) on my machine. Below are the details through which I am able to connect from my Java application.

connect('dbi:Oracle://IP/wborcle', 'username', 'pwd'));

What will be the hoststring when connecting via SQLPLUS?

Answer 1

Try

sqlplus username/password@host:port/service

sqlplus system/system@localhost:1521/xe

Copied from https://dba.stackexchange.com/questions/65032/connect-to-sql-plus-from-command-line-using-connection-string

Answer 2

Oracle offers several different methods for lookup up databases when you're trying to connect to them:

• tnsnames.ora entries
• LDAP
• EZConnect
• ...

The most common approach is to put the databases you're connecting to into your tnsnames.ora; usually, your client installation contains an example tnsnames.ora file that you can modify.

The easiest approach is probably to use EZConnect. An EZConnect string is built like

<username>/<password>@<hostname>:<port>/SID

so in your case, it (probably) will be something like

sqlplus scott/tiger@localhost:1521/wborcle

Answer 3

 sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))

Maybe, and this might be dependant on the command line environment you're using, you need to quote the string, something like

sqlplus "user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))"

or

 sqlplus 'user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))'