Home » RDBMS Server » Server Administration » Database Creation using DBCA stalls at 92% (Oracle 9.2.0.8.0 on RHEL 4)
Database Creation using DBCA stalls at 92% [message #335524] Tue, 22 July 2008 07:47 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi,

I am trying to create 9i database - General Purpose using DBCA which hanged at 92% since last 90 minutes

There is nothing in the following directories
assistants/dbca/logs
rdbms/log

Also the cloneDBCreation.log file is not modified since last 90 minutes and its contents are as follows


ORACLE instance started.
Total System Global Area  235999648 bytes
Fixed Size                   450976 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Elapsed: 00:00:00.53
Elapsed: 00:00:00.31
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area  235999648 bytes
Fixed Size                   450976 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Elapsed: 00:00:00.47
Elapsed: 00:00:00.01
Elapsed: 00:00:06.58
Elapsed: 00:00:00.02
Elapsed: 00:00:00.43
Elapsed: 00:00:03.06
Elapsed: 00:00:00.75
Elapsed: 00:00:00.00
Connected.


Only files getting created at this moment are in rdbms/audit directory

Also this database server has total of 4G RAM and out of which 1.5G is allocated to another database instance created earlier.

The database (being test db) being created has following memory structure


13:42:25 SQL> show sga

Total System Global Area  235999648 bytes
Fixed Size                   450976 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes


I have checked there is no disk space issue either

can anybody suggest what is wrong here

Thanks and Regards,
OraKaran
Re: Database Creation using DBCA stalls at 92% [message #335545 is a reply to message #335524] Tue, 22 July 2008 09:26 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check the ORACLE_<yourSID>.log available at $ORACLE_BASE/admin/<yourSID>/bdump

Previous Topic: Failure to extend rollback segment because of 30036 condition
Next Topic: 10g ORA-00201 - Controlfile version
Goto Forum:
  


Current Time: Fri Dec 09 23:11:53 CST 2016

Total time taken to generate the page: 0.08554 seconds