Mainpage
Searchform
History
Versions
Categories
Contents
Deutsch
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/oracleNow (being the user
oracle
) you should launch the installation script:
/cdrom/orainst/installEnter the name of the Oracle group when the installation scripts asks you for it:
dbaNow you will need to enter the Oracle directory:
/opt/oracleNow 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.
root
and launch
/opt/oracle/orainst/root.shThis 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
/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.
Feedback welcome: Send Mail to Lars.Rusdorf@suse.de (Please give the following subject: SDB-oracle8_suse
)
Mainpage
Searchform
History
Versions
Categories
Contents
Deutsch