Forum Stats

  • 3,735,183 Users
  • 2,247,136 Discussions
  • 7,857,765 Comments

Discussions

DBCA NOT SHOWING DATA AND FRA .. PLEASE HELP ?

Ujjwal Rana
Ujjwal Rana Member Posts: 273

Hi, I was in the process of fresh installation of Oracle 11g. While running DBCA command, at DATA CONFIGURATION ASSISTANT, Step 6 of 12 : Database File Locations. Under Database Area, I click at BROSE BUTTON but it does not show either DATA nor FRA. Please find the attached screenshot for more clear.

databasearea.png

Tagged:

Best Answer

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273
    edited Jan 29, 2015 11:46PM Accepted Answer

    PROBLEM WAS SOLVED...as we know that /dev/raw/* must contain ORACLE as USER AND OINSTALL as GROUP in order to allocate ASM for DATA and FRA..NO ONE INCLUDING ME NOTICE THE USER AND GROUP which i have submitted above. I am again submitting the above information over here as well or you can check the same information [[email protected] dev]# ls -ld /dev/raw/* from the above. So this is what the users and group was before. Since in order to show DATA AND FRA disk under ASM , the  /DEV/RAW/  should be under ORACLE as USER AND OINSTALL as GROUP  but earlier /dev/raw/* was located under ROOT as USER and DISK as GROUP and due to this it was not showing the DATA and FRA allocated disk while using DBCA COMMAND

    [[email protected] dev]# ls -ld /dev/raw/*

    crw-rw----. 1 root   disk     162, 1 Jan 29 21:29 /dev/raw/raw1

    crw-rw----. 1 root   disk     162, 2 Jan 29 21:29 /dev/raw/raw2

    crw-rw----. 1 root   disk     162, 3 Jan 29 21:29 /dev/raw/raw3

    crw-rw----. 1 root   disk     162, 4 Jan 29 21:29 /dev/raw/raw4

    crw-rw----. 1 root   disk     162, 5 Jan 29 21:29 /dev/raw/raw5

    crw-rw----. 1 root   disk     162, 6 Jan 29 21:29 /dev/raw/raw6

    crw-rw----. 1 oracle oinstall 162, 0 Jan 29 21:29 /dev/raw/rawctl

    THE MAIN PROBLEM IN MY CASE WAS ON FOLLOWING, If you give OR type chown -R oracle:oinstall /dev/raw, chmod 770 /dev/raw, chmod 660 /dev/raw/raw* MANUALLY then it will show the correct USERS and GROUPS

    [[email protected] Desktop]# chown -R oracle:oinstall /dev/raw

    [[email protected] Desktop]# chmod 770 /dev/raw

    [[email protected] Desktop]# chmod 660 /dev/raw/raw*

    [[email protected] Desktop]# ls -ld /dev/raw/*

    crw-rw----. 1 oracle oinstall 162, 1 Jan 30 09:35 /dev/raw/raw1

    crw-rw----. 1 oracle oinstall 162, 2 Jan 30 09:35 /dev/raw/raw2

    crw-rw----. 1 oracle oinstall 162, 3 Jan 30 09:35 /dev/raw/raw3

    crw-rw----. 1 oracle oinstall 162, 4 Jan 30 09:35 /dev/raw/raw4

    crw-rw----. 1 oracle oinstall 162, 5 Jan 30 09:35 /dev/raw/raw5

    crw-rw----. 1 oracle oinstall 162, 6 Jan 30 09:35 /dev/raw/raw6

    crw-rw----. 1 oracle oinstall 162, 0 Jan 30 09:16 /dev/raw/rawctl

    [[email protected] Desktop]#

    WHEREAS

    If you the same things chown -R oracle:oinstall /dev/raw, chmod 770 /dev/raw, chmod 660 /dev/raw/raw* inside /etc/rc.d/rc.local then it shows the USERS and DISK as root and disk.

    [[email protected] ~ ] vi /etc/rc.d/rc.local

    !/bin/sh

    #

    # This script will be executed *after* all the other init scripts.

    # You can put your own initialization stuff in here if you don't

    # want to do the full Sys V style init stuff.

    touch /var/lock/subsys/local

    raw /dev/raw/raw1 /dev/sda11

    raw /dev/raw/raw2 /dev/sda12

    raw /dev/raw/raw3 /dev/sda13

    raw /dev/raw/raw4 /dev/sda14

    raw /dev/raw/raw5 /dev/sda15

    raw /dev/raw/raw6 /dev/sda16

    chown -R oracle:oinstall /dev/raw

    chmod 770 /dev/raw

    chmod 660 /dev/raw/raw*

    [[email protected] dev]# reboot or refresh

    AFTER THEN AGAIN IF YOU CHECK THE USER AND GROUP by using ls -ld /dev/raw/* commands then its shows the root and disk as user and group. It shows the root and disk where it should be ORACLE and OINSTALL under USER and GROUPS. I could not find out the reason why even after putting chown -R oracle:oinstall /dev/raw, chmod 770 /dev/raw, chmod 660 /dev/raw/raw* shows the wrong USER AND GROUP ?

    [[email protected] dev]# ls -ld /dev/raw/*

    crw-rw----. 1 root   disk     162, 1 Jan 29 21:29 /dev/raw/raw1

    crw-rw----. 1 root   disk     162, 2 Jan 29 21:29 /dev/raw/raw2

    crw-rw----. 1 root   disk     162, 3 Jan 29 21:29 /dev/raw/raw3

    crw-rw----. 1 root   disk     162, 4 Jan 29 21:29 /dev/raw/raw4

    crw-rw----. 1 root   disk     162, 5 Jan 29 21:29 /dev/raw/raw5

    crw-rw----. 1 root   disk     162, 6 Jan 29 21:29 /dev/raw/raw6

    crw-rw----. 1 oracle oinstall 162, 0 Jan 29 21:29 /dev/raw/rawctl

    SO HERE IS WHAT I DID.... THE SOLUTION THAT work for me is I created shell script file named test.sh.

    STEP 1 : CREATE SHELL SCRIPT FILE test.sh

    [[email protected] Desktop]# cat /root/test.sh

    chown -R oracle:oinstall /dev/raw

    chmod 770 /dev/raw

    chmod 660 /dev/raw/raw*

    STEP 2 : Locate test.sh file inside rc.local

    [[email protected] ~ ] vi /etc/rc.d/rc.local

    !/bin/sh

    #

    # This script will be executed *after* all the other init scripts.

    # You can put your own initialization stuff in here if you don't

    # want to do the full Sys V style init stuff.

    touch /var/lock/subsys/local

    raw /dev/raw/raw1 /dev/sda11

    raw /dev/raw/raw2 /dev/sda12

    raw /dev/raw/raw3 /dev/sda13

    raw /dev/raw/raw4 /dev/sda14

    raw /dev/raw/raw5 /dev/sda15

    raw /dev/raw/raw6 /dev/sda16

    /root/test.sh

    STEP 3 : REFRESH rc.local or you can REBOOT the pc one more time

    [[email protected] Desktop]# /etc/rc.d/rc.local

    STEP 4 : CHECK the USER and GROUP as mentioned below :-

    [[email protected] Desktop]# ls -ld /dev/raw/*

    crw-rw----. 1 oracle oinstall 162, 1 Jan 30 09:35 /dev/raw/raw1

    crw-rw----. 1 oracle oinstall 162, 2 Jan 30 09:35 /dev/raw/raw2

    crw-rw----. 1 oracle oinstall 162, 3 Jan 30 09:35 /dev/raw/raw3

    crw-rw----. 1 oracle oinstall 162, 4 Jan 30 09:35 /dev/raw/raw4

    crw-rw----. 1 oracle oinstall 162, 5 Jan 30 09:35 /dev/raw/raw5

    crw-rw----. 1 oracle oinstall 162, 6 Jan 30 09:35 /dev/raw/raw6

    crw-rw----. 1 oracle oinstall 162, 0 Jan 30 09:16 /dev/raw/rawctl

    [[email protected] Desktop]#

    [[email protected] Desktop]$ asmca

    asmshowing.png

    DATA AND FRA PROBLEM SOLVED

«1

Answers

  • what happens when you de-select "Use Oracle-Managed Files"?

    do you usually use OMF?

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273
    edited Jan 28, 2015 10:13PM

    By DE-SELECT or not clicking on browse AND If i click on NEXT then it gives a message saying ENTER A VALID VALUE FOR DATABASE AREA

  • One of us needs to have an eye exam.

    Best Wishes

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273

    By DE-SELECT or not clicking on browse AND If i click on NEXT then it gives a message saying ENTER A VALID VALUE FOR DATABASE AREA

  • rchem
    rchem Member Posts: 972

    Some options

    1) If you are using grid and oracle users , does oracle user has asmdba group assigned to it?

    2) check if there is a ASM password file at GRID_HOME/dbs

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273
    edited Jan 28, 2015 10:22PM

    UNDER GRID IT HAS FOLLOWING  OPERATIONS AND SYSTEM GROUP

    Oracle ASMDBA = asmdba

    Oracle ASM OPERATER = asmoper

    Oracle ASM ADMINISTRATOR = asmadmin

  • Jain Kunal
    Jain Kunal Member Posts: 26

    Hi,

    Can you check status of your HAS and other BG processes? Are you using asmlib, if yes is it up?

    Are diskgroups mounted in ASM?

    Try giving diskgroup name manually as +DATA, if it accepts.

    What are your configured environmental variables while running dbca (an output of env)?

    -Kunal

  • >What are your configured environmental variables while running dbca (an output of env)?

    DBCA requires ZERO  environmental variables to exist prior to invoking dbca.

  • rchem
    rchem Member Posts: 972

    There is similar question in below thread, see if this helps in your case

    Cannot see ASM disk groups in DBCA from oracle account

  • Jain Kunal
    Jain Kunal Member Posts: 26
    edited Jan 28, 2015 10:36PM

    Incorrect value of ORA_NLS10 can cause asmca to not work properly as it works on links internally

    I know this is about dbca but still there could be issues, no one knows

  • Jain Kunal wrote:
    
    I know this is about dbca but still there could be issues, no one knows 
    
    

    What issues? Please enumerate & elaborate specifics.

    If no one knows, then please explain how you would know what is correct & what is not correct in looking at OP's environmental variable values!

  • Jain Kunal
    Jain Kunal Member Posts: 26
    sol.beach wrote:
    
    
    Jain Kunal wrote:
    
    I know this is about dbca but still there could be issues, no one knows 
     
    
    
    What issues? Please enumerate & elaborate specifics.
    
    If no one knows, then please explain how you would know what is correct & what is not correct in looking at OP's environmental variable values!
    

    cooool man, we are just trying to help someone, you need to know sure i will tell, use context env file in an OeBS environment to load db env and then change to ASM env using oraenv and check your ORA_NLS10, it will point to 9idata folder. Now run asmca and you won't see any diskgroup there.....whoooolaaaa.......just unset ORA_NLS10 and you will be fine

  • Jain Kunal wrote:
    
    
    sol.beach wrote:
    
    
    Jain Kunal wrote:
    
    I know this is about dbca but still there could be issues, no one knows 
      
    
    
    What issues? Please enumerate & elaborate specifics.
    
    If no one knows, then please explain how you would know what is correct & what is not correct in looking at OP's environmental variable values!
    
    
    cooool man, we are just trying to help someone, you need to know sure i will tell, use context env file in an OeBS environment to load db env and then change to ASM env using oraenv and check your ORA_NLS10, it will point to 9idata folder. Now run asmca and you won't see any diskgroup there.....whoooolaaaa.......just unset ORA_NLS10 and you will be fine
    

    How does ORA_NLS10 apply to this V11 database & environment?

    >check your ORA_NLS10, it will point to 9idata folder

    what 9idata folder on new V11 database that does not yet exist?

    Ready, Fire, AIM!

  • Igoroshka
    Igoroshka Member Posts: 1,585 Gold Trophy

    1. Is GI (SIHA, RAC) installed?

    2. Are there diskgroups available? -- asmcmd lsdg

    3. Please check HA: [GI user] crsctl status resource -t

  • Hemant K Chitale
    Hemant K Chitale Member Posts: 15,755 Blue Diamond

    UNDER GRID IT HAS FOLLOWING  OPERATIONS AND SYSTEM GROUP

    Oracle ASMDBA = asmdba

    Oracle ASM OPERATER = asmoper

    Oracle ASM ADMINISTRATOR = asmadmin

    And what about the Oracle account for the database running dbca ?  Exactly what version are you running for GI and RDBMS ?  Is this a standalone (non-RAC) server ?  As you are using Role Separation for Grid and RDBMS, have you checked for instructions about Role Separation -- e.g. importantly what groups the dbca oracle account is a member of, what permissions are on the ASM disks ?   11g versions also had you to  see Support Note Doc ID 10814186.1 and 1054033.1

    Hemant K Chitale

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273

    Hi,

    I thought to share the information which i followed for the configuration of DATA AND FRA.
    THIS IS WHAT I DID FOR DATA AND FRA DISK ALLOCATION but the problem still exist. Please help :-

    [[email protected] ~]# parted

    GNU Parted 2.1

    Using /dev/sda

    Welcome to GNU Parted! Type 'help' to view a list of commands.

    (parted) print                                                         

    Model: ATA TOSHIBA MQ01ABD0 (scsi)

    Disk /dev/sda: 500GB

    Sector size (logical/physical): 512B/4096B

    Partition Table: gpt

    Number  Start   End     Size    File system     Name     Flags

    1      1049kB  4195MB  4194MB  fat32                    boot

    2      4195MB  8914MB  4719MB  ext4

    3      8914MB  40.4GB  31.5GB  ext4

    4      40.4GB  71.8GB  31.5GB  ext4

    5      71.8GB  98.0GB  26.2GB  ext4

    6      98.0GB  124GB   26.2GB  ext4

    7      124GB   145GB   21.0GB  ext4

    8      145GB   156GB   10.5GB  ext4

    9      156GB   164GB   8389MB  ext4

    10      164GB   169GB   5243MB  linux-swap(v1)

    11      170GB   180GB   9999MB                  logical

    12      181GB   191GB   10.0GB                  logical

    13      192GB   202GB   10.0GB                  logical

    14      203GB   213GB   10.0GB                  logical

    15      214GB   224GB   10.0GB                  logical

    16      225GB   235GB   9999MB                  logical

    (parted)  mkpart logical ext4 236GB 246GB (THIS IS THE EXAMPLE OF HOW I CREATED A DISK FOR SDA11 TO SDA16 FOR DATA AND FRA WHICH IS MENTIONED ABOVE)                                      

    ===================================================================================================================================

    [[email protected] ~]# raw /dev/raw/raw1 /dev/sda11

    [[email protected] ~]# raw /dev/raw/raw2 /dev/sda12

    [[email protected] ~]# raw /dev/raw/raw3 /dev/sda13

    [[email protected] ~]# raw /dev/raw/raw4 /dev/sda14

    [[email protected] ~]# raw /dev/raw/raw5 /dev/sda15

    [[email protected] ~]# raw /dev/raw/raw6 /dev/sda16

    [[email protected] ~]# ls -l /dev/raw

    [[email protected] ~]# chown -R oracle:oinstall /dev/raw

    [[email protected] dev]# ls -ld /dev/raw/*

    crw-rw----. 1 root   disk     162, 1 Jan 29 21:29 /dev/raw/raw1

    crw-rw----. 1 root   disk     162, 2 Jan 29 21:29 /dev/raw/raw2

    crw-rw----. 1 root   disk     162, 3 Jan 29 21:29 /dev/raw/raw3

    crw-rw----. 1 root   disk     162, 4 Jan 29 21:29 /dev/raw/raw4

    crw-rw----. 1 root   disk     162, 5 Jan 29 21:29 /dev/raw/raw5

    crw-rw----. 1 root   disk     162, 6 Jan 29 21:29 /dev/raw/raw6

    crw-rw----. 1 oracle oinstall 162, 0 Jan 29 21:29 /dev/raw/rawctl

    [[email protected] dev]#

    [[email protected] ~]# chmod 770 /dev/raw

    [[email protected] ~]# chmod 660 /dev/raw/raw*

    [[email protected] ~]# ls -ld /dev/raw/raw*

    crw-rw----. 1 root   disk     162, 1 Jan 29 21:29 /dev/raw/raw1

    crw-rw----. 1 root   disk     162, 2 Jan 29 21:29 /dev/raw/raw2

    crw-rw----. 1 root   disk     162, 3 Jan 29 21:29 /dev/raw/raw3

    crw-rw----. 1 root   disk     162, 4 Jan 29 21:29 /dev/raw/raw4

    crw-rw----. 1 root   disk     162, 5 Jan 29 21:29 /dev/raw/raw5

    crw-rw----. 1 root   disk     162, 6 Jan 29 21:29 /dev/raw/raw6

    crw-rw----. 1 oracle oinstall 162, 0 Jan 29 21:29 /dev/raw/rawctl

    [[email protected] ~]#

    [[email protected] ~]# vi /etc/rc.d/rc.local

    #!/bin/sh

    #

    # This script will be executed *after* all the other init scripts.

    # You can put your own initialization stuff in here if you don't

    # want to do the full Sys V style init stuff.

    touch /var/lock/subsys/local

    raw /dev/raw/raw1 /dev/sda11

    raw /dev/raw/raw2 /dev/sda12

    raw /dev/raw/raw3 /dev/sda13

    raw /dev/raw/raw4 /dev/sda14

    raw /dev/raw/raw5 /dev/sda15

    raw /dev/raw/raw6 /dev/sda16

    chown -R oracle:oinstall /dev/raw

    chmod 770 /dev/raw

    chmod 660 /dev/raw/raw*

    [[email protected] ~]$ asmca

    asmca_screenshot.png

    [[email protected] ~]$ asmcmd

    ASMCMD> ls

    ASMCMD>

    THOUGHT TO SHARE FOLLOWING STATUS

    [[email protected] ~]$ crsctl status res -t

    --------------------------------------------------------------------------------

    NAME           TARGET  STATE        SERVER                   STATE_DETAILS  

    --------------------------------------------------------------------------------

    Local Resources

    --------------------------------------------------------------------------------

    ora.DATA.dg

                   ONLINE  OFFLINE      example                       

    ora.FRA.dg

                   ONLINE  OFFLINE      example                       

    ora.LISTENER.lsnr

                   ONLINE  INTERMEDIATE example        Not All Endpoints R

                                                                 egistered      

    ora.asm

                   ONLINE  ONLINE       example        Started        

    ora.ons

                   OFFLINE OFFLINE      example                       

    --------------------------------------------------------------------------------

    Cluster Resources

    --------------------------------------------------------------------------------

    ora.cssd

          1        ONLINE  ONLINE       example                       

    ora.diskmon

          1        OFFLINE OFFLINE                                              

    ora.evmd

          1        ONLINE  ONLINE       example                       

    [[email protected] ~$

  • BPeaslandDBA
    BPeaslandDBA Member Posts: 4,615 Blue Diamond

    Your screenshot here shows that you do not have any disk groups. Are you sure they are created correctly in ASM? The DBCA won't be able to create them in advance.

    Cheers,
    Brian

  • Igoroshka
    Igoroshka Member Posts: 1,585 Gold Trophy

    Your disk groups DATA and FRA are offline.

    ora.DATA.dg
                   ONLINE  OFFLINE      example                       
    ora.FRA.dg
                   ONLINE  OFFLINE      example                     
    

    Also there are problems with listener.

    ora.LISTENER.lsnr
                   ONLINE  INTERMEDIATE example        Not All Endpoints R
                                                                 egistered      
    

    First of all it is necessary to get ASM working correctly.

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273

    While installing grid software I allocate three disc for DATA ...it did showed sda11 to sda16 during that time and I allocate only three disk for DATA also by using asmca command i allocate three more disk for FRA but when i was in the process of installing database by dbca command...It was supposed to show both the DATA and FRA disk but id does not show. Also I again tried asmca again but this time it does not show any disk by using asmca.


    Please advice ?

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273

    While installing grid software I allocate three disc for DATA ...it did showed sda11 to sda16 during that time and I allocate only three disk for DATA also by using asmca command i allocate three more disk for FRA but when i was in the process of installing database by dbca command...It was supposed to show both the DATA and FRA disk but id does not show. Also I again tried asmca again but this time it does not show any disk by using asmca.


    Please suggest if you need more information in order to make sure.

  • Jain Kunal
    Jain Kunal Member Posts: 26

    Seems like your rawdevices service is disabled, try this

    service rawdevices status   ---- to check state

    service rawdevices start   ---- to start

    chkconfig rawdevices on   ---- to start rawdevices at system boot

    After this mount your diskgroups in ASM.

    -Kunal

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273

    RAW DEVICES COMMAND does not recognized


    [[email protected] ~]# chkconfig –list | grep raw

    [[email protected] ~]# service rawdevices status

    rawdevices: unrecognized service

    [[email protected] ~]# service rawdevices start

    rawdevices: unrecognized service

    [[email protected] ~]# chkconfig rawdevices on

    error reading information on service rawdevices: No such file or directory

    [[email protected] ~]#

  • Jain Kunal
    Jain Kunal Member Posts: 26

    Wait a minute.....you have separation of duties using grid and oracle user.....under grid you have asmdba, asmoper, asmadmin but you are setting permission only for oracle:dba

    660 will not let grid identify raw disks.

    Check this out

    https://docs.oracle.com/database/121/CWSOL/usrgrps.htm#CWSOL483

    -Kunal

  • Ujjwal Rana
    Ujjwal Rana Member Posts: 273
    edited Jan 29, 2015 10:27PM

    [[email protected] ~]# grep oinstall /etc/group

    oinstall:x:503:

    [[email protected] ~]# id oracle

    uid=501(oracle) gid=503(oinstall) groups=503(oinstall),501(asmdba),504(dba),505(oper)

    [[email protected] ~]#

    [[email protected] ~]# /sbin/start_udev

    Starting udev:                                             [  OK  ]

    [[email protected] ~]# ls -l /dev/sd*

    brw-rw----. 1 root disk   8,  0 Jan 30 08:53 /dev/sda

    brw-rw----. 1 root disk   8,  1 Jan 30 08:53 /dev/sda1

    brw-rw----. 1 root disk   8, 10 Jan 30 08:53 /dev/sda10

    brw-rw----. 1 root disk   8, 11 Jan 30 08:53 /dev/sda11

    brw-rw----. 1 root disk   8, 12 Jan 30 08:53 /dev/sda12

    brw-rw----. 1 root disk   8, 13 Jan 30 08:53 /dev/sda13

    brw-rw----. 1 root disk   8, 14 Jan 30 08:53 /dev/sda14

    brw-rw----. 1 root disk   8, 15 Jan 30 08:53 /dev/sda15

    brw-rw----. 1 root disk 259,  0 Jan 30 08:53 /dev/sda16

    brw-rw----. 1 root disk   8,  2 Jan 30 08:53 /dev/sda2

    brw-rw----. 1 root disk   8,  3 Jan 30 08:53 /dev/sda3

    brw-rw----. 1 root disk   8,  4 Jan 30 08:53 /dev/sda4

    brw-rw----. 1 root disk   8,  5 Jan 30 08:53 /dev/sda5

    brw-rw----. 1 root disk   8,  6 Jan 30 08:53 /dev/sda6

    brw-rw----. 1 root disk   8,  7 Jan 30 08:53 /dev/sda7

    brw-rw----. 1 root disk   8,  8 Jan 30 08:53 /dev/sda8

    brw-rw----. 1 root disk   8,  9 Jan 30 08:53 /dev/sda9

    [[email protected] ~]#

    [[email protected] ~]# raw -qa

    /dev/raw/raw1:    bound to major 8, minor 11

    /dev/raw/raw2:    bound to major 8, minor 12

    /dev/raw/raw3:    bound to major 8, minor 13

    /dev/raw/raw4:    bound to major 8, minor 14

    /dev/raw/raw5:    bound to major 8, minor 15

    /dev/raw/raw6:    bound to major 259, minor 0

    [[email protected] ~]#

  • NEVER, EVER, Never use OS root use to do anything involving Oracle software

This discussion has been closed.