Re: Where is the Trace Log?

"Robert A. Rosenberg" wrote:
>
> After installing Oracle and setting it to autostart when we rebooted the
> program no longer comes up. We can not find out why nor do we see any error
> messages documenting the reason for this failure. When we looked at the
> location where Alert and Trace logs are supposed to be stored, there were
> none. What should we be doing to track down the cause so we can get our
> server up and running?
>
> Thank you.

This just keeps cropping up.
here's the procedure to do this

1. login as root
2. edit /etc/oratab as follows

find a line like:

ORACLE_SID:ORACLE_HOME:{Y|N} i.e.

server1:/oracle/product/8.1.5:N

change the 'N' at the end to a y

server1:/oracle/product/8.1.5:Y

this lets the oracle script know to
start this database.

3. copy the start script (with some mods) to /sbin/init.d, (may vary with platform)

chmod 750 oracle

4.change the .rhosts file in the oracle user directory to allow root access
<host name> root

8. link the script into the startup & shutdown procedures:

ln -s /sbin/init.d/oracle /sbin/rc3.d/S99oracle ln -s /sbin/init.d/oracle /sbin/rc0.d/K99oracle

9. Test!@!! MAKE SURE ALL PERMISSIONS ARE CORRECT!!!

Step 9 is very important... Received on Tue Sep 12 2000 - 04:01:52 CDT