在伺服器增加引數檔案event事件語法錯誤的解決

paulyibinyi發表於2008-01-16
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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-148331/,如需轉載,請註明出處,否則將追究法律責任。

相關文章