Oracle 11gR2 RAC environment DBCA create database error ORA-15055 ORA-15001

Source: Internet
Author: User

Oracle 11gR2 RAC environment DBCA create database error ORA-15055 ORA-15001

Symptom:

After installing the Oracle 11gR2 GridInfrastructure and Database software, run DBCA to create a Database to 30% and report the following error. Click OK to ignore and stop the installation.

Problem Analysis:

From the above problem, it is not difficult to see that it is caused by the inability to access the ASM disk group. But to solve this problem, you have to go to the ASM to find out why the database is built on the newly installed cluster.

Then, we first log on to the asm instance through the grid user to perform the following query operations. We found that the disk groups are all in the mount status, indicating that the disk group status is normal.

 

SQL> select name, state, type from v $ asm_diskgroup;

NAME STATE TYPE
-----------------------------------------------
OCR_VOTE MOUNTED HIGH
DATA001 MOUNTED EXTERN
FRA001 MOUNTED EXTERN
BAK001 MOUNTED EXTERN

Next, we log on to the asm disk management through amcmd and enter the volume group + DATA001. At this time, we also saw the data files generated by the dbca database creation.
[Grid @ db01 ~] $ Asmcmd
ASMCMD> cd DATA001
ASMCMD> ls
XMMAN/
ASMCMD> cd XMMAN/
ASMCMD> LS
ASMCMD> ls
DATAFILE/
ASMCMD> cd DATAFILE/
ASMCMD> ls
SYSAUX.258.859553539
SYSTEM.259.859553539
UNDOTBS1.257.859553539
USERS.256.859553539
ASMCMD>

If we see the above information, we can basically eliminate the problem of ASM. We may consider it as a permission issue and try to re-execute the root. sh script.

Solution:

Execute the following script again

[Root @ db01 DBSoft] #/DBSoft/oracle/product/11.2.4/dbhome_1/root. sh
Padding Ming root user operation for Oracle 11g

The following environment variables are set:
ORACLE_OWNER = oracle
ORACLE_HOME =/DBSoft/oracle/product/11.2.4/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the/etc/oratab file as needed
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be saved med.
Finished product-specific root actions.
[Root @ db01 DBSoft] # pwd
/DBSoft

Run the dbca database again to troubleshoot the problem.

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.