HOME   ·Î±×ÀΠ  ȸ¿ø°¡ÀÔ
    
ȸ¿ø°¡ÀÔ
ºñ¹Ð¹øÈ£ ã±â ÀÚµ¿·Î±ä
ÀÌÀü°Ô½ÃÆÇ
   free_board
   °Ç°­°Ô½ÃÆÇ
   ¿À¶óŬDB
   Linux
   HTML/javascript
   Áú¹®°ú ´ä
È£¼­±â
   À̹ÌÁö°Ô½ÃÆÇ  
   °Ç°­°Ô½ÃÆÇ  
   À½¾ÇÀÚ·á  
   ¼ºÁØÀÌ °Ô½ÃÆÇ  
[ÀϹÝ] ORA-27123 ¿¡·¯ ¸ÞŸ¸µÅ© ÂüÁ¶
  È£¼® ´Ô²²¼­ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 ÀÐÀ½:4118  
Subject:  ORA-27123 During Startup, Immediately after a Shutdown
  Doc ID:  Note:250966.1 Type:  PROBLEM
  Last Revision Date:  02-JUL-2004 Status:  PUBLISHED


The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0
This problem can occur on any platform.

Errors
ORA-27123

Symptoms

Startup of database fails
Startup done immediately after shutdown from SQL*Plus
ORA-27123:unable to attach to shared memory segment
Linux error :22: Invalid argument
Additional information:1
Additional information:2457610

Cause

Oracle did not shutdown cleanly and could not attach to shared memory segments upon startup
Fix
- Restart your SQL*Plus session after shutdown.
OR..
- Remove shared memory and semaphores using

ipcs -mt
to list shared memory segments and

ipcs -st
to list semaphores to be removed.

Then remove them using
ipcrm -m (shared memory id)
ipcrm -s (semaphore id)
Where id is the ID of the shared memory segment and semaphores to be removed respectively.


¸ñ·Ï

ºÐ·ù ¼±ÅÃ
79 ÀÏ¹Ý oracle10g + php5.1.2 error [OCIEnvNlsCreate() failed] È£¼® 07-04-27 7111
78 ÀÏ¹Ý [sql] select case when then ¸¦ ÀÌ¿ëÇÑ Äõ¸®¹® È£¼® 07-04-26 5946
77 ÀÏ¹Ý ¿À¶óŬ¿¡¼­ ÀÓÀÇ·Î ¹üÀ§ÀÇ ³¯Â¥¸¦ °¡Á®¿À´Â Äõ¸®¹® È£¼® 07-04-05 3921
76 ÀÏ¹Ý undotbs01°¡ ³Ê¹« Ä¿Á³À» °æ¿ì ÃʱâÈ­ ¿À¶óŬ 9i È£¼® 07-04-04 4777
75 ÀÏ¹Ý [Æß]·Ñ¹é ¼¼±×¸ÕÆ® , ÅÛÆ÷·¯¸® ¼¼±×¸ÕÆ® ´Ù·ç±â È£¼® 07-04-04 3949
74 ÀÏ¹Ý decode È°¿ëÄõ¸® ºñ±³¿¬»êÀÚ ´ë¿ë sign() È£¼® 07-03-29 4291
73 ÀÏ¹Ý ¿À¶óŬ Ä¿³Î shared max °ª Àû¿ëÇϱâ È£¼® 07-03-26 3635
72 ÀÏ¹Ý ORU-10027 ¿¡·¯ -> dbms_output.enable('10000000000') »ç¿ë È£¼® 07-03-19 3782
ÀÏ¹Ý ORA-27123 ¿¡·¯ ¸ÞŸ¸µÅ© ÂüÁ¶ È£¼® 07-03-19 4119
70 ÀÏ¹Ý RHEL4 ¸®´ª½º¿¡¼­ ¿À¶óŬ¼³Ä¡ ¡Ú¡Ú¡Ú¡Ú¡Ú (1) È£¼® 07-03-09 4215
69 ÀÏ¹Ý ¿À¶óŬ¿¡¼­ pfile°ú spfileÀÇ Æ¯Â¡ È£¼® 07-03-09 3933
68 ÀÏ¹Ý ¿À¶óŬ À妽º ÀÛ¼º ±ÔÄ¢ ORACLE È£¼® 07-02-15 4384
67 ÀÏ¹Ý ¿À¶óŬ »ç¿ëÀÚ¼öº° ÆĶó¹ÌÅÍ ¼³Á¤°ª È£¼® 07-02-10 3731
66 ÀÏ¹Ý MYSQL manual Çѱ۹ø¿ª(260k) È£¼® 07-02-10 4930
65 ÀÏ¹Ý [Æ©´×] °è¼Ó swap paging ¹ß»ý½Ã¿¡ È£¼® 07-02-09 3961
óÀ½ÀÌÀü  [1] [2] [3] [4] 5 [6] [7] [8] [9] [10]  ´ÙÀ½¸Ç³¡

 
Copyright © zenos.pe.kr. All rights reserved.