Home » RDBMS Server » Server Administration » DB Creation process stuck to 85% (12.2.0.1.0)
DB Creation process stuck to 85% [message #678610] Thu, 19 December 2019 00:20 Go to next message
vippysharma
Messages: 61
Registered: May 2013
Location: www
Member
I am trying to create DB via DBCA in Oracle 12.2.0.1.0 using 11.2.0.0 DB template and the creation process got stuck to 85% from more then 24 hours. No Error pop up and No error message is there in wizard.

What i edited in template: Removed <initParam name="compatible" value="11.1.0.0.0"/> this parameter because i am creating DB in Oracle 12c. (this is ok?)

I am bit new to DBA stuff so request you to please help me to get out of this.

Attachment: Alert log
Re: DB Creation process stuck to 85% [message #678616 is a reply to message #678610] Thu, 19 December 2019 08:03 Go to previous messageGo to next message
JPBoileau
Messages: 88
Registered: September 2017
Member
It doesn't look like the DB is hung as you were still getting alert log entries until 7:30a today.

Can you connect to the database as sysdba? if you can, you could potentially turn on trace for the all the sessions and see what the database is doing.

JP
Re: DB Creation process stuck to 85% [message #678629 is a reply to message #678616] Sun, 22 December 2019 22:25 Go to previous message
vippysharma
Messages: 61
Registered: May 2013
Location: www
Member
Quote:
Can you connect to the database as sysdba?
No,

From google, i found some points to take care like... (but all in vain)

  • Clear all temp file
  • Install without flash recovery area
  • Delete version compatible parameter from Template used for DB creation and let the oracle decide it.
At last I just uninstall and reinstall oracle in my m/c and it worked properly. Don't know how ? and what was the real problem :/

Previous Topic: Schema Undo
Next Topic: File I/O error
Goto Forum:
  


Current Time: Tue Dec 01 15:53:07 CST 2020