DBCA创建数据库ORA-01034 ORACLE not available

SYMPTOMS


在利用dbca创建数据库时,当设置完成所有参数,开始装时 跑到2% 就报错 ORA-01034 ORACLE not available,

如下图

CAUSE

There‘s a script in ORACLE_HOME/sqlplus/admin which is called glogin.sql.  This script is automatically run when the user starts SQL*PLUS or uses the Connect command, hence any command added to it will be executed. 

Checking the script, it had a "select * from v$instance;" statement added. It was always executing this statement when SQL*PLUS was started or when Connect was issued, and this statement is returning the ORA-01034 when invoking DBCA. 

SOLUTION

1. Check the glogin.sql script in ORACLE_HOME/sqlplus/admin and make sure it has no statements that could cause the ORA-01034.
    disable glogin.sql (mv glogin.sql glogin.sql.bak)  
2. If the issue is still not resolved, then please log an SR with Oracle Support.

 


DBCA创建数据库ORA-01034 ORACLE not available,古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。