Can't start 10g automatically at reboot on AIX 5.3

Hi,

I've got a problem with Oracle 10g on AIX 5.3 which even Oracle support seems unable to fix. I want to start the database automatically at system restart, so I put the appropriate entry into /etc/inittab (su oracle -c dbstart, for short). After reboot, however, no Oracle processes are running, and I can't connect to the database (sqlplus says ORA-01034). Logging in as oracle and running dbstart manually works fine.

I had a similar problem with my own background processes started via inittab (they started but were terminated immediately), so I moved them out of inittab and into /etc/rc.d/rc2.d. This fixed the problem for my own processes (they run fine now) but not for Oracle. I use the following in /etc/rc.d/rc2.d/S02-oracle:

su oracle -c /u01/app/oracle/OraHome_1/bin/dbstart >>/var/tmp/s02.out 2>&1

Running S02-oracle manually works fine, but running it during system reboot doesn't. Most of the time, after logging in I find the following at the end of /var/tmp/s02.out:

	SQL> Connected to an idle instance.
	SQL>

and that's it (and I've waited long enough). Sometimes, however, there is a completion message in s02.out (meaning that the DB was started properly), but after logging on, all Oracle processes are gone.

Did anyone encounter similar problems? Any ideas what to do?

My AIX version (oslevel) is 5.3.0.0, and the Oracle version is 10.1.0.2.0.

Thanks for any help
W. Rösler Received on Fri Jul 01 2005 - 05:21:49 CDT