ORACLE 11g 一次ORA-27125 Linux-x86_64 Error
ORACLE 11g 一次ORA-27125 Linux-x86_64 Error
啟動資料庫報錯如下:
SQL> startup
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 589825
Additional information: 2
檢視METALINK 0RA-27125無果,檢視/etc/sysctl.conf沒有問題,然後檢視/dev/shm發現許可權不對,
然後用chmod 777賦予所有許可權,然後啟動資料庫,資料庫啟動不再報錯,但是停頓在startup,檢視
日誌沒有發現報錯,一直在startup(nomarl)就沒有記錄日誌了,不得已shutdown abort
然後再次df -Tk 發現盡然/dev/shm 的檔案型別是ext3 而且掛載的裝置是/dev/sdc1
[grid@rac2 ~]$ df -Tk
Filesystem Type 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
ext3 56848636 15510084 38404180 29% /
/dev/sda1 ext3 101086 12606 83261 14% /boot
/dev/sdc1 ext3 4127076 277392 3640040 8% /dev/shm
正常的情況下檔案型別應該是如下
[root@rac2 ~]# df -Tk
Filesystem Type 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
ext3 56848636 15538780 38375484 29% /
/dev/sda1 ext3 101086 12606 83261 14% /boot
tmpfs tmpfs 2097152 694920 1402232 34% /dev/shm
檔案型別和掛載點都是tmpfs,然後檢視fstab確實有人為的把/dev/sdc1掛載到了/dev/shm上。最後修改回來後正常啟動,
至於為什麼會啟動很慢,/dev/sdc1是物理磁碟分割槽,是物理讀寫。而tmpfs是記憶體讀寫。那速度能一樣嗎??
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7728585/viewspace-753088/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【ERROR】ORA-27125Error
- Linux-x86_64 Error: 28: No space left on device問題LinuxErrordev
- Oracle報錯"ORA-01034 ORA-27101 Linux-x86_64 Error"OracleLinuxError
- oracle 11g expdb autoextend tablespace and create directory error;OracleError
- Linux-x86_64 Error: 30: Read-only file systemLinuxError
- 啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space leftOracleLinuxError
- 一次磁碟變成readonly問題的解決 Linux-x86_64 Error: 30: Read-only file systemLinuxError
- Oracle® Database Error Messages 11g Release 2 (11.2)OracleDatabaseError
- ORA-09187、linux-x86_64 Error:28 AND ORA-09945LinuxError
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on deviceLinuxErrordev
- Oracle 10.2.0.5 DBCA建庫報錯ORA-27125Oracle
- 超過最大檔案數—Linux-x86_64 Error: 23: Too many open files in systemLinuxError
- startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on deviceLinuxErrordev
- ORA-27102:out of memory Linux-x86_64 Error: 12: Cannot allocate memory的處理LinuxError
- ORACLE STREAM ERROROracleError
- 【Oracle】Linux7安裝11g Error in invoking target 'agent nmhs' of makefileOracleLinuxError
- oracle 11g使用DML Error Logging來避免bulk insert故障OracleError
- 一次oracle 11g 資料泵 報錯 的解決過程Oracle
- linux 5.6 ORA-27125Linux
- OCP(11g)------> SEC_PROTOCOL_ERROR_FURTHER_ACTIONProtocolError
- oracle 11gOracle
- ORA-27125錯誤解決
- Oracle XA Exception error codeOracleExceptionError
- oracle之啟動errorOracleError
- 【Oracle】Linux7安裝11g 86%報錯:Error in invoking target 'agent nmhs' of makefileOracleLinuxError
- oracle 11g acfsOracle
- oracle 11g dataguardOracle
- WebServices in Oracle 11gWebOracle
- Oracle 11g報錯"ORA-12012: error on job ORACLE_OCM.MGMT_CONFIG_JOB_2_1"OracleError
- 記一次OPatch failed with error code 73錯誤AIError
- Oracle 11G DataGuard生產環境又一次啟動具體過程Oracle
- 一次Linux虛擬機器安裝Oracle 11G資料庫經歷Linux虛擬機Oracle資料庫
- Oracle之11g DataGuardOracle
- Oracle 11G EM建立Oracle
- Oracle 11G Virtual ColumnsOracle
- Oracle 11G Duplicate DatabaseOracleDatabase
- oracle 11G dataguard配置Oracle
- oracle 11g 磁碟操作Oracle