Issues and solutions for
10g RAC Database creation on 11gR2 grid infra:
Issue 1 :
Oracle Single instance creation screen appears instead of RAC database creation screen.
![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sqFcFmay5Pmllg0IybcZrj3cmrMt4rJLkiAjJEefDo4WeDkcydiH5lW4VpSVdsSiJddc9KWWOnkA4pq7tZXOW1pk2uqRHBNLEX2m13STIpbcR5vnb9a8PfpHpJr_TOAoeRFWgJYzH7Qp2VaS7uiKpimg=s0-d)
Solution : Note ID 1073926.1
Issue 2 :
From the above note 1073926.1, it is also required to apply the patch 8288940 to fix 11g ASM Incompatibility for 10g
Issue 3 :
While creating the database using dbca , getting the following error.
"Encountered file error when copying listeners from home=/o001/home/11.2.0/grid/"
![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_v-xqsD1jvqkc28chAsZ_zM24-gLpq-iauO6yNs3TOc8AsFnJhRPh9o2qnEyzG_Y7-63Gs1o_V3T4H3AtqHh8U6neZLClULTbG9d5R1k7Q3c99n5UCBY4lptbLLDTAUiWecH9ZBUXO5PR_ZGheGBctYfA=s0-d)
Solution : Note ID : 762304.1
Issue 4 :
Invalid specification for system parameter "REMOTE_LISTENER" …..
![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vUKRQpCCqqufC-Y26_pO8P4GkXfv1IMCP0L4aDjSdiDaUPXlrIuUWOOf6ZBEw0RyRj9VXwQaIjZQhfqw1o0_BgT9KkLlmpiEn4TZJ9MIh4ivf3jJbg6SxutKLKaSEkUKcWgFQTx-qNzQuq5VsU4LYNUg=s0-d)
Solution :
Modified the remote_listener init parameter to point to "<scan-name>:1521"
Issue 5:
![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vp_WB7Azq914ZfSoPe8FMF1CzQqDiVRrIdE522qUD5Umn-Fs1jgruKjyHok9jq2PUtD1lIVhTRZ1yBTi3n0xWvBOAwmYix4SAZ-i2-K6M6vZ_CML0iTbcURn-BzxJ0iPVdxXQKF31br4yJxrz2rXbe=s0-d)
Found the following messages in alert log file
Work Around :
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
FRA MOUNTED
RACDB_DATA MOUNTED
SQL> select name,path from v$asm_disk;
NAME PATH
--------------------------------------------------------------------------------
CRS_0000 /dev/oracleasm/disks/CRSVOL1
FRA_0000 /dev/oracleasm/disks/FRAVOL1
RACDB_DATA_0000 /dev/oracleasm/disks/DATAVOL1
SQL> !
[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/DATAVOL1
brw-rw---- 1 grid asmadmin 8, 32 Aug 20 11:53 /dev/oracleasm/disks/DATAVOL1
[grid@rac1 disks]$ id oracle
uid=1659(oracle) gid=501(dba) groups=501(dba),552(admin2),503(oper),1000(oinstall),1201(asmdba)
[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/*
brw-rw---- 1 grid asmadmin 8, 48 Aug 20 11:54 /dev/oracleasm/disks/FRAVOL1
brw-rw---- 1 grid asmadmin 8, 32 Aug 20 11:54 /dev/oracleasm/disks/DATAVOL1
brw-rw---- 1 grid asmadmin 8, 64 Aug 20 11:54 /dev/oracleasm/disks/CRSVOL1
[grid@rac1 disks]$ chmod 777 /dev/oracleasm/disks/*
[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/*
brwxrwxrwx 1 grid asmadmin 8, 48 Aug 20 11:55 /dev/oracleasm/disks/FRAVOL1
brwxrwxrwx 1 grid asmadmin 8, 32 Aug 20 11:55 /dev/oracleasm/disks/DATAVOL1
brwxrwxrwx 1 grid asmadmin 8, 64 Aug 20 11:55 /dev/oracleasm/disks/CRSVOL1
[grid@rac1 disks]$
Issue 6 :
PRKP-1001 : Error starting the instance rac10g2 on node rac2
CRS-0215 Could not start resource 'ora.rac10g.rac10g2.inst'
This error can be ignored. The instance is started automatically.
10g RAC Database creation on 11gR2 grid infra:
Issue 1 :
Oracle Single instance creation screen appears instead of RAC database creation screen.
Solution : Note ID 1073926.1
Issue 2 :
From the above note 1073926.1, it is also required to apply the patch 8288940 to fix 11g ASM Incompatibility for 10g
Issue 3 :
While creating the database using dbca , getting the following error.
"Encountered file error when copying listeners from home=/o001/home/11.2.0/grid/"
Solution : Note ID : 762304.1
Issue 4 :
Invalid specification for system parameter "REMOTE_LISTENER" …..
Solution :
Modified the remote_listener init parameter to point to "<scan-name>:1521"
Issue 5:
Found the following messages in alert log file
ORA-15025: could not open disk '/dev/oracleasm/disks/DATAVOL1'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Fri Aug 20 09:41:54 2010
SUCCESS: diskgroup RACDB_DATA was mounted
SUCCESS: diskgroup RACDB_DATA was dismounted
Fri Aug 20 09:41:54 2010
Errors in file /o001/home/oracle/admin/rac10g/udump/rac10g1_ora_14539.trc:
ORA-00200: control file could not be created
ORA-00202: control file: '+RACDB_DATA/rac10g/control01.ctl'
ORA-15012: ASM file 'rac10g/control01.ctl' does not exist
ORA-17502: ksfdcre:5 Failed to create file +RACDB_DATA/rac10g/control01.ctl
ORA-15081: failed to submit an I/O operation to a disk
Work Around :
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
FRA MOUNTED
RACDB_DATA MOUNTED
SQL> select name,path from v$asm_disk;
NAME PATH
--------------------------------------------------------------------------------
CRS_0000 /dev/oracleasm/disks/CRSVOL1
FRA_0000 /dev/oracleasm/disks/FRAVOL1
RACDB_DATA_0000 /dev/oracleasm/disks/DATAVOL1
SQL> !
[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/DATAVOL1
brw-rw---- 1 grid asmadmin 8, 32 Aug 20 11:53 /dev/oracleasm/disks/DATAVOL1
[grid@rac1 disks]$ id oracle
uid=1659(oracle) gid=501(dba) groups=501(dba),552(admin2),503(oper),1000(oinstall),1201(asmdba)
[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/*
brw-rw---- 1 grid asmadmin 8, 48 Aug 20 11:54 /dev/oracleasm/disks/FRAVOL1
brw-rw---- 1 grid asmadmin 8, 32 Aug 20 11:54 /dev/oracleasm/disks/DATAVOL1
brw-rw---- 1 grid asmadmin 8, 64 Aug 20 11:54 /dev/oracleasm/disks/CRSVOL1
[grid@rac1 disks]$ chmod 777 /dev/oracleasm/disks/*
[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/*
brwxrwxrwx 1 grid asmadmin 8, 48 Aug 20 11:55 /dev/oracleasm/disks/FRAVOL1
brwxrwxrwx 1 grid asmadmin 8, 32 Aug 20 11:55 /dev/oracleasm/disks/DATAVOL1
brwxrwxrwx 1 grid asmadmin 8, 64 Aug 20 11:55 /dev/oracleasm/disks/CRSVOL1
[grid@rac1 disks]$
Issue 6 :
PRKP-1001 : Error starting the instance rac10g2 on node rac2
CRS-0215 Could not start resource 'ora.rac10g.rac10g2.inst'
This error can be ignored. The instance is started automatically.
+ comments + 1 comments
[...] refer:- Vineet's Oracle Blog: Creating Oracle 10g RAC database on 11g Grid Infrastructure Issues and solutions for 10g RAC Database creation on 11gR2 grid infra Reply With [...]
Post a Comment
Thank you for visiting our site and leaving your valuable comment.