| Error while creating database on 10.2 enterprise eidition [message #270201] |
Wed, 26 September 2007 02:11  |
|
|
Hi,
When i trying to create database through batch file on oracle version 10.2 enterprise edition, its giving error.
ORA-01092: ORACLE instance terminated. Disconnection forced
Following error message logged in log file:
ORA-00604: error occurred at recursive SQL level 2
ORA-00942: table or view does not exist
Offending statement at line 7032
create unique index apply$_conf_hdlr_columns_unq1
on apply$_conf_hdlr_columns(object_number, column_name)
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 7032
ORA-00604: error occurred at recursive SQL level 2
ORA-00942: table or view does not exist
Content of PFILE:
#
# Basic Initialization Parameters
#
cluster_database=false
compatible=10.1.0.2.0
control_files = ("F:/oracle/oradata/DTO/ctrl01.ctl", "F:/oracle/oradata/DTO/ctrl02.ctl")
db_block_size=8192
# db_create_file_dest # only used in OMF mode
# db_create_online_log_dest_n # only used in OMF mode
db_domain=""
db_name=DTO
db_recovery_file_dest=F:/oracle/oradata/DTO/flash_recovery_area
db_recovery_file_dest_size=2G
db_unique_name=DTO_01
# instance_number # RAC parameter
job_queue_processes=10
# log_archive_dest_n # NOARCHIVELOG mode
# log_archive_dest_state_n # NOARCHIVELOG mode
# nls_language # OS dependant
# nls_territory # OS dependant
open_cursors=50
pga_aggregate_target=10M
processes=50
# remote_listener # RAC parameter
remote_login_passwordfile=EXCLUSIVE
# rollback_segments # UNDO_MANAGEMENT mode
# sessions # derived from processes
sga_target=100M
shared_servers=0
star_transformation_enabled=FALSE
undo_management=AUTO
# undo_tablespace # first UNDO tablespace
#
# Other Parameters
#
background_dump_dest=F:/oracle/admin/DTO/bdump
core_dump_dest=F:/oracle/admin/DTO/cdump
cursor_sharing=SIMILAR
db_file_multiblock_read_count=64
db_files=400
db_writer_processes=2
instance_name=DTO
log_buffer = 8192
log_checkpoint_interval = 10000
log_checkpoint_timeout = 0
os_authent_prefix=""
service_names=DTO
statistics_level=typical
timed_statistics=true
user_dump_dest=F:/oracle/admin/DTO/udump
utl_file_dir=*
Command in batch script:
CONNECT sys/oracle AS SYSDBA
STARTUP NOMOUNT PFILE=&ADMN_DIR/pfile/init&ORA_INST..ora
CREATE DATABASE &ORA_INST
CONTROLFILE REUSE
LOGFILE
GROUP 1 ('&REDO_DIR_1/redo11.log','&REDO_DIR_2/redo12.log') SIZE 10M REUSE,
GROUP 2 ('&REDO_DIR_1/redo21.log','&REDO_DIR_2/redo22.log') SIZE 10M REUSE,
GROUP 3 ('&REDO_DIR_1/redo31.log','&REDO_DIR_2/redo32.log') SIZE 10M REUSE,
GROUP 4 ('&REDO_DIR_1/redo41.log','&REDO_DIR_2/redo42.log') SIZE 10M REUSE
DATAFILE
'&DATA_DIR/syst01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 40M MAXSIZE 2G
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE
'&DATA_DIR/saux01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 40M MAXSIZE 2G
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '&TEMP_DIR/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 2G
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M
UNDO TABLESPACE undo
DATAFILE '&UNDO_DIR/undo01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 2G,
'&UNDO_DIR/undo02.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 2G
CHARACTER SET AL32UTF8
SET TIME_ZONE = 'Europe/Warsaw';
The same script is working fine on Oracle 10.1 Enterprise edition But its giving error on Oracle 10.2 Enterprise edition while creating database.
Please help.
Thanks in advance
[Updated on: Wed, 26 September 2007 07:49] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
