Forum Stats

  • 3,782,436 Users
  • 2,254,645 Discussions
  • 7,880,078 Comments

Discussions

DBCA NOT SHOWING DATA AND FRA .. PLEASE HELP ?

2

Answers

  • 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,759 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.

This discussion has been closed.