服务器是solaris9,数据库是oracle9i,原pfile文件内容如下:
oracle datbase two
*.aq_tm_processes=1
*.background_dump_dest='/home/oracle/admin/orcl/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/home/oracle/oradata/orcl/control01.ctl','/home/oracle/oradata/orcl/control02.ctl','/home/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/home/oracle/admin/orcl/cdump'
*.db_block_buffers=131072
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.fast_start_mttr_target=300
*.instance_name='orcl'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=268435456
*.open_cursors=300
*.pga_aggregate_target=1054867456
*.processes=100
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='NONE'
*.shared_pool_size=858993459
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/home/oracle/admin/orcl/udump'
该数据库运行后,总是在/home/oracle/admin/orcl/udump/目录下产生类似orcl_ora_23112.trc这样的后缀为.trc的文件。网上查找后,说是sql_trace设置为true,产生的跟踪文件。我把pfile文件中增加了*.sql_trace='FALSE'语句后,重新导入数据库为spfile文件,重起服务后,仍然产生后缀为.trc文件,不知道这是为什么?请哪位大侠指点一下,谢谢!
oracle datbase two
*.aq_tm_processes=1
*.background_dump_dest='/home/oracle/admin/orcl/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/home/oracle/oradata/orcl/control01.ctl','/home/oracle/oradata/orcl/control02.ctl','/home/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/home/oracle/admin/orcl/cdump'
*.db_block_buffers=131072
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.fast_start_mttr_target=300
*.instance_name='orcl'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=268435456
*.open_cursors=300
*.pga_aggregate_target=1054867456
*.processes=100
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='NONE'
*.shared_pool_size=858993459
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/home/oracle/admin/orcl/udump'
该数据库运行后,总是在/home/oracle/admin/orcl/udump/目录下产生类似orcl_ora_23112.trc这样的后缀为.trc的文件。网上查找后,说是sql_trace设置为true,产生的跟踪文件。我把pfile文件中增加了*.sql_trace='FALSE'语句后,重新导入数据库为spfile文件,重起服务后,仍然产生后缀为.trc文件,不知道这是为什么?请哪位大侠指点一下,谢谢!
sql> alter system set sql_trace=false;
用sys登录进去,alter后最好重启下数据库。
/home/oracle/admin/orcl/udump/orcl_ora_23112.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/product/10g
System name: SunOS
Node name: dbsvr2
Release: 5.9
Version: Generic_122300-08
Machine: sun4u
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 23112, image: oracleorcl@dbsvr2*** SERVICE NAME:(orcl) 2009-12-14 03:03:05.059
*** SESSION ID:(89.7927) 2009-12-14 03:03:05.059
oer 8102.2 - obj# 10202, rdba: 0x0140a675(afn 5, blk# 42613)
kdk key 8102.2:
ncol: 1, len: 13
key: (13): 0c 4b 68 6a 33 35 30 32 56 6e 20 20 20
mask: (4096):
01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00
看下改的生效没有
sqlplus /nolog
connect /as sysdba
alter system set sql_trace = 'FALSE';
commit;
exit
然后再重启服务对吧?
然后报这个错误 ORA-00922: missing or invalid option,请问应该怎么处理?
sqlplus /nolog
connect /as sysdba
alter system set sql_trace = 'FALSE' scope=both;重起数据库后才能生效
sqlplus /nolog
connect /as sysdba
alter system set sql_trace = 'FALSE' scope=spfile楼主请试试