Home » RDBMS Server » Enterprise Manager » OEM asking to do recovery or startup (oracle 10gR1 os -sp2)
OEM asking to do recovery or startup [message #343864] Thu, 28 August 2008 06:38
sureshm.ora
Messages: 17
Registered: August 2008
Location: BANGLORE
Junior Member
HELLO HAI to one & all
please help me..
oem asking to do startup or recovery but still database is functioning well . One thing is that sysman password cheanged by using alter user command , when all services up & running ...

i traced the session by toad utilty it showing like following ...




/* Formatted on 2008/08/23 07:24 (Formatter Plus v4.8.0) */
/* OracleOEM */
SELECT trans_count
FROM (SELECT 'def_trans_err' NAME, COUNT (*) trans_count
FROM SYS.deferror
UNION ALL
SELECT 'def_trans_noerr' NAME, COUNT (*) trans_count
FROM SYS.deftran)
ORDER BY NAME


SELECT 'RECOVERY AREA' recovery_area,
CASE
WHEN space_limit > 0 AND space_used >= space_reclaimable
THEN 100
* (space_used - space_reclaimable)
/ space_limit
ELSE NULL
END free_space
FROM v$recovery_file_dest
WHERE NAME IS NOT NULL AND ROWNUM = 1



BEGIN
:MESSAGE :=
dbms_server_alert.expand_message (:LANGUAGE,
:message_id,
:argument_1,
:argument_2,
:argument_3,
:argument_4,
:argument_5
);
END;

SELECT TO_CHAR (CAST (d.end_time AS TIMESTAMP) AT TIME ZONE 'GMT',
'YYYY-MM-DD HH24:MI:SS TZD') TIME, d.service_name,
d.elapsedpercall, d.cpupercall
FROM v$servicemetric_history d
WHERE d.end_time >= SYSDATE - 15 / (60 * 24) AND :1 != 'BASIC'
ORDER BY d.end_time ASC


/* Formatted on 2008/08/23 07:29 (Formatter Plus v4.8.0) */
/* OracleOEM */
SELECT trans_count
FROM (SELECT 'def_trans_err' NAME, COUNT (*) trans_count
FROM SYS.deferror
UNION ALL
SELECT 'def_trans_noerr' NAME, COUNT (*) trans_count
FROM SYS.deftran)
ORDER BY NAME


/* Formatted on 2008/08/23 07:31 (Formatter Plus v4.8.0) */
/* OracleOEM */
SELECT /*+ ORDERED */
TO_CHAR (CAST (m.end_time AS TIMESTAMP) AT TIME ZONE 'GMT',
'YYYY-MM-DD HH24:MI:SS TZD'),
SUM (CASE
WHEN a.internal_metric_name = 'logons'
THEN m.VALUE
ELSE 0
END
) logons,
SUM (CASE
WHEN a.internal_metric_name = 'opencursors'
THEN m.VALUE
ELSE 0
END
) opencursors,
SUM (CASE
WHEN a.internal_metric_name = 'user_limit'
THEN m.VALUE
ELSE 0
END
) user_limit,
SUM (CASE
WHEN a.internal_metric_name = 'process_usage'
THEN m.VALUE
ELSE 0
END
) process_usage,
SUM (CASE
WHEN a.internal_metric_name = 'session_usage'
THEN m.VALUE
ELSE 0
END
) session_usage
FROM v$alert_types a, v$threshold_types t, v$sysmetric m
WHERE a.internal_metric_category = 'Database_Resource_Usage'
AND a.reason_id = t.alert_reason_id
AND t.metrics_id = m.metric_id
AND m.GROUP_ID = 2
AND :1 != 'BASIC'
GROUP BY m.end_time
ORDER BY m.end_time ASC


/* Formatted on 2008/08/23 07:32 (Formatter Plus v4.8.0) */
/* OracleOEM */
SELECT TO_CHAR (CAST (d.end_time AS TIMESTAMP) AT TIME ZONE 'GMT',
'YYYY-MM-DD HH24:MI:SS TZD'), n.NAME, d.average_read_time,
d.average_write_time
FROM v$dbfile n, v$filemetric d
WHERE d.file_id = n.FILE# AND :1 != 'BASIC'
ORDER BY d.end_time ASC


/* Formatted on 2008/08/23 07:33 (Formatter Plus v4.8.0) */
/* OracleOEM */
SELECT trans_count
FROM (SELECT 'def_trans_err' NAME, COUNT (*) trans_count
FROM SYS.deferror
UNION ALL
SELECT 'def_trans_noerr' NAME, COUNT (*) trans_count
FROM SYS.deftran)
ORDER BY NAME

/* Formatted on 2008/08/23 07:36 (Formatter Plus v4.8.0) */
/* OracleOEM */
SELECT /*+ ORDERED */
TO_CHAR (CAST (m.end_time AS TIMESTAMP) AT TIME ZONE 'GMT',
'YYYY-MM-DD HH24:MI:SS TZD'),
SUM (CASE
WHEN a.internal_metric_name = 'logons'
THEN m.VALUE
ELSE 0
END
) logons,
SUM (CASE
WHEN a.internal_metric_name = 'opencursors'
THEN m.VALUE
ELSE 0
END
) opencursors,
SUM (CASE
WHEN a.internal_metric_name = 'user_limit'
THEN m.VALUE
ELSE 0
END
) user_limit,
SUM (CASE
WHEN a.internal_metric_name = 'process_usage'
THEN m.VALUE
ELSE 0
END
) process_usage,
SUM (CASE
WHEN a.internal_metric_name = 'session_usage'
THEN m.VALUE
ELSE 0
END
) session_usage
FROM v$alert_types a, v$threshold_types t, v$sysmetric m
WHERE a.internal_metric_category = 'Database_Resource_Usage'
AND a.reason_id = t.alert_reason_id
AND t.metrics_id = m.metric_id
AND m.GROUP_ID = 2
AND :1 != 'BASIC'
GROUP BY m.end_time
ORDER BY m.end_time ASC

/* OracleOEM */
SELECT TO_CHAR (CAST (d.end_time AS TIMESTAMP) AT TIME ZONE 'GMT',
'YYYY-MM-DD HH24:MI:SS TZD'), n.NAME, d.average_read_time,
d.average_write_time
FROM v$dbfile n, v$filemetric d
WHERE d.file_id = n.FILE# AND :1 != 'BASIC'
ORDER BY d.end_time ASC





Previous Topic: RAC Management Server
Next Topic: expired (locked) for sysman user
Goto Forum:
  


Current Time: Thu Mar 28 10:29:46 CDT 2024