| database [message #312] |
Tue, 05 February 2002 04:17  |
bina
Messages: 10
Registered: December 2001
|
Junior Member |
|
|
hello,
my database creation fails reasons
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%RDBMS80%ADMINSQL.BSQ' near line 856
ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment number 0
ORA-00600: internal error code, arguments: [[ktsxsgin6]], [[0]], [[1]], [[2]], [[1403]], [[
]], [[]], [[]]
please help me.
|
|
|
|
| Re: database [message #341 is a reply to message #312] |
Wed, 06 February 2002 05:00  |
Armani D
Messages: 19
Registered: February 2002
|
Junior Member |
|
|
Hi bina,
How many Rollback segments do you have? Make sure that you have adequate rollback segments and that they are online before you execute the create database commad.
I have attahced a create_database script I used and works fine. Use it a sa guideline:
spool $ORALOG/sav/rcat_db_create.log
connect internal
startup nomount pfile=$ORACLE_HOME/dbs/initrcat.ora
create database "rcat" controlfile reuse
character set "WE8ISO8859P1"
national character set "WE8ISO8859P1"
datafile
'$ORAD06/system_01.dbf' size 60M
logfile
group 1 ('$ORAD03/log_1a.ora',
'$ORAD04/log_1b.ora') size 2M,
group 2 ('$ORAD03/log_2a.ora',
'$ORAD04/log_2b.ora') size 2M,
group 3 ('$ORAD03/log_3a.ora',
'$ORAD04/log_3b.ora') size 2M
maxdatafiles 249
maxlogfiles 32
maxlogmembers 5
noarchivelog
;
set echo off feedback off termout off verify off
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
set echo on feedback on termout on verify on
create rollback segment rbs_temp storage (initial 512k next 256k optimal 1024k) ;
alter rollback segment rbs_temp online ;
create tablespace rollback1
datafile '$ORAD05/rollback1_01.dbf' size 10m
default storage (
initial 10k
next 10k
minextents 1
maxextents unlimited
pctincrease 0)
;
create rollback segment rs_1 storage (optimal 50k) tablespace rollback1 ;
alter rollback segment rs_1 online ;
create rollback segment rs_2 storage (optimal 50k) tablespace rollback1 ;
alter rollback segment rs_2 online ;
create rollback segment rs_3 storage (optimal 50k) tablespace rollback1 ;
alter rollback segment rs_3 online ;
create rollback segment rs_4 storage (optimal 50k) tablespace rollback1 ;
alter rollback segment rs_4 online ;
alter rollback segment rbs_temp offline ;
drop rollback segment rbs_temp ;
create tablespace rcvcat
datafile '$ORAD07/rcvcat_01.dbf' size 15M
default storage (
initial 16k
next 16k
minextents 1
maxextents unlimited
pctincrease 0)
;
create tablespace oem_repository
datafile '$ORAD09/oem_repository_01.dbf' size 200M reuse
default storage (
initial 32K
next 16K
minextents 1
maxextents unlimited
pctincrease 0)
;
create tablespace temp
datafile '$ORAD06/temp_01.dbf' size 10M
default storage (
initial 10k
next 10k
minextents 1
maxextents unlimited
pctincrease 1)
temporary
;
connect system/manager
set echo off feedback off termout off verify off
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
set echo on feedback on termout on verify on
alter user sys temporary tablespace temp;
alter user system temporary tablespace temp;
create user rman identified by rman
default tablespace rcvcat temporary tablespace temp;
grant recovery_catalog_owner to rman ;
grant dba, connect, resource to rman ;
grant sysdba to rman;
commit;
spool off;
exit;
|
|
|
|
| Re: database [message #380 is a reply to message #312] |
Fri, 08 February 2002 07:41 |
bina
Messages: 10
Registered: December 2001
|
Junior Member |
|
|
hi Armani,
thanku for the answer and sorry for being late.
I have a single rbs.
1. why is it necessary to have more than one rbs.
2.please explain
"set echo off feedback off termout off verify off"
3. is this script for psora8.
bina
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
