ORA-15055 Unable to Connect to ASM When Starting an Instance
嘗試啟動一個spfile 檔案在asm 中的資料庫時會遇到如下錯誤:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA_ASM/gisqe1/spfilegisqe1.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA_ASM/gisqe1/spfilegisqe1.ora
ORA-15055: unable to connect to ASM instance
ORA-15055: unable to connect to ASM instance
Error: ORA-15055 (ORA-15055)
===========================================
Text: unable to connect to ASM instance
---------------------------------------------------------------------------
Cause: When accessing a diskgroup for the first time, the database was
unable to connect to the required ASM instance.
Action: Check the additional error messages. May need to configure
correct ASM sid or make sure the database instance has OS
privileges for ASM SYSDBA.
===========================================
相似的錯誤發生在例項嘗試連線 ASM 來獲取控制檔案和資料檔案時也會發生這樣的錯誤,即使使用init.ora檔案來代替在asm 中的spfile檔案。ora-15055 錯誤經常發生在第一次連線asm 例項時。
原因:
以上錯誤可能是由於以下原因引起。
1) ASM 使用者 和ORACLE 使用者不是同一個使用者
2) oracle binary 的setuid 和 setgid 沒有正確設定
例如:檢查ASM_HOME/bin 目錄的oracle binary的許可權
ls -l oracle
結果使用者和所屬組應該有 s 標識,當asm 第一次被建立並且在建立的過程中沒有錯誤發生,上述命令的結果應為:
-rwsr-s--x
解決方法:
執行一下步驟設定 oracle binary 檔案的setuid 和setgid:
1) cd ASM_HOME/bin
2) chmod 6751 oracle
3) "ls -l oracle" should show -rwsr-s--x
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA_ASM/gisqe1/spfilegisqe1.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA_ASM/gisqe1/spfilegisqe1.ora
ORA-15055: unable to connect to ASM instance
ORA-15055: unable to connect to ASM instance
Error: ORA-15055 (ORA-15055)
===========================================
Text: unable to connect to ASM instance
---------------------------------------------------------------------------
Cause: When accessing a diskgroup for the first time, the database was
unable to connect to the required ASM instance.
Action: Check the additional error messages. May need to configure
correct ASM sid or make sure the database instance has OS
privileges for ASM SYSDBA.
===========================================
相似的錯誤發生在例項嘗試連線 ASM 來獲取控制檔案和資料檔案時也會發生這樣的錯誤,即使使用init.ora檔案來代替在asm 中的spfile檔案。ora-15055 錯誤經常發生在第一次連線asm 例項時。
原因:
以上錯誤可能是由於以下原因引起。
1) ASM 使用者 和ORACLE 使用者不是同一個使用者
2) oracle binary 的setuid 和 setgid 沒有正確設定
例如:檢查ASM_HOME/bin 目錄的oracle binary的許可權
ls -l oracle
結果使用者和所屬組應該有 s 標識,當asm 第一次被建立並且在建立的過程中沒有錯誤發生,上述命令的結果應為:
-rwsr-s--x
解決方法:
執行一下步驟設定 oracle binary 檔案的setuid 和setgid:
1) cd ASM_HOME/bin
2) chmod 6751 oracle
3) "ls -l oracle" should show -rwsr-s--x
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31520497/viewspace-2156862/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-15055: unable to connect to ASM instance 造成 RAC的db不能啟動ASM
- ORA-15055 ORA-12549 Unable To Connect To ASM Instance問題ASM
- ASM Spfile Is Not Used when ASM Instance StartsASM
- Unable To Create Database Using ASM ORA-15055DatabaseASM
- 【RAC】ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contactASM
- ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contact(轉載)ASM
- ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS InstanceASM
- ORA-00845 When Starting Up An 11g Instance With AMM Configured
- ASM例項啟動報錯:ORA-29701 :unable to connect to Cluster ManagerASM
- Unable to connect to SQL Server ExpressSQLServerExpress
- 3.1.5.2 Starting an Instance, and Mounting and Opening a DatabaseDatabase
- Unable to connect to any hosts due to exceptionException
- ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]ASMAI
- SVN-Unable to connect to a repository at URL
- Unable to Connect to Database with Oracle Client Software for WindowsDatabaseOracleclientWindows
- Unable to View Chinese Font When Using Tools>Copy FileView
- asm 相容性、asm instance 主要引數管理ASM
- unable to connect to converter enterprise serverServer
- Login Oracle Instance Even When sysdba Cannot Do SoOracle
- android-Building a Notification,Preserving Navigation when Starting an ActivityAndroidUINavigation
- oracle asm Unable to mount ASMlib driver filesystemOracleASM
- How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]ASM
- Convert a Single-Instance to RAC with ASMASM
- ASM ORA-15055,ORA-00020問題解決(原)ASM
- ORA-19527 reported in Standby Database when starting Managed Recovery_352879.1Database
- ASM Diskgroup Can Not Be Shown When Creating Database With DBCAASMDatabase
- GoldenGate&ASM&Connecting to a 'BLOCKED' instanceGoASMBloC
- 能夠管理ASM instance的三種角色ASM
- CRS-215 Srvctl unable to start ASM, Listener, RDBMS ResourcesASM
- Taking Systemstate Dumps when You cannot Connect to Oracle [ID 121779.1]Oracle
- 【ASM】ORA-27504 ORA-27300 ORA-27303 while starting ASM (Doc ID 2281441.1)ASMWhile
- Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]SQL
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- How to create user for oracle10g/11g asm instanceOracleASM
- 【RAC】Diskgroup shows offline after restart even it is mounted in ASM instanceRESTASM
- 建立asm磁碟 報錯 oracleasm-write-label: Unable to clear deviceASMOracledev
- nested exception is io.lettuce.core.RedisConnectionException: Unable to connect to localhost:6379ExceptionRedislocalhost
- TNS-12535 Unable To Connect To Remote Database using certain ApplicationsREMDatabaseAIAPP