联系:手机/微信(+86 17813235971) QQ(107644445)
标题:ksuapc : ORA-1033 foreground process starts before PMON
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
在11.2.0.1数据库中启动出现ksuapc : ORA-1033 foreground process starts before PMON错误
Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =27 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 /opt/oracle/product/11.2.0/dbhome_1/dbs/spfileora11bak.ora System parameters with non-default values: processes = 150 nls_language = "SIMPLIFIED CHINESE" nls_territory = "CHINA" sga_target = 1536M control_files = "/opt/oracle/oradata/ora11bak/control01.ctl" control_files = "/opt/oracle/flash_recovery_area/ora11bak/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/opt/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=ora11bakXDB)" audit_file_dest = "/opt/oracle/admin/ora11bak/adump" audit_trail = "DB" db_name = "ora11bak" open_cursors = 300 pga_aggregate_target = 1595M diagnostic_dest = "/opt/oracle" Fri May 17 05:03:15 2013 ksuapc : ORA-1033 foreground process starts before PMON Fri May 17 05:03:15 2013 ksuapc : ORA-1033 foreground process starts before PMON Fri May 17 05:03:16 2013 ksuapc : ORA-1033 foreground process starts before PMON Fri May 17 05:03:16 2013 ksuapc : ORA-1033 foreground process starts before PMON Fri May 17 05:03:16 2013 ksuapc : ORA-1033 foreground process starts before PMON Fri May 17 05:03:16 2013 ksuapc : ORA-1033 foreground process starts before PMON …………
该错误的原因是数据库在启动过程中有前台进程连接数据库导致,该现象是数据库bug 8991997,该bug影响版本为:11.2.0.1/11.1.0.7,在11.2.0.1.1开始修复