欢迎投稿

今日深度:

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

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


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.

 



创建数据表的时,报ORA-01034,Oracle not available

你在登陆数据库后它提示你已经连接到一个空闲实例,在命令行下输入ps -ef|grep ora_命令,看看是否有数据库实例,如果有可能是你ORACLE_SID设置错了,如果没有需要启动数据库。
 

Oracle手动创建数据库,执行以下命令,提示错误: 第1行出现错误:ORA-01034:ORACLE not available

首先可以确定的说:ORA-01034:ORACLE not available 说明你的数据库没有启动到mount状态下,执行建库脚本需要数据启动到mount下.
 

www.htsjk.Com true http://www.htsjk.com/shujukunews/2444.html NewsArticle DBCA创建数据库ORA-01034 ORACLE not available,dbcaora-01034 SYMPTOMS 在利用dbca创建数据库时,当设置完成所有参数,开始装时 跑到2% 就报错 ORA-01034 ORACLE not available, 如下图 CAUSE There's a script in...
相关文章
    暂无相关文章
评论暂时关闭