Oracle: Running under SuSE 10

[^rooker]

[PROBLEM]
While trying to install Oracle 10g, I received the following message:

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2

Failed <<<<

[SOLUTION]
run the installer with this parameter:

Code: Select all

./runInstaller -IGNORESYSPREREQS

[My-2-cents]
Every time I have to touch oracle, it gives me another reason why I do NOT like it.

[^rooker]

[PROBLEM]
Oracle's installation does NOT seem to come with proper startup scripts useful in the SysV init process.

Check the SuSE ftp for RPMs including startup files for oracle.


I didn't want to blindly execute this RPM, so I unpacked it to use only the startup scripts I wanted, using this:

Code: Select all

rpm2cpio foo.rpm | cpio -idmv --no-absolute-filenames

I couldn't find a ready file for /etc/sysconfig/oracle, so I created my own, based on the code in /etc/init.d/oracle:

Code: Select all

#!/bin/bash






SET_ORACLE_KERNEL_PARAMETERS="yes";


START_ORACLE_DB_OCFS="no";


START_ORACLE_DB_OCM="no";


START_ORACLE_DB_GSD="no";


START_ORACLE_DB_LISTENER="yes";


START_ORACLE_DB="yes";


START_ORACLE_DB_APACHE="no";


START_ORACLE_DB_CMANAGER="no";


START_ORACLE_DB_AGENT="no";


START_ORACLE_DB_IFS="no";


START_ORACLE_DB_OID="no";

[^rooker]

[PROBLEM]
When starting oracle using "$ORACLE_HOME/bin/dbstart" that's coming with it, I received the following error:

Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr

[SOLUTION]
Obiously, the creator of "dbstart" whose username seems to be 'vikrkuma' has left us with this line here:

Code: Select all

# Set this to bring up Oracle Net Listener
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle

by setting this variable to $ORACLE_HOME, everything's back in place where it belongs.

[^rooker]

[PROBLEM]
By default, apache is running as user 'wwwrun', Oracle 10g has its default accessrights configured so that ONLY the oracle-user or members of the dba-group (specified during installation) can even list subdirs of $ORACLE_HOME.

Thus, you get the nice error:

oci_open_server: Error while trying to retrieve text for error ORA-12154"

although your ORACLE_HOME and ORACLE_SID is set properly.


[SOLUTION]
I always thought that "dba" was short for "Database Administrat[or|ion]", but apparently it means "DB-access".

so: add 'wwwrun' to your dba-group, restart apache (YES! that's important - and it took me almost 1 hour to find that out) and you're set.