5 Replies Latest reply on Oct 11, 2019 1:12 AM by Beauty_and_dBest

    How to convert spfile to pfile in EBS 12.2.8

    Beauty_and_dBest

      EBS 12.2.8

      12c

      OL6

       

      Hi ALL,

       

      Our database is in spfile  mode.

      How do I convert it to pfile?

      I tried to sql> create pfile from spfile;  but the it won't start by default on pfile.

      Plus the initPROD.ora is not the same format as the autoconfig generated init.ora like below?

       

      cat $ORACLE_HOME/dbs/initP1228.ora

      P1228.__data_transfer_cache_size=0

      P1228.__db_cache_size=1325400064

      P1228.__java_pool_size=33554432

      P1228.__large_pool_size=16777216

      P1228.__oracle_base='/u04/orap1228/P1228/12.1.0'#ORACLE_BASE set from environment

      P1228.__pga_aggregate_target=1073741824

      P1228.__sga_target=2147483648

      P1228.__shared_io_pool_size=117440512

      P1228.__shared_pool_size=620756992

      P1228.__streams_pool_size=16777216

      *._b_tree_bitmap_plans=FALSE# Required 11i setting

      *._fast_full_scan_enabled=FALSE

      *._like_with_bind_as_equality=TRUE

      *._optimizer_autostats_job=false# Turning off auto statistics

      *._sort_elimination_cost_ratio=5

      *._system_trig_enabled=true

      *._TRACE_FILES_PUBLIC=FALSE

      *.aq_tm_processes=1

      *.AUDIT_SYS_OPERATIONS=TRUE

      *.compatible='12.1.0'

      *.control_files='/u04/orap1228/P1228/data/cntrl01.dbf','/u04/orap1228/P1228/data/cntrl02.dbf','/u04/orap1228/P1228/data/cntrl03.dbf'

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

       

       

      Please help...

       

       

      Kind regards,

      jc