Oracle 10g installation steps in CentOS 5

 Download the Oracle 10g database from the Oracle website. Graphical environment should be installed correctly in the server before installing oracle. Open a terminal command line and Untar the zip file and go to the folder 'database'. From there type the below given command as a user other than root. Better create a user named 'oracle'.

./runInstaller -ignoreSysPrereqs

If you find any error as shown below,
----------
Initializing Java Virtual Machine from /tmp/OraInstall2008-08-25_11-53-58AM/jre/bin/java. Please wait...
Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-08-25_11-53-58AM/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
 ---------

Then install libXp as shown below,


yum install libXp


And then give the command 'runinstaller' . The software will then open a graphical interface and will check for the system requirements. If it shows some errors in the requirements, we need to correct them. Most common errors that I see are with regard to the kernel values. It can be corrected as shown below.


cd /proc/sys/kernel/
echo 250 32000 100 128 > sem
echo 536870912 > shmmax

cd /proc/sys/net/ipv4
echo 1024 65000 >ip_local_port_range

cd /proc/sys/net/core
  echo 262144 > rmem_max
  echo 262144 > wmem_max
  echo 262144 > wmem_default
  echo 262144 > rmem_default     


Then retry and go on with the installation....

At the end of the installation, you will be asked to the following commands in the command line as 'root'

/home/oracle/oraInventory/orainstRoot.sh 
 /home/oracle/oracle/product/10.2.0/db_1/root.sh


after the installation, don't forget to put the kernel values in the sysctl.conf file. Otherwise while rebooting the OS, the default values will be taken instead of what we had entered.


to do that,


vi /etc/sysctl.conf
put the values as shown below
  
kernel.shmall = 4294967296
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.core.rmem_default = 262144
net.core.rmem_max = 262144

After saving the file, type the below given command to update the file.
sysctl -p 

That's it.. and enjoy :)








 


Comments

Post a Comment

Popular posts from this blog

CDbConnection failed to open the DB connection mysql 8

Image
While accessing web configured with mysql 8 and php and you see the following error: CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client OR  PHP Fatal error:  Uncaught PDOException: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]  It maybe due to  PHP devs might have not implemented the MySQL's 8.0 connection protocol ( auth with caching_sha2_password ) within the newer PHP versions. If you want to use mysql >= 8 and you dont care about caching_sha2_password,  If you are running a fresh install of mysql 8, just select the second option as shown in the image. Otherwise, you need to  configure MySQL 8.0 to run in mysql_native_password mode. As it can't configured in my.cnf, change the user profile as:- ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUs...
Read more

/bin/sh^M: bad interpreter: No such file or directory Linux

While running a script in Linux, if you encounter an error such as : /bin/sh^M: bad interpreter: No such file or directory The error is due to incorrect format of the script. Most probably when the script is created in Windows and transferred to Linux. The script might have a dos line ending file. The clue is the ^M Inorder to resolve this error: Open the script in Linux using vim editor,  enter in vi command mode (key ESC), then type this: : set fileformat = unix   Finally save it :x! or :wq! Thats it! Try running the script again and the error would have disappeared.  
Read more

Send mail from Oracle Solaris OS with attached files

To send mail from Solaris, use this syntax echo "some text to send" | mailx -s "subject of email" recipient's@address Or, if you have body of email in some file: mailx -s "subject of email" recipient's@address < some_file.txt If you want to send mails with zip files of image files use the following formats: uuencode reports.tar.gz reports.tar.gz | mailx -s "My Report" you@domain.com     uuencode office.jpeg office.jpeg | mail -s "Subject" you@domain.com   If you need to send multiple attachments in single mail:   $ uuencode r1.tar.gz r1.tar.gz > /tmp/out.mail $ uuencode r2.tar.gz r3.tar.gz >> /tmp/out.mail $ uuencode r3.tar.gz r3.tar.gz >> /tmp/out.mail $ cat email-body.txt >> /tmp/out.mail $ mail -s "Reports" you@domain.com < /tmp/out.mail            
Read more