Introduction

During the installation of an Oracle database under Windows as an OS is relatively easy now possible to prepare the installation of the Oracle database on Linux system numerous difficulties. These difficulties result from the fact that before installing the operating system must first be configured (eg the kernel configuration parameter). Furthermore, the installation itself is not as automated as currently done at an installation under Windows is the case, so that a good knowledge eg User administration but also of setting parameters for Oracle should be present.

The installation process is broken down for reasons of clarity, into two parts. In the first part of (this) is just the configuration of the operating system and the installation of Oracle described. In the second part is the installation of Oracle, as well as the installation of a database shown.

System Requirements

In order to install Oracle 9i, the manufacturer recommends the following system requirements:
Memory: Minimum 512 MB RAM
Swap Space: 1 GB is optimal but at least as large as the RAM.

In our system were the following steps: 
OS: Suse Linux 7.3 Professional 
Processor: Pentium II 750 Mhz 
Ram: 512 Mb 
HD: 10 GB free

Preparation of the system

1.An set of users and groups:

The installation and administration of Oracle should be under a separate user made. This user is called "oracle" and is used by Suse during the installation of the distribution is created. He belongs to the dba and oinstall groups and receives his personal list, in contrast to other users not under / home, but under / opt / oracle.
In order for the installation and administration of Oracle can be performed, must be. Profile of the user oracle nor paths to work with Oracle can be inserted. Since the. Profile under / opt / oracle does not exist, they may be issued by another user in the directory / opt / home to be copied to the environment variables must be set. These variables override the login as the oracle etc / profile.d / oracle.sh input variables.


# ORACLE Umgebungsvariablen setzenORACLE_BASE=/opt/oracle; export ORACLE_BASE
ORACLE_HOME=/opt/oracle/IhrOraHome; export ORACLE_HOME
ORACLE_SID=IhreSID; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_OWNER=oracle; export ORACLE_OWNER
NLS_LANG=german_germany.WE8ISO8859P1; export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33

# Den PATH erweitern
set PATH=$PATH:/$ORACLE_HOME/bin 

# CLASSPATH:
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

2. Configuration and verification of the kernel parameters of the C libraries and the C compiler:
Oracle on Suse requires at least kernel 2.4.7 and glibc 2.2.2. Which kernel is available, can be found with this command:

$ uname -a

The version of the system on your existing C libraries can be found on this command:

$ /lib/libc.so.6

The environment variables such as $ ORACLE_HOME for each login by an entry in the file etc / profile.d / oracle.sh set. However, these variables exactly to our system and coordinate our installation, we have already in / opt / oracle file. Profile adapted to the login of the user entries in the oracle of oracle.sh overwrites.

The crucial point is the set of kernel parameters such as max. shared memory (SHMMAX) to a value as required by Oracle. Start and stop the Oracle database at startup and shutdown of Linux. More info is under / usr / share / doc / packages / orarun / README to find

3. Note on the Java runtime environment:

In some installation guides you will find the indication that there will be problems when on a Linux system already have a jre installed as Oracle's own runtime environment brings. These problems could be under Oracle 9.0.2 does not reproduce and were apparently in the current Oracle distribution fixed.

To continue, please read Installation Oracle under Suse Linux


 Oracle Errors
Oracle Errors and their explanations
Oracle Invalid Objects
Oracle Softwares & Tools

 Frequently asked oracle errors
  • ORA-19502:write error on file "string", blockno string (blocksize=string)
  • ORA-28001:the password has expired
  • ORA-24033:no recipients for message
  • ORA-12152:TNS:unable to send break message
  • ORA-21561:OID generation failed
  • ORA-01144:File size (string blocks) exceeds maximum of string blocks
  • ORA-01086:savepoint 'string' never established
  • ORA-12712:new character set must be a superset of old character set
  • ORA-00824:cannot set sga_target due to existing internal settings, see alert log for more information
  • ORA-19804:cannot reclaim string bytes disk space from string limit
  • ORA-01610:recovery using the BACKUP CONTROLFILE option must be done
  • ORA-16224:Database Guard is enabled
  • ORA-00600:internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ORA-12853:insufficient memory for PX buffers: current stringK, max needed stringK
  • ORA-02069:global_names parameter must be set to TRUE for this operation
  • ORA-00027:cannot kill current session
  • ORA-01732:data manipulation operation not legal on this view
  • ORA-21780:Maximum number of object durations exceeded.
  • ORA-01149:cannot shutdown - file string has online backup set
  • ORA-01190:control file or data file string is from before the last RESETLOGS
  • Main Page      Contact Us