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

Open Blocked Web Site in any Country

-
How to Open Blocked Web Site Like Youtube, if any web site blocked in any Country by using proxy address you can open web site in your country i have some sample proxy address free for you. use it and enjoy it Thanks 061244235034.static.ctinets.com:3128 112.65.135.54:8080 114.143.12.28:8080 118.175.12.178:3128 118.228.148.52:3128 118.98.169.50:80 119.147.113.116:80 119.167.219.78:80 119.180.24.12:8080 119.245.230.164:80 119.62.128.38:80 119.70.40.101:8080 119.70.40.102:8080 121.10.120.214:80 121.14.158.76:80 121.30.255.38:8080 122.139.57.46:80 122.139.60.102:8080 122.224.33.10:80 122.224.33.4:80 125.64.96.21:8008 147.91.193.101:80 173-203-206-253.static.cloud-ips.com:80 174.142.104.57:3128 174.142.24.201:3128 174.142.24.203:3128 174.142.24.205:3128 174.142.24.206:3128 187.51.150.2:8080 189.115.161.205.static.gvt.net.br:8080 189.3.177.146:8080 189.3.47.146:3128 189.3.50.34:3128 196.12.52.2:80 196.38.158.197:80 201.45.216.115:3128 201.73.223.150:8080 202.51.105.10:3128 202.51.107.37:8080
Read more

OPERATION OF STENO PHONE

-
OPERATION OF STENO PHONE 1 EXTENSION WANTS TO TALK TO MAIN STATION Lift the handset at ext. and depress the call push button, buzzer at main station will ring after lifting the handset at main station and by throughing the key at main station to right side, ext can talk with main station. 2 MAIN STATION WANT TO TALK TO EXTENSION Main station through the key towards the right side and depress the pushbutton, the buzzer will ring at ext. Main station can talk with ext when handset is lifted at the ext. 3 INCOMING CALL DURING CONVERSATION BETWEEN MAIN AND EXTENSION The exchange call can only be received at the main station by throughing the key to the middle position, main can talk with exchange. INCOMING CALL 4 MAIN STAION WANTS TO HOLD THE INCOMIN CALL AND CONSULT THE EXTENSION Main station press the pushbutton and through the key again towards the right. 5 MAIN STATION WANTS TO CALL AGAIN WITH EXCHANGE Through the key again back in middle position. 6 EXTENSION WANTS TO GET THE EXCHANG
Read more