DBCA Creating a database ORA-01034 ORACLE not available

Symptoms

When you create a database with DBCA, the full number of parameters is set to complete. Run to 2% when you start loading error ORA-01034 ORACLE not available,

For example with

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqveglhb2zhbjizeg==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

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.

DBCA Creating a database ORA-01034 ORACLE not available