[HP-UX] ORA-01081: cannot start already-running ORACLE - shut it down first
Oracle啟動的時候報了這個錯誤:
ORA-01081: cannot start already-running ORACLE - shut it down first
ipcs檢視shared memory後,發現有oracle的shared memory
[root@xxxxx002:/]# ipcs -m
IPC status from /dev/kmem as of Tue Apr 5 22:58:59 2016
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x411c07ba --rw-rw-rw- root root
m 1 0x4e0c0002 --rw-rw-rw- root root
m 2 0x41202002 --rw-rw-rw- root root
m 5123 0x0c6629c9 --rw-r----- root root
m 4 0x06347849 --rw-rw-rw- root root
m 517 0xffffffff --rw-r--rw- root root
m 29702 0x5e1800f6 --rw------- root root
m 519 0x41202aff --rw-rw-rw- root root
m 520 0x41202b0d --rw-rw-rw- root root
m 521 0x4120295d --rw-rw-rw- root root
m 522 0x41202b22 --rw-rw-rw- root root
m 11 0x8aab0dd4 --rw-rw---- oracle dba
利用ipcrm清除shared memory.
[root@xxxxx002:/]# ipcrm -m 11
中間有個反應時間,之後確認 oracle的shared memory消失
[root@xxxxx002:/]# ipcs -m
IPC status from /dev/kmem as of Tue Apr 5 23:01:40 2016
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x411c07ba --rw-rw-rw- root root
m 1 0x4e0c0002 --rw-rw-rw- root root
m 2 0x41202002 --rw-rw-rw- root root
m 5123 0x0c6629c9 --rw-r----- root root
m 4 0x06347849 --rw-rw-rw- root root
m 517 0xffffffff --rw-r--rw- root root
m 29702 0x5e1800f6 --rw------- root root
m 519 0x41202aff --rw-rw-rw- root root
m 520 0x41202b0d --rw-rw-rw- root root
m 521 0x4120295d --rw-rw-rw- root root
m 522 0x41202b22 --rw-rw-rw- root root
shared memory消失後,oracle正常啟動
#fsck -F vxfs /dev/vgxxxxxx/lvol1
#fsck -F vxfs /dev/vgxxxxxx/lvol2
#fmount /dev/vgxxxxxx/lvol1 /oradata/xxxxxx/system
#fmount /dev/vgxxxxxx/lvol2 /oradata/xxxxxx/data
ORA-01081: cannot start already-running ORACLE - shut it down first
ipcs檢視shared memory後,發現有oracle的shared memory
[root@xxxxx002:/]# ipcs -m
IPC status from /dev/kmem as of Tue Apr 5 22:58:59 2016
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x411c07ba --rw-rw-rw- root root
m 1 0x4e0c0002 --rw-rw-rw- root root
m 2 0x41202002 --rw-rw-rw- root root
m 5123 0x0c6629c9 --rw-r----- root root
m 4 0x06347849 --rw-rw-rw- root root
m 517 0xffffffff --rw-r--rw- root root
m 29702 0x5e1800f6 --rw------- root root
m 519 0x41202aff --rw-rw-rw- root root
m 520 0x41202b0d --rw-rw-rw- root root
m 521 0x4120295d --rw-rw-rw- root root
m 522 0x41202b22 --rw-rw-rw- root root
m 11 0x8aab0dd4 --rw-rw---- oracle dba
利用ipcrm清除shared memory.
[root@xxxxx002:/]# ipcrm -m 11
中間有個反應時間,之後確認 oracle的shared memory消失
[root@xxxxx002:/]# ipcs -m
IPC status from /dev/kmem as of Tue Apr 5 23:01:40 2016
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x411c07ba --rw-rw-rw- root root
m 1 0x4e0c0002 --rw-rw-rw- root root
m 2 0x41202002 --rw-rw-rw- root root
m 5123 0x0c6629c9 --rw-r----- root root
m 4 0x06347849 --rw-rw-rw- root root
m 517 0xffffffff --rw-r--rw- root root
m 29702 0x5e1800f6 --rw------- root root
m 519 0x41202aff --rw-rw-rw- root root
m 520 0x41202b0d --rw-rw-rw- root root
m 521 0x4120295d --rw-rw-rw- root root
m 522 0x41202b22 --rw-rw-rw- root root
shared memory消失後,oracle正常啟動
#fsck -F vxfs /dev/vgxxxxxx/lvol1
#fsck -F vxfs /dev/vgxxxxxx/lvol2
#fmount /dev/vgxxxxxx/lvol1 /oradata/xxxxxx/system
#fmount /dev/vgxxxxxx/lvol2 /oradata/xxxxxx/data
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2076443/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- shut down and start crs for Oracle10GOracle
- 另類的曲線方式定時Start up/Shut down VM 的解決方案
- redhat your system appears to have shut down uncleanlyRedhatAPP
- [HP-UX] cannot fork: too many processesUX
- [fabric]Cannot start service orderer: Mounts denied: In MacMac
- You cannot change a partition into an extended one or vice versa Delete it firstdelete
- centOS7 Failed to start LSB Bring up/down networkingCentOSAI
- hp-ux oracleUXOracle
- first oracle sqlOracleSQL
- OCP(11g)-----> oracle First In First Out (FIFO)/Last In First OutOracleAST
- cannot read prpperty ‘start‘ of undefined(問題記錄)Undefined
- SOA Suite Purge Log 指令碼報錯問題ORA-20001: Jobs still running or not shut downUI指令碼
- linux start oracleLinuxOracle
- Oracle Start with ....Connect ByOracle
- [HP-UX] cmviewcl執行時提示cmviewcl : Cannot talk to all the nodes.UXView
- hp-ux: CRS not Start on One of Nodes in a Two Node Cluster With HP MC_967090.1UX
- CRS: Resource in UNKNOWN state and srvctl Cannot Start/Stop Resource_845709.1
- cannot send session cache limiter-headers already sent (output start at ............)SessionMITHeader
- Shutting down the Oracle ASMLib driver: [ failed ]OracleASMAI
- START WITH and CONNECT BY in Oracle SQLOracleSQL
- AUTO START ORACLE ON LINUX(zt)OracleLinux
- oracle中start with connect by priorOracle
- Oracle DataPump Quick Start [ID 413965.1]OracleUI
- put it down?
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Oracle start with connect by PostgreSQL recursive cteOracleSQL
- oracle多例項start-stop指令碼Oracle指令碼
- Oracle dbconsole can't startOracle
- Change AUTO_START in ASM Resource Oracle ClusterwareASMOracle
- Oracle集合的first, last , next ,count,existOracleAST
- Oracle 的 INSERT ALL和INSERT FIRSTOracle
- why app_start startAPP
- Oracle 樹操作(select…start with…connect by…prior)Oracle
- 關於ORACLE RESTRICT模式,以及START OPEN RECOVEROracleREST模式
- Oracle 10g isqlplus start/stopOracle 10gSQL
- Upside DownIDE
- 201012 Oracle OpenWorld First DayOracle
- Step By Step Install Oracle10g RAC On Hp-uxOracleUX