-
manual create 9i database problem
Hi all,
I am on 9.2.0.4 running Linux Rehat Advance Server 2.1 and I tried to create 9i database manually and I have some problem, below is the error I got:
Created Undo Segment _SYSSMU10$
ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/u01/ora...
Tue Sep 16 09:09:49 2003
Errors in file /home/oracle/admin/test/udump/test_ora_17792.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Tue Sep 16 09:09:49 2003
Errors in file /home/oracle/admin/test/udump/test_ora_17792.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5166
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 = 17792
ORA-1092 signalled during: create database test
controlfile reuse
When I looked into ORA-01519, It said "Try the system installation procedure again or contact customer support", Does it mean my o/s and Oracle software is messed up????
Everything went successful during my installation. DBCA ran successull to create the database
any thoughts???
Last edited by candyman; 09-16-2003 at 10:27 AM.
-
Show the database creation script. Did you mention the 'create undo tablespace' command to create the undo tablespace ??
Amar
"There is a difference between knowing the path and walking the path."
-
adewi,
below is my creation scripts:
startup nomount pfile=/home/oracle/admin/HULAND01/pfile/initHULAND01.ora
create database HULAND01
controlfile reuse
logfile ('/u01/oradata/HULAND01/log1HULAND01_A.log',
'/u01/oradata/HULAND01/log1HULAND01_B.log') size 20M,
('/u01/oradata/HULAND01/log2HULAND01_A.log',
'/u01/oradata/HULAND01/log2HULAND01_B.log') size 20M,
('/u01/oradata/HULAND01/log3HULAND01_A.log',
'/u01/oradata/HULAND01/log3HULAND01_B.log') size 20M
maxdatafiles 1022
maxlogfiles 32
maxlogmembers 5
maxinstances 10
character set "WE8ISO8859P1"
EXTENT MANAGEMENT LOCAL
datafile '/u01/oradata/HULAND01/system01.dbf' size 400m
DEFAULT TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u01/oradata/HULAND01/TEMP_01.DBF'
SIZE 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k
UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/HULAND01/undo01.dbf'
size 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k;
one thing on my init.ora I have as follow:
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
-
Originally posted by candyman
adewi,
below is my creation scripts:
startup nomount pfile=/home/oracle/admin/HULAND01/pfile/initHULAND01.ora
create database HULAND01
controlfile reuse
logfile ('/u01/oradata/HULAND01/log1HULAND01_A.log',
'/u01/oradata/HULAND01/log1HULAND01_B.log') size 20M,
('/u01/oradata/HULAND01/log2HULAND01_A.log',
'/u01/oradata/HULAND01/log2HULAND01_B.log') size 20M,
('/u01/oradata/HULAND01/log3HULAND01_A.log',
'/u01/oradata/HULAND01/log3HULAND01_B.log') size 20M
maxdatafiles 1022
maxlogfiles 32
maxlogmembers 5
maxinstances 10
character set "WE8ISO8859P1"
EXTENT MANAGEMENT LOCAL
datafile '/u01/oradata/HULAND01/system01.dbf' size 400m
DEFAULT TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u01/oradata/HULAND01/TEMP_01.DBF'
SIZE 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k
UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/HULAND01/undo01.dbf' <--
size 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k;
one thing on my init.ora I have as follow:
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
Change the following line in your creation script.
UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/HULAND01/undo01.dbf'
to
UNDO TABLESPACE undotbs1 DATAFILE '/u01/oradata/HULAND01/undo01.dbf'
Amar
"There is a difference between knowing the path and walking the path."
-
thanks for prompt reply.
I did make the change and I run into problem with password file,
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/or
Tue Sep 16 10:23:32 2003
CREATE TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u01/oradata/HULAND01/TEMP_01.DBF'
SIZE 204800k AUTOEXTEND ON NEXT 51201k MAXSIZE 2048000k
Completed: CREATE TEMPORARY TABLESPACE TEMP_01 TEMPFILE '/u0
Tue Sep 16 10:23:32 2003
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_01
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_0
Tue Sep 16 10:23:33 2003
SMON: enabling tx recovery
Tue Sep 16 10:23:35 2003
Errors in file /home/oracle/admin/HULAND01/udump/huland01_ora_18242.trc:
ORA-01501: CREATE DATABASE failed
ORA-01990: error opening password file '/home/oracle/product/9.2.0/dbs/orapw'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Tue Sep 16 10:23:35 2003
Error 1990 happened during db open, shutting down database
USER: terminating instance due to error 1990
Instance terminated by USER, pid = 18242
ORA-1092 signalled during: create database HULAND01
controlfile reuse
I did create the password file and it's there on dbs folder, how come it's still looking for orapw file???
Please tell me how to fix this
Last edited by candyman; 09-16-2003 at 12:23 PM.
-
Your password file should be:
orapw$ORACLE_SID
Also try to comment out
remote_login_passwordfile
from init.ora file first.
After database created, use orapwd to create a new one and change
remote_login_passwordfile to execlusive
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|