ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: internal error code, arguments: [kspsetpao1], [1289], [1242], [*], [u

ORA-00600: internal error code, arguments: [kspsetpao1], [1289], [1242], [*], [u

原创 Linux操作系统 作者:fengjin821 时间:2009-06-14 15:12:25 0 删除 编辑

在同一台Server上创建Physical Standby Database,在使用pfile创建spfile时候出现错误.

SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kspsetpao1], [1289], [1242], [*],
[user_dump_dest], [27], [], []


SQL> create spfile from pfile='/u01/product/oracle/dbs/initdg.ora';
create spfile from pfile='/u01/product/oracle/dbs/initdg.ora'
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kspsetpao1], [1289], [1242], [*],
[user_dump_dest], [27], [], []


alert log:

Fri Oct 5 14:25:37 2007
Errors in file /u01/product/admin/dg/udump/dg_ora_4935.trc:
ORA-00600: internal error code, arguments: [kspsetpao1], [1289], [1242], [*], [user_dump_dest], [27], [], []
Fri Oct 5 14:25:59 2007
Errors in file /u01/product/admin/dg/udump/dg_ora_4935.trc:
ORA-00600: internal error code, arguments: [kspsetpao1], [1289], [1242], [*], [user_dump_dest], [27], [], []

dg_ora_4935.trc:

pceit-rac2$cat /u01/product/admin/dg/udump/dg_ora_4935.trc | more
/u01/product/admin/dg/udump/dg_ora_4935.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /u01/product/oracle
System name: Linux
Node name: pceit-rac2
Release: 2.4.21-4.ELsmp
Version: #1 SMP Fri Oct 3 17:52:56 EDT 2003
Machine: i686
Instance name: dg
Redo thread mounted by this instance: 0
Oracle process number: 12
Unix process pid: 4935, image:
oracle@pceit-rac2 (TNS V1-V3)

*** 2007-10-05 14:25:37.723
*** SESSION ID:(9.1) 2007-10-05 14:25:37.722
kspdmpsetpctx: ibufsiz:[1257] obufsiz:[1289] ooffset:[1242]
kspdmpsetpctx: sid:[*] param:[remote_archive_enable] vallen:[6] value:['TRUE']
kspdmpsetpctx: ibuf:
*.background_dump_dest='/u01/product/admin/dg/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/product/oradata/dg/control01.ctl','/u01/product/oradata/dg/control02.ctl','/u01/product/oradata/dg/co
ntrol03.ctl'
*.core_dump_dest='/u01/product/admin/dg/cdump'
*.db_block_size=8192
*.db_cache_size=117440512
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/u01/product/oradata/rman/','/data/product/oradata/dg/','/data/rman/','data/dg/'
*.db_name='rman'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dgXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='dg'
*.java_pool_size=33554432
*.large_pool_size=28311552
*.log_archive_dest_1='LOCATION=/data/dg/arch'
*.log_archive_format='%t_%s.arc'
*.log_archive_start=true
*.log_file_name_convert='/u01/product/oradata/rman/','/u01/product/oradata/dg/''
*.open_cursors=300
*.pga_aggregate_target=103809024

使用的pfile: initdg.ora:

*.background_dump_dest='/u01/product/admin/dg/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/product/oradata/dg/control01.ctl','/u01/product/oradata/dg/control02.ctl','/u01/product/oradata/dg/control03.ctl'
*.core_dump_dest='/u01/product/admin/dg/cdump'
*.db_block_size=8192
*.db_cache_size=117440512
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='rman'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dgXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='dg'
*.java_pool_size=33554432
*.large_pool_size=28311552
*.log_archive_dest_1='LOCATION=/data/dg/arch'
*.log_archive_format='%t_%s.arc'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=103809024
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=38797312
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/product/admin/dg/udump'
*.standby_archive_dest='/data/dg/arch'
*.db_file_name_convert=('/u01/product/oradata/rman/','/data/product/oradata/dg/','/data/rman/','data/dg/')
*.log_file_name_convert=('/u01/product/oradata/rman/',/u01/product/oradata/dg/')#*.standby_file_management='AUTO'
*.remote_archive_enable=TRUE
*.lock_name_space=dg

仔细看下,错误出现的原因不在于remote_archive_enable参数设置,而在于之前的log_file_name_convert初始化参数设置的问题,少写了一个';

修改该参数设置后,create spfile from pfile执行OK.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13165828/viewspace-606281/,如需转载,请注明出处,否则将追究法律责任。

下一篇: lsnrctl中设置口令
请登录后发表评论 登录
全部评论

注册时间:2009-04-29

  • 博文量
    191
  • 访问量
    505109