when i try the following command
startup force nomount pfile=/Users/oracle/9iR2/orahome/dbs/initab.ora
I am able to get the instance started for a few moments. This is what i see
ORACLE instance started.
Total System Global Area 113873180 bytes
Fixed Size 450844 bytes
Variable Size 92274688 bytes
Database Buffers 20480000 bytes
Redo Buffers 667648 bytes
After a few seconds, the instance crashes and this is what i see in the alert logs.
Wed Nov 26 14:45:48 2003
Starting ORACLE instance (force)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
shared_pool_reserved_size= 4500000
control_files = /Users/oracle/9iR2/orahome/dbs/ctl18.f, /Users/oracle/9iR2/orahome/dbs/ctl28.f, /Users/oracle/9iR2/orahome/dbs/ctl38.f
db_block_buffers = 10000
rollback_segments = system, rback1
db_domain = US.ORACLE.COM
global_names = FALSE
instance_name = ab
service_names = ab.US.ORACLE.COM
db_name = ab
open_cursors = 2000
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Nov 26 14:45:54 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_ckpt_1840.trc:
ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x53EB8D44] [] []
Wed Nov 26 14:46:04 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc:
ORA-00470: LGWR process terminated with error
Wed Nov 26 14:46:04 2003
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 1834
[kapil-khannas-Computer:orahome/rdbms/log] oracle% tail -10000 alert_ab.log
Wed Nov 26 14:45:48 2003
Starting ORACLE instance (force)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
shared_pool_reserved_size= 4500000
control_files = /Users/oracle/9iR2/orahome/dbs/ctl18.f, /Users/oracle/9iR2/orahome/dbs/ctl28.f, /Users/oracle/9iR2/orahome/dbs/ctl38.f
db_block_buffers = 10000
rollback_segments = system, rback1
db_domain = US.ORACLE.COM
global_names = FALSE
instance_name = ab
service_names = ab.US.ORACLE.COM
db_name = ab
open_cursors = 2000
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Nov 26 14:45:54 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_ckpt_1840.trc:
ORA-07445: exception encountered: core dump [semop+8] [SIGFPE] [Invalid floating point operation] [0x53EB8D44] [] []
Wed Nov 26 14:46:04 2003
Errors in file /Users/oracle/9iR2/orahome/rdbms/log/ab_pmon_1834.trc:
ORA-00470: LGWR process terminated with error
Wed Nov 26 14:46:04 2003
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 1834
|
