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
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
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
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.
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?
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
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
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.
Hi Bharat,
Check if all the datafiles on standby site are accessible.
Regards
Anju Garg
hi mam,
datafile are not accessible in standby site, current_scn is behind to the primary DB,
Plz help me out this problem.
Do you have any backup of the affected files – on standby or primary site?
yes , i have on primary site???
Is the SCN# of the backup < current SCN# of standby database?
yes, scn#of primary < current scn# of stadby db????
Pls go through following post:
http://oracleinaction.com/recover-standby-datafile-primary/
Regards
Anju Garg
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 …………………………….
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
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
Hi Dhaneesh,
You can post your query. I will try to help.
Regards
ANju GArg
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.
Thanks for your time Raju!!!
Your comments and suggestions are always welcome.
Regards
Anju Garg
Hello Anju,
Is that you who was writing in this blog below post before 2012 ?(http://koenigocm.blogspot.in/2012/01/sql-plan-management-oracle-database-11g.html).
I use to read your posts regularly but when I got redirected to this site from its homepage, was little surprised….
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.
Hi Bharat
Here are some links I have found by googling. I have not tested any of them
http://select-star-from.blogspot.in/2013/09/how-to-check-table-fragmentation-in.html
https://www.linkedin.com/groups/Table-Fragmentation-in-Oracle-11g-77941.S.5807914721717796864
http://www.dbas-oracle.com/2011/04/identify-and-remove-table-fragmentation.html
Regards
Anju Garg
thanks mam
You are always welcome Bharat!
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.
Hello Veera
Kindly look at the following links:
http://oracleinaction.com/eviction-netwk-heartbeat/
http://oracleinaction.com/eviction-disk-heartbeat/
http://oracleinaction.com/eviction-member-escalation/
Regards
Anju Garg
Hi Anju,
Thanks for the reply, I will check the links & update you if i have any queries.
Thanks
Veera.
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.
Hi Veera,
Pls refer to following links :
http://www8.hp.com/h20195/V2/getpdf.aspx/4AA4-8504ENW.pdf?ver=1.0
https://docs.oracle.com/database/121/CWLIN/prelinux.htm#CHDCEBCD
https://access.redhat.com/solutions/54164
http://www.dba-oracle.com/t_linux_disk_i_o.htm
Hope it helps
Regards
Anju Garg
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
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
Hi Bharat,
Pls check your /etc/hosts entry for racnode1 and racnode2.
Regards
Anju
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………….
Hi Anju,
Can u send me RAC to RAC db clonning steps………..
Regards
Bharat
Hi Bharat,
Please refer to following post of mine:
http://oracleinaction.com/migrate-rac-db/
regards
Anju
Thanks Anju………….
Hi Mam,
Please suggest why is rconfig faild, please refer above logs.
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
I was having issues with the expdp on ASM and your post was just accurate as hell, thank you very much!!!
Hi Daniel,
Thanks for your time and feedback!
regards
Anju Garg