Re: Creating PFILE from SPFILE with *.

Thanks Dave.

I started using pfile option....
SQL> startup pfile='$ORACLE_HOME/dbs/inittest.ora'

but get following errors...
LRM-00101: unknown parameter name 'q_tm_processes' ORA-01078: failure in processing system parameters SQL> Here are the contents of my INITTEST.ORA file:

*.q_tm_processes=1
*.background_dump_dest='/usr/local/oracle/OraHome1/admin/test/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/data/test/cfile/control02.ctl','/dict/test/cfile/control01.ctl','/usr/local/oracle/OraHome1/oradata/test/control03.ctl'
*.core_dump_dest='/usr/local/oracle/OraHome1/admin/test/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='test'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='test'
*.java_pool_size=155189248
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=377487360
*.shared_pool_size=157286400
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/usr/local/oracle/OraHome1/admin/test/udump'
Received on Tue Mar 01 2005 - 15:01:36 CST