Forum Stats

  • 3,769,554 Users
  • 2,252,976 Discussions
  • 7,875,083 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

«13

Answers

This discussion has been closed.