Dbca create database ORA-01034ORACLEnotavailable

Dbca create database ORA-01034ORACLEnotavailable
SYMPTOMS

When using dbca to create a database, when all the parameters are set up, the ORA-01034 ORACLE not available,

For example

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