TSI_DB_SK

Thu Apr 30 21:17:53 MEST 2009
ccbdb2 ccbaq /svc/home/oracle/admin/ccbaq/pfile $ cp -p spfileccbaq.ora spfileccbaq.ora.eric
ccbdb2 ccbaq /svc/home/oracle/admin/ccbaq/pfile $ s+
 
SQL*Plus: Release 9.2.0.8.0 - Production on Thu Apr 30 21:20:08 2009
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Connected to an idle instance.
 
SQL> create pfile='/svc/home/oracle/admin/ccbaq/pfile/initccbaq.eric.ora' from spfile;
 
File created.
 
SQL> exit
 
 
 
ccbdb2 ccbaq /svc/home/oracle/admin/ccbaq/pfile $ more initccbaq.eric.ora
*._kghdsidx_count=1
*.aq_tm_processes=0
*.audit_trail='FALSE'
*.background_dump_dest='/svc/app/oracle/admin/ccbaq/bdump'
*.backup_tape_io_slaves=TRUE
*.compatible='9.2.0.8.0'
*.control_files='/dev/vx/rdsk/oracledg/t3_1_l1_ctl_1_001','/dev/vx/rdsk/oracledg/t3_2_l1_ctl_1_00
1','/dev/vx/rdsk/oracledg/t3_3_l1_ctl_1_001'
*.core_dump_dest='/svc/app/oracle/admin/ccbaq/cdump'
*.db_block_size=8192
*.db_cache_size=10485760000
*.db_domain='WORLD'
*.db_file_multiblock_read_count=8
*.db_files=2000
*.db_name='ccbaq'
*.distributed_lock_timeout=150
*.event='10235 trace name context forever 2'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='ccbaq'
*.java_pool_size=268435456
*.job_queue_processes=0
*.large_pool_size=134217728
*.log_archive_dest_1='location=/svc/app/oracle/admin/ccbaq/arch'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_format='ccbaq_%S.arc'
*.log_archive_start=TRUE
*.max_dump_file_size='500M'
*.open_cursors=4500
*.parallel_max_servers=32
*.pga_aggregate_target=4294967296
*.processes=3000
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=1000000000
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=144000
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/svc/app/oracle/admin/ccbaq/udump'
ccbdb2 ccbaq /svc/home/oracle/admin/ccbaq/pfile $ ls -lrt
 
-- deleted line: *.event='10235 trace name context forever 2'
 
SQL> create spfile = '/svc/home/oracle/admin/ccbaq/pfile/spfileccbaq.ora' from pfile = '/svc/home/oracle/admin/ccbaq/pfile/initccbaq.eric.ora';
 
File created.
 
SQL>
SQL> exit
Disconnected
ccbdb2 ccbaq /svc/home/oracle/admin/ccbaq/pfile $
 
SQL> startup restrict
SQL> shutdown immediate
 
--
you can create pfile or spfile without mounted DB Instance, only with sqlplus  ;-)
 
Eric