Oralcle 10g Fedora Core x Quick Installation Guide

Source: Internet
Author: User
Tags exit dba variables unpack variable oracle database sqlplus linux
Core
Home-> Oracle-> Oracle 10g Release 1 (10.1.0.2) on Fedora core 1
Oracle Database 10g Release 1 (10.1.0.2) installation on Fedora core 1
Please note that Oracle Database 10g are not certified to run on Fedora Linux, therefore your should not use this Combinatio N on a production server. can examine Oracle certification matrix at Metalink
Contents
1. Downloading and unpacking installation files
2. Preparing Your system
2.1 Steps to perform as root
2.2 Steps to perform as Oracle user
3. Running the Installer
4. Post-Installation Steps
4.1 Starting database Services
4.2 Shutting down database services
4.3 Automating Oracle Startup and shutdown
1. Downloading and unpacking installation files
Download Oracle Database 10g from Oracle Technology network. Four files are available:

Ship.ccd.cpio.gz-oracle 10g Companion CD
Ship.client.cpio.gz-oracle 10g Client
Ship.crs.cpio.gz-oracle 10g Cluster Ready Services
Ship.db.cpio.gz-oracle 10g Database
Only ship.db.cpio.gz are required in order to install the database.
Once you downloaded the file, unpack it:
Gunzip ship.db.cpio.gz
Cpio-idmv<ship.db.cpio
All four installation files unpack to directory named "Disk1", so rename directory before you eventually unpack another fi Le.
You could want to create the Oracle installation CD set from unpacked installation files. As I don ' t have a cd-burner on any of my Linux boxes, I created ISO images using
Mkisofs-jr-l-O ship.db.iso disk1/
and burned CDs on Windows machine.
2. Preparing Your system
2.1 Steps to perform as root
Install following fedora packages using RPM-IVH package_name:
From Fedora-core Disk 1:

setarch-1.0-1.i386.rpm
From Fedora-core Disk 2:

openmotif-2.2.2-16.1.i386.rpm
From Fedora-core Disk 3:

compat-libstdc++-7.3-2.96.118.i386.rpm
compat-db-4.0.14-2.i386.rpm
compat-gcc-7.3-2.96.118.i386.rpm
compat-libgcj-7.3-2.96.118.i386.rpm
compat-libstdc++-devel-7.3-2.96.118.i386.rpm
compat-libgcj-devel-7.3-2.96.118.i386.rpm
Now we have to make Oracle installer "we" have one of the supported Distributions:create a backup of YOUR/ETC/R Edhat-release file, a change its contents:
# Cp/etc/redhat-release/etc/redhat-release.orig
# echo "Red Hat Enterprise Linux as Release 3 (Taroon)" >/etc/redhat-release
Change kernel parameters by adding the following lines in/etc/sysctl.conf:
Kernel.shmall = 2097152
Kernel.shmmax = 2147483648
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Fs.file-max = 65536
Net.ipv4.ip_local_port_range = 32768 65000
Update Kernel configuration:
[Root@fedora root]# sysctl-e-p/etc/sysctl.conf
Add the following lines to/etc/security/limits.conf file:
* Soft Nproc 2047
* Hard Nproc 16384
* Soft Nofile 1024
* Hard Nofile 65536
Add the following line to The/etc/pam.d/login file, if it does not already exist:

Session required/lib/security/pam_limits.so
Create user and groups that would own Oracle installation. In this exaple the username would be Oracle:
[root@fedora]# Groupadd Oinstall
[root@fedora]# Groupadd DBA
[root@fedora]# useradd-g oinstall-g dba Oracle
[root@fedora]# passwd Oracle
Create directories in which Oracle software would be installed. Oracle recommends Ofa-optimal flexible architecture (for Oracle Installation Guide), but in this example everything would be installed under/home/oracle:
[root@fedora]# mkdir-p/home/oracle/product/10g
[root@fedora]# chown-r oracle.oinstall/home/oracle/*
2.2 Steps to perform as Oracle user
Make gcc296 default compiler to user Oracle by creating symbolic link. It is important This directory containing the link (/home/oracle/bin) is listed in the PATH variable before/usr/bin.
[Oracle@fedora oracle]$ Mkdir/home/oracle/bin
[Oracle@fedora oracle]$ Cd/home/oracle/bin
[Oracle@fedora bin]$ ln-s/usr/bin/gcc296 gcc
Put the following lines in Oracle user. Bash_profile
Export Oracle_base=/home/oracle
Export oracle_home=/home/oracle/product/10g
Export ORACLE_SID=ORCL
Export Oracle_term=xterm
Export path= $HOME/bin: $ORACLE _home/bin: $PATH
Ulimit-u 16384-n 65536
#
# change this NLS settings to suit your country:
# example:
# GERMAN_GERMANY.WE8ISO8859P15, AMERICAN_AMERICA.WE8ISO8859P1 etc.
#
Export nls_lang= ' CROATIAN_CROATIA.EE8ISO8859P2 '
Since I am from Croatia, I with Croatian national language Support (Nls_lang, Nls_date_language, Nls_sort and Nls_date_form at). You are should set these variables to suit your needs.
Listing of valid Oracle NLS Data parameters including supported languages, territories and storage character sets can be f Ound here.
In this example ORACLE_SID=ORCL. You are prompted by installer to specify SID and global database name, and your should replace the SID in. Bash_profile With your own SID.
Update environment to include new variables:

[Oracle@fedora]$ Source/home/oracle/.bash_profile
Everything is now ready to start the Oracle installer.
3. Running the Installer
If you have Oracle 10g Database CD, login as root and mount it:
[root@fedora]# Mount/mnt/cdrom
Oracle Installer needs to is run from Xwindows, so start xwindows and login as user Oracle.
Make sure that your envionment be correctly set up:
[Oracle@fedora oracle]$ Set|grep Oracle
Oracle_base=/home/oracle
oracle_home=/home/oracle/product/10g
Oracle_sid=orcl
Oracle_term=xterm
[Oracle@fedora oracle]$ gcc--version
2.96
Start the installer:
[Oracle@fedora oracle]$/mnt/cdrom/runinstaller
Note:if you are thew following error when running the installer from CD-ROM
BASH:/mnt/cdrom/runinstaller:/bin/sh:bad Interpreter:permission denied
You are should check how your CD-ROM was mounted. It should be mounted by user root, and the information about the filesystem In/etc/fstab sohuld look similar to this:
/dev/cdrom/mnt/cdrom Auto Exec,noauto,owner,kudzu,ro 0 0
Now the installer should is up and running.
4. Post-Installation Steps
We want to change back The/etc/redhat-release file:
[root@fedora]# Cp/etc/redhat-release.orig/etc/redhat-release
Next, modify The/etc/oratab file in order to use database startup and shutdown scripts provided by Oracle. Find the line in/etc/oratab which looks similar to this:
*:/home/oracle/product/10g:n
Entries are of the form: $ORACLE _sid: $ORACLE _home:<n| Y>
Change the "last Field" (N) to Y, and you are able to start the database using Dbstart utility.
4.1. Starting Database Services
Note:if you just installed Oracle, the database, TNS Listener and Enterprise Manager are already.
Start TNS Listener:

[Oracle@fedora oracle]$ lsnrctl start
You can start the database via Dbstart utility:
[Oracle@fedora oracle]$ Dbstart
or via Sql*plus:
[Oracle@fedora oracle]$ Sqlplus/as SYSDBA

Sql*plus:release 10.1.0.2.0-production on Sat Feb 21 18:05:43 2004

Copyright (c) 1982, Oracle. All rights reserved.

Connected to a idle instance.

Sql> Startup
ORACLE instance started.

Total System Global area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database buffers 25165824 bytes
Redo buffers 262144 bytes
Database mounted.
Database opened.
Sql> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-
Production with the partitioning, OLAP and Data Mining options
[Oracle@fedora oracle]$
Start Enterprise Manager Server:
[Oracle@fedora oracle]$ emctl start Dbconsole
4.2. Stopping Database Services
Stop Enterprise Manager Server:
[Oracle@fedora oracle]$ Emctl Stop Dbconsole
You can stop the database via Dbshut utility:
[Oracle@fedora oracle]$ Dbshut
or via Sql*plus:
[Oracle@fedora oracle]$ Sqlplus/as SYSDBA

Sql*plus:release 10.1.0.2.0-production on Sat Feb 21 18:11:23 2004

Copyright (c) 1982, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-
Production with the partitioning, OLAP and Data Mining options

sql> shutdown Immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Sql> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-
Production with the partitioning, OLAP and Data Mining options
[Oracle@fedora oracle]$
Stop TNS Listener:
[Oracle@fedora oracle]$ Lsnrctl Stop
4.3 Automating Oracle Startup and shutdown
To automatically start/shut Oracle database during system Startup/shutdown your need to write a script in/etc/rc.d/init.d Directory. can view or Download an example script.
Copy the script To/etc/rc.d/init.d as root user, edit environment variables to match your settings and modify its Permiss Ions:
[Root@fedora root]# chown root.root/etc/rc.d/init.d/ora10
[Root@fedora root]# chmod 755/etc/rc.d/init.d/ora10
The script I wrote uses Chkconfig utility to simplify service management. IT is configured to start Oracle Services in Runlevels 3 and 5,with start priority and stop Priority 1.
Initialize New service:
[Root@fedora root]# chkconfig ora10 Reset
[Root@fedora root]# chkconfig--list ora10
ORA10 0:off 1:off 2:off 3:on 4:off 5:on 6:off
Now Oracle services'll is automatically started when entering Runlevels 3 and 5, and shut down when entering no other R Unlevel. For the more information on the Chkconfig utility refer to it man page.
To manually start/stop Oracle services and can use
[Root@fedora root]# Service ora10 start
and
[Root@fedora root]# service ora10 stop
Hope this helps.
Denis.
Home-> Oracle-> Oracle 10g Release 1 (10.1.0.2) on Fedora core 1




--------------------
Happymeng


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.