Stephen's Oracle Blog

One of the tasks I've recently been given is to collate information about our Oracle and SQLServer databases. Stuff like sizes, init.ora parameters &c. I've developed a script that gets a lot of the stuff we need out of Oracle. Here it is: set echo off set verify off set feedback off set linesize 132 set pagesize 60 set heading off /* This script must be run as SYS (SYSDBA) */ Prompt "Audit Information" select 'Run on: '||to_char(sysdate, 'HH24:MI DD-MON-YYYY') from dual / prompt prompt set heading on column name heading "Database Name" select name from v$database / prompt column banner heading "Database Version Information" select banner from v$version / prompt prompt column log_mode format a16 heading "Archivelog mode" select log_mode from v$database / prompt prompt column option_param format a70 heading "Option" prompt "Options Installed" select parameter option_param from v$option where value=...

Finally got a response from Oracle, turned out they had put it with their US office who don't start work until 13:00 our time. The eventual response was: 23-MAY-06 14:49:43 GMT DATA COLLECTED =============== On alert.log we can see some: ORA-07445: exception encountered: core dump [00000001009B0B04] [SIGSEGV] [Address not mapped to obj ect] [0x000000000] [] [] Trace file uploaded shows: /opt/oracle/app/oracle/admin/dchr/udump/dchr_ora_5662.trc Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production JServer Release 9.2.0.6.0 - Production *** SESSION ID:(37.1317) 2006-05-18 15:34:04.409 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1009b0b04, 00000001009B0B04] *** 2006-05-18 15:34:04.410 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [00000001009B0B04] [SIGSEGV] [Address not mapped to object] [0x000000000 ] [] [] Current SQL statement for this session: select all count(dm_type.r_object_id) "the_cou...

Late yesterday one of our projects passed me information abvout an ORA-07445 error they'd had earlier in the day, apparently this is stopping one of the modules in their application to stop working. Why they couldn't have told me about it earlier I don't know, I would have had time to raise a Service Request with Oracle during our maintenence hours (the why we don't have 24x7 cover is a rant for another time). I raised a call with Oracle before I went home but there's been no updates on it as of yet, other than a note saying they will update it when they have some information (fair enough I suppose). This long silence is worrying, maybe it's something serious? Here's the header of the trace file: *** 2006-05-19 10:57:39.159 *** SESSION ID:(21.4255) 2006-05-19 10:57:39.158 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1009b0b04, 00000001009B0B04] *** 2006-05-19 10:57:39.159 ksedmp: internal or fatal error ORA-0744...