Introduction to Oracle 10g R1 (10.1.0.3) on SUSE LINUX Professional 9.3

-
Introduction to Oracle 10g
R1 (10.1.0.3) on
SUSE LINUX Professional 9.3


Introduction
This paper is designed to help you get started with Oracle 10g on SUSE LINUX 9.3. This will help you to work on latest SUSE OS and latest Oracle Database 10g from Oracle. Oracle 10g is supported and certified only on SUSE LINUX Enterprise Server (SLES), but occasionally for development and testing purposes you will prefer to have it up and running on your desktop for quick access. Instruction provided here will also work on SUSE LINUX 9.2.
Hardware Requirements
The system must meet the following minimum hardware requirements:

Requirement Minimum Value
RAM 512 MB
Swap space Approx. twice the size of RAM
Disk space in /tmp 400 MB
Disk space for software files 2.5 GB (2621440 KB)
Disk space for database files 1.2 GB

Required Software
You need SUSE LINUX 9.3 and Oracle 10g. Also, Novell/SUSE orarun package will help you to make Oracle pre-Install task simple.
Novell/SUSE
1. Novell SUSE LINUX 9.3
(ftp install location: ftp://ftp.suse.com/pub/suse/i386/9.3/)
2. orarun : Get latest version from
(http://ftp.novell.com/partners/oracle/sles-9/)
3. Novell/SUSE Documents are available here:
http://www.novell.com/documentation/
4. For more "Oracle on SUSE" related information visit
http://www.novell.com/oracle.
Oracle
Oracle database 10g R1(10.1.0.3) Software is available for download from Oracle web site. File name: ship.db.lnx32.cpio.gz.
1. URL to Download:
(http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/linuxsoft.html).
2. Oracle Documents are available on
http://www.oracle.com/technology/documentation/database10g.html
3. Oracle Development Tools:
http://www.oracle.com/tools/index.html

Installation Steps
1. Install SUSE LINUX Operating System
Follow the Installation instructions provided in the SUSE LINUX 9.3 installation manual. We will focus on Oracle related component and make sure you meet Oracle software space requirement.

SUSE LINUX 9.3 with default packages along with "C/C++ Compiler and Tools" is sufficient for Oracle 10g R1 (10.1.0.3) install. Here is snap-shot from my system.

Check whether C/C++ compiler is installed. "gcc --version" will show "gcc (GCC) 3.3.3 (SUSE LINUX)". If gcc is not installed, then use YaST setup tool to install "C/C++ Compiler and Tools".


2. Oracle Install prerequisites
Refer to Oracle installation document for complete list of prerequisites. Novell/SUSE provides orarun packages to automate most of the Oracle pre-install task. orarun package is not included in SUSE LINUX 9.3 as this is for SUSE LINUX Enterprise Server.
Note: orarun is only available on x86. You can use orarun on other platforms (x86-64), but on these platforms please comment out the following line from the file "/etc/profile.d/oracle.sh" and "/etc/init.d/oracle":
#test -d /lib/i686 && export LD_ASSUME_KERNEL=2.2.5
orarun :
1. Install orarun package. It will ask to install dependent packages first.
# rpm -ivh --nodeps orarun-1.8-109.12.i586.rpm
2. Install libaio, libaio-devel and pdksh from SUSE LINUX 9.3 media.

3. Please ignore xshared not available conflict reported by YaST. Here is snap-shot:


4. Now orarun package is installed. Please enable newly created "oracle" user for Oracle 10g installation.

1. The account for oracle user is disabled. Enable it, by changing the shell for the "oracle" user from "/bin/false" to "/bin/bash", either by using YaST setup tool or by editing the "/etc/passwd" file.

2. Set a new password for user "oracle" i.e. "/usr/bin/passwd oracle".
You can use SUSE setup tool YaST to accomplish above tasks.
/sbin/yast2 -> "security and Users" -> "Edit and create groups"
(Select users tab and set "System Users" filter to see oracle user.)
Following are the screen shots of "oracle" user properties:



5. Now set your Oracle environment variables.

1. Change Oracle home directory by editing ORACLE_HOME variable in "/etc/profile.d/oracle.sh" file. ORACLE_HOME=$ORACLE_BASE/product/10g
2. Default ORACLE_SID set by orarun install is "mydb". Change it to your preferred name in "/etc/profile.d/oracle.sh" file.

6. Run "/usr/sbin/rcoracle start" to set kernel parameters. Ignore ORACLE_HOME not set message as this will get fixed once Oracle 10g is installed.

7. Exit from current root user session and login as new "oracle" user. Following is snap-shot verifying current user.


3. Oracle 10g R1 (10.1.0.3) Installation

1. Get Oracle 10g R1 (10.1.0.3) Software from oracle web or use your Oracle Database 10g CD. If you have downloaded SW ( ship.db.lnx32.cpio.gz) then use gunzip and cpio to extract files:

a. gunzip ship.db.lnx32.cpio.gz
b. cpio -idmv <> connect / as sysdba
SQL> startup
2. To shutdown the database:
sl93$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown
Note: "/" connects you to the schema owned by SYS with the privilege SYSDBA.
5. Oracle Database Start at boot time
Set parameter START_ORACLE_DB="yes" in "/etc/sysconfig/oracle" file. You can edit file "/etc/sysconfig/oracle" manually or use YaST setup tool to change oracle specific parameters.
"/sbin/yast2->System->/etc/sysconfig Editor ->Productivity->Databases"

1. Edit /etc/oratab entry corresponding to your database to "Y".
i.e. mydb:/opt/oracle/product/10g:Y

2. Edit dbstart, dbshut and dbhome scripts to reflect correct location for ORATAB entry. i.e ORATAB=/etc/oratab

Note: If you are lazy in editing /etc/oratab entries then following will do:
#ln -s /etc/oratab /var/opt/oracle/oratab
3. Create symbolic link to start Apache Server.
#ln -s /usr/lib/libdb.so.3 /usr/lib/libdb.so.2
6. Oracle Enterprise Manager

1. Start Oracle listener, If it is not already started by "lsnrctl start". If it fails, then make sure your listener.ora file has proper SID_DESC entry.



# listener.ora Network Configuration File: /opt/oracle/product/10gR1/network/admin/listener.ora
# Generated by Oracle configuration tools.
...
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /opt/oracle/product/10gR1)
(GLOBAL_NAME = ORCL)
)
....

2. If dbconsole Oracle services is not started, then start it manually by entering following command "emctl start dbconsole".

3. Enterprise Manager web interface ( http://localhost:5500/em) to perform routine database administration and tuning tasks.


Conclusion

Popular posts from this blog

History of Labor Day

-
Casting a glance back on Labor Day history is essentially about commemorating and celebrating the American Labor Movement. It is all about knowing the share that the American laborers had in building up the nation with its richness and its many achievements. The Labor Day, usually held on the first Monday in September, inspires this sense of the togetherness that workers need to feel and share in respecting their own contribution to the history of America . Labor Day is an annual recognition of all those dedicated American workers whose achievements, both socially and economically, deserve to be honored. On every Labor Day, Americans pay their tributes to those workers of strength and perseverance whose selfless efforts have added to the growth and prosperity of the American nation. Even after a century-long celebration, there is no one consistent theory about the Labor Day history. The prominent amongst these attributes the Labor Day to one Peter J. McGuire. He is the one who is cr...
Read more

Relationships Ruined by the Internet

-
10 Relationships Ruined by the Internet The wife who found pictures of her husband's wedding to another woman at Facebook Lynn France, a wife who suspected her husband was having an affair, found he was actually married to another woman through a simple Facebook search. All she had to do was type in the name of the woman she believed her husband, John, was seeing. The pair had been married at Disney World , no less, with France's husband dressed as Prince Charming , and his new bride as Sleeping Beauty . There was like an album of 200 pictures there. Their whole wedding. She had grown suspicious when her husband began taking frequent business trips, even leaving the day the couple's newborn son came home from the hospital. Once, she found his passport at home when he was supposed to be in China for business. She once caught her husband with another woman in a hotel so a girlfriend recommended checking the woman's Facebook page, where France...
Read more