Re: Trace Files and Alert Logs Filling Up Hard Drive

HMM wrote:
> Sorry, I don't use forums very often..I get a little mixed up with the
> ettiquitte. I hope this isn't top-posted.
>
> Thanks for your help! I'm not using DataGuard or Standby database. It
> is Enterprise Edition and not a domain controller. The Oracle is
> installed on a stand-alone test server. I checked the parameters you
> gave and they are the following:
>
> db_name = gisx
> db_unique_name = gisx
> log_archive_config = (blank)
> control_files = c:\oracle\product\10.2.0\oradata\gisx\control1.ctl,
> c:\oracle\product\10.2.0\oradata\gisx\control2.ctl,
> c:\oracle\product\10.2.0\oradata\gisx\control3.ctl
> log_archive_dest_1 = (blank)
> log_archive_dest_2 = (blank)
> log_archive_dest_state_1 = enable
> log_archive_dest_state_2 = enable
> remote_login_passwordfile = exclusive
> log_archive_format = ARC%S_%R.%T
> log_archive_max_processes = 2
>
>
> joel garry wrote:
> > HMM wrote:
> > > Bug: 5568622 is mine. The only reason I posted is that it just seemed
> > > odd to me that I would be the first one to find this installation bug
> > > when 10.2.0.2 has been out awhile. I'm not running any special memory
> > > config. Its a 32 bit 10.2.0.2 install. I took all the defaults when I
> > > installed Oracle and all the defaults when I created the database. The
> > > alert log just keeps growing and several trace files are being created.
> > > The error in the alert log is the following:
> > >
> > > ~Errors in file
> > > c:\oracle\product\10.2.0\admin\gisx\udump\gisx_drcx_2628.trc:~ORA-07445:
> > > exception encountered: core dump [ACCESS_VIOLATION]
> > > [unable_to_trans_pc] [PC:0xB6BE2B] [ADDR:0x0] [UNABLE_TO_WRITE] []~
> > >
> > > Yes...the main bulk of files being created is in udump. They are drcx
> > > trace files. The error in these files is DRCX Client did not establish
> > > network login. I can't find anything on DRCX..I'm not sure what it is.
> >
> > That would be Data Guard Connection Process. Are you using DG? Have
> > you set any init.ora parameters for DG? Are you using logical standby?
> > Any RAC involved? Parallel servers?
> >
> > I suspect you've accidentally turned on a feature you don't want and
> > haven't configured properly. Post your systems' values of the
> > parameters in this example:
> > http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i68626
> >
> > By the way, don't top post in this group. Google if you don't know
> > what that means.
> >
> > jg
> > --
> > @home.com is bogus.
> > http://www.black-market-babies.com/

Yes, unfortunately, you did top-post. Stop doing that, please, and follow the examples provided you by this response and others in this thread by noticing WHERE I place my text.

I imagine it's the log_archive_dest_state_2 parameter causing your problems as you don't have two archive log destinations configured on your machine and, I expect, Oracle is attempting to connect to the second, nonexistent destination via Data Guard. Comment this parameter in your init.ora file and restart the database. You may find the process, and the resulting errors, go away. If not you at least have the bug registered with Oracle and will, hopefully, receive a patch to correct it.

David Fitzjarrell Received on Wed Nov 15 2006 - 08:56:29 CST