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.
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
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.