Re: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x77E7F348] [ADDR:0x7D44] [UNABLE_TO_WRITE] []

As none of the MV were created with '*' and used only column names, that fix would not have helped much.

The only fix was going to Patch Level 15+ IIRC.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

On Tue, Dec 22, 2009 at 7:04 AM, Pankaj Jain <pjain_at_ibasis.net> wrote:

> replace the "select * " from the MV and the queries with the actual
> column name. and you will not receive the 7445 error again , this is a
> reported bug and tar is available on metalink. I think it is restricted and
> not available to all.
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Balakrishna Y
> *Sent:* Tuesday, December 22, 2009 4:55 AM
> *To:* dennis_at_conus.info
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: ORA-07445: exception encountered: core dump
> [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x77E7F348] [ADDR:0x7D44]
> [UNABLE_TO_WRITE] []
>
> Hi,
>
> Yes i have seen there is some DLL file .. in the trace files but what do
> with that .. Thats the question .
>
> Regards
>
> Bala
>
> On Tue, Dec 22, 2009 at 3:16 PM, Dennis Yurichev <dennis_at_conus.info>wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Balakrishna Y wrote:
>> > I have Oracle 10g(10.2.0.4) on my local machine (Windows XP) . when ever
>> > i start the database on my machine it start throwing this Error.
>> >
>> > ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
>> > [unable_to_trans_pc] [PC:0x77E7F348] [ADDR:0x7D44] [UNABLE_TO_WRITE] []
>> >
>> >
>> > Even metalink does'nt have much supporting documents on this issue. Does
>> > any one came across this problem.I appreciate your comments on this.
>>
>> "unable_to_trans_pc" mean "unable to translate PC (program counter)"
>> mean that address (0x77E7F348 in your case) cannot be resolved to
>> function name.
>>
>> Look at trace files, Oracle dump there loaded win32 modules at the
>> moment of exception. Address 0x77E7F348 cannot be in oracle.exe, it
>> should be in some DLL.
>>
>>
>>
>> - --
>> My PGP public key: http://yurichev.com/dennis.yurichev.asc
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.8 (MingW32)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>>
>> iEYEARECAAYFAkswlYEACgkQ1YPmFmJG++NJPwCbBrUXLv3TJfdbJoazlIy1Vnhp
>> amMAmweuRYu2kwz2scUPiTnL6H8E5VnW
>> =zkws
>> -----END PGP SIGNATURE-----
>>
>
>

--
http://www.freelists.org/webpage/oracle-l