• Apache Instance with OCI/PHP/MySQL Modules


• PHP with GD,OCI, and MySQL


• Oracle Client


• MySQL

C:\Program Files\Apache\Apache229\htdocs\setup>mysql -h localhost -u root -P 330
7 -p < setup_dbsaurus.sql
Enter password: ********

C:\Program Files\Apache\Apache229\htdocs\setup> move dbsaurus.ini C:\dbsaurus.ini

var $ini = 'C:\dbsaurus.ini';

$ export ORACLE_SID=emrep
$ . oraenv
$ sqlplus "/ as sysdba" @setup_orauser.sql

Labels: DBAdminisaurus, Monitoring

$ export ORACLE_SID=agent10g
$ . oraenv
$ emctl config agent listtargets | grep oracle_emrep

<target type="oracle_emrep" name="Management Services and Repository" version="1.0">
<property value="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.colestock.test)(PORT=1521)))(CONNECT_DATA=(SID=emrep)))" name="ConnectDescriptor"></property>
<property value="sysman" name="UserName" encrypted="FALSE"></property>
<property value="password" name="password" encrypted="FALSE"></property></target>

$ emctl reload agent
Oracle Enterprise Manager 10g Release 4 Grid Control 10.2.0.4.0.
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD reload completed successfully

$ emctl config agent listtargets | grep oracle_emrep
[Management Services and Repository, oracle_emrep]

emd_email_address=oracle@rac1.colestock.test,james@colestock.com
emd_email_gateway=localhost
emd_from_email_address=

$ emctl reload agent
Oracle Enterprise Manager 10g Release 4 Grid Control 10.2.0.4.0.
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD reload completed successfully

$ export ORACLE_SID=oms10g
$ . oraenv
$ $ORACLE_HOME/opmn/bin/opmnctl stopall
opmnctl: stopping opmn and all managed processes...

From oracle@colestock.com  Wed Sep 24 18:29:16 2008
Return-Path: 
Received: from rac1.colestock.test (localhost.colestock.test [127.0.0.1])
        by rac1.colestock.test (8.13.1/8.13.1) with ESMTP id m8P0TFTp006370;
        Wed, 24 Sep 2008 18:29:16 -0600
Received: (from oracle@localhost)
        by rac1.colestock.test (8.13.1/8.13.1/Submit) id m8P0TFpN006368;
        Wed, 24 Sep 2008 18:29:15 -0600
Date: Wed, 24 Sep 2008 18:29:15 -0600
From: Oracle Software Owner 
Message-Id: <200809250029.m8P0TFpN006368@rac1.colestock.test>
To: oracle@rac1.colestock.test, james@colestock.com
Subject: Severe Enterprise Manager problem


Wed Sep 24 18:29:15 MDT 2008
Severe Enterprise Manager problem
Error message: No active Management Services were found

Labels: Grid Control, Monitoring

SELECT   /* SQL Monitor Query for >= 10g */
         '(' || s.SID || ',' || s.serial# || ')' "sid/serial",
         s.program "pgrm", s.terminal "term", s.username "db user",
         DECODE (ROUND (s.last_call_et / 60),
                 '0', '< 1',
                 ROUND (s.last_call_et / 60)
                ) "rtime (mins)",
         DECODE (ps."px oper cnt", '', 'N/A', ps."px oper cnt") "px opers",
         DECODE (ps."px count", '', 'N/A', ps."px count") "px slaves",
         si.block_changes "sess bchgs", si.physical_reads "sess preads",
         pss_pr."px preads" "child px preads",
         si.consistent_gets "sess cgets", pss_cg."px cgets" "child px cgets",
         ss_cpu."sess cpu" "sess cpu", pss_cpu."px cpu" "child px cpu",
         sa.optimizer_cost "curr sql cost", su."blocks" "temp blocks",
         t."used_ublk" "undo blocks", s.event "wait",
         s.seconds_in_wait "wait secs", s.state "wait state",
         s.sql_id "current sql id", sa.sql_fulltext "sql text",
         DBMS_XPLAN.display_cursor (s.sql_id, s.sql_child_number) "sql xplan"
    FROM v$session s,
         v$sess_io si,
         v$sql sa,
         (SELECT   qcsid, COUNT (DISTINCT server_set) "px oper cnt",
                   COUNT (*) "px count"
              FROM v$px_session
             WHERE NOT server_set IS NULL
          GROUP BY qcsid, DEGREE) ps,
         (SELECT   qcsid, SUM (VALUE) "px preads"
              FROM v$px_sesstat
             WHERE statistic# = 54 AND SID != qcsid
          GROUP BY qcsid) pss_pr,
         (SELECT   qcsid, SUM (VALUE) "px cgets"
              FROM v$px_sesstat pss
             WHERE statistic# = 50 AND SID != qcsid
          GROUP BY qcsid) pss_cg,
         (SELECT   qcsid, SUM (VALUE) "px cpu"
              FROM v$px_sesstat pss
             WHERE statistic# = 12 AND SID != qcsid
          GROUP BY qcsid) pss_cpu,
         (SELECT   ss.SID, SUM (ss.VALUE) "sess cpu"
              FROM v$sesstat ss
             WHERE statistic# = 12
          GROUP BY ss.SID) ss_cpu,
         (SELECT   t.ses_addr, SUM (t.used_ublk) "used_ublk"
              FROM v$transaction t
          GROUP BY t.ses_addr) t,
         (SELECT   su.session_addr, SUM (su.blocks) "blocks"
              FROM v$sort_usage su
          GROUP BY su.session_addr) su
   WHERE s.sql_address = sa.address
     AND s.sql_hash_value = sa.hash_value
     AND s.saddr = su.session_addr(+)
     AND s.SID = ps.qcsid(+)
     AND s.SID = si.SID(+)
     AND s.saddr = t.ses_addr(+)
     AND s.SID = pss_pr.qcsid(+)
     AND s.SID = pss_cg.qcsid(+)
     AND s.SID = pss_cpu.qcsid(+)
     AND s.SID = ss_cpu.SID(+)
     AND s.TYPE != 'BACKGROUND'
     AND s.status = 'ACTIVE'
     AND program NOT LIKE ('%(C%')                 --Eliminate Streams Capture
     AND program NOT LIKE ('%(A%')                   --Eliminate Streams Apply
     AND program NOT LIKE ('%(P%')                 --Eliminate Parallel Slaves
ORDER BY sa.optimizer_cost DESC;

Labels: Monitoring