37 thoughts on “blogger

  1. The first topic I read in your blog is checkpoint. You have written it excellent. I will be start using your blog. Thank U for making this blog…
    — Pradeep Rajanna
    Mysore, Karnataka

    1. hi mam,

      i got the error in dataguad are following,

      in ora-16766: redo apply is stopped (standby site) databroker congfig shows me,

      in alert filer shows me on standby site,

      ora-01110 & ora-01157

      please help me out these error.

  2. thanks for solving my previous issue,

    Now it is ISCSI issue , when i installed mention below rpm it shows me following error

    [root@host01 RAC_REQUIREMENTS]# rpm -ivh iscsi-initiator-utils-6.2.0.872-16.el5.i386.rpm
    warning: iscsi-initiator-utils-6.2.0.872-16.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e8562897
    Preparing… ########################################### [100%]
    file /etc/iscsi/iscsid.conf from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /etc/rc.d/init.d/iscsi from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /etc/rc.d/init.d/iscsid from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /sbin/iscsi-iname from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /sbin/iscsiadm from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /sbin/iscsid from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /sbin/iscsistart from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /usr/include/libiscsi.h from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /usr/lib/libfwparam.a from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /usr/lib/libiscsi.so.0 from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /usr/lib/python2.4/site-packages/libiscsimodule.so from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /usr/share/man/man8/iscsiadm.8.gz from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386
    file /usr/share/man/man8/iscsid.8.gz from install of iscsi-initiator-utils-6.2.0.872-16.el5.i386 conflicts with file from package iscsi-initiator-utils-6.2.0.871-0.10.el5.i386

    plz help me out …………………………….

    1. Hi Bharat!

      You are getting this error because already have iscsi-initiator-utils-6.2.0.871-0.10.el5.i386 installed on your machine.

      Either you can continue with the existing rpm or
      – you can try installing using rpm -Uvh
      or
      – First deinstall existing rpm and then install the new one

      Regards
      Anju Garg

  3. Hi ,

    I would like to know more about on interpreting AWR, Identifying and Evaluating I/O Bottlenecks in Oracle Database .could you please help me

  4. Hi Anju, your explanation on any concept is original and you make complex technical aspects very simple. Thanks for your efforts ad sharing the knowledge with all.

  5. Hi Anju,

    I need script to find table fragmentation. although i googled it but didn,t find any usefull blog

    Please do the needfull on ASAP.

  6. Hi ALL,

    Good day, I’m linux admin, what are the string/words need to search in alertlog and ocssd.log & etc file to analyze in case the node evection.

    Thanks
    Veera.

  7. Hi Anju,

    What is the best i/o schedular for ORACLE RAC running on Linux servers. how read and write happens in DB server? is more read and less write happens on DB? could you please explain bit more on I/O behaviour if it DB server?

    Thanks
    Veera.

      1. Anju,

        Thanks for reply, it was helpful.

        I have another query, could you please ping me to Linux performance tuning guide for oracle RAC.

        Thanks
        Veera

  8. Hi Anju,

    I got the mention following error i am doing grid clonning 11203 i googled it but not helpfull.

    Please do the needfull.

    Checking hosts config file…
    Node Name Status Comment
    ———— ———————— ————————
    racnode2 failed Invalid Entry
    racnode1 failed Invalid Entry

    ERROR:
    PRVF-4190 : Verification of the hosts config file failed

      1. Hi Anju,

        Thanks for your kind suggestion, now error is rectify after mention following entry in etc/hosts file

        [root@racnode2 ~]# cat /etc/hosts
        127.0.0.1 localhost.localdomain localhost

        # Public

        192.168.1.151 racnode1.orcl.com racnode1
        192.168.1.152 racnode2.orcl.com racnode2

        # Private
        192.168.2.151 racnode1-priv racnode1-priv
        192.168.2.152 racnode2-priv racnode2-priv

        [grid@racnode1 grid]$ ./runcluvfy.sh stage -pre crsinst -n racnode1,racnode2 -verbose

        Performing pre-checks for cluster services setup

        Checking node reachability…

        Check: Node reachability from node “racnode1″
        Destination Node Reachable?
        ———————————— ————————
        racnode1 yes
        racnode2 yes
        Result: Node reachability check passed from node “racnode1″

        Checking user equivalence…

        Check: User equivalence for user “grid”
        Node Name Status
        ———————————— ————————
        racnode2 passed
        racnode1 passed
        Result: User equivalence check passed for user “grid”

        Checking node connectivity…

        Checking hosts config file…
        Node Name Status
        ———————————— ————————
        racnode2 passed
        racnode1 passed

        Verification of the hosts config file successful

        Thanks a lot………………..plz continue this work………….

    1. Hi Bharat,

      Pls refer to the last line in the output:
      The cluster is not configured or is not running on node: racnode1

      Start/configure clusterware on racnode1.

      Hope it helps

      Regards
      Anju

Your comments and suggestions are welcome!