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
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] [0×000000000] [] []
Trace file uploaded shows:
/opt/
© 2008 Blog Aggregator - Amardeep Sidhu | Entries (RSS) and Comments (RSS)
Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette