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

Manual creation of Oracle RAC Database

vasuoracledba Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    Check the permissions of the raw device and not the block device.
  • 2. Re: Manual creation of Oracle RAC Database
    vasuoracledba Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points