DBCA failing with ora-19870 ora-19504 ora-17502 ora-15081

Today while creating database on ASM using DBCA I got following error exactly after reaching 4%.

issue

After searching on net I found, a workaround of using “custom database” tempalate instead of “general purpos or transaction processing” in dbca.

template

I was not sure about this workaround, and as expected it failed at same point with same error.

DBCA was failing to create datafile in +DATA diskgroup. ASM database was up & running with +DATA in MOUNTED state.

Was it due to file permission issue on raw disks under ASM??

We have separate OS users for grid & rdbms home which belong to same primary group “oinstall”.

root@rmb-zdr-odb01# pwd
/dev/rdsk
root@rmb-zdr-odb01# ls -lrt
crw-r----- 1 grid oinstall 206, 69 Aug 16 10:39 c0t5000CCA01D2EC43Cd0s5
crw-r----- 1 grid oinstall 206, 68 Aug 16 10:39 c0t5000CCA01D2EC43Cd0s4
crw-r----- 1 grid oinstall 206, 66 Aug 17 17:24 c0t5000CCA01D2EC43Cd0s2
crw-r----- 1 grid oinstall 206, 64 Aug 17 17:24 c0t5000CCA01D2EC43Cd0s0
crw-r----- 1 grid oinstall 206, 67 Aug 17 17:26 c0t5000CCA01D2EC43Cd0s3
crw-r----- 1 grid oinstall 206, 65 Aug 17 17:36 c0t5000CCA01D2EC43Cd0s1

So here’s the culprit 🙂 . Changed permissions to 660 instead of 640

 

root@rmb-zdr-odb01# ls -lrt
crw-rw---- 1 grid oinstall 206, 69 Aug 16 10:39 c0t5000CCA01D2EC43Cd0s5
crw-rw---- 1 grid oinstall 206, 68 Aug 16 10:39 c0t5000CCA01D2EC43Cd0s4
crw-rw---- 1 grid oinstall 206, 66 Aug 17 17:24 c0t5000CCA01D2EC43Cd0s2
crw-rw---- 1 grid oinstall 206, 64 Aug 17 17:24 c0t5000CCA01D2EC43Cd0s0
crw-rw---- 1 grid oinstall 206, 67 Aug 17 17:26 c0t5000CCA01D2EC43Cd0s3
crw-rw---- 1 grid oinstall 206, 65 Aug 17 17:36 c0t5000CCA01D2EC43Cd0s1

This time DBCA worked successfully without any issue!!

Hope so u will find this post very useful 🙂

Cheers

Regards,

Adityanath

Advertisements

DBCA failing with ORA-01034

I faced this issue while creating database using DBCA in one of the UAT database server. Issue was with just DBCA , I was able to create database manually without any issues.

Each attempt of creating database with DBCA utility was failing with ORA-01034: ORACLE not available.

After putting lots of efforts, I started concentrating on error itself ORA-01034: ORACLE not available. 

What is the possibility of getting ORA-01034 in normal scneario:

  •  Database is down & u r trying execute some sql statement on it

Simple… I am creating my database, means database is not open, & what is the possibility of someone executing any query on my database….

one and only glogin.sql is the culprit.

What Oracle documentation says about glogin.sql

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. 

I found following sql was present in glogin.sql:

select name,open_mode from v$database;

After removing all entries from glogin.sql, I was able to create database using DBCA without issues.

..

Hope so this post will be useful for u 🙂

Cheers

Regards,

Adityanath