新手求助 在线等答复【以下显示了当前数据库状态:ASM实例正常打开,数据库ora2打开,监听正常】
[oracle@dbs2 ~]$ which srvctl
/u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
[oracle@dbs2 ~]$ which lsnrctl
/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl
[oracle@dbs2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-MAY-2015 09:38:52Copyright (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 29-MAY-2015 09:34:48
Uptime 0 days 0 hr. 4 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbs2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbs2)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "ora2.rowen" has 1 instance(s).
Instance "ora2", status READY, has 1 handler(s) for this service...
Service "ora2XDB.rowen" has 1 instance(s).
Instance "ora2", status READY, has 1 handler(s) for this service...
The command completed successfully【以下表明EM dbcontrol无法打开】
[oracle@dbs2 ~]$ which emctl
/u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl
[oracle@dbs2 ~]$ emctl start dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dbs2_ora2 not found. 【重建失败】
[oracle@dbs2 ~]$ emca -config dbcontrol db -repos createSTARTED EMCA at May 29, 2015 9:42:31 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following information:
Database SID: ora2
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/grid ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/grid ]:
ASM SID [ +ASM ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]: oracle
ASM user password:
May 29, 2015 9:43:10 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-15000: command disallowed by current instance typenull [ORA-01219: database not open: queries allowed on fixed tables/views only]
ASM user password:
May 29, 2015 9:44:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-15000: command disallowed by current instance type
[oracle@dbs2 ~]$ which srvctl
/u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
[oracle@dbs2 ~]$ which lsnrctl
/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl
[oracle@dbs2 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-MAY-2015 09:38:52Copyright (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 29-MAY-2015 09:34:48
Uptime 0 days 0 hr. 4 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbs2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbs2)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "ora2.rowen" has 1 instance(s).
Instance "ora2", status READY, has 1 handler(s) for this service...
Service "ora2XDB.rowen" has 1 instance(s).
Instance "ora2", status READY, has 1 handler(s) for this service...
The command completed successfully【以下表明EM dbcontrol无法打开】
[oracle@dbs2 ~]$ which emctl
/u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl
[oracle@dbs2 ~]$ emctl start dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dbs2_ora2 not found. 【重建失败】
[oracle@dbs2 ~]$ emca -config dbcontrol db -repos createSTARTED EMCA at May 29, 2015 9:42:31 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.Enter the following information:
Database SID: ora2
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/grid ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/grid ]:
ASM SID [ +ASM ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]: oracle
ASM user password:
May 29, 2015 9:43:10 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-15000: command disallowed by current instance typenull [ORA-01219: database not open: queries allowed on fixed tables/views only]
ASM user password:
May 29, 2015 9:44:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-15000: command disallowed by current instance type
解决方案 »
- 数据泵导出数据报错50分求大神解救
- 求解SQL优化!
- .NET 使用ODP.NET, BULKCOPY.WriteToServer 造成重复数据
- imp导入和recoverd database的问题
- 怎么创建ORACLE 10g 数据库自带的实例
- 一个性能调优的SQL问题,在线等,急!!!!!!!!!!!!!!!!
- 请问ORA-12571:TNS packet writer failure. 写入数据包失败是什么原因????
- 有关Oracle8.17的问题
- 触发器问题!!!郁闷啊!!
- 本人菜鸟一名,看了半天也不知道以下程序段实现什么功能,望高手帮忙解析,谢谢!
- oracle如何从库中抽取sql建库脚本
- Oracle11g中字符集如何如何修改为UTF8修改?
-》当前实例是打开的
SQL> select open_mode from v$database;OPEN_MODE
--------------------
READ WRITE