opensuse 11.2 and Oracle XE Installation

Hello,

i tried to install Oracle XE on openSUSE 11.2.
The first attempt without orarun didn’t work, so i read
How to install OracleXE on openSUSE 11.1 - openSUSE Forums
and wrote a script for installation:


#!/bin/bash

# Log-file
touch /var/log/XEsilentinstall.log

rpm -ivh orarun.rpm > /var/log/XEsilentinstall.log

rpm -ivh oracle-xe-10.2.0.1-1.0.i386.rpm >> /var/log/XEsilentinstall.log

cp /etc/profile.d/oracle.sh /etc/profile.d/oracle-xe.sh
mkdir /tmp/OraRun_BKUP
mv /etc/init.d/oracle /tmp/OraRun_BKUP/etc-init.d-oracle
mv /etc/profile.d/oracle.sh /tmp/OraRun_BKUP/etc-profile.d-oracle.sh
mv /etc/profile.d/oracle.csh /tmp/OraRun_BKUP/etc-profile.d-oracle.csh
mv /etc/sysconfig/oracle /tmp/OraRun_BKUP/etc-sysconfig-oracle

cp /usr/local/sbin/oracle/oracle-xe.sh /etc/profile.d/oracle-xe.sh

/etc/init.d/./oracle-xe configure < /usr/local/sbin/oracle/rf.txt >> /var/log/XEsilentinstall.log

cp profile.local /etc/profile.local
cp profile.local /etc/bash.bashrc.local
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

sqlplus sys/<password> as sysdba @dbid_linux.sql >> /var/log/XEsilentinstall.log

## deleted other stuff##

setterm -default
setterm -clear

chown -R oracle:dba /usr/lib/oracle
chmod -R 755 /usr/lib/oracle

chown -R oracle:dba /var/tmp/.oracle
chmod -R 755 /var/tmp/.oracle

chown -R oracle:dba /tmp/.oracle
chmod -R 755 /tmp/.oracle

chown oracle:dba /var/opt/oracle
chmod 755 /var/opt/oracle

chgrp -R dba /usr/lib/oracle/xe/app/oracle/admin/XE/dpdump  >> /var/log/XEsilentinstall.log
chmod g+s /usr/lib/oracle/xe/app/oracle/admin/XE/dpdump  >> /var/log/XEsilentinstall.log
chmod -R 770 /usr/lib/oracle/xe/app/oracle/admin/XE/dpdump  >> /var/log/XEsilentinstall.log

groupmod -A oracle dba

rm /etc/init.d/rc3.d/K01oracle
rm /etc/init.d/rc3.d/S09oracle
rm /etc/init.d/rc5.d/K01oracle
rm /etc/init.d/rc5.d/S09oracle


This seemed to work, the windows-app did
an imort off data.
but after that i noticed that all oracle processes
on the linux machine are running as user oracle and group oinstall.
During installation the rights were user oracle and group dba

As a result of that i can’t login via sqlplus
and i get a
ora-01034 oracle not available
and a
ora-27121 unable to determine size of shared memory segment
Linux error: 13: Permission denied

variables changed to:
ORACLE_BASE=/usr/lib/oracle/xe/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/server
ORACLE_SID=XE

Kernel switched from kernel-desktop to
kernek-pae 32bit.
boot.sysctl is on
no KDE or GNOME, minimal installation

How can i fix this or have oracel-xe running as oracle:dba?
Or do i need “groupmod -A oracle oinstall”?

Best regards.

Please read my post.

Installing Oracle 10g Express Edition in OpenSUSE 11.2 – How To - openSUSE Forums

regards
jon2ryhme:)