| ORA-27102: out of memory [message #553561] |
Sun, 06 May 2012 21:34  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Sir,
Our contractor requested last Friday (May 4, 2012) a database restoration
because of a faulty configurations on their Application server.
After restoration from an April 30, 2012 backup, we can't startup the
database for now, re:
[xserver]:abcxyz>/export/home/oracle>> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 7 08:19:09 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
SQL> exit
Disconnected
What causes this?
Thanks in advance.
alert_abcxyz.log
-----------------------------------------------------------------------
Fri May 04 01:00:27 2012
Thread 1 cannot allocate new log, sequence 2210
Private strand flush not complete
Current log# 1 seq# 2209 mem# 0: /u201/oradata/portal/redo/redo01.log
Thread 1 advanced to log sequence 2210 (LGWR switch)
Current log# 2 seq# 2210 mem# 0: /u401/oradata/portal/redo/redo02.log
Fri May 04 01:00:31 2012
Archived Log entry 2205 added for thread 1 sequence 2209 ID 0xfffffffff722188e dest 1:
Fri May 04 02:00:00 2012
Clearing Resource Manager plan via parameter
Fri May 04 08:13:26 2012
Thread 1 advanced to log sequence 2211 (LGWR switch)
Current log# 3 seq# 2211 mem# 0: /u601/oradata/portal/redo/redo03.log
Fri May 04 08:13:27 2012
Archived Log entry 2206 added for thread 1 sequence 2210 ID 0xfffffffff722188e dest 1:
Fri May 04 15:48:52 2012
Thread 1 cannot allocate new log, sequence 2212
Private strand flush not complete
Current log# 3 seq# 2211 mem# 0: /u601/oradata/portal/redo/redo03.log
Thread 1 advanced to log sequence 2212 (LGWR switch)
Current log# 1 seq# 2212 mem# 0: /u201/oradata/portal/redo/redo01.log
Fri May 04 15:48:55 2012
Archived Log entry 2207 added for thread 1 sequence 2211 ID 0xfffffffff722188e dest 1:
Fri May 04 16:35:14 2012
Shutting down instance (immediate)
Stopping background process SMCO
Starting background process EMNC
Fri May 04 16:35:16 2012
EMNC started with pid=20, OS id=25072
Shutting down instance: further logons disabled
Stopping background process QMNC
Fri May 04 16:35:17 2012
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 470
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Fri May 04 16:35:20 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri May 04 16:35:21 2012
Shutting down archive processes
Archiving is disabled
Fri May 04 16:35:21 2012
ARCH shutting down
Fri May 04 16:35:21 2012
Fri May 04 16:35:21 2012
ARCH shutting downARCH shutting down
ARC1: Archival stoppedFri May 04 16:35:21 2012
ARCH shutting down
ARC0: Archival stoppedARC2: Archival stopped
ARC3: Archival stopped
Thread 1 closed at log sequence 2212
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri May 04 16:35:23 2012
Stopping background process VKTM:
Fri May 04 16:35:27 2012
Instance shutdown complete
Mon May 07 07:54:16 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:04:04 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:06:24 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:06:33 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:07:05 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:16:51 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:19:12 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:23:45 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x0000000060002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:32:10 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x000000007d002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:49:44 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x000000009d002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:52:43 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x000000009d002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 08:59:51 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x000000009d002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 09:00:07 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x000000009d002000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
Mon May 07 09:35:48 2012
Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x00000000bc004000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance
[EDITED by LF: applied [spoiler] tags]
[Updated on: Mon, 07 May 2012 00:02] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
