Oracle :多实例切换
Connecting to 10.1.4.21:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
Last login: Mon Oct 14 13:58:58 2013 from 10.1.4.39
[root@db1 ~]# su - oracle
urpdb1:/home/oracle@db1>echo $ORACLE_SID
urpdb1
urpdb1:/home/oracle@db1>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 14 15:16:57 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
urpdb1 OPEN
SQL> !
[oracle@db1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-OCT-2013 15:17:29
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 03-SEP-2013 14:35:17
Uptime 41 days 0 hr. 42 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/product/11.2.0/grid_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/db1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.4.21)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.4.22)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "urpdb" has 1 instance(s).
Instance "urpdb1", status READY, has 1 handler(s) for this service...
Service "urpdbXDB" has 1 instance(s).
Instance "urpdb1", status READY, has 1 handler(s) for this service...
Service "ywkdb" has 1 instance(s).
Instance "ywkdb1", status READY, has 1 handler(s) for this service...
Service "ywkdbXDB" has 1 instance(s).
Instance "ywkdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@db1 ~]$ export ORACLE_SID=ywkdb1
[oracle@db1 ~]$ echo $ORACLE_SID
ywkdb1
[oracle@db1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 14 15:18:18 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
ywkdb1 OPEN
SQL>
最新文章
- 做图表统计你需要掌握SQL Server 行转列和列转行
- win7显示不是正版系统的解决方法
- 11.python之线程,协程,进程,
- Android请求返回417解决办法
- Java API —— Date类
- setsockopt、getsockopt详细介绍(转)
- ipython及Python初体验
- Oracle 数据库基础知识
- 对Faster R-CNN的理解(3)
- 多点数据同步服务器sql汇总
- Android 解压zip文件
- anaconda资源链接
- Intellij Idea常用配置设置
- c++builder 代码模板 code templates
- 【JavaScript】赛码网前端笔试本地环境搭建
- 502 解决:[WARNING] fpm_children_bury
- Matlab绘图基础——用print函数批量保存图片到文件(Print figure or save to file)
- java 反序列化 漏洞
- python学习整理
- [LeetCode] 11. Container With Most Water ☆☆
热门文章
- 【Codeforces Round #503 (Div. 2)】
- javascript事件委托和jQuery事件绑定on、off 和one以及on绑定多个事件(重要)
- Chrome V8系列--浅析Chrome V8引擎中的垃圾回收机制和内存泄露优化策略
- c字符和字符数组/字符串
- 《Java虚拟机原理图解》 1.2.3、Class文件中的常量池详解(下)
- spring mvc拦截器原理分析
- 使用MVP模式重构代码
- 【转载】容器技术 &; Docker &; 与虚拟化的比较
- sklearn preprocessing data(数据预处理)
- Service具体解释(一):什么是Service