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???

Show the database creation script. Did you mention the 'create undo tablespace' command to create the undo tablespace ??

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

Quote:

---

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'

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

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