change in parameter file in step 17

[oraascp@TJPSB007 dbs]$ cat initASC.ora

*._b_tree_bitmap_plans=FALSE# Required 11i setting

*._fast_full_scan_enabled=FALSE

*._like_with_bind_as_equality=TRUE

*._optimizer_autostats_job=TRUE

*._sort_elimination_cost_ratio=5

*._sqlexec_progression_cost=147483647

*._system_trig_enabled=true

*._trace_files_public=TRUE

*.aq_tm_processes=1

*.compatible='11.2.0'

*.control_files='/ASCPPROD_DB/oracle/product/ASCPCRP/db/crpdata/data/cntr01.dbf','/ASCPPROD_DB1/ascpcrp/data/cntr02.dbf','/ASCPPROD_DB/oracle/product/ASCPCRP/db/crpdata/data/cntr03.dbf'

*.cursor_sharing='EXACT'# Required 11i settting

*.db_block_checking='FALSE'

*.db_block_checksum='TRUE'

*.db_block_size=8192

*.db_file_multiblock_read_count=8# Required 11i setting

*.db_files=512# Max. no. of database files

*.db_name='ASC'

*.db_unique_name='ASCC'

#*.diagnostic_dest='/ASCPPROD_DB/oracle/adr'----MAKE THIS COMMENTED

*.dml_locks=10000

*.java_pool_size=57286400---MAKE THIS SOME WHAT LOW 157MB TO 57MB

*.job_queue_processes=12

*.log_buffer=10485760--CHECK ALSO SIZE .IT IS AS IT IS.

*.log_checkpoint_interval=100000

*.log_checkpoint_timeout=1200# Checkpoint at least every 20 mins.

*.log_checkpoints_to_alert=FALSE

*.max_dump_file_size='20480'# trace file size

*.memory_max_target=1G---MMAKE AS 1 OR 2 GB

*.memory_target=1G----MAKE AS 1 OR 2 GB

*.nls_comp='binary'# Required 11i setting

*.nls_date_format='DD-MON-RR'

*.nls_language='american'

*.nls_length_semantics='BYTE'# Required 11i setting

*.nls_numeric_characters='.,'

*.nls_sort='binary'# Required 11i setting

*.nls_territory='america'

*.olap_page_pool_size=57286400----MAKE FROM 157MB TO 57MB

*.open_cursors=600# Consumes process memory, unless using MTS.

*.optimizer_secure_view_merging=false

*.parallel_max_servers=8

*.parallel_min_servers=0

*.pga_aggregate_target=2G---NAKE FROM 4GB TO 2GB

*.plsql_code_type='INTERPRETED'# Default 11i setting

*.plsql_optimize_level=2# Required 11i setting

*.processes=200# Max. no. of users x 2----SET AS 200 FROM 1200

*.resource_manager_plan=''

*.session_cached_cursors=500

*.sessions=400# 2 X processes----SET AS 400 FROM 2400

*.sga_target=0

*.shared_pool_reserved_size=400M

*.shared_pool_size=2G----CHANGED TO 2 GB

*.standby_file_management='AUTO'

*.sec_case_sensitive_logon=false

*.timed_statistics=true

*.undo_management='AUTO'# Required 11i setting

*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting

*.utl_file_dir='/usr/tmp','/usr/tmp','/ASCPPROD_DB/oracle/product/ASCPCRP/db/tech_st/11.2.0/appsutil/outbound/ASCPCRP_tjtgb006','/usr/tmp'

*.workarea_size_policy='AUTO'# Required 11i setting

##*.db_file_multiblock_read_count=8

　

　

===================================================================================

　

ERROR:

　

SQL> startup nomount pfile='/GSTDB/app/oraascp/db/11.2.0/dbs/initASC.ora';

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 4384M

ORA-01078: failure in processing system parameters

　

ORA-00838: Specified value of MEMORY_TARGET is too small,

　

　

　

　

SQL> startup

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 4384M

　

make your calculation 4384*1024*1024 = 4596957184

*.memory_max_target=4596957184

*.memory_target=4596957184

or SET AS 5G

*.memory_max_target=5G

*.memory_target=5G

　

　

SQL > create pfile='/u02/backup.init' from spfile;

edit file and put the above number in memory_target.

SQL > Create spfile from pfile='/u02/backup.init' ;

QL > Startup ;

　

==========================================

2.

　

SQL> alter database mount;

alter database mount

*

ERROR at line 1:

ORA-00205: error in identifying control file, check alert log for more info

chnage VALUE FROM EXISTING SERVER;

　

　

FROM

　

*.compatible='11.2.0'

*.control_files='/GSTDB/app/oraascp/oradata/ASCP/cntrl01.dbf','/GSTDB/app/oraascp/oradata/ASCP/cntrl02.dbf','/GSTDB/app/oraascp/oradata/ASCP/cntrl03.dbf'

　

　

TO

/GSTDB/app/oraascp/oradata/ASCP/

cntrl01.dbf

cntrl02.dbf

cntrl03.dbf