使用sqlplus连接到Oracle DB [英] Connect to Oracle DB using sqlplus

问题描述

我在Unix环境中使用以下命令连接到Oracle数据库:

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.

推荐答案

请尝试以下操作: sqlplus USER/PW@//hostname:1521/SID

这篇关于使用sqlplus连接到Oracle DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！