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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 3.1.5.2 Starting an Instance, and Mounting and Opening a DatabaseDatabase
- SVN-Unable to connect to a repository at URL
- 【ASM】ORA-27504 ORA-27300 ORA-27303 while starting ASM (Doc ID 2281441.1)ASMWhile
- could not connect to redis Instance at xxx.xxx.xxx.xxx:6379Redis
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- nested exception is io.lettuce.core.RedisConnectionException: Unable to connect to localhost:6379ExceptionRedislocalhost
- unable to access ‘https://gitee.com/XXX/XXX.git/‘: Failed to connect to 127.0.0.1 portHTTPGiteeAI127.0.0.1
- vertx instance
- GPU InstanceGPU
- 【Azure Redis】部署在AKS中的應用連線Redis時候出現Unable to connect to Redis serverRedisServer
- 3.2.1 Mounting a Database to an InstanceDatabase
- 3.1.5.6 Forcing an Instance to Start
- case when 語句
- C++ instance的使用C++
- RMAN Duplicate RAC to Single Instance
- Unable to find a specification for ''
- Kubeadm安裝k8s叢集升級100年證書時報錯:Unable to connect to the server: EOF:求解決方法.K8SServer
- Rancher Dashboard 無法訪問 引申發現K8S報錯Unable to connect to the server: x509: certificate has expired or is not yet validK8SServer
- Non-UTF-8 code starting with '\xe4'
- Property [title] does not exist on this collection instance
- Laravel connect oracleLaravelOracle
- database的connectDatabase
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- 【ASM】ASM磁碟頭被重寫,如何修復ASM
- OUTLOOK - Unable to Delete Meetingsdelete
- goldengate + asm + racGoASM
- gnu inline asminlineASM
- mysql中case when的使用MySql
- sql case when, Exist ,group by ,聚合SQL
- Oracle case when改寫SQLOracleSQL
- Laravel query when 的查詢Laravel
- SpokenEnglish01_ When's it due?
- [Reactive] Run functions when data changesReactFunction
- SQL Server CASE WHEN ... THEN ... ELSE ... ENDSQLServer
- What are general rules when deciding on index?Index
- drools中的條件 when
- TLS Poison - When TLS Hack youTLS
- 【ASM】ASM啟動無法找到spfile問題原因ASM