用sqlplus远程连接oracle命令
来源:互联网 发布:网络密钥怎么设置 编辑:程序博客网 时间:2024/05/07 07:36
语法:sqlplus usr/pwd@//host:port/sid
[oracle@mzl ~]$ sqlplus risenet/1@//192.168.130.99:1521/risenet
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 18 15:53:34 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
risenet OPEN
或者是
SQL> conn risenet/1@//192.168.130.99:1521/risenet
Connected.
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_T
--------------- ---------------- --------------- ----------------- ---------
STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ LOGINS SHU DATABASE_STATUS
------------ --- ---------- ------- ----------- ---------- --- -----------------
INSTANCE_ROLE ACTIVE_ST
------------------ ---------
1 risenet RISENET56 9.2.0.1.0 13-FEB-08
OPEN NO 1 STOPPED ALLOWED NO ACTIVE
PRIMARY_INSTANCE NORMAL
[oracle@mzl ~]$ sqlplus risenet/1@//192.168.130.99:1521/risenet
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 18 15:53:34 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
risenet OPEN
或者是
SQL> conn risenet/1@//192.168.130.99:1521/risenet
Connected.
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_T
--------------- ---------------- --------------- ----------------- ---------
STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ LOGINS SHU DATABASE_STATUS
------------ --- ---------- ------- ----------- ---------- --- -----------------
INSTANCE_ROLE ACTIVE_ST
------------------ ---------
1 risenet RISENET56 9.2.0.1.0 13-FEB-08
OPEN NO 1 STOPPED ALLOWED NO ACTIVE
PRIMARY_INSTANCE NORMAL
- 用sqlplus远程连接oracle命令
- 用sqlplus远程连接oracle命令
- 用sqlplus远程连接oracle命令
- 用sqlplus远程连接oracle命令
- 用sqlplus远程连接oracle命令
- 用sqlplus远程连接oracle命令
- sqlplus 远程连接oracle 命令
- sqlplus连接远程oracle
- sqlplus远程连接Oracle
- sqlplus连接远程Oracle
- oracle用sqlplus命令远程登录
- sqlplus 远程连接oracle语法
- Oracle sqlplus远程连接数据库
- Oracle sqlplus远程连接数据库
- sqlplus 连接远程oracle数据库
- Oracle远程连接sqlplus字符串
- Oracle sqlplus远程连接数据库
- SQLPLUS远程连接Oracle数据库
- 分享一个蓝屏代码查询器
- 斐波那契 非递归方法
- 扫雷程序-地雷位置生成
- C语言中volatile关键字的作用
- CRM 2011 Online SSRS report UTC time to local time
- 用sqlplus远程连接oracle命令
- hibernate实现对sqlserver 2005的增删改查
- cocos2d-x的action
- 道听途说Struts2之9:接收中文参数
- 道听途说Struts2之10:简单的数据验证
- struts2 的action动态调用时 报错
- tomcat(apache-tomcat-6.0.33)进不去
- NYOJ 520 & HDU 2136 Largest prime factor(筛法思想)
- 209. He is not laughed at that laughs at himself first.自嘲者不会让人见笑