Archive for the ‘Tips’ Category

SAP on Linux

Monday, September 17th, 2007

I was at my Chennai office to conduct training and I called it as “SAP on Linux
I started by Thursday for two days training, to meet some of my counterparts and friends out there.

The class was packed with around 20 new joiners, who have just started to venture into SAP Basis. I started my session by keeping in mind: On the long run; if they have to make a choice between Windows and Linux/UNIX on SAP, there wouldn’t be a second thought to have the fun with Linux.

I picked up RedHat Linux for the demo session; since I had deployed FIVE SAP systems at my Bangalore office and they are running well on RedHat AS-4 and CentOS-5 [The number FIVE really matters for me]

I would like to paste the contents of some of the important slides:

    0.ENV_VARIABLE settings :

On Bash shell before you run ./sapinst as root


• JAVA_HOME=/opt/java1.4;
export JAVA_HOME
• SAPINST_JRE_HOME=/opt/java1.4/jre;
export SAPINST_JRE_HOME
• PATH=$PATH:/opt/java1.4/bin;
export PATH
• PATH=$PATH:/opt/java1.4/jre/bin;
export PATH

    1. Aditional Package Information for RHEL-4

: rpm -ivh

• glibc-2.3.4-2.9.x86_64.rpm
• kernel-smp-2.6.9-42.EL.x86_64.rpm [The kernel patch is important]
• glibc-common-2.3.4-2.9.x86_64.rpm
• mkinitrd-4.2.1.6-1.x86_64.rpm
• IBMJava2-AMD64-142-SDK-1.4.2-7.0.x86_64.rpm [For Java]
• saplocales-2.3.4-3.x86_64.rpm
• libaio-0.3.103-3.x86_64.rpm‎ [To avoid Oracle: error while loading Libraries libio.so.1 ]

    3. Important SAP Notes

• Red Hat Enterprise Linux 5: Installation and Upgrade (Note 1048303)
• Red Hat Enterprise Linux 3 and 4: Installation and upgrade (Note 722273)

I packed up on Sunday night after the fun with the same ‘ol feelings; Chennai, it’s still not a classic rock


Tail:
Closely an year back at the same workplace: My first SAP installation [SAP-CRM4] on “ ONE ” server out of 30 other running SAP servers.
I proposed to do it on Linux, but it didn’t happened since the senior was comfortable with Windows-2003. I said to myself “My call is not too far but FAR and the count started from FIVE

    Current Music:- The temple of the king by Rainbow -

Xen: I am a para-virtualized one!

Thursday, September 6th, 2007

The party over and my virtual machine is ready for topping with SAP.

One point: I have done a kernel upgrade from 2.6.18-8 to 2.6.18-8.1.8 at the guest OS level; in fact the dom0 machine too.

Heck with, I wanna know what would happen if I use the normal kernel on my PV/guest_OS and I change the default kernel-2.6.18-8.1.8.el5xen to kernel-2.6.18-8.1.8.el5 :)

[fubar@blxvirtual ~]# xm reboot cenos5v

screwed! [Didn’t came up]

Later I have resolved the issue. All I have done

mount my image

[foobar@blxvirtual sagar]# lomount -diskimage /var/lib/xen/images/cenos5v.img -partition 1 /vipin

[foobar@blxvirtual sagar]# cd /vipin/grub/grub.conf

change default 1 to 0 :)

Happy Xenning around !!!

500 Internal Server Error Web Dynpro Container/SAP J2EE Engine/6.40 [Why it shows 640 instead 700]

Friday, July 20th, 2007

Kernel Update List

Sunday, July 8th, 2007

There were times I need to get the update of latest stable version of the Linux kernel, pre-patch, snapshots of 2.6.x.x 2.4.x and with a single click; you are watching :)

Kernel update list:

I am still a linux boy and SAP on top of it now!

Keyboard Hack: (®, µ, æ, £, ©, ñ, ±)

Thursday, January 4th, 2007

I have been looking for something like this. No downloads or setting changes necessary. Quick reference sheet on how to type lesser used, but often needed symbols and characters.

read more

New Year’s Resolutions for Unix SysAdmins

Wednesday, January 3rd, 2007

Obviously Linux Sys-Admins too!

I feel it’s a good deal shown up by Sandra.

Sandra Henry-Stocker has been administering Unix systems for nearly 18 years. She describes herself as “USL” (Unix as a second language) but remembers enough English to write books and buy groceries. She currently works for TeleCommunication Systems, a wireless communications company, in Annapolis, Maryland, where no one else necessarily shares any of her opinions. She lives with her second family on a small farm on Maryland’s Eastern Shore. Send comments and suggestions to sandra@toadmail.com.

New Years celebrations have been going on for as long as 4,000 years. Some historians date them back to the ancient Babylonians welcoming the return of Spring. And New Years resolutions have probably been made throughout these years. While their success rate does not seem to have improved over the millennia, the practice has still not lost its appeal and the beginning of each new year is a time when many people will be thinking about what they want to improve both in their personal lives and in their jobs. So, what are some likely resolutions for Unix sysadmins? Here are a dozen worth considering.
–>

A DaY With MySQL

Thursday, May 11th, 2006

:) I am not a MySQL expert so far…but here was my one day with the MySQL =>

I gotta requirement for MySQL Server version 5.x.x but my distro RH-AS-4 Update-1 (kernel-2.6.9-5) has MySQL-4.1.7. So I erased/un-installed all the MySQL RPMS [ rpm -e mysql* - -nodeps ]
and I choose the source bundle mysql-5.0.21, configured for a separate database on a different partition named /database and made install. Things were fine but some integration issue with Perl and PHP. Both are not able to connect MySQL (were I got screwed up).. I am sure, its not because of the php-mysql and perl-mysql packages Yeah… the default database comes under /var/lib/mysql now its /database/mysql/

I couldn’t see mysql module in php -m. Whats the solution “google” I gotta hell lot of out put that everybody saying I do have the same issue, some stamped this a as bug.

Well… now I am ready to go back to the packages ;
the RPM’s coming wih the distro [ rpm -ivh mysql*4.17* - -force :) ]

Here my DIVIDE & RULE Policy got worked. I umount the /database partition and mount to /var/lib

Issues: fstab is not ready to take the new partition
Solution: edit /etc/rc.local [ mount /dev/cciss/c0d0p11 /var/lib ]

Any luck…? the screw is still getting tight for me…

I gotta the following errors when I started using my middle finger to set this up….at different stages…

1. /usr/libexec/mysqld: Can’t change dir to ‘/var/lib/mysql/’
2. mysql error Errcode: 13
Error code 13: Permission denied [ you can try bash-3.00$ perror 13 ]
3. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock
4. mysqld dead but subsys locked
5. /usr/libexec/mysqld: Can’t change dir to ‘/var/lib/mysql/’ (Errcode: 13)
6. Timeout error occurred trying to start MySQL Daemon.
7. ‘Problems running mysql_install_db’
8. Installation of system tables failed!

Woops..!! Dido is Stoned after The Sand In My Shoes
Yokay..
I un-mount the /var/lib for my old /var/lib. Confused..well

/dev/cciss/c0d0p7 4.9G 155M 4.5G 4% /var [ Created at installation ]
/dev/cciss/c0d0p11 51G 144M 48G 1% /var/lib [ Newly mounted ]

:) because I have to back up all the files under “4% /var/lib “ to “1% /var/lib” with out loosing the permission settings.

cd /var/lib
find . -print -depth | cpio -pvdum ~admin/bkup_lib

Mounted back /var/lib to /dev/cciss/c0d0p11
Remove all files under /var/lib/ and once again use the find-cpio combination to place all the files back to ” 1% /var/lib/ “

Now the time to rpm -ivh mysql* [if you are “ivh” ing WITH OUT placing the files under /var/lib …heY..it’s gonna be a PITA with depedency and if those files are not with proper permission settings…..well… whats your numer from 1 to 8 ]

If all went fine so far; one request, dont use the mysql_install_db script now, but you can have a try and collect your number :)

Good…try this

[root@python ~] /usr/bin/mysqld_safe –user=mysql –skip-grant-tables &
[root@python ~] /usr/bin/mysql mysql

Yes..! it’s running; atleast for me but with one issue that I have to manually stop/kill the mysqld daemon.
There is NO service mysqld stop/restart …
I tried all the day to get it up and once it got up…hmmm… very funny…
Do ya have any hack around… :)

Linux Partioning: To avoid chaos

Sunday, April 23rd, 2006

Dear All,

I am writing this mail as an information when we do installation of Linux Operating System by considering the manual partitioning (Diskdruid or fdisk).

People get annoyed after using Linux machine for a while by saying ” hey.. I got a Kernel Panic. I am worried about my data” or ” I don’t know where my GUI has gone

One of the reason for this panic is, your ” / ” file system got squeezed ! ( say used space for / partition is 98% )

Please do comment, if you have got any suggestion.

I suggest; its a good practice to take care of this issue from the scratch; at the time of OS installation.

Here I am considering a 40GB HDD [** workstation specific NOT Server**]

By considering the fact; most of our machines are in dual boot so I don’t wanna deal with 15GB for Windows (15GB is fair enough for viruses to play and flood around :) )

well…the rest 25 GB.

This is just a DIVIDE & RULE Policy for better management and for recovery when we had troubles.

/boot

= 100MB [Make this as the first choice when you do partition, because older BIOS were not able to detect the second part of boot loader beyond 1024 cylinders of the HDD]

/usr

= 8 GB [ Happily we can deal this for a workstations, mine is 6 GB and 73% so far ]

swap

= Rule of Thumb; 2xRAM Size, but not always true [Try to have it on the middle part of the HDD, because its fast to access the middle portion of HDD]

/home

= 12 GB [ If you don’t have a dual boot, add much more or go for a separate user(you) defined partition to keep your data like documents, pdfs, mp3s and other stuffs ]

/

= 2 GB is more than enough. Yes I said 2048 MB *

/var

= 500 MB [ This separate partition avoid the electronic jamming of / by logfiles, mails and other junks..]
If you are using any RedHat distro and trying to configure MySQL, please consider much more space for the growing database which comes under /var/lib/mysql

/opt

= Are ya trying to install any applications like Oracle db &| its client ? Do you have any “optional” application which you don’t have to mess around ?. If the answer is “yes” go ahead and allocate desired space. I feel 3-4GB is okay. The best part is, you can remove the installed package under /opt as such, because all the files will come under that particular directory (directory=pkg-name) even the “bin” files. If you are not sure about this, add up this amount of space to your /usr or /home filesystem.

/tmp

= Normally, this never go beyond 100MB


NOTE:

1. Never log into your system as root. Log into as a normal user and configure your mail, desktop, browser and all other part which makes you comfortable. This way all your mails and other heavy stuff only fall under /home/[normalusr].

2. Do sudo or su - option when needed.

3. If you are in dual boot and have more space; its a good option to create FAT-32 partition by naming /winshare or something. So that we could access the data [pdfs, mp3s and other stuffs] from both OS.

Please do revert for any suggestion which you feel much practical or logical.

Thank You

~vipin

Contrary to popular belief, Unix is user friendly.
It just happens to be selective about who it makes friends with.
Dave Parnas