| DBCA / CREATE DATABASE hangs (9i, Redhat 7.3) [message #53153] |
Thu, 29 August 2002 07:02  |
Rick Root
Messages: 8
Registered: August 2002
|
Junior Member |
|
|
Having solved all my other problems with getting oracle installed and getting the instance to actually start so that a database can be created, I've encountered a new problem.
RedHat 7.3, Oracle 9i Release 2 (9.2.0.1.0), 1GB physical memory, 1GB swap, PIII-550 processor.
SHMMAX = 512MB (I've also tried setting it to 2GB)
In order to be able to more closely watch what was going on, I used the DBCA to create the scripts, and I'm running the script from the command line.
All of this is done after a reboot, so I know everything is pretty clean.
The CREATE DATABASE SQL statement appears after the database is started up, and then nothing. No error message. No more activity of any kind.
There is a log file in the /opt/oracle/admin/EVNT/bdump directory called alert_EVNT.log... there do not appear to be any errors here but the last few lines are:
Thu Aug 29 10:27:27 2002
create tablespace SYSTEM datafile '/opt/oracle/oradata/EVNT/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL online
CPU USAGE is at or near 100% according to "top", with oracle using most of that.
1576 oracle_d 25 0 48556 15M 10028 R 98.4 1.3 24:06 oracle
I still have over 450 MB of free physical memory.
Of all the files that should be created (to my knowledge, which isn't very great), it appears that the undo tablespace and the temporary table space are not created. The redo logs, the control files and the system01.dbf datafiles are created.
Help!
- Rick Root
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
