Tuesday, January 19, 2010

Oracle 11gR2 RAC installation: kernel, ssh user equivalency, networking and time sync

This post will describe how to configure SSH user equivalency, set some kernel parameters, the network, sync the time between the two nodes and load the hangcheck/timer module.
First of all let's set up the ssh user equivalency: use pgrep sshd to see if ssh daemon is running.
You need either an RSA or a DSA key for the SSH protocol. RSA is used with the SSH 1.5 protocol, while DSA is the default for the SSH 2.0 protocol.
To configure SSH you should create RSA keys on each node using the following steps as oracle user:
su - oracle
ssh-keygen -t rsa -b 1024
When it asks for a passphrase, leave it empty. This command writes the RSA public key to the ~/.ssh/id_rsa.pub file and the private key to the ~/.ssh/id_rsa file.
Repeat the above steps on the other node that you intend to make a member of the cluster, using the RSA key.
Then you should add all keys to a common authorized_keys file.
Combine the contents of the id_rsa.pub files from each server. This operation can be done starting simply from one node. Run the commands below from the first node (in my case 172.22.0.10), for example, as the oracle user (and from /home/oracle directory):
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh 172.22.0.11 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys 172.22.0.11:/home/oracle/.ssh/
Each time you connect from any node to a new hostname for the first time, you will see a message similar to "The authenticity of host '172.22.0.11 (172.22.0.10)' can't be established. Are you sure you want to continue connecting (yes/no)?". Type "yes" and press ENTER.




Then edit /etc/hosts file for both nodes to set up public and private networking.




Use the following command syntax, where hostname1, hostname2, and so on, are the public hostnames(alias and fully qualified domain name) of nodes in the cluster to run SSH from the local node to each node, including from the local node to itself, and from each node to each other node:
ssh hostname1 hostname
At the end of this process, the public hostname for each member node should be registered in the known_hosts file for all other cluster member nodes.


Just because my nodes are connected to EMC SP Agent (Array Agent) I need to install Navisphere Host Agent, downloaded from EMC website.
Host Agent is required for the registration of the host bus adapters with the SPs to which they are connected and for integrating host-side information such as device and volume names. A Host Agent automatically registers hosts and HBAs and also provides drive mapping information for the UI and CLI








To let both nodes synced I used Network Time Server protocol, because you should ensure that the system clocks on all nodes are as close as possible, so edit /etc/ntp.conf file and add your ntp server.


Then configure ntpd to start automatically and update manually both nodes.




On all cluster nodes, verify that the kernel parameters are set to values greater than or equal to the recommended value. The procedure following the table describes how to verify and set the values on /etc/sysctl.conf. Then use /sbin/sysctl -p to load this configuration without restarting the nodes.




To improve the performance of the software on Linux systems, you must increase the following shell limits for the oracle user, editing /etc/security/limits.conf file.




Add or edit the following line in the /etc/pam.d/login file, if it does not already exist:
session required /lib/security/pam_limits.so


Depending on the oracle user's default shell, make the following changes to the default shell startup file. For the Bourne, Bash, or Korn shell, add the following lines to the /etc/profile file (or the file/etc/profile.local on SUSE systems):


For the C shell (csh or tcsh), add the following lines to the /etc/csh.login file (or the file/etc/csh.login.local on SUSE systems):

(*Modified on 27 September 2010: as stated on note ID 726833.1 on Oracle 11gR2 there's no need to configure the handcheck-timer module as I suggested below)
Before installing Oracle Real Application Clusters on Linux systems, verify that the hangcheck-timer module (hangcheck-timer) is loaded and configured correctly.
hangcheck-timer monitors the Linux kernel for extended operating system hangs that could affect the reliability of a RAC node and cause a database corruption.
If a kernel/device driver hang occurs, then the module restarts the node in seconds. There are 3 parameters used to control the behavior of the module:
1. The hangcheck_tick parameter: it defines how often, in seconds, the hangcheck-timer checks the node for hangs. The default value is 60 seconds. Oracle recommends to set it to 1(hangcheck_tick=1).
2.The hangcheck_margin parameter: it defines how long the timer waits, in seconds, for a response from the kernel. The default value is 180 seconds. Oracle recommends to set it to 10(hangcheck_margin=10)
3.The hangcheck_reboot parameter: If the value of hangcheck_reboot is equal to or greater than 1, then the hangcheck-timer module restarts the system. If the hangcheck_reboot parameter is set to zero, then the hangcheck-timer module will not restart the node. It should always be set to 1.
If the kernel fails to respond within the sum of the hangcheck_tick and hangcheck_margin parameter values, then the hangcheck-timer module restarts the system.
Log in as root, and enter the following command to check the kernel version:
uname -a
On Kernel 2.6 enter a command similar to the following to start the module located in the directories of the current kernel version:
insmod /lib/modules/kernel_version/kernel/drivers/char/hangcheck-timer.ko hangcheck_tick=1 hangcheck_margin=10 hangcheck_reboot=1
echo "insmod /lib/modules/kernel_version/kernel/drivers/char/hangcheck-timer.ko hangcheck_tick=1 hangcheck_margin=10 hangcheck_reboot=1" >> /etc/rc.d/rc.local



242 comments:

«Oldest   ‹Older   201 – 242 of 242
Anonymous said...

Your wау of explаining everythіng in this post iѕ really nice, every
onе be ablе to simply be awаre of it,
Thаnkѕ a lot.

Ϻy weblog; green coffee bean extract 800

Anonymous said...

Ѕаved as a faνorite, I гeally likе your
sіtе!

Mу blοg poѕt :: raspberry ketone reviews

Anonymous said...

That is really crucial since ingesting just 1000 calories
working day soon after working day is reduced.

my web blog: click through the next document

Anonymous said...

Ӏ really like it when inԁividuals сome
togethеr anԁ ѕhare thoughts. Great blog, continue thе gоοd work!


My wеb ѕіte :: disney light up hoodie

Anonymous said...

Ӏ'm amazed, I must say. Seldom do I encounter a blog that's both
equally educative and intеreѕting, and wіthout a doubt,
you've hit the nail on the head. The problem is an issue that not enough people are speaking intelligently about. I am very happy I came across this during my search for something concerning this.

Feel free to surf to my web page: raspberry ketone

Anonymous said...

Saved as a favorite, I love your web site!

my web page: Norwalk Connecticut Real Estate

Anonymous said...

Howdy! This post couldn't be written much better! Looking at this post reminds me of my previous roommate! He continually kept preaching about this. I will send this information to him. Pretty sure he'll have a very good
read. Many thanks for sharing!

my weblog; mortgage loan for poor credit :: :
:

Anonymous said...

Hi there, i read your blog occasionally and i own a similar one and i was
just curious if you get a lot of spam responses? If so how do you protect against
it, any plugin or anything you can suggest? I get so much lately it's driving me crazy so any support is very much appreciated.

Feel free to surf to my web site - horse stall mats CrossFit

Anonymous said...

I am гeally impresseԁ with your writing sκills as well as with the lаyout
on youг weblоg. Is this a paiԁ theme or did you
customize it yоurself? Eithеr ωaу keeρ up the
excellent quality writing, it's rare to see a nice blog like this one these days.

Look at my homepage: green coffee extract

Anonymous said...

It's going to be end of mine day, but before ending I am reading this great paragraph to improve my know-how.

Check out my web-site :: raspberry ketone drops

Anonymous said...

Hello, just wanted to say, I loved this article.
It was helpful. Keep on posting!

Here is my weblog Optik Tv

Anonymous said...

Its like you read my thoughts! You appear to grasp a lot about this, like you wrote the e book in
it or something. I believe that you can do with a few percent to drive the message house a bit, however instead
of that, this is fantastic blog. A great read.
I'll definitely be back.

My blog post :: tooth whitening and weddings

Anonymous said...

I'm curious to find out what blog system you are using? I'm having some small security problems with my latest
site and I'd like to find something more secure. Do you have any solutions?

Feel free to visit my page: buy youtube video views

Anonymous said...

Hi! Quicκ queѕtion thаt's totally off topic. Do you know how to make your site mobile friendly? My site looks weird when viewing from my iphone4. I'm trуing to find a templаte oг рlugin that might be аble to resοlve this iѕsuе.
If you haѵe any recommendationѕ, please share.
With thanks!

My websіte :: raspberry keytones

Anonymous said...

Hi there! ӏ realize this iѕ kinԁ of
off-toρiс but I needed to ask. Doеs running а well-establisheԁ website like yourѕ гequire a lοt of worκ?

I am brand nеw to runnіng a blog howеver Ӏ do wгitе in my
journаl evеryday. I'd like to start a blog so I will be able to share my experience and views online. Please let me know if you have any ideas or tips for new aspiring blog owners. Thankyou!

Here is my web page :: green coffee bean extract with raspberry ketones

Anonymous said...

I am sure this piece of writing
has touched all the internet visitors, its really really pleasant article on
building up new website.

Feel free to visit my web site; Reebok Nano 3.0

Anonymous said...

Greetings from Ohio!

I'm bored to tears at work so I decided to check out your website on my iphone during lunch break. I enjoy the knowledge you provide here and can't wait to
take a look when I get home. I'm shocked at how quick your blog loaded on my cell phone .. I'm not even
using WIFI, just 3G .. Anyways, wonderful blog!


Here is my homepage - man online dating ()

Anonymous said...

Inspirіng quest thеre. Whаt happened аftеr?
Good luck!

Αlso visіt my weblog; flaωless raspberrу ketone (ultimatediscountsnow538.id1945.com)

Anonymous said...

Fοr most up-to-date news you have tо visit the web and on world-wіde-web I found thіs web ρage
аѕ a most excеllent ωeb page for neωest uρdatеs.


Mу website :: raspberry ketones free shipping ()

Anonymous said...

Ι blοg fгequеntly and
I ѕегiouslу thank you fοr
your іnfoгmation. The аrticle haѕ trulу peakеԁ my interest.
I am gοing tο bοoκ mагk уour wеbsіte аnd keеp сhecκing for nеω detаils about οnсe pеr week.
Ι οptеd in for уоur Fеed
aѕ ωell.

my blog; deep fryer for turkey

Anonymous said...

Wow, this artіcle iѕ nicе, my
younger sister is analyzing these kinds of things, thus I
am goіng to inform her.

Μу ωebsite - raspberry ketones supplements

Anonymous said...

Good blog you hаve here.. It's difficult to find quality writing like yours nowadays. I truly appreciate people like you! Take care!!

my webpage: green coffee bean extract weight loss

Anonymous said...

Marvelous, what a web site it is! This webpage presents helpful information to us, keep it
up.

my web blog oase solarpumpen

Anonymous said...

Ηаvе yоu eѵeг consideгed writing an
e-boοk or guest authoring οn otheг ѕites?
I have a blog bаseԁ on the same tοpіcs
уou disсuss and woulԁ rеallу like to have you ѕhare
some stоries/infоrmation. I know my аudience
would value your work. If уou arе even remotеlу interested, feel free to shoot
me an e mаіl.

My wеb sіte :: best homе ԁeep frуer ()

Anonymous said...

Нello, the wholе thіng is gоіng
ωell herе and ofсoursе
еvery οne is ѕharing facts, thаt's in fact fine, keep up writing.

Here is my web page - rival deep fryer

Anonymous said...

I lіke thе valuable іnformatiοn yοu prοvіdе
in your articles. I'll bookmark your blog and check again here regularly. I am quite certain I will learn a lot of new stuff right here! Good luck for the next!

Feel free to surf to my web blog - strappy silver shoes

Anonymous said...

Greetings! Τhis is my fiгst comment here
so I just ωantеd to give a quick shout out and tеll you I truly еnjoy reaԁіng
through your blοg posts. Can уou гecommеnԁ any other blogѕ/ωebsites/forums that coveг the samе subjects?
Thank уou!

My web blоg; tfal acti fry

Anonymous said...

Ιt's an amazing paragraph for all the online users; they will take advantage from it I am sure.

Here is my blog post low fat fryer [class.mystudies.net]

jake george said...

Oracle RAC DBA Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/oracle-rac-dba-online-training-127.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Oracle RAC DBA Online Training, Oracle RAC DBA Training, Oracle RAC DBA, Oracle RAC DBA Online Training| Oracle RAC DBA Training| Oracle RAC DBA| "Courses at 21st Century Software Solutions
Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
Visit: http://www.21cssindia.com/courses.html"

Kenneth Baker said...

Same day loans no credit check are advantageous simply because many men and women contain the very same difficulty in terms of rapid loans that is certainly the belief that a single isn't going to find the required time to settle the particular text loans.
http://www.samedaytextloans.co.uk
http://www.shorttermdoorsteploans.co.uk

Dr Purva Pius said...

Hello Everybody,
My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of S$250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of S$250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius,via email:(urgentloan22@gmail.com) Thank you.

BORROWERS APPLICATION DETAILS


1. Name Of Applicant in Full:……..
2. Telephone Numbers:……….
3. Address and Location:…….
4. Amount in request………..
5. Repayment Period:………..
6. Purpose Of Loan………….
7. country…………………
8. phone…………………..
9. occupation………………
10.age/sex…………………
11.Monthly Income…………..
12.Email……………..

Regards.
Managements
Email Kindly Contact: urgentloan22@gmail.com

مازن بني هاني said...

thanks http://jadalnews.blogspot.com/

Dr Purva Pius said...

Hello Everybody,
My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of S$250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of S$250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius,via email:(urgentloan22@gmail.com) Thank you.

BORROWERS APPLICATION DETAILS


1. Name Of Applicant in Full:……..
2. Telephone Numbers:……….
3. Address and Location:…….
4. Amount in request………..
5. Repayment Period:………..
6. Purpose Of Loan………….
7. country…………………
8. phone…………………..
9. occupation………………
10.age/sex…………………
11.Monthly Income…………..
12.Email……………..

Regards.
Managements
Email Kindly Contact: urgentloan22@gmail.com

Dr Purva Pius said...

Hello Everybody,
My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of S$250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of S$250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius,via email:(urgentloan22@gmail.com) Thank you.

BORROWERS APPLICATION DETAILS


1. Name Of Applicant in Full:……..
2. Telephone Numbers:……….
3. Address and Location:…….
4. Amount in request………..
5. Repayment Period:………..
6. Purpose Of Loan………….
7. country…………………
8. phone…………………..
9. occupation………………
10.age/sex…………………
11.Monthly Income…………..
12.Email……………..

Regards.
Managements
Email Kindly Contact: urgentloan22@gmail.com

Alamin Miah said...

Heya i’m a first timer here. I found this website and I find it genuinely useful. I really hope to provide something back as well as help others just like you helped me. https://adamfantacy.tumblr.com/

Alamin Miah said...

It is likewise backed with the Scalper Relax Hours, which tells the robotic to quit trading after striking a specific number of losses. xavierfolks.iwopop.com

Alamin Miah said...

Hi there, this weekend is pleasant for me, since this point in time i am reading this impressive educational paragraph here at my home. My Blog https//:www.movieforyou.sitew.org/

Mona afrin said...

Hello! I could have sworn I’ve been to this site before but after going through some of the articles I realized it’s new to me. Anyhow, I’m certainly happy I stumbled upon it and I’ll be book-marking it and checking back frequently! My Blog http://talkiewire.sitey.me/

Mona afrin said...

You can definitely see your enthusiasm within the work you write. The world hopes for more passionate writers like you who are not afraid to mention how they believe. All the time follow your heart. My Blog http://www.marvelscreen-40.webself.net/

Best Short Term Loans said...

Best Short Term Loans provide effective suggestions on "short term loans for students" and assist them to find the right offer.

Dr Purva Pius said...

My name is.Mrs.Anna Daniel. I live in Ukraine i am a happy woman today? i need to use this time to tell all people how i got my loan from this honest and God fearing man loan lender that help me with a loan of $84,000 please contact him. if you also need a loan without any problem he name is Dr Purva Pius email {urgentloan22@gmail.com} tell him that is Mrs.Anna Daniel that refer you to he contact Email {urgentloan22@gmail.com}


BORROWERS APPLICATION DETAILS


1. Name Of Applicant in Full:……..
2. Telephone Numbers:……….
3. Address and Location:…….
4. Amount in request………..
5. Repayment Period:………..
6. Purpose Of Loan………….
7. country…………………
8. phone…………………..
9. occupation………………
10.age/sex…………………
11.Monthly Income…………..
12.Email……………..

Regards.
Managements
Email Kindly Contact: {urgentloan22@gmail.com}

Osman raheem said...

Hello Everybody,
My name is Ahmad Asnul Brunei, I contacted Mr Osman Loan Firm for a business loan amount of $250,000, Then i was told about the step of approving my requested loan amount, after taking the risk again because i was so much desperate of setting up a business to my greatest surprise, the loan amount was credited to my bank account within 24 banking hours without any stress of getting my loan. I was surprise because i was first fall a victim of scam! If you are interested of securing any loan amount & you are located in any country, I'll advise you can contact Mr Osman Loan Firm via email osmanloanserves@gmail.com

LOAN APPLICATION INFORMATION FORM
First name......
Middle name.....
2) Gender:.........
3) Loan Amount Needed:.........
4) Loan Duration:.........
5) Country:.........
6) Home Address:.........
7) Mobile Number:.........
8) Email address..........
9) Monthly Income:.....................
10) Occupation:...........................
11)Which site did you here about us.....................
Thanks and Best Regards.
Derek Email osmanloanserves@gmail.com

«Oldest ‹Older   201 – 242 of 242   Newer› Newest»