Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA`s in th alert

Status
Not open for further replies.

mrcomino

Technical User
Sep 21, 2000
21
0
0
ES
Hi
Im using Oracle 7.3.4.5 over a Compaq Digital V4.0 D (878).
Im getting more and more errors in the alert file.
They are produced at night, just whe the cron is trying
to shutdown the database after a full consistent export.
For shutting down the DB, i use a changed version of oracle dbshut script.
(The only change is that i replace the "shutdown normal" with a "shutdown
immediate").
Im getting things so beautifulls as :

Shutting down instance (immediate)
Mon Mar 26 23:09:28 2001
Mon Mar 26 23:09:28 2001
License high water mark = 9
License high water mark = 9
Mon Mar 26 23:09:32 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_18961.trc:
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Mon Mar 26 23:09:32 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_18263.trc:
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Mon Mar 26 23:09:35 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_18961.trc:
ORA-00600: internal error code, arguments: [922], [28616064], [], [], [],
[], [], []
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Mon Mar 26 23:09:35 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_18263.trc:
ORA-00600: internal error code, arguments: [922], [13969488], [], [], [],
[], [], []
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Mon Mar 26 23:11:01 2001
License high water mark = 9
Mon Mar 26 23:11:03 2001
Starting ORACLE instance (normal)
...
Shutting down instance (immediate)
Tue Mar 27 23:09:42 2001
License high water mark = 7
Shutting down instance (immediate)
Tue Mar 27 23:09:42 2001
License high water mark = 7
Tue Mar 27 23:09:45 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_23687.trc:
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Tue Mar 27 23:09:45 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_21661.trc:
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Tue Mar 27 23:09:49 2001
Tue Mar 27 23:09:49 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_21661.trc:
ORA-00600: internal error code, arguments: [922], [20123024], [], [], [],
[], [], []
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_23687.trc:
ORA-00600: internal error code, arguments: [922], [11965784], [], [], [],
[], [], []
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Tue Mar 27 23:11:24 2001
License high water mark = 7
Tue Mar 27 23:11:27 2001
Starting ORACLE instance (normal)
...
Wed Mar 28 23:12:39 2001
Wed Mar 28 23:12:39 2001
Shutting down instance (immediate)
Wed Mar 28 23:12:40 2001
License high water mark = 15
Shutting down instance (immediate)
Wed Mar 28 23:12:40 2001
License high water mark = 15
Wed Mar 28 23:12:43 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_1304.trc:
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Wed Mar 28 23:12:43 2001
Errors in file
/usr/users/oracle73/app/oracle/product/7.3.4/op73/udump/ora_837.trc:
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
Wed Mar 28 23:14:18 2001
License high water mark = 15
Wed Mar 28 23:14:20 2001
Starting ORACLE instance (normal)

I dont know if the problem is related with: The use of TOAD or The recent
change of the database to Archive mode.
Any ideas? Thanks in advance
Antonio
 
Do the trace files enlighten the matter anymore? It might be worth posting one of those.
 
The trace files are of shadow proceesses
example:
cat ora_22615.trc

...
Redo thread mounted by this instance: 1
Oracle process number: 9
Unix process pid: 22615, image: oracleop73

*** SESSION ID:(7.251) 2001-04-05 23:09:55.755
Exception signal: 11, code = 1
...
*** 2001-04-05 23:09:55.827
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [11] [1] [0] [0] [] []
...


Thats not ligth for me.
I will try to ensure , that no user session is
in oracle when all my users gone.

More ideas ?
Thanks anyway
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top