Oracle 10g RAC sqlplus / as sysdba Connected to an idle instance
来源:互联网 发布:java多线程 菜鸟教程 编辑:程序博客网 时间:2024/05/22 18:23
刚搭建的rac环境在用sqlplus 连接数据库是报如下情况:
[oracle@rac2 ~]$ export ORACLE_SID=RAC2
[oracle@rac2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 00:55:19 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
没有连接到数据库,实际上数据库是启动的。
用以下方式就可以连接:
[oracle@rac2 ~]$ sqlplus sys@rac2 as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 00:57:24 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
经过一番波折发现原来是安装的rac环境的oracle sid 是小写的
SQL> select instance_name from gv_$instance;
INSTANCE_NAME
----------------
rac1
rac2
当oracle sid换成小写之后问题解决:
[oracle@rac2 ~]$ export ORACLE_SID=rac2
[oracle@rac2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 00:59:13 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL>
玩了这么多年的oracle,此次居然被其愚弄了一把。哈哈
- Oracle 10g RAC sqlplus / as sysdba Connected to an idle instance
- RAC database open,但是sqlplus进去,提示Connected to an idle instance
- Connected to an idle instance-RAC 10.2.0.4.1
- Connected to an idle instance
- 【翻译自mos文章】在10g中,当发生ORA-00020时,sqlplus登陆会报“connected to an idle instance”
- Connected to an idle instance. ORA-01034: ORACLE not available
- oracle报错Connected to an idle instance
- Connected to an idle instance 解决
- 关于sqlplus中出现"Connected to an idle instance"问题的处理
- 解决Linux 下oracle 报错 Connected to an idle instance. Linux启动Oracle实例
- 11gR2报connected to an idle instance.
- Connected to an idle instance问题的小小仇恨
- ORACLE sqlplus / as sysdba
- 连接一个运行的实例显示:"Connected to an Idle Instance"
- Oracle sqlplus/as sysdba命令详解
- Oracle:sqlplus命令行登录方法 as sysdba
- Oracle 11g安装完成登录sqlplus / as sysdba出错,权限不足解决办法
- system as sysdba 无法登录oracle 10g em
- $_SERVER['PHP_SELF']和$_SERVER['SCRIPT_NAME']区别
- Trim
- Win 7 下如何添加硬件
- 套接字和协议的关系
- appWidget学习
- Oracle 10g RAC sqlplus / as sysdba Connected to an idle instance
- 解决Office 2010中的程序打开显示“正在配置”。。。
- 10个最受欢迎的Java类
- java中excel的属性设置
- CO01/CO02/CO40保存增强点
- 黑马程序员_交通灯改造版!
- 飞鸽传书2013
- 两个包含group by 语句的select 语句的连接查询
- 成员函数指针数组,处理函数中调用: