"HARI OM" <hari_om_at_hotmail.com> wrote in message
news:1109710896.369730.34780_at_z14g2000cwz.googlegroups.com...
> 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'
Hmmm. The parameters appear to be in alphabetical order. Curious that it
would begin with q_tm_processes. But wait... Isn't that the parameter that
Oracle said is unknown? Suppose there might be a connection?
Received on Tue Mar 01 2005 - 16:11:48 CST
