Connect to Oracle DB using sqlplus

oracle unix sqlplus
Chaitanya picture Chaitanya · Mar 27, 2013 · Viewed 162.5k times · Source

I am using below command in Unix environment to connect to Oracle database:

sqlplus test/test@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.com )(PORT=1521)))(CONNECT_DATA=(SID=mysid))'

But I am getting below error:

Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.

Usage 1: sqlplus -H | -V

    -H             Displays the SQL*Plus version and the
                   usage help.
    -V             Displays the SQL*Plus version.

Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]

  <option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]

Please help me where I am doing mistake in using the command.

Answer

Alexander picture Alexander · Sep 24, 2013

try this: sqlplus USER/PW@//hostname:1521/SID

Related questions

SqlPlus SP2-0734: Error

I am new to using SqlPlus but not new to using SQL, and I get the following error after writing this in my editor and attempting to run the script that I wrote. All of this appears to be valid …

Read More
Oracle imp and exp commands

Normally when i have to take a backup of of a database on unix, i do, exp DBUSER/DBPSW@INST file=xxx.dmp or load from a dump imp DBUSER/DBPSW@INST file=xxx.dmp my question here is : how …

Read More
ORA-00060: deadlock detected while waiting for resource

I have a series of scripts running in parallel as a nohup on an AIX server hosting oracle 10g. These scripts are written by somebody else and are meant to be executed concurrently. All the scripts are performing updates on …

Read More