11gR2RAC environment DBCA create database error ORA-15055 ORA-15001, 11gr2racdbca

Source: Internet
Author: User

11gR2RAC environment DBCA create database error ORA-15055 ORA-15001, 11gr2racdbca

11gR2RAC environment DBCA create database error ORA-15055 ORA-15001

 

Symptom:

After 11gR2 GridInfrastructure and Database software are installed, the following error is reported when DBCA is executed to create a Database to 30%. Click OK and the system prompts 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 HIGHDATA001 MOUNTED EXTERNFRA001 MOUNTED EXTERNBAK001 mounted extern. Then 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 ~] $ AsmcmdASMCMD> cd DATA001ASMCMD> lsXMMAN/ASMCMD> cd XMMAN/ASMCMD> LSASMCMD> lsDATAFILE/ASMCMD> cd DATAFILE/ASMCMD> example. Example>

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.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= oracle    ORACLE_HOME=  /DBSoft/oracle/product/11.2.4/dbhome_1Enter 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 byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@db01 DBSoft]# pwd/DBSoft


Run the dbca database again to troubleshoot the problem.




An error is reported when em is configured for oracle 11gR2 DBCA database creation

When installing oracle software and libraries in Windows, you cannot open a firewall. Otherwise, there will be such an error.

Run the dbca command to run oracle11gr2 on redhat64 and report an error.

Check whether the following RPM packages are installed:
Elfutils-libelf
Elfutils-libelf-devel
Libaio
Libaio-devel
If not, install the RHEL mounting disk, including 64-bit and 32-bit.
Then:

$ ORACLE_HOME/bin/relink all

It should be fine.
 

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.