Oracle 9i 9.2.0.1 dbstart problems
Is there a way in which I can have both my listener and database startup automatically as part of the Linux boot process? I am running Red Hat Linux 7.2 and Oracle 9i 9.2.0.1. I followed the instructions for creating a script named dbora which calls dbstart and dbstop respectively and created the links as well. However, this doesn't seem to work. I've found several threads here which indicate that dbstart is "buggy" and that svrmgrl is no longer supported in 9i which leads me to beleive dbstart might not function. When I run su - $ORA_OWNER -c $ORA_HOME/bin/dbstart & I get the following error: ORA-01031 insufficient privileges. This I do not understand because my oracle user has been granted the dba role. Interestingly enough I can start the listener and mount the database without error by doing the following:
$lsnrctl start oracle (no problem)
$sqlplus "oracle/oracle@xyz as sysdba" (this works too, and is the same account as ORA_OWNER)
I am also able to startup the database without any errors so it seems unlikely that there's a insufficient privileges issue when using dbstart.
So, the question is what is the best way to configure my Linux server so that my listener is started and database opened after the system starts? Thank you in advance for any suggestions you might have.