dbawiki - User contributions [en]

RMAN

2011-11-22T22:35:23Z

Shb:

==Query to check the status of the database backups==
select s.db_name
, s.status
, max(s.start_time) start_time
, max(round(s.mbytes_processed/1024)) "processed_data(GB)"
, max(round((end_time-start_time)*60*24)) "duration(min)"
, trunc(sysdate)-trunc(s.start_time) days_since_last_backup
from rman.rc_rman_status s
where 1=1
and lower(s.operation) = 'backup'
and lower(s.object_type) ='db full'
and s.start_time =
(
select max(md.start_time)
from rman.rc_rman_status md
where 1=1
and lower(md.operation) = 'backup'
and lower(md.object_type) ='db full'
and md.db_name = s.db_name
)
group by s.db_name
, s.object_type
, s.operation
, s.status
, trunc(sysdate)-trunc(s.start_time)
order by trunc(sysdate)-trunc(s.start_time) desc

==Which tapes are the backups on?==
Not really necessary as RMAN can work it out but if you need to know...
select media
, to_char(completion_time,'DD-MON-YYYY HH24:MI:SS') backed_up
from rc_backup_piece
where 1=1
and db_id = 4053457814
and completion_Time > sysdate - 2
order by 2

==Get rid of an agent that won’t go away in the Grid screens:==
emctl stop agent
exec mgmt_admin.cleanup_agent('<myserver>:<port>')
emctl start agent

==Get rid of targets that won’t go away in the Grid screens:==
exec mgmt_admin.delete_target('target_name','target_type’)

See mgmt_targets table in sysman schema for list of known targets.

Which databases are running on the machine

2011-11-22T22:31:50Z

Shb: /* From Windows */

==From Unix==
ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq

==From Windows==
Start,run... then:
services.msc
Look through list for services beginning with OracleService<SID>
When I get the hang of bat files, I'll write a script for it.

==How to see what databases have been defined (running or not)==
cat /var/opt/oracle/oratab (Solaris)

cat /etc/oratab (others)

Which databases are running on the machine

2011-11-22T22:25:37Z

Shb: Created page with "==From Unix== ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq ==From Windows== services.msc Look through list for services beginning with OracleService<SID> ==How to see ..."

==From Unix==
ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq

==From Windows==
services.msc
Look through list for services beginning with OracleService<SID>

==How to see what databases have been defined (running or not)==
cat /var/opt/oracle/oratab (Solaris)

cat /etc/oratab (others)

Grid Control

2011-11-22T22:25:29Z

Shb: /* Agent Unreachable */

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g (how to see [[which databases are running on the machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

===To list targets known to an agent:===
emctl config agent listtargets
It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing this file and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml

Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

How to find what SIDs are available on your machine

2011-11-22T22:23:06Z

Shb:

Grid Control

2011-11-22T22:21:19Z

Shb: Undo revision 29 by Shb (talk)

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g ([[how to find what SIDs are available on your machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

===To list targets known to an agent:===
emctl config agent listtargets
It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing this file and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml

Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

Grid Control

2011-11-22T22:17:40Z

Shb: /* Agent Unreachable */

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g (how to see [[what databases are running on the machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

===To list targets known to an agent:===
emctl config agent listtargets
It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing this file and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml

Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

How to find what SIDs are available on your machine

2011-11-22T22:15:12Z

Shb:

==From Unix==
ps -ef|grep [o]ra_smon|sed -e 's/.*_//'|sort|uniq

==From Windows==
services.msc
Look through list for services beginning with OracleService<SID>

RMAN

2011-11-22T21:42:44Z

Shb: /* Query to check the status of the database backups */

RMAN

2011-11-22T21:39:25Z

Shb: /* Script to check what has been backed up */

RMAN

2011-11-22T21:38:10Z

Shb: /* A collection of useful bits and pieces I used on a regular basis when I was using RMAN */

==Script to check what has been backed up==
select s.db_name
, s.status
, max(s.start_time) start_time
, max(round(s.mbytes_processed/1024)) "processed_data(GB)"
, max(round((end_time-start_time)*60*24)) "duration(min)"
, trunc(sysdate)-trunc(s.start_time) days_since_last_backup
from rman.rc_rman_status s
where 1=1
and lower(s.operation) = 'backup'
and lower(s.object_type) ='db full'
and s.start_time =
(
select max(md.start_time)
from rman.rc_rman_status md
where 1=1
and lower(md.operation) = 'backup'
and lower(md.object_type) ='db full'
and md.db_name = s.db_name
)
group by s.db_name
, s.object_type
, s.operation
, s.status
, trunc(sysdate)-trunc(s.start_time)
order by trunc(sysdate)-trunc(s.start_time) desc

RMAN

2011-11-22T21:36:25Z

Shb: Created page with "==A collection of useful bits and pieces I used on a regular basis when I was using RMAN== select s.db_name , s.status , max(s.start_time) start_time , max(round(..."

==A collection of useful bits and pieces I used on a regular basis when I was using RMAN==

select s.db_name
, s.status
, max(s.start_time) start_time
, max(round(s.mbytes_processed/1024)) "processed_data(GB)"
, max(round((end_time-start_time)*60*24)) "duration(min)"
, trunc(sysdate)-trunc(s.start_time) days_since_last_backup
from rman.rc_rman_status s
where 1=1
and lower(s.operation) = 'backup'
and lower(s.object_type) ='db full'
and s.start_time =
(
select max(md.start_time)
from rman.rc_rman_status md
where 1=1
and lower(md.operation) = 'backup'
and lower(md.object_type) ='db full'
and md.db_name = s.db_name
)
group by s.db_name
, s.object_type
, s.operation
, s.status
, trunc(sysdate)-trunc(s.start_time)
order by trunc(sysdate)-trunc(s.start_time) desc

Main Page

2011-11-22T21:35:12Z

Shb: /* A collection of useful DBA tips and tricks */

=A collection of useful DBA tips and tricks=
This is a collection of handy tips I've used to do various DBA tasks.
Some may be specific to the environment I used at the time, others may be more generic.
It's mainly a place to put things so that I don't forget where I put all the scraps of virtual paper.

*[[Grid Control]]
*[[Disaster Recovery testing]]
*[[RMAN]]

== Getting started ==
* [http://meta.wikimedia.org/wiki/Help:Contents User's Guide]
* [http://www.mediawiki.org/wiki/Manual:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Grid Control

2011-11-22T21:07:42Z

Shb: /* To list targets known to an agent: */

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g ([[how to find what SIDs are available on your machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

===To list targets known to an agent:===
emctl config agent listtargets
It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing this file and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml

Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

Grid Control

2011-11-22T21:06:24Z

Shb: /* Agent Unreachable */

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g ([[how to find what SIDs are available on your machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

===To list targets known to an agent:===
emctl config agent listtargets
It looks at the file $AGENT_HOME/sysman/emd/targets.xml

Manually add targets by editing the file $AGENT_HOME/sysman/emd/targets.xml
and running:
emctl config agent addtargets $AGENT_HOME/sysman/emd/targets.xml
Check state and upload directories under $AGENT_HOME/sysman/emd for .err files

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

Grid Control

2011-11-22T21:04:18Z

Shb: /* Agent Unreachable */

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g ([[how to find what SIDs are available on your machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

'''Check the agent log in $ORACLE_HOME/sysman/log'''

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

Grid Control

2011-11-22T21:03:41Z

Shb: /* Agent Unreachable */

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g ([[how to find what SIDs are available on your machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

Check the agent log in $ORACLE_HOME/sysman/log

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

Grid Control

2011-11-22T20:35:34Z

Shb: /* Agent Unreachable */

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

==Agent Unreachable==
* Is the agent running?
From SQL*Plus:
select username,program from v$session where LOWER (program) like 'emagent%';
If no rows selected, the agent is not running.
or
From Unix:
. oraenv
agent11g ([[how to find what SIDs are available on your machine]])
emctl status agent

ps -ef|grep [a]gent
There should be a handful. If only a few, kill them and restart the agent.
emctl start agent

==Some useful Metalink Master Documents related to Grid Control==
*Master Index for Managing Oracle Database and Listener with Grid Control [ID 1304021.1]
*Master Note for 10g Grid Control Agent Process Control (Start, Stop & Status) & Configuration [ID 1082009.1]
*How to Run the RDA against a Grid Control Installation [ID 1057051.1]
*How to Run the RDA against a Grid Control Installation Release 11g [ID 1190193.1]
*Grid Control Target Maintenance: Steps to Diagnose Issues Related to "Agent Unreachable" Status [ID 271126.1]
*Master Note for 10g Grid Control Enterprise Manager Communication and Upload issues [ID 1086343.1]
*Master Note for Target Maintenance Through 10g Enterprise Manager Grid Control [ID 1202453.1]
*Receiving agent unreachable notification emails very often after 10.2.0.4 agent upgrade [ID 752296.1]
*Healthcheck Metric failing for a 10.2.0.4 Target Database with 10.2.0.4 Agent [ID 602633.1]

Main Page

2011-11-22T19:59:26Z

Shb: /* A collection of useful DBA tips and tricks */

=A collection of useful DBA tips and tricks=
This is a collection of handy tips I've used to do various DBA tasks.
Some may be specific to the environment I used at the time, others may be more generic.
It's mainly a place to put things so that I don't forget where I put all the scraps of virtual paper.

*[[Grid Control]]
*[[Disaster Recovery testing]]

== Getting started ==
* [http://meta.wikimedia.org/wiki/Help:Contents User's Guide]
* [http://www.mediawiki.org/wiki/Manual:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Use Physical Standby for testing

2011-11-22T19:37:14Z

Shb: Created page with "This assumes the Primary has failed and the Standby must be brought up to replace it. shutdown abort; startup mount; select name from v$restore_point; flashback database to ..."

This assumes the Primary has failed and the Standby must be brought up to replace it.

shutdown abort;
startup mount;
select name from v$restore_point;
flashback database to restore point DRTEST;
alter database convert to physical standby;
shutdown abort;
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect;

Disaster Recovery testing

2011-11-22T19:32:54Z

Shb: /* Using Flashback */

==Using Flashback==
*[[How to prepare a database to use Flashback Recovery]]
*[[Enable Flashback]]
*[[Use Physical Standby for testing]]
*[[Disable Flashback]]

Disaster Recovery testing

2011-11-22T19:32:31Z

Shb:

==Using Flashback==
[[How to prepare a database to use Flashback Recovery]]
[[Enable Flashback]]
[[Use Physical Standby for testing]]
[[Disable Flashback]]

Disaster Recovery testing

2011-11-22T19:31:45Z

Shb: Created page with "How to prepare a database to use Flashback Recovery Enable Flashback Use Physical Standby for testing Disable Flashback"

[[How to prepare a database to use Flashback Recovery]]
[[Enable Flashback]]
[[Use Physical Standby for testing]]
[[Disable Flashback]]

Main Page

2011-11-22T19:27:16Z

Shb: /* A collection of useful DBA tips and tricks */

=A collection of useful DBA tips and tricks=
This is a collection of handy tips I've used to do various DBA tasks.
Some may be specific to the environment I used at the time, others may be more generic.
It's mainly a place to put things so that I don't forget where I put all the scraps of virtual paper.

[[Grid Control]]
[[Disaster Recovery testing]]

== Getting started ==
* [http://meta.wikimedia.org/wiki/Help:Contents User's Guide]
* [http://www.mediawiki.org/wiki/Manual:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

How to find what SIDs are available on your machine

2011-11-22T19:25:40Z

Shb: /* From Unix */

==From Unix==
cat /var/opt/oracle/oratab (Solaris)

cat /etc/oratab (others)

==From Windows==
services.msc
Look through list for services beginning with OracleService<SID>

How to find what SIDs are available on your machine

2011-11-22T19:24:27Z

Shb: Created page with "==From Unix== cat /var/opt/oracle/oratab (Solaris) cat /etc/oratab (others)"

==From Unix==
cat /var/opt/oracle/oratab (Solaris)

cat /etc/oratab (others)

Grid Control

2011-11-22T19:22:17Z

Shb:

Grid Control

2011-11-22T19:21:30Z

Shb: /* Agent Unreachable */

Grid Control

2011-11-22T19:06:08Z

Shb: /* Definitions */

Grid Control

2011-11-22T18:45:51Z

Shb: /* Grid Control */

Grid Control

2011-11-22T18:45:03Z

Shb: Created page with "=Grid Control= ==Definitions== * OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR * OMR - Management Repos..."

=Grid Control=

==Definitions==
* OMS - Management Service - This is responsible for communicating with the user via a GUI and communicating with the OMR
* OMR - Management Repository - This is a collection of tables owned by the sysman schema that stores all the data collected by the OMA
* OMA - Management Agent - This is a perl program that runs on the database host (one for all databases on the host) and uploads data to the OMS

Main Page

2011-11-22T18:36:57Z

Shb: /* A collection of useful DBA tips and tricks */

=A collection of useful DBA tips and tricks=
This is a collection of handy tips I've used to do various DBA tasks.
Some may be specific to the environment I used at the time, others may be more generic.
It's mainly a place to put things so that I don't forget where I put all the scraps of virtual paper.

[[Grid Control]]

== Getting started ==
* [http://meta.wikimedia.org/wiki/Help:Contents User's Guide]
* [http://www.mediawiki.org/wiki/Manual:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Main Page

2011-11-22T18:31:52Z

Shb: /* A collection of useful DBA tips and tricks */

=A collection of useful DBA tips and tricks=
This is a collection of handy tips I've used to do various DBA tasks.
Some may be specific to the environment I used at the time, others may be more generic.
It's mainly a place to put things so that I don't forget where I put all the scraps of virtual paper.

== Getting started ==
* [http://meta.wikimedia.org/wiki/Help:Contents User's Guide]
* [http://www.mediawiki.org/wiki/Manual:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Main Page

2011-11-22T18:28:52Z

Shb:

=A collection of useful DBA tips and tricks=
This is a collection of handy tips I've used to do various DBA tasks.
Some may be specific to the environment I used at the time, others may be more generic.
It's mainly a place to put things so that I don't forget where I put all the scraps of virtual paper.

Consult the [http://meta.wikimedia.org/wiki/Help:Contents User's Guide] for information on using the wiki software.

== Getting started ==
* [http://www.mediawiki.org/wiki/Manual:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Manual:FAQ MediaWiki FAQ]
* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]