空间管理您的位置: ITPUB个人空间 » benn_wpj的个人空间 » 日志

ora-27123

上一篇 / 下一篇 2008-05-22 15:19:30 / 个人分类：ORA-erroid

ora-27037,ora-27123

startup mount是报如下错误
SQL> ORA-27123: unable to attach to shared memory segment
Linux Error: 22: Invalid argument
Additional information: 1
Additional information: 2496
还有alter database rename ** to ** 是报如下错误
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 6 - new file '/sjg/a.dbf' not found
ORA-01110: data file 6:
'/home/oracle/app/oracle/product/9i/oradata/ora9i/users01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
请问有遇到过这个问题的吗?unixware713,oracle9i

hzawei2004-12-8 09:14

你的ORACLE_SID是不是没有设置？你的SHARED_POOL_SIZE和DATA BUFFER设置了多大？

[ Last edited by hzawei on 2004-12-8 at 09:17 ]

daydayupliq2004-12-8 10:31

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.

第二﹕

調整內核參數shmmax(Linux)