DBCA建立資料庫ORA-01034 ORACLE not available，dbcaora-01034

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下.