sqplus远程连接Oracle

语法

sqlplus username/passwortd@//host:port/sid

例子

在sqlplus中连接

908869@CNSHA05NB70810 ~
$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 17 16:55:46 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> conn dding/password@cnsha05wk70802:1521/sample
Connected.
SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
sample OPEN

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

908869@CNSHA05NB70810 ~
$

直接在命令行中连接

908869@CNSHA05NB70810 ~ 
$ sqlplus dding/password@cnsha05wk70802:1521/sample

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 17 17:29:46 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
sample OPEN

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

908869@CNSHA05NB70810 ~
$

通过 Wiz 发布

转载于:https://www.cnblogs.com/heart-runner/archive/2012/01/17/2324910.html