在oracle服务器增加参数文件event事件语法错误的解决
alter system set event="10203 trace name context forever off" scope=spfile
参数需要重启才生效
shutdown immediate
关闭数据库
paul@TEST(192.168.1.117)> startup;
ORA-02194: event specification syntax error 230 (minor error 215) near 'OFF'
报以上错误,一看就知道设置上面这个事件时语法出错
解决方法:
C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on 星期五 9月 14 08:36:05 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

已连接到空闲例程。
> create pfile from spfile;

文件已创建。
然后我们修改pfile文件,去掉这项内容 文件路径放在$ORACLE_HOME\database
下
pfile文件中的内容如下
*.background_dump_dest='d:\oracle\admin\test\bdump'
*.compatible='9.2.0.0.0'
*.control_files='d:\oracle\oradata\test\STDCOTRL.CTL','d:\oracle\oradata\test\STDCOTRL01.CTL'
*.core_dump_dest='d:\oracle\admin\test\cdump'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='test'
*.event='10203 trace name context forever off' --这句就是刚刚添加的参数 去掉,或改为正确的语法都行
*.fal_client='STANDBY'
*.fal_server='PRIMARY'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='test'
*.java_pool_size=0
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=d:\oraarc'
*.log_archive_dest_2='service=standby lgwr sync affirm'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=TRUE
*.log_checkpoint_timeout=60
*.log_checkpoints_to_alert=TRUE
*.open_cursors=300
*.pga_aggregate_target=104857600
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=524288
*.sql_trace=FALSE
*.standby_archive_dest='d:\oraarc'
*.standby_file_management='AUTO'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='d:\oracle\admin\test\udump'
*.utl_file_dir='d:\dba'

然后再创建回spfile文件,数据库能正常启动

> create spfile from pfile;

文件已创建。

已用时间: 00: 00: 01.04
> startup;
ORACLE 例程已经启动。

Total System Global Area 101785252 bytes
Fixed Size 454308 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
数据库已经打开。
> exit