OraFAQ Forum: Server Administration » DB Creation process stuck to 85%

Home » RDBMS Server » Server Administration » DB Creation process stuck to 85% (12.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB Creation process stuck to 85% [message #678610]

Thu, 19 December 2019 00:20

vippysharma
Messages: 73
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

Attachment: alert_stc10.log
(Size: 45.88KB, Downloaded 1136 times)

Report message to a moderator

Re: DB Creation process stuck to 85% [message #678616 is a reply to message #678610]

Thu, 19 December 2019 08:03

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

Report message to a moderator

Re: DB Creation process stuck to 85% [message #678629 is a reply to message #678616]

Sun, 22 December 2019 22:25

vippysharma
Messages: 73
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 :/

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 14:41:32 CDT 2023