Cannot start oracle database: multiple errors -
i have 3 oracle dbs installed on server separate user. 3 working until server reboot. after wasn't able start database , not able execute other command.
$ sqlplus / sysdba sql*plus: release 11.2.0.1.0 production on wed oct 26 04:53:30 2016 copyright (c) 1982, 2009, oracle. rights reserved. connected idle instance. sql> shutdown abort oracle instance shut down. sql> startup mount ora-03113: end-of-file on communication channel sql> shutdown abort ora-24324: service handle not initialized ora-01041: internal error. hostdef extension doesn't exist sql> startup ora-24324: service handle not initialized ora-01041: internal error. hostdef extension doesn't exist sql querires give:
error: ora-03114: not connected oracle and connecting sqldeveloper gives
an error encountered performing requested operation: ora-01034: oracle not available ora-27101: shared memory realm not exist linux-x86_64 error: 2: no such file or directory 01034. 00000 - "oracle not available" *cause: oracle not started up. possible causes include following - sga requires more space allocated it. - operating-system variable pointing instance improperly defined. *action: refer accompanying messages possible causes , correct problem mentioned in other messages. if oracle has been initialized, on operating systems, verify oracle linked correctly. see platform specific oracle documentation. vendor code 1034 how startup database , recover data. able start listener using lsnrctl start. , working fine.
alert log file::
sun oct 16 06:00:01 2016 begin automatic sql tuning advisor run special tuning task "sys_auto_sql_tuning_task" end automatic sql tuning advisor run special tuning task "sys_auto_sql_tuning_task" sun oct 16 06:00:16 2016 thread 1 cannot allocate new log, sequence 203 private strand flush not complete current log# 1 seq# 202 mem# 0: /home/oracle/data/datafiles/db/redo01.log thread 1 advanced log sequence 203 (lgwr switch) current log# 2 seq# 203 mem# 0: /home/oracle/data/datafiles/db/redo02.log sun oct 16 18:05:38 2016 thread 1 advanced log sequence 204 (lgwr switch) current log# 3 seq# 204 mem# 0: /home/oracle/data/datafiles/db/redo03.log mon oct 17 02:00:00 2016 clearing resource manager plan via parameter mon oct 17 06:00:04 2016 thread 1 advanced log sequence 205 (lgwr switch) current log# 1 seq# 205 mem# 0: /home/oracle/data/datafiles/db/redo01.log mon oct 17 22:00:00 2016 setting resource manager plan scheduler[0x3003]:default_maintenance_plan via scheduler window setting resource manager plan default_maintenance_plan via parameter mon oct 17 22:00:00 2016 starting background process vkrm mon oct 17 22:00:00 2016 vkrm started pid=21, os id=29144 mon oct 17 22:00:00 2016 begin automatic sql tuning advisor run special tuning task "sys_auto_sql_tuning_task" end automatic sql tuning advisor run special tuning task "sys_auto_sql_tuning_task" mon oct 17 22:00:28 2016 thread 1 cannot allocate new log, sequence 206 private strand flush not complete current log# 1 seq# 205 mem# 0: /home/oracle/data/datafiles/db/redo01.log thread 1 advanced log sequence 206 (lgwr switch) current log# 2 seq# 206 mem# 0: /home/oracle/data/datafiles/db/redo02.log mon oct 17 22:30:25 2016 thread 1 advanced log sequence 207 (lgwr switch) current log# 3 seq# 207 mem# 0: /home/oracle/data/datafiles/db/redo03.log tue oct 18 02:00:00 2016 clearing resource manager plan via parameter tue oct 25 11:22:27 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] tue oct 25 14:40:20 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] tue oct 25 14:53:23 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] tue oct 25 15:10:00 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] tue oct 25 15:34:28 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] wed oct 26 01:49:06 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] wed oct 26 01:49:34 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] wed oct 26 03:17:52 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] wed oct 26 04:01:42 2016 starting oracle instance (normal) exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d566cd, {empty}] [flags: 0x8, count: 2] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 3] exception [type: sigbus, non-existent physical address] [addr:0xec8910] [pc:0x6d53dad, {empty}] [flags: 0xa, count: 4] edit: (addition) set , working before server reboot. working 3+ months , have started , shut off database many times. working until time.
as others suggest, broad issue answer. off-hand, looks unix environment not correct database(s) in question. minimum, oracle_home , oracle_sid need set. databases need proper initialization files defined, etc, etc.
Comments
Post a Comment