Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I have trouble with RECYCLE-BIN in 10g

Re: I have trouble with RECYCLE-BIN in 10g

From: <dominica_at_gmail.com>
Date: 8 Feb 2006 11:46:59 -0800
Message-ID: <1139428019.202423.152900@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US