OraFAQ Forum: Server Administration » Database Creation using DBCA stalls at 92%

Home » RDBMS Server » Server Administration » Database Creation using DBCA stalls at 92% (Oracle 9.2.0.8.0 on RHEL 4)

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

Database Creation using DBCA stalls at 92% [message #335524]

Tue, 22 July 2008 07:47

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

Report message to a moderator