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, […]

Create pfile from memory

Many a times situation comes when database initialization parameter file gets accidentally removed or overwritten. From version 11g Oracle has came up with solution of recreating parameter file from memory if database is up & running. Oracle already has functionality of creating pfile from spfile & vice-versa. But now with […]