1 2 Previous Next 17 Replies Latest reply: Apr 24, 2013 10:21 PM by vasuoracledba RSS

    Manual creation of Oracle RAC Database

    vasuoracledba
      Hello Guru's,

      I successfully installed Oracle Grid(clusterware) and Oracle RDBMS 11.2.0.1.0 for RAC containing 2 nodes on Linux 5.3 64 bit.
      All the clusterware services and ASM instance are running fine on both nodes.
      Now im planning to create database manually on node1 (RAC-NODE1).
      1) configure the environmental variables as follows
      export TMP=/tmp
      export ORACLE_HOSTNAME=`hostname`
      export ORACLE_SID=finance1
      export ORACLE_UNQNAME=finance
      export ORACLE_BASE=/rdbms1/app/oracle/
      export ORACLE_HOME=/rdbms1/app/oracle/product/11.2.0/db_home/
      export ORACLE_TERM=xterm
      export PATH=$ORACLE_HOME/bin:$PATH:.
      export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
      export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

      2) created the pfile and modified the parameters as follows
      db_name='finance'
      processes = 200
      audit_trail ='db'
      db_block_size=8192
      db_domain='vod.com'
      diagnostic_dest='/oradump/oradata/finance/dump'
      sessions=200
      remote_login_passwordfile='EXCLUSIVE'
      undo_tablespace='UNDOTBS1'
      control_files = +CTRL
      compatible ='11.2.0'
      job_queue_processes = 10
      undo_management = 'AUTO'
      finance1.instance_name = finance1
      db_create_file_dest = +DBFILE
      db_create_online_log_dest_1 = +REDO1
      db_create_online_log_dest_2 = +REDO2

      3) Created the password file as follows
      $ orapwd file=orapwfinance1 passwors=syspassword entries=10

      4) edit the /etc/oratab file as follows
      finance1:/rdbms1/app/oracle/product/11.2.0/db_home:N

      5) created the rac db script as follows.
      CREATE DATABASE FINANCE
      DATAFILE '+DBFILE' SIZE 500M
      AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
      EXTENT MANAGEMENT LOCAL
      SYSAUX DATAFILE '+DBFILE' SIZE 500M
      AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
      DEFAULT TEMPORARY TABLESPACE TEMP
      TEMPFILE '+DBFILE' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 500M
      UNDO TABLESPACE UNDOTBS1
      DATAFILE '+DBFILE' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 500M
      DEFAULT TABLESPACE USERDATA
      DATAFILE '+DBFILE' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 500M
      LOGFILE
      GROUP 1 ('+REDO1','+REDO2') SIZE 20M,
      GROUP 2 ('+REDO1','+REDO2') SIZE 20M,
      GROUP 3 ('+REDO1','+REDO2') SIZE 20M
      MAXINSTANCES 8
      MAXLOGHISTORY 300
      MAXLOGFILES 64
      MAXLOGMEMBERS 5
      MAXDATAFILES 150
      USER SYS IDENTIFIED BY "sys_123"
      USER SYSTEM IDENTIFIED BY "system_123";

      6) started the instance as follows.
      $ sqlplus / as sysdba
      SQL> startup nomount
      ORACLE instance started.

      Total System Global Area 217157632 bytes
      Fixed Size 2211928 bytes
      Variable Size 159387560 bytes
      Database Buffers 50331648 bytes
      Redo Buffers 5226496 bytes
      SQL> @rac_db.sql
      CREATE DATABASE FINANCE
      *
      ERROR at line 1:
      ORA-01501: CREATE DATABASE failed
      ORA-00200: control file could not be created
      ORA-00202: control file: '+CTRL'
      ORA-15045: ASM file name '+CTRL' is not in reference form
      ORA-17502: ksfdcre:5 Failed to create file +CTRL
      ORA-15081: failed to submit an I/O operation to a disk

      It shows that oracle unable to create control file on +CTRL diskgroup, i found that there is a problem with permissions on disks in diskgroups.

      brw-rw-r-- 1 grid asmadmin 8, 49 Apr 8 04:25 CTRLDISK1
      brw-rw-r-- 1 grid asmadmin 8, 50 Apr 8 04:25 CTRLDISK2
      brw-rw-r-- 1 grid asmadmin 8, 51 Apr 8 04:25 CTRLDISK3
      brw-rw-r-- 1 grid asmadmin 8, 52 Apr 8 04:25 CTRLDISK4

      since all the disks in diskgroup has 664 permision and owned by grid user primary group is asmadmin.

      # id grid
      uid=1001(grid) gid=501(oinstall) groups=501(oinstall),504(asmadmin),505(asmdba),506(asmoper)
      # id oracle
      uid=1002(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),505(asmdba)

      please help me to overcome the above problem.

      regards,
        • 1. Re: Manual creation of Oracle RAC Database
          FreddieEssex
          Check the permissions of the raw device and not the block device.
          • 2. Re: Manual creation of Oracle RAC Database
            vasuoracledba
            Sorry to ask u, im new to RAC. Im using only ASM Diskgroups, where is raw devices.

            Kindly clarify me..
            Thanks,
            • 3. Re: Manual creation of Oracle RAC Database
              FreddieEssex
              When you showed the output of ls -l you see the first character begins with "b". This means it is the block device. You need to change the permissions of the character raw device. When you do a ls -l of this device it will begin with a "c".

              See output on my system below:
              brw-------    1 root     system       17, 10 28 Mar 16:09 /dev/hdisk10
              brw-------    1 root     system       17, 11 28 Mar 16:52 /dev/hdisk11
              crw-rw----    1 oracle   dba          17, 10 10 Apr 08:59 /dev/rhdisk10
              crw-rw----    1 oracle   dba          17, 11 10 Apr 07:12 /dev/rhdisk11
              This is an AIX system so probably set up different from your Linux RAC.

              The following query should give you the path to the disks your ASM instance is using and lets you know if it's a member disk or a candidate:
              SQL> select header_status, path from v$asm_disk;
              
              HEADER_STATU PATH
              ------------ --------------------------------------------------
              MEMBER       /dev/rhdisk10
              MEMBER       /dev/rhdisk11
              Hope that makes sense.

              Edited by: Freddie Essex on 10-Apr-2013 09:11
              • 4. Re: Manual creation of Oracle RAC Database
                FreddieEssex
                Also noticed one additional thing.

                The permissions on the device are grid:asmadmin and oracle isn't part of the asmadmin group so would not be able to create files on these disks.

                oracle would only have read access to the devices if permissions are 664.
                • 5. Re: Manual creation of Oracle RAC Database
                  vasuoracledba
                  Thanks for comments,
                  I successfully created the database, once i restared the database it is unbale to mount because of unbale to open +CTRL group file.

                  SQL> startup
                  ORACLE instance started.

                  Total System Global Area 217157632 bytes
                  Fixed Size 2211928 bytes
                  Variable Size 159387560 bytes
                  Database Buffers 50331648 bytes
                  Redo Buffers 5226496 bytes
                  ORA-00205: error in identifying control file, check alert log for more info

                  alert log:

                  ORACLE_BASE from environment = /rdbms1/app/oracle/
                  Thu Apr 11 09:36:34 2013
                  ALTER DATABASE MOUNT
                  ORA-00210: cannot open the specified control file
                  ORA-00202: control file: '+CTRL'
                  ORA-17503: ksfdopn:2 Failed to open file +CTRL
                  ORA-15045: ASM file name '+CTRL' is not in reference form
                  ORA-205 signalled during: ALTER DATABASE MOUNT...
                  Thu Apr 11 09:36:42 2013
                  NOTE: initiating MARK startup

                  raw devices:

                  # ls -l /dev/sd*

                  brw-rw-r-- 1 grid asmadmin 8, 16 Apr 11 09:04 /dev/sdb
                  brw-rw-r-- 1 grid asmadmin 8, 17 Apr 11 09:51 /dev/sdb1
                  brw-rw-r-- 1 grid asmadmin 8, 18 Apr 11 09:51 /dev/sdb2
                  brw-rw-r-- 1 grid asmadmin 8, 19 Apr 11 09:51 /dev/sdb3
                  brw-rw-r-- 1 grid asmadmin 8, 20 Apr 11 09:45 /dev/sdb4
                  brw-rw-r-- 1 grid asmadmin 8, 32 Apr 11 09:04 /dev/sdc
                  brw-rw-r-- 1 grid asmadmin 8, 33 Apr 11 09:30 /dev/sdc1
                  brw-rw-r-- 1 grid asmadmin 8, 34 Apr 11 09:30 /dev/sdc2
                  brw-rw-r-- 1 grid asmadmin 8, 35 Apr 11 09:30 /dev/sdc3
                  brw-rw-r-- 1 grid asmadmin 8, 36 Apr 11 09:05 /dev/sdc4
                  brw-rw-r-- 1 grid asmadmin 8, 48 Apr 11 09:04 /dev/sdd
                  brw-rw-r-- 1 grid asmadmin 8, 49 Apr 11 09:51 /dev/sdd1
                  brw-rw-r-- 1 grid asmadmin 8, 50 Apr 11 09:51 /dev/sdd2
                  brw-rw-r-- 1 grid asmadmin 8, 51 Apr 11 09:51 /dev/sdd3
                  brw-rw-r-- 1 grid asmadmin 8, 52 Apr 11 09:30 /dev/sdd4
                  brw-rw-r-- 1 grid asmadmin 8, 64 Apr 11 09:04 /dev/sde
                  brw-rw-r-- 1 grid asmadmin 8, 65 Apr 11 09:51 /dev/sde1
                  brw-rw-r-- 1 grid asmadmin 8, 66 Apr 11 09:51 /dev/sde2
                  brw-rw-r-- 1 grid asmadmin 8, 67 Apr 11 09:51 /dev/sde3
                  brw-rw-r-- 1 grid asmadmin 8, 68 Apr 11 09:30 /dev/sde4
                  brw-rw-r-- 1 grid asmadmin 8, 80 Apr 11 09:04 /dev/sdf
                  brw-rw-r-- 1 grid asmadmin 8, 81 Apr 11 09:51 /dev/sdf1
                  brw-rw-r-- 1 grid asmadmin 8, 82 Apr 11 09:51 /dev/sdf2
                  brw-rw-r-- 1 grid asmadmin 8, 83 Apr 11 09:51 /dev/sdf3
                  brw-rw-r-- 1 grid asmadmin 8, 84 Apr 11 09:30 /dev/sdf4
                  brw-rw-r-- 1 grid asmadmin 8, 96 Apr 11 09:04 /dev/sdg
                  brw-rw-r-- 1 grid asmadmin 8, 97 Apr 11 09:51 /dev/sdg1
                  brw-rw-r-- 1 grid asmadmin 8, 98 Apr 11 09:51 /dev/sdg2
                  brw-rw-r-- 1 grid asmadmin 8, 99 Apr 11 09:51 /dev/sdg3
                  brw-rw-r-- 1 grid asmadmin 8, 100 Apr 11 09:30 /dev/sdg4
                  brw-rw-r-- 1 grid asmadmin 8, 112 Apr 11 09:04 /dev/sdh
                  brw-rw-r-- 1 grid asmadmin 8, 113 Apr 11 09:51 /dev/sdh1
                  brw-rw-r-- 1 grid asmadmin 8, 114 Apr 11 09:51 /dev/sdh2
                  brw-rw-r-- 1 grid asmadmin 8, 115 Apr 11 09:51 /dev/sdh3
                  brw-rw-r-- 1 grid asmadmin 8, 116 Apr 11 09:30 /dev/sdh4

                  asm disks:

                  [09:52 AM root@RAC-NODE1.vod.com disks]# ll

                  brw-rw-r-- 1 grid asmadmin 8, 65 Apr 11 09:05 ARCLOGDISK1
                  brw-rw-r-- 1 grid asmadmin 8, 66 Apr 11 09:05 ARCLOGDISK2
                  brw-rw-r-- 1 grid asmadmin 8, 67 Apr 11 09:05 ARCLOGDISK3
                  brw-rw-r-- 1 grid asmadmin 8, 68 Apr 11 09:05 ARCLOGDISK4
                  brw-rw-r-- 1 grid asmadmin 8, 49 Apr 11 09:05 CTRLDISK1
                  brw-rw-r-- 1 grid asmadmin 8, 50 Apr 11 09:05 CTRLDISK2
                  brw-rw-r-- 1 grid asmadmin 8, 51 Apr 11 09:05 CTRLDISK3
                  brw-rw-r-- 1 grid asmadmin 8, 52 Apr 11 09:05 CTRLDISK4
                  brw-rw-r-- 1 grid asmadmin 8, 33 Apr 11 09:05 DBFILEDISK1
                  brw-rw-r-- 1 grid asmadmin 8, 34 Apr 11 09:05 DBFILEDISK2
                  brw-rw-r-- 1 grid asmadmin 8, 35 Apr 11 09:05 DBFILEDISK3
                  brw-rw-r-- 1 grid asmadmin 8, 36 Apr 11 09:05 DBFILEDISK4
                  brw-rw-r-- 1 grid asmadmin 8, 113 Apr 11 09:05 FRADISK1
                  brw-rw-r-- 1 grid asmadmin 8, 114 Apr 11 09:05 FRADISK2
                  brw-rw-r-- 1 grid asmadmin 8, 115 Apr 11 09:05 FRADISK3
                  brw-rw-r-- 1 grid asmadmin 8, 116 Apr 11 09:05 FRADISK4
                  brw-rw-r-- 1 grid asmadmin 8, 81 Apr 11 09:05 REDODISK1
                  brw-rw-r-- 1 grid asmadmin 8, 82 Apr 11 09:05 REDODISK2
                  brw-rw-r-- 1 grid asmadmin 8, 83 Apr 11 09:05 REDODISK3
                  brw-rw-r-- 1 grid asmadmin 8, 84 Apr 11 09:05 REDODISK4
                  brw-rw-r-- 1 grid asmadmin 8, 97 Apr 11 09:05 REDODISK5
                  brw-rw-r-- 1 grid asmadmin 8, 98 Apr 11 09:05 REDODISK6
                  brw-rw-r-- 1 grid asmadmin 8, 99 Apr 11 09:05 REDODISK7
                  brw-rw-r-- 1 grid asmadmin 8, 100 Apr 11 09:05 REDODISK8
                  brw-rw-r-- 1 grid asmadmin 8, 17 Apr 11 09:05 VOTEDISK1
                  brw-rw-r-- 1 grid asmadmin 8, 18 Apr 11 09:05 VOTEDISK2
                  brw-rw-r-- 1 grid asmadmin 8, 19 Apr 11 09:05 VOTEDISK3
                  brw-rw-r-- 1 grid asmadmin 8, 20 Apr 11 09:05 VOTEDISK4

                  [09:53 AM root@RAC-NODE1.vod.com ~]# ls -l /rdbms1/app/oracle/product/11.2.0/db_home/bin/oracle
                  -rwsr-s--x 1 oracle asmadmin 210824720 Apr 8 13:39 /rdbms1/app/oracle/product/11.2.0/db_home/bin/oracle

                  I know this problem is coming for improper assiging of permissions, but i could not pin point. kindly clarify the same.

                  one more thing i need to know.., whenever i rebooted nodes, both of raw devices and asm disks are come to default permission brw------, i have to change every time to brw-rw-r--. is there any way to make these disks and devices permissions make permenet.

                  Thanks in advance.
                  • 6. Re: Manual creation of Oracle RAC Database
                    FreddieEssex
                    The issue is that your disks belong to grid:asmadmin and the oracle user has only read access to these disks.

                    You can change the ownership of the disks to oracle:oinstall or and permissions should really be 660.

                    You need change the permissions of the these disks on server startup. See link below.

                    http://www.oracle-base.com/articles/10g/asm-using-asmlib-and-raw-devices.php#raw_device_setup
                    • 7. Re: Manual creation of Oracle RAC Database
                      vasuoracledba
                      Hi,

                      I changed the permissioons to oracle:oinstall for asm disks and permissions are also 664.

                      brw-rw-r-- 1 oracle oinstall 8, 65 Apr 20 22:26 ARCLOGDISK1
                      brw-rw-r-- 1 oracle oinstall 8, 66 Apr 20 22:26 ARCLOGDISK2
                      brw-rw-r-- 1 oracle oinstall 8, 67 Apr 20 22:26 ARCLOGDISK3
                      brw-rw-r-- 1 oracle oinstall 8, 68 Apr 20 22:26 ARCLOGDISK4
                      brw-rw-r-- 1 oracle oinstall 8, 49 Apr 20 22:26 CTRLDISK1
                      brw-rw-r-- 1 oracle oinstall 8, 50 Apr 20 22:26 CTRLDISK2
                      brw-rw-r-- 1 oracle oinstall 8, 51 Apr 20 22:26 CTRLDISK3
                      brw-rw-r-- 1 oracle oinstall 8, 52 Apr 20 22:26 CTRLDISK4
                      brw-rw-r-- 1 oracle oinstall 8, 33 Apr 20 22:26 DBFILEDISK1
                      brw-rw-r-- 1 oracle oinstall 8, 34 Apr 20 22:26 DBFILEDISK2
                      brw-rw-r-- 1 oracle oinstall 8, 35 Apr 20 22:26 DBFILEDISK3
                      brw-rw-r-- 1 oracle oinstall 8, 36 Apr 20 22:26 DBFILEDISK4
                      brw-rw-r-- 1 oracle oinstall 8, 113 Apr 20 22:26 FRADISK1
                      brw-rw-r-- 1 oracle oinstall 8, 114 Apr 20 22:26 FRADISK2
                      brw-rw-r-- 1 oracle oinstall 8, 115 Apr 20 22:26 FRADISK3
                      brw-rw-r-- 1 oracle oinstall 8, 116 Apr 20 22:26 FRADISK4
                      brw-rw-r-- 1 oracle oinstall 8, 81 Apr 20 22:26 REDODISK1
                      brw-rw-r-- 1 oracle oinstall 8, 82 Apr 20 22:26 REDODISK2
                      brw-rw-r-- 1 oracle oinstall 8, 83 Apr 20 22:26 REDODISK3
                      brw-rw-r-- 1 oracle oinstall 8, 84 Apr 20 22:26 REDODISK4
                      brw-rw-r-- 1 oracle oinstall 8, 97 Apr 20 22:26 REDODISK5
                      brw-rw-r-- 1 oracle oinstall 8, 98 Apr 20 22:26 REDODISK6
                      brw-rw-r-- 1 oracle oinstall 8, 99 Apr 20 22:26 REDODISK7
                      brw-rw-r-- 1 oracle oinstall 8, 100 Apr 20 22:26 REDODISK8
                      brw-rw-r-- 1 oracle oinstall 8, 17 Apr 20 22:26 VOTEDISK1
                      brw-rw-r-- 1 oracle oinstall 8, 18 Apr 20 22:26 VOTEDISK2
                      brw-rw-r-- 1 oracle oinstall 8, 19 Apr 20 22:26 VOTEDISK3
                      brw-rw-r-- 1 oracle oinstall 8, 20 Apr 20 22:26 VOTEDISK4

                      but still im getting the same error as follows.

                      ORA-00205: error in identifying control file, check alert log for more info

                      ORA-00210: cannot open the specified control file
                      ORA-00202: control file: '+CTRL'
                      ORA-17503: ksfdopn:2 Failed to open file +CTRL
                      ORA-15045: ASM file name '+CTRL' is not in reference form
                      ORA-205 signalled during: ALTER DATABASE MOUNT...

                      All the diskgroups are in mount state.

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

                      NAME STATE OFFLINE_DISKS
                      ------------------------------ ----------- -------------
                      DBFILE MOUNTED 0
                      VOTE MOUNTED 0
                      CTRL MOUNTED 0
                      ARCLOG MOUNTED 0
                      REDO1 MOUNTED 0
                      REDO2 MOUNTED 0
                      FRA MOUNTED 0

                      please assite me to resolve the same.

                      Thanks in advance.

                      Edited by: vasuoracledba on Apr 21, 2013 7:41 PM
                      • 8. Re: Manual creation of Oracle RAC Database
                        P.Forstmann
                        Did you create ASM disk groups ?
                        Please post output of following statement run on ASM instance:
                        select name, state from v$asm_diskgroup;
                        If not you must create them before creating a database because database instance parameters DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n must be set to ASM diskgroup names (and not to ASM disk names).

                        If you want to create a database on ASM you should not define instance parameter CONTROL_FILES but let Oracle create control files in default location (in your case in disk group defined by DB_CREATE_FILE_DEST). After database creation you can relocate control files with RMAN if needed.

                        Edited by: P. Forstmann on 22 avr. 2013 08:29
                        • 9. Re: Manual creation of Oracle RAC Database
                          vasuoracledba
                          Thanks for comments,

                          The following query shows the asm diskgroups and there status.
                          SQL> select name,statefrom v$asm_diskgroup;
                          NAME STATE
                          --------------------------------------------------------------------------------
                          -----------
                          --------------------------------------------------------------------------------
                          DBFILE MOUNTED
                          VOTE MOUNTED
                          CTRL MOUNTED
                          ARCLOG MOUNTED
                          REDO1 MOUNTED
                          REDO2 MOUNTED
                          FRA MOUNTED

                          The following are the parameters list for database(pfile)

                          db_name='finance'
                          processes = 200
                          audit_trail ='db'
                          db_block_size=8192
                          db_domain='vod.com'
                          diagnostic_dest='/oradump/oradata/finance/dump'
                          sessions=200
                          remote_login_passwordfile='EXCLUSIVE'
                          undo_tablespace='UNDOTBS1'
                          control_files = +CTRL
                          compatible ='11.2.0'
                          job_queue_processes = 10
                          undo_management = 'AUTO'
                          finance1.instance_name = finance1
                          db_create_file_dest = +DBFILE
                          db_create_online_log_dest_1 = +REDO1
                          db_create_online_log_dest_2 = +REDO2

                          i already created the database using ASM diskgroups. Control files are created on CTRL, datafiles are also created on DBFILE diskgroup.
                          Once i bounced the instance, then it is unbale to open the control file in +CTRL diskgroup.

                          SQL> startup
                          ORACLE instance started.

                          Total System Global Area 217157632 bytes
                          Fixed Size 2211928 bytes
                          Variable Size 159387560 bytes
                          Database Buffers 50331648 bytes
                          Redo Buffers 5226496 bytes
                          ORA-00205: error in identifying control file, check alert log for more info

                          Alert log contents are follows:

                          ORACLE_BASE from environment = /rdbms1/app/oracle/
                          Thu Apr 11 09:36:34 2013
                          ALTER DATABASE MOUNT
                          ORA-00210: cannot open the specified control file
                          ORA-00202: control file: '+CTRL'
                          ORA-17503: ksfdopn:2 Failed to open file +CTRL
                          ORA-15045: ASM file name '+CTRL' is not in reference form
                          ORA-205 signalled during: ALTER DATABASE MOUNT...
                          Thu Apr 11 09:36:42 2013
                          NOTE: initiating MARK startup

                          I know im facing the prodlem with permissions of grid and oracle user, im unable to pinpoint.
                          grid and oracle has secondary group asmadmin. all the rawdisks(/dev/sd*) and asm disks(/dev/oracleasm/disks/*) are owned by grid:asmadmin with permissions 664.

                          ls -l /rdbms1/app/oracle/product/11.2.0/db_home/bin/oracle
                          -r-sr-s--x 1 oracle asmadmin 210824720 Apr 8 13:39 /rdbms1/app/oracle/product/11.2.0/db_home/bin/oracle

                          Still im facing the problem with mounting the database.

                          Thanks in Advance.
                          • 10. Re: Manual creation of Oracle RAC Database
                            P.Forstmann
                            Try to:
                            1. start instance in NOMOUNT mode:
                            startup nomount
                            2. create database
                            3. after database successfull creation, query V$CONTROLFILE and set CONTROL_FILES parameter to right value in PFILE with full pathname.
                            • 11. Re: Manual creation of Oracle RAC Database
                              vasuoracledba
                              Hi Forstmann,

                              I already created the database on ASM., Why do i create again. I'm able to started the instance, but it is not open the +CTRL diskgroup.

                              The problem with only permissions, please clarify me about this.
                              • 12. Re: Manual creation of Oracle RAC Database
                                P.Forstmann
                                If you have already created database, you must set CONTROL_FILES instance parameter to control file full path name; something like:
                                CONTROL_FILES='+CRTL/<db_name>/controlfile.current.<number1>.<number2>'
                                You can find control file full path name with:
                                $ asmcmd find --type controlfile CTRL %
                                • 13. Re: Manual creation of Oracle RAC Database
                                  vasuoracledba
                                  Thanks for the proper comments, now im able to open the database.
                                  1. I created the spfile in asm diskgroup and bounced the database, but instance is going for pfile in dbs location, instaed spfile in asm diskgroup.
                                  How to make instance to accept spfile in diskgroup other than pfile in normal file system in dbs location.

                                  2. when i tried to start the database using srvctl cmd, it is showing following error.

                                  PRCR-1079 : Failed to start resource ora.finance.db
                                  ORA-01034: ORACLE not available
                                  ORA-27101: shared memory realm does not exist
                                  Linux-x86_64 Error: 2: No such file or directory
                                  Process ID: 0
                                  Session ID: 0 Serial number: 0

                                  ORA-01078: failure in processing system parameters
                                  CRS-2674: Start of 'ora.finance.db' on 'rac-node2' failed
                                  ORA-01034: ORACLE not available
                                  ORA-27101: shared memory realm does not exist
                                  Linux-x86_64 Error: 2: No such file or directory
                                  Process ID: 0
                                  Session ID: 0 Serial number: 0

                                  CRS-2632: There are no more servers to try to place resource 'ora.finance.db' on that would satisfy its placement policy
                                  ORA-01034: ORACLE not available
                                  ORA-27101: shared memory realm does not exist
                                  Linux-x86_64 Error: 2: No such file or directory
                                  Process ID: 0
                                  Session ID: 0 Serial number: 0

                                  ORA-01078: failure in processing system parameters
                                  CRS-2674: Start of 'ora.finance.db' on 'rac-node1' failed
                                  ORA-01034: ORACLE not available
                                  ORA-27101: shared memory realm does not exist
                                  Linux-x86_64 Error: 2: No such file or directory
                                  Process ID: 0
                                  Session ID: 0 Serial number: 0

                                  I already attached the oracle_home, instances finance1 and finance2 on rac-node1 and rac-node2 rep.,.
                                  Name Type Target State Host
                                  ------------------------------------------------------------
                                  ora.ARCLOG.dg ora....up.type ONLINE OFFLINE
                                  ora.CTRL.dg ora....up.type ONLINE OFFLINE
                                  ora.DBFILE.dg ora....up.type ONLINE OFFLINE
                                  ora.FRA.dg ora....up.type ONLINE OFFLINE
                                  ora....N1.lsnr ora....er.type ONLINE ONLINE rac-node2
                                  ora.REDO1.dg ora....up.type ONLINE OFFLINE
                                  ora.REDO2.dg ora....up.type ONLINE OFFLINE
                                  ora.VOTE.dg ora....up.type ONLINE OFFLINE
                                  ora.asm ora.asm.type ONLINE ONLINE rac-node1
                                  ora.eons ora.eons.type ONLINE ONLINE rac-node2
                                  ora.finance.db ora....se.type ONLINE    OFFLINE
                                  ora.gsd ora.gsd.type OFFLINE OFFLINE
                                  ora....network ora....rk.type ONLINE ONLINE rac-node1
                                  ora.oc4j ora.oc4j.type OFFLINE OFFLINE
                                  ora.ons ora.ons.type ONLINE ONLINE rac-node1
                                  ora....SM1.asm application ONLINE ONLINE rac-node1
                                  ora....de1.gsd application OFFLINE OFFLINE
                                  ora....de1.ons application ONLINE ONLINE rac-node1
                                  ora....de1.vip ora....t1.type ONLINE ONLINE rac-node1
                                  ora....SM2.asm application ONLINE ONLINE rac-node2
                                  ora....de2.gsd application OFFLINE OFFLINE
                                  ora....de2.ons application ONLINE ONLINE rac-node2
                                  ora....de2.vip ora....t1.type ONLINE ONLINE rac-node2
                                  ora....ry.acfs ora....fs.type ONLINE ONLINE rac-node1
                                  ora.scan1.vip ora....ip.type ONLINE ONLINE rac-node2

                                  Kindly help me this.
                                  Thanks in advance.
                                  • 14. Re: Manual creation of Oracle RAC Database
                                    P.Forstmann
                                    1. Try to run:
                                    create spfile='+DBFILE' from pfile;
                                    and shudown/restart database instances.

                                    2. What is the output of:
                                    $GRID_HOME/bin/crsctl stat res -t
                                    Please format result using following tags :{noformat}
                                     <crsctl output> 
                                    {noformat}

                                    To create manually a RAC database is not recommended if you are new to RAC: I would recommend to drop your existing database and recreate it from scratch with DBCA because DBCA will do all the work for RAC by default (especially creating cluster resource which are maybe not OK in your case).
                                    1 2 Previous Next