Unable To Create Database Using ASM ORA-15055
不能在asm 例項上建立oracle 10g 資料庫,報錯如下:
CREATE DATABASE "ekbkprd1"
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '+DG1_NR/ekbkprd1/control/ekbkprd1_control.ctl'
ORA-17502: ksfdcre:4 Failed to create file
+DG1_NR/ekbkprd1/control/ekbkprd1_control.ctl
ORA-15001: diskgroup "DG1_NR" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
原因:
1 磁碟組一 "+"開頭建立。 例如:
create diskgroup +ASM_DISKGP1 normal redundancy
failgroup f1 disk '/dev/rdsk/c0t2d0s1' name disk1
failgroup f2 disk '/dev/rdsk/c0t2d0s3' name disk2;
2 使用DBCA 建立資料庫,磁碟組以 兩個 + 號開頭這種不正確的方式被引用:
++ASM_DISKGP1
ASM 磁碟組不能以"+" 開頭的方式建立因為oracle 預設會自動的加上字首 "+"來辨別資料庫檔案的存放位置。
解決方法:
1) 刪除當前的磁碟組:
SQL> drop diskgroup;
2)重建磁碟組注意:這次不要加 "+" 字首:
例如:
SQL>create diskgroup ASM_DISKGP1 normal redundancy
2 failgroup f1 disk '/dev/rdsk/c0t2d0s1' name disk1
3 failgroup f2 disk '/dev/rdsk/c0t2d0s3' name disk2;
3) 手工或者使用DBCA建立資料庫
CREATE DATABASE "ekbkprd1"
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '+DG1_NR/ekbkprd1/control/ekbkprd1_control.ctl'
ORA-17502: ksfdcre:4 Failed to create file
+DG1_NR/ekbkprd1/control/ekbkprd1_control.ctl
ORA-15001: diskgroup "DG1_NR" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
原因:
1 磁碟組一 "+"開頭建立。 例如:
create diskgroup +ASM_DISKGP1 normal redundancy
failgroup f1 disk '/dev/rdsk/c0t2d0s1' name disk1
failgroup f2 disk '/dev/rdsk/c0t2d0s3' name disk2;
2 使用DBCA 建立資料庫,磁碟組以 兩個 + 號開頭這種不正確的方式被引用:
++ASM_DISKGP1
ASM 磁碟組不能以"+" 開頭的方式建立因為oracle 預設會自動的加上字首 "+"來辨別資料庫檔案的存放位置。
解決方法:
1) 刪除當前的磁碟組:
SQL> drop diskgroup
2)重建磁碟組注意:這次不要加 "+" 字首:
例如:
SQL>create diskgroup ASM_DISKGP1 normal redundancy
2 failgroup f1 disk '/dev/rdsk/c0t2d0s1' name disk1
3 failgroup f2 disk '/dev/rdsk/c0t2d0s3' name disk2;
3) 手工或者使用DBCA建立資料庫
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-689079/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-15183 Unable to Create Database on Server using 11.2 ASMDatabaseServerASM
- Fatal error in launcher: Unable to create process using '"'Error
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- ORA-15055 Unable to Connect to ASM When Starting an InstanceASM
- ORA-15183 Unable to Create DB on Server using 11.2 ASM and GI_1054033.1ServerASM
- 12CR2 using create database command for create non-CDB rac databaseDatabase
- ORA-15055: unable to connect to ASM instance 造成 RAC的db不能啟動ASM
- ORA-15055 ORA-12549 Unable To Connect To ASM Instance問題ASM
- oracle create a new database using backup controlfile to traceOracleDatabase
- GET ORA-32700 WHEN TRYING TO CREATE DATABASE USING 9.2Database
- 【RAC】ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contactASM
- Create Physical stdby Using RMAN Duplicate In ASM File... For ASM Prim-837102.1ASM
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contact(轉載)ASM
- Create DatabaseDatabase
- Unable to create git index lockGitIndex
- Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2DatabaseASM
- TNS-12535 Unable To Connect To Remote Database using certain ApplicationsREMDatabaseAIAPP
- DBCA建立ASM報錯ORA-27125: unable to create shared memory segmentASM
- PG create databaseDatabase
- Create database manuallyDatabase
- Step-By-Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMANGUIIDEORMASM
- alter database create datafileDatabase
- CREATE DATABASE LINKDatabase
- alter database create datafile '' as ''Database
- create table of mysql databaseMySqlDatabase
- The method of create a replicate of the database .Database
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 1ASM
- 【OH】Creating a Database with the CREATE DATABASE StatementDatabase
- Create a Seco VD in a Diffe ASM Disk G When Using Exter Redun in 11.2_950730.1ASM
- ftp_rawlist: Unable to create temporary file.FTP
- How to re-create the ASMASM
- create a database stepsDatabase
- Tasks of a Database Administrator : Create and Open the Database (10)Database
- Unable to create index.lock File exists錯誤Index
- Using Regular Expressions in Oracle DatabaseExpressOracleDatabase
- create a partition table using a exsit table