Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I have trouble with RECYCLE-BIN in 10g
The strange thing is I have no error even
when my compatible is set to 8.1.6.0 (this is in my original
initINSTANCE_NAME.ora file)
when I try to startup.
That is still very strange:
The following is my initSCHEMA_NAME.ora file:
===
*._trace_files_public=true# allows .trc files to be publicly readable
*.background_dump_dest='/x02/oracle/admin/DDDTEST2/bdump'
*.compatible='10.1.0'# change for upgrade
*.control_files='/local4/oracle/oradata/DDDTEST2/control01.ctl','/local4/oracle/oradata/DDDTEST2/control02.ctl','/local4/oracle/oradata/DDDTEST2/control03.ctl'
*.core_dump_dest='/x02/oracle/admin/DDDTEST2/cdump'
*.db_block_buffers=1000# LARGE
*.db_block_size=8192
*.db_domain='ga'
*.db_file_multiblock_read_count=8
*.db_files=80# ??? # SMALL
*.db_flashback_retention_target=1440
*.db_name='DDDTEST2'
*.db_recovery_file_dest_size=5242880000
*.db_recovery_file_dest='/local4/oracle/oradata/DDDTEST2_flash'
*.dispatchers='(address=(protocol=tcp)(host=dddtest2.db.companyabc.com))(dispatchers=5)'
*.instance_name='DDDTEST2'
*.java_pool_size=67108864# change for upgrade
*.job_queue_processes=0
*.large_pool_size=49152000
*.local_listener='LISTENER_DDDTEST2'
*.log_archive_dest_1='location=/local4/oracle/oradata/DDDTEST2/arch'
*.log_archive_dest_2='location=use_db_recovery_file_dest'
*.log_archive_format='arch_%t_%s_%r.arc'
*.log_buffer=32768# MEDIUM
*.log_checkpoint_interval=40000
*.log_checkpoint_timeout=1800
*.max_dispatchers=7
*.max_dump_file_size='10000'# limit trace file size to 5M each
*.max_shared_servers=100
*.NLS_DATE_FORMAT='YYYY-MM-DD'
*.open_cursors=50
*.open_links=4
*.os_authent_prefix=''
*.pga_aggregate_target=25165824# change for upgrade
*.processes=50# SMALL
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='exclusive'# Dominica change it temporary
*.service_names='DDDTEST2'
*.session_cached_cursors=1000
*.session_max_open_files=30# change for upgrade
*.shared_pool_size=193327104# change for upgrade
*.shared_servers=20
*.sort_area_retained_size=50000
*.sort_area_size=500000
*.streams_pool_size=50331648# change for upgrade
*.timed_statistics=true# if you want timed statistics
*.undo_management='auto'# 10g
*.undo_retention=1000# 10g
*.undo_tablespace='undo_tbs1'# 10g
*.user_dump_dest='/x02/oracle/admin/DDDTEST2/udump'
*.utl_file_dir='/local4/oracle/web/utlFileDir/upload','/local4/oracle/web/utlFileDir/download','/local4/oracle/web/utlFileDir/system'
Received on Wed Feb 08 2006 - 13:46:59 CST