DBCA Creating a database ORA-01034 ORACLE not available

Symptoms

When using DBCA to create a database, when set to complete all parameters, start loading run to 2% error ORA-01034 ORACLE not available,

Such as

Cause

There ' s a script in Oracle_home/sqlplus/admin which is called Glogin.sql. This script was automatically run when the user starts Sql*plus or uses the Connect command, hence any command added to it would be executed.

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

Solution

1. Check the Glogin.sql script in Oracle_home/sqlplus/admin and make sure it have no statements that could cause the ORA-01 034.
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.