Home » RDBMS Server » Server Administration » Error while creating database on 10.2 enterprise eidition
Error while creating database on 10.2 enterprise eidition [message #270201] Wed, 26 September 2007 02:11 Go to next message
fantooshguy23
Messages: 2
Registered: September 2007
Location: sf
Junior Member

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

Re: Error while creating database on 10.2 enterprise eidition [message #270208 is a reply to message #270201] Wed, 26 September 2007 02:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 7032


Check this file.
Re: Error while creating database on 10.2 enterprise eidition [message #270210 is a reply to message #270208] Wed, 26 September 2007 02:47 Go to previous message
fantooshguy23
Messages: 2
Registered: September 2007
Location: sf
Junior Member

I checked this file but did not find anything wrong..

The same scripts are working fine with Oracle 10.1 enterprose edition. But give error on Oracle 10.2.
Previous Topic: Trace.log in directory $ORACLE_BASE/admin/SID/core
Next Topic: Trying to putinto archivelog mode-shutdown and can't restart
Goto Forum:
  


Current Time: Sat Dec 10 14:27:38 CST 2016

Total time taken to generate the page: 0.28761 seconds