Attachment 29724 Details for Bug 41881 – xml version

xml version

oracle8.xml (text/xml), 8.25 KB, created by Benny Chuang (RETIRED) on 2004-04-20 15:58:36 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Benny Chuang (RETIRED)

Created: 2004-04-20 15:58:36 UTC

Size: 8.25 KB

patch

obsolete

><?xml version='1.0' encoding="UTF-8"?>
>
><!DOCTYPE guide SYSTEM "/dtd/guide.dtd">
>
><guide link="/doc/en/oracle.xml">
>
><title>Installing Oracle 8i Database on Gentoo</title>
>
><author title="Author">
> <mail link="rodica.balasa@nemesisit.ro">Rodica Balasa</mail>
></author>
><author title="Editor">
> <mail link="bennyc@gentoo.org">Benny Chuang</mail>
></author>
>
><abstract>
>This is a guide to install Oracle 8i on Gentoo
></abstract>
>
><version>1.0</version>
><date>April 20, 2004</date>
>
><chapter>
><title>Before you start</title>
><section>
><title>Introduction</title>
><body>
>
>
>I wrote this installation guide after succesfully installing Oracle8 on Gentoo
>to describe the steps I used in hope that other people will experience a smooth
>migration of Oracle8 server on Gentoo distribution. For further details please
>contact me at <mail>rodica.balasa@nemesisit.ro</mail>.
>
>
></body>
></section>
><section>
><title>Requirements</title>
><body>
>
>
>Unfortunately Oracle 8i requires an older version of java. Therefore you are
>required to download
>Database Version: Oracle 8i R3 (8.1.7), available here:
><uri>http://otn.oracle.com/software/products/oracle8i/htdocs/linuxsoft.html</uri>
>
>
>
>Unfortunately Oracle 8i requires an older version of java. Therefore you are
>required to download Java 1.1.8 at one of the www.blackdown.org mirrors or from 
>here:
><uri>
>http://mirrors.sunsite.dk/java-linux/JDK-1.1.8/i386/v3/jre118_v3-glibc-2.1.3.tar.bz2
></uri>
>
>
></body>
></section>
></chapter>
><chapter>
><title>Installation</title>
><section>
><title>Unpack the install kit</title>
><body>
>
>
>The first step is to unpack the install kit:
>
>
><pre caption="The first step is to unpack the install kit">
># tar xvf linux81701.tar
></pre>
>
></body>
></section>
><section>
><title>Create users and groups</title>
><body>
>
>
>The oracle database requires the oracle user and also two groups for database
>install and administration. The standard group names used are oinstall and dba.
>Oracle user must be member of oinstall and dba group, with main group dba. Also
>oracle user password must be set.
>
>
>
>You will need to require root access to execute the following commands:
>
>
><pre caption="Create users and groups">
># groupadd oinstall
># groupadd dba
># adduser -g oinstall -G dba,wheel,audio,video,cdrom,cdrw -s /bin/bash -d
># /home/oracle -m oracle
># passwd oracle
></pre>
>
></body>
></section>
><section>
><title>Preinstallation(System configuration)</title>
><body>
>
>
>Some preinstallation configuration is required for successful oracle
>installation. The new gcc installed on your system is not compatible with the
>older gcc version required by Oracle. The fix is to install the gcc
>compatibility libraries.
>
>
><pre caption="Install the compatibility libraries">
># emerge lib-compat
># emerge gcc-compact
></pre>
>
>
>The oracle graphical install utility requires Java 1.1.8. To install it, first
>we will have to copy it to <path>/opt</path> then extract it.
>
>
><pre caption="Install java 1.1.8">
># cp jre118_v3-glibc-2.1.3.tar.bz2 /opt
># cd /opt
># xvfj jre118_v3-glibc-2.1.3.tar.bz2
></pre>
>
>
>The next step is to set the environment variables required by the oracle
>installation. In this example the locale settings are for Romanian language. One
>important setting is ORACLE_SID which is the name of the oracle server.
>
>
>
>First we have to login as user: oracle:
>
>
><pre caption="Login as oracle">
># su oracle
></pre>
>
>
>Put the following lines in <path>~/.bashrc</path> (the script is executed each time the
>oracle user logs in):
>
>
><pre caption="Content of ~/.bashrc">
>umask 022
>unset LANG
>export ORACLE_BASE=/home/oracle
>export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
>export ORACLE_TERM=vt100
>export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
>export ORACLE_SID=orcl
>export PATH=$PATH:$ORACLE_HOME/bin
>export NLS_LANG='ROMANIAN_ROMANIA.EE8ISO8859P2'
></pre>
>
><note>
>You can change NLS_LANG according to the computer local settings. Do not set
>LD_ASSUME_KERNEL=2.2.5, it is not required and it will only generate lots of
>errors (probably you do not have 2.2.5 kernel).
></note>
>
></body>
></section>
><section>
><title>Installation</title>
><body>
>
>
>The first step is to give the oracle user the right to use X, using xhost +
>command. Then DISPLAY variable must be set for the oracle user to be able to
>connect the X server.
>
>
>
>Login as root and allow user oracle to write to X display:
>
>
><pre caption="allow oracle to write to X display">
># su -
># xhost +
><comment>Change to oracle</comment>
># su oracle
><comment>Export display for oracle user</comment>
># export DISPLAY=&quot;ocalhost:0.0&quot;
><comment>Now is a good time to start the installation</comment>
># Disk1/install/linux/runInstaller
></pre>
>
>
>You will be asked about the group for installation and upgrade, enter oinstall.
>Also you will be asked about oracle sid and name, enter orcl to both.
>
>
><note>
>During install you will be asked about java 1.1.8 installation directory
>(<path>/opt/jre118_v3</path>)
></note>
>
>
>Choose not to register to oracle or other directories.
>At the end, Oracle installation will probably inform you that creating a
>database failed. Ignore on this one, we will fix it later.
>
>
></body>
></section>
><section>
><title>Postinstall</title>
><body>
>
>
>After install (but before creating the database) some patches must be applied:
>stub patch and libnldapj8.so. The stub patch is a set of stub libraries which
>are used at link-time only to mimic the contents of old glibc-2.1.3 shared
>objects. The libnldapj8.so is a patch for the bug 1542738 of Oracle Directory
>Manager.
>
>
><pre caption="Applying the stub patch">
># su oracle
># cp glibc-2.1.3-stubs.tar.gz $ORACLE_HOME
># cd $ORACLE_HOME
># tar xvfz glibc-2.1.3-stubs.tar.gz
># ./setup_stubs.sh
><comment>Then apply libnldapj8.so patch</comment>
># cp Disk1/patch/bug1542738/libnldapj8.so $ORACLE_HOME/lib
># cp Disk1/patch/bug1542738/oidadmin $ORACLE_HOME/bin
></pre>
>
></body>
></section>
><section>
><title>Creat the database</title>
><body>
>
>
>Once the patches have been applied, we can proceed to database creation, using
>the dbassist utility.
>
>
><pre caption="Create database">
># su oracle
># cd $ORACLE_HOME/bin
># ./dbassist
></pre>
>
></body>
></section>
><section>
><title>Start the database</title>
><body>
>
>
>After initial database creation we can start the database engine. For that we
>must login as oracle user, only as oracle user you can start and stop the
>database and perform other database operations.
>
>
><pre caption="Starting database">
># su oracle
># cd $ORACLE_HOME/bin
><comment>Next we start the server, using svrmgrl to open the server console.
>From the console we can connect to the server using connect internal command. 
>After we connect we start the database database with startup command.
></comment>
># ./svrmgrl
>&gt; connect internal
>&gt; startup
>&gt; quit
></pre>
>
>
>After the server is started also the listener must be started. The listener
>answers to connect requests on 1521 port (oracle default port), it must be
>started in order to bee able to connect to the database. The listener starts
>using <c>lsnrctl</c> command.
>
>
><pre caption="Starting listener">
># ./lsnrctl start
></pre>
>
></body>
></section>
><section>
><title>Testing database</title>
><body>
>
>
>Next we can test the database (as oracle user). The initial database contains
>demo tables for user scott with password tiger. The database client utility is
>sqlplus. Gqlplus is an improved command line client, with completion and command
>history, more details at: <uri>http://gqlplus.sourceforge.net</uri>
>
>
><pre caption="Testing database">
># ./sqlplus
><comment>When asked password enter:</comment>scott/tiger@orcl
><comment>For a graphical client try the worksheet application:</comment>
># ./oemapp worksheet
><comment>For administration you can start the enterprise manager. The enterprise
>manager is started using oemapp utility with parameter dbastudio. For maximum
>privileges connect with user sys, password change_on_install as dba.</comment>
>./oemapp dbastudio
></pre>
>
></body>
></section>
></chapter>
></guide>

Actions: View

Attachments on bug 41881: 25754 | 25755 | 25756 | 28976 | 28977 | 28978 | 29499 | 29500 | 29501 | 29724 | 30857 | 30858