ITPub博客

首页 > 数据库 > Oracle > ksuapc : ORA-1033 foreground process starts before PMON

ksuapc : ORA-1033 foreground process starts before PMON

原创 Oracle 作者:tianya_2011 时间:2014-01-17 12:48:27 0 删除 编辑
平台:redhat linux6.0 64bit  + oracle 11.2.0.1

1,在数据库启动过程中alert日志报以下错误:

Starting ORACLE instance (normal)
Tue Jan 22 03:19:10 2013
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Tue Jan 22 03:19:35 2013
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/product/11.2/db_1/dbs/spfileora10g.ora
System parameters with non-default values:
  processes                = 1500
  sessions                 = 2280
  sga_target               = 80G
  memory_target            = 88G
  control_files            = "/oracle/oradata/ora10g/control01.ctl"
  control_files            = "/oracle/oradata/ora10g/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "LOCATION=/oradata1/ora_log"
  log_archive_format       = "%t_%s_%r.dbf"
  db_files                 = 1024
  db_recovery_file_dest    = "/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 10G
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ora10gXDB)"
  audit_file_dest          = "/oracle/admin/ora10g/adump"
  audit_trail              = "DB"
  db_name                  = "ora10g"
  open_cursors             = 300
  diagnostic_dest          = "/oracle"
Tue Jan 22 03:19:36 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:36 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:36 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:36 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:37 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:38 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:38 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:38 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:38 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:38 2013
ksuapc : ORA-1033 foreground process starts before PMON
Tue Jan 22 03:19:38 2013
ksuapc : ORA-1033 foreground process starts before PMON


2,问题分析:

这是oracle的已知8991997. 
影响版本:11.2.0.1/11.1.0.7
该Bug触发的原因是:在数据库启动过程中有前台进程连接数据库。


3,解决方案:

这个问题在以下版本中修复。
12.1.0.1   (Base Release)
11.2.0.2   (Server Patch Set)
11.2.0.1.1 Database Patch Set Update
11.2.0.1   Bundle Patch 4 for Exadata Database
11.2.0.1   Patch 3 on Windows Platforms

参考:MOS文章(Doc ID 8991997.8)

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

请登录后发表评论 登录
全部评论

注册时间:2011-04-11

  • 博文量
    85
  • 访问量
    606635