SuSE Support Database

Title: Oracle 8 on Linux

---

Mainpage ---- Searchform ---- History ---- Versions ---- Categories ---- Contents
Deutsch
---

Oracle 8 on Linux

Anliegen:

You would like to run the Oracle 8.0.5 trial version on your machine with S.u.S.E. Linux.

IMPORTANT : This description is based upon the following CD:

Oracle 8 Server Pre-production Version 8.0.5 for Linux

Procedure:

Create a data base user (here : oracle). The name is not important but the group isn't (!!) This ought to be: dba Furthermore you need to create a directory whereto you want to install Oracle 8. The owner of this directory should be the oracle user. An example:
mkdir /opt/oracle
chown oracle.dba /opt/oracle
Now (being the user oracle) you should launch the installation script:
/cdrom/orainst/install
Enter the name of the Oracle group when the installation scripts asks you for it:
dba
Now you will need to enter the Oracle directory:
/opt/oracle
Now the scripts wants to now the ORACLE_SID. This is the name of the data base you want to install. This is called OracleDB in our example.

Now the software is going to be installed ...

After the installation you are asked whether you want to install a data base. Please answer by the confirmative. Then the data base will be created.

Now become user root and launch
/opt/oracle/orainst/root.sh
This programm assumes that you have set the environment variables ORACLE_HOME, ORACLE_SID and PATH! The easiest way to do so is to source the file $ORACLE_HOME/.env:
cd /opt/oracle
. ./.env

Now the data base is installed properly and may be started by invoking:
/opt/oracle/bin/svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect system/manager
Connected.
SVRMGR>
For testing purposes we will create a table and insert a value into this table. Thereafter we will read this value and delete the table afterwards.
SVRMGR> create table test (number int, text varchar(100));
Statement processed.
SVRMGR> insert into test values (1,'This is our first Oracle test entry');
1 row processed.
SVRMGR> select * from test;
NUMBER       TEXT                                                                            
---------- --------------------------------------------------------------------------------
         1 This is our first Oracle test entry
1 row selected.
SVRMGR> drop table test;
Statement processed.
SVRMGR> quit
Server Manager complete.
Now the data base is ready for use.

Please keep in mind that there is no (!!) support for this product!!!

---

Keywords: ORACLE, DATENBANK

---

Feedback welcome: Send Mail to Lars.Rusdorf@suse.de (Please give the following subject: SDB-oracle8_suse)

---

Mainpage ---- Searchform ---- History ---- Versions ---- Categories ---- Contents
Deutsch
---

SDB-oracle8_suse, Copyright SuSE GmbH, Nuremberg, Germany - Version: 16. Oct 1998
Impressum - Last generated: 24. Feb 1999 15:17:25 by maddin with sdb_gen 1.00.0