| ORA-01092 - manually creating a database [message #497698] |
Sun, 06 March 2011 21:15  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
I've been working to create (via script) this database for the last 2 days.. everytime I startup in nomount mode (as sysdba), it displays this error:
$ echo $ORACLE_SID
elams
$
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 7 09:41:26 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 2236696 bytes
Variable Size 219930344 bytes
Database Buffers 67108864 bytes
Redo Buffers 4325376 bytes
SQL> @elams_dbc_4Mar11A.sql
CREATE DATABASE elams
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
SQL> shutdown abort
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Please advise me on what to do next... Thank you.
|
|
|
|
|
|
| Re: ORA-01092 - manually creating a database [message #497715 is a reply to message #497701] |
Sun, 06 March 2011 23:17  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Thanks for your immediate response:
This is the script I used:
REM elams_dbc-4Mar11a.sql
REM creation of elams instance at prodn server (bir-dbs)
CREATE DATABASE elams
LOGFILE GROUP 1('/u401/oradata/elams/redo/redo01.log',
'/u402/oradata/elams/redo/redo01.log') SIZE 50M,
GROUP 2('/u501/oradata/elams/redo/redo02.log',
'/u502/oradata/elams/redo/redo02.log') SIZE 50M,
GROUP 3('/u601/oradata/elams/redo/redo03.log',
'/u602/oradata/elams/redo/redo03.log') SIZE 50M
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/VOL02/oradata/elams/system01.dbf' SIZE 1024M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/VOL02/oradata/elams/sysaux01.dbf' SIZE 1024M
DEFAULT TABLESPACE elams DATAFILE '/VOL02/oradata/elams/data/elams01.dbf' SIZE 2048M
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/VOL03/oradata/elams/temp/temp01.dbf' SIZE 10248M
UNDO TABLESPACE undo DATAFILE '/VOL03/oradata/elams/undo/undo01.dbf' SIZE 256M
AUTOEXTEND ON MAXSIZE UNLIMITED;
While what was captured in the altert.log:
Mon Mar 7 13:32:05 2011
Errors in file /appl1/home/oracle/10.2/admin/elams/udump/elams_ora_20436.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Mon Mar 7 13:32:05 2011
Errors in file /appl1/home/oracle/10.2/admin/elams/udump/elams_ora_20436.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5798
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 20436
ORA-1092 signalled during: CREATE DATABASE elams
LOGFILE GROUP 1('/u401/oradata/elams/redo/redo01.log',
'/u402/oradata/elams/redo/redo01.log') SIZE 50M,
GROUP 2('/u501/oradata/elams/redo/redo02.log',
'/u502/oradata/elams/redo/redo02.log') SIZE 50M,
GROUP 3('/u601/oradata/elams/redo/redo03.log',
'/u602/oradata/elams/redo/redo03.log') SIZE 50M
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/VOL02/oradata/elams/system01.dbf' SIZE 1024M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/VOL02/oradata/elams/sysaux01.dbf' SIZE 1024M
DEFAULT TABLESPACE elams DATAFILE '/VOL02/oradata/elams/data/elams01.dbf' SIZE 2048M
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/VOL03/oradata/elams/temp/temp01.dbf' SIZE 10248M
UNDO TABLESPACE undo DATAFILE '/VOL03/oradata/elams/undo/undo01.dbf' SIZE 256M
AUTOEXTEND ON MAXSIZE UNLIMITED...
Thanks again.
|
|
|
|
|
|
| Re: ORA-01092 - manually creating a database [message #498429 is a reply to message #497749] |
Wed, 09 March 2011 23:50 |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Sorry for this late reply...
Yes Sir, I successfuly created the database by changing the filename of my UNDO tablespace.
It's now up and running.
Thanks to you and to Black Swan.
Regards & keep up the good work!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
