APEX Application DBAdmin

APEX application DBAdmin

APEX Server Info

Change APEX Port
###################################################################
#!/bin/ksh
sqlplus -s “/ as sysdba” <<EOF
exec dbms_xdb.sethttpport(0);
commit;
exec dbms_xdb.sethttpport(8081);
commit;

EOF
###################################################################

Pull Registry Information
#################################################################
#!/bin/ksh

sqlplus -s “/ as sysdba” <<EOF

col comp_name format a35
col status format a12
select comp_name, status, version
from dba_registry
order by comp_name;

EOF
###################################################################

EPG Status
##################################################################
#!/bin/ksh
sqlplus -s “/ as sysdba” <<EOF

@/oracle/product/11.2.0/db_1/rdbms/admin/epgstat.sql
EOF

##################################################################
This is an APEX application that tracks databases and other information around

Objects include:
Database –

CREATE TABLE “DATABASE”
( “DB_ID” VARCHAR2(10),
“DB_NM” VARCHAR2(20),
“DB_DSCR” VARCHAR2(1000),
“DB_CMT” VARCHAR2(4000),
“DB_QADT” DATE,
“DB_INST_NM” VARCHAR2(15),
“DB_TP” VARCHAR2(3),
“DB_VER” VARCHAR2(15),
“DB_OS” VARCHAR2(4),
“DB_OS_VER” VARCHAR2(3),
“DB_UPG_VER” VARCHAR2(10),
“DB_UPG_STAT” VARCHAR2(3),
“DB_DBA_CRT” VARCHAR2(4),
“DB_APL” VARCHAR2(4),
“DB_DBA_CUR” VARCHAR2(4),
“DB_CRT_DT” DATE,
“DB_DT_NXT_UPG” DATE,
“DB_DT_UPG” DATE,
“DB_CMP” VARCHAR2(3),
“DB_DBA_PRIM” VARCHAR2(4),
“DB_DBA_SECD” VARCHAR2(4),
“DB_CST_ID” NUMBER,
“DB_CPU” NUMBER,
“DB_DSK_USED” NUMBER,
“DB_DSK_ALLOC” NUMBER,
“DB_MEM_PGA” NUMBER,
“DB_MEM_SGA” NUMBER,
“DB_MEM_TGT” NUMBER,
“DB_DBID” VARCHAR2(25),
“DB_BKP_FRQ” VARCHAR2(2000),
“DB_SVC_NM” VARCHAR2(50),
“DB_CAT_TP” VARCHAR2(35),
“DB_DBA_LU” VARCHAR2(25),
“DB_DBA_NU” VARCHAR2(25),
“DB_MCH_ID” VARCHAR2(10),
“DB_DT_DECOMM” DATE,
“DB_STORM” VARCHAR2(4000),
“DB_UNQ_NM” VARCHAR2(20),
“DB_AIT” VARCHAR2(20),
“DB_STO_DATA” NUMBER,
“DB_STO_SYS” NUMBER,
“DB_STO_FRA” NUMBER,
“DB_UPG_CMTS” CLOB,
“DB_PRCS” NUMBER,
“DB_SESS” NUMBER,
“DB_QST” VARCHAR2(4000),
“DB_HC_DBID” NUMBER,
“DB_STO_DATA_USD” NUMBER,
“DB_STO_FRA_USD” NUMBER,
“DB_STO_SYS_USD” NUMBER,
“DB_AUD_TP” VARCHAR2(50),
“DB_BCK” VARCHAR2(1),
“DB_SQLT” VARCHAR2(1),
“DB_CRTAB” VARCHAR2(1),
“DB_DDL” VARCHAR2(1),
“DB_ENV” VARCHAR2(1),
“DB_RMAN_ARGS” VARCHAR2(1),
“DB_RON_FO_TST” VARCHAR2(1),
“DB_RISK_RTG” VARCHAR2(4000),
“DB_NA_DT” DATE,
“DB_VFY_ASM” VARCHAR2(1),
“DB_DBCA” VARCHAR2(1),
“DB_DBCA_SL” VARCHAR2(4000),
“DB_TST_NWS” VARCHAR2(1),
“DB_ESM” VARCHAR2(1),
“DB_TST_CNCT” VARCHAR2(1),
“DB_PORT” VARCHAR2(4000),
“DB_HST” VARCHAR2(4000),
“DB_SVC_NM02” VARCHAR2(4000),
“DB_LOG_CLN” VARCHAR2(1),
“DB_LSN_CLN” VARCHAR2(1),
“DB_CRON_TXT” VARCHAR2(4000),
– stores the crontab entry text for this database
“DB_CLN_RUN” VARCHAR2(1),

“DB_MON_TST” VARCHAR2(1),
“DB_MRD” VARCHAR2(1),
“DB_SPM” VARCHAR2(1),
“DB_AWR” VARCHAR2(1),
“DB_INST_CG” VARCHAR2(3),
“DB_FOG” VARCHAR2(1),
“DB_SPT” VARCHAR2(1),
“DB_ORATAB” VARCHAR2(1),
“DB_90_CFG” VARCHAR2(1),
“DB_100_TBSPC” VARCHAR2(1),
“DB_QA_CMTS” CLOB,
“DB_STO_SAUX” NUMBER,
“DB_STO_SAUX_USD” NUMBER,
“DB_STO_USERS” NUMBER,
“DB_STO_USERS_USD” NUMBER,
“DB_STO_UNDO” NUMBER,
“DB_STO_UNDO_USD” NUMBER,
“DB_STO_TOOLS” NUMBER,
“DB_STO_TOOLS_USD” NUMBER,
“DB_STO_TEMP” NUMBER,
“DB_STO_TEMP_USD” NUMBER,
“DB_STO_ONREDO” NUMBER,
“DB_STO_ONREDO_USD” NUMBER,
CONSTRAINT “DATABASE_PK” PRIMARY KEY (“DB_ID”) ENABLE
) ;

cluster

Tracking the problem tickets include:
incident table
inc_no
Ticket Number
Severity
Time Opened
Time Resolved
Total hrs worked
After hours worked
SLA Missed
Hostname
Resolved Group
Root Cause – drop down?
Duplicate? – has this ticket occured before
Detailed description
Brief Description
Work log
Comments
Detiled Resolution

Leave a Reply

Your email address will not be published. Required fields are marked *