<lament>
The initscripts issue is a huge pain.

It seems that both Oracle and SUSE try to accomplish too much with "ONE script
to rule them all".

I doubt that it can be done with one big script, the particular setups of
users can vary too much.

SUSE script tries to handle every Oracle application and every version.
Oracle Clusterware scripts try to handle every *nix.

I ended up editing the SUSE script so much that I might have been better off
making my own from scratch. I have broken it into smaller scripts for each
application:
- for setting up kernel parameters
- for starting database and enterprise manager
- for starting application server and it's manager

The scripts still have the cruft necessary to work around Oracle 8 and 9
quirks, even if I run 10g R2.

Probably SUSE and Oracle try to maintain just one script so that it's less
work. But what's the use, if the scripts don't work as they're supposed to,
except for very simple cases. There might as well be no scripts at all, at
least we wouldn't have false hopes.

And, BTW I don't see why SUSE has to make the Oracle initscripts. This is
Oracle's product! SUSE just tried to be nice and help us users where Oracle
should have and didn't.
</lament>

I'm working on scripts that start my whole Oracle stack.
- OCFS2
- Clusterware
- Database, EM
- App Server Forms & Reports, EM

The script that starts the database does it like this:
echo startup | sqlplus -S / as sysdba
(BTW, dbstart from Oracle does jack)

The problem is that database starts and is shut down with Oracle error 29702
(clusterware problem). Then starts again "by itself" in a way that I haven't
been able to identify yet. The second start is after all the initscripts
have finished running. I suppose that it's started after the inittab stuff
for Clusterware is in effect. And that happens after the initscripts are
done.

The second time the database is started, it has a limit of 1024 open files,
which is very wrong. If I restart it using my initscript, it's fine, the
limit is higher, as set in /etc/security/limits.conf.


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting