Configuring Websphere Plugin with NAGIOS Monitoring System
1. Download WAS plugin for Nagios from here.
Recent Articles
Digging deep in Oracle Grid Repository for Information
How Grid Repository Stores Data?
The agents upload data at MGMT_METRIC_RAW table which is retained for 7 days.
Raw data are aggregated by Grid Control based on a predefined policy into 1-hour records, stored in MGMT_METRIC_1HOUR.
After 31 days or a month, 1-hour records in MGMT_METRIC_1HOUR are subject for further aggregation that rolls into 1-day records.
These 1-day records are stored in MGMT_METRIC_1Day for 365 days or 1 year before purged by Grid Control.
SQL Server Error Messages
SQL Server comes with pre-defined error messages that can be raised when a particular condition occurs. Built-in error messages are stored in the sysmessages table of the master database. Depending on the severity level, error messages can be returned to the offending connection or could be recorded in the SQL Server error log. The severity level determines the type and seriousness of the problem that caused the error. The following table summarizes various error severity levels: Read more…
SQL server SQLDIAG Utility
SQLDIAG.exe executable can be found in the SQL Server installation directory under the BINN folder. SQLDIAG records the SQL Server configuration, contents of the error logs (current, as well as archived logs), and Windows configuration including registry keys. If SQL Server is running when SQLDIAG is executed, it will record the output of the following routines: Read more…
SQL Server | How to create a Read Only User/Role
I have number of SQL server databases and users . I am in a need to create read only access to users who wants to look at data. Read more…
TSQL | Delete All Objects from Database
Often I have to copy number of SQL server database structures from prod system for testing. It’s difficult to get rid of all objects within a database manually. Following script will do just about that.
What patches are applied to my SQL Server
Use
- select @@VERSION” OR
- SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) ” Or
- Simply look at the value in the Management Studio Explorer
How to use SP_CONFIGURE in SQL Server
sp_configure is a tool to display and change SQL Server settings. Please be aware that changing these settings can dramatically affect your instance.
SQL Server Maintenance Scripts : YourSqlDba & SQL Server Maintenance Solution
If you are looking for a good TSQL packaged scripts which will do usual database maintenance activities then you are on right page. I have detailed 2 such projects which will help you to setup maintenance job in less than an hour.
How to create a new named instance under SQL 2005/2008
We can only configure one default instance under SQL server installation. If we need additional instance it should be a named instance.
How to locate SQL server clustered database & it’s properties
1. How to locate if I am connected to a SQL server cluster?
SELECT SERVERPROPERTY(‘IsClustered’)
Streams | ORA-24082 while disabling a propagation job
The reason for the ORA-24082 error is that a message has been enqueued onto the AQ$_PROP_NOTIFY_<N> queue to notify the job_queue_process associated with the propagation schedule to stop propagating messages and the
job_queue_process has failed to acknowledge that message within a reasonable amount of time. Read more…
Streams – Capture Process States
The state of a capture process describes what the capture process is doing currently. You can view the state of a capture process by querying the STATE column in the V$STREAMS_CAPTURE dynamic performance view. The following capture process states are possible
Useful Tables and Views, for Troubleshooting Streams Issues
| CAPTURE PROCESS | |
| streams$_capture_process | Lists all defined capture processes |
| dba_capture | Basic status, error info |
| v$streams_capture | Detailed status info |
| dba_capture_parameters | Configuration information |
| PROPAGATE PROCESS | |
| streams$_propagation_process: | Lists all defined propagate processes |
| dba_propagation | Basic status, error info |
| v$propagation_sender | Detailed status info |
| v$propagation_receiver | Detailed status info |
| APPLY PROCESS | |
| streams$_apply_process | Lists all defined apply processes |
| dba_apply | Basic status, error info |
| v$streams_apply_reader | Status of the apply reader |
| v$streams_apply_server | Status of apply server(s) |
| v$streams_apply_coordinator | Overall status, latency info |
| dba_apply_parameters | Configuration information |
| Miscellaneous Tables | |
| v$buffered_queues | View that displays the current and cumulative number of messages enqueued and spilled, for each buffered queue. |
| sys.streams$_apply_spill_msgs_part | Table that the apply process uses, to “spill” messages from large transactions to disk. |
| system.logmnr_restart_ckpt$ | Table that holds capture process “checkpoint” information. |
Identify Issues and Fix Streams Capture Process
My Capture, Propagate and apply processes were working fine until the server fial over. After a restart even though capture processes are enabled, they are stalled at status “INITIALIZING”. The Propagate and Apply were working fine.
Cloning Oracle Clusterware (Applicable only to 11.2.0.2.0 and not for any previous Releases)
Cloning is the process of copying an existing Oracle installation to a different location and then updating the copied installation to work in the new environment.
Streams/RAC and Database Link Problem
While working with streams 10g RAC, setup went well but source database propagation process won’t work with target database “strmrepl1″ and returned TNS “12514″ error.
Streams Performance Data Collection Tools for 10g & 11g
There are diferent ways to collect performance related data
- Install Application Workload Repository (AWR) /Active Session History (ASH). Take AWR snapshots an hour or for desired interval
- Install and Configure STRMMON utility if you have 10gR2(Not available in 11g). Use Metalink Article “290605.1″
- Use UTL_SPADV as a alternative to STRMMON for > 11gR1
- Run Streams Healthcheckat each database: before, during , and after performance period of interest, available from Metalink:Article273674.1
11gR2 RAC-Dataguard Sync issue Between Primary & Standby
I have a 2 node RAC -DG setup between 2 remote data centres. After building DataGuard between them I am now coming across stange latency stats. Read more…
Setting up Bidirectional Streams SCHEMA Replication
Details below are for configuring a schema level replication using API DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS.
Building Tablespace Growth Report from Grid Data
Use SQL Query below at Grid sysman database to locate growth of tablespaces over time. The returned results data could be used under EXCEL to generate graphs. Read more…
Oracle Roles and Users audit report
I have often used following procedure to create list of roles & corresponding users mapped into it. This was then used to email business owners as well as for user accesss auditing. Read more…
Streams Replication| Monitoring Streams Capture Processes
Capture process is an optional Streams client that is an Oracle background process that scans a database redo log to capture DML and DDL changes made to database objects. Read more…
Streams Replication | Monitoring Streams Queues and Propagations
This post lists sample queries to monitor Streams queues and propagations.
1) Monitoring ANYDATA Queues and Messaging
2) Monitoring Buffered Queues
3) Monitoring Streams Propagations and Propagation Jobs
Streams Replication| Monitoring Oracle Streams Apply Processes at Destination Server
Following shell script will be handy when you are working with Streams Replication. There are 2 versions, one for 10g:monitor_streams_applyprocess_10g and another for 11g: monitor_streams_applyprocess_11g Read more…
Monitoring Streams Replication| How to Display Detailed Information About Apply Errors?
SQL scripts below can display detailed information about error transactions in the error queue in a database.
These scripts are designed to display information about LCRs, but you can extend them to display information about any non-LCR messages used.
Linux – List file count by Day
ls -lt | grep "^-" | awk '{ if($8 ~ /:/) $8=2011 Date_count=$6" "$7", "$8 freq[Date_count]++} END {for (date in freq) printf "%s\t%d\n", date, freq[date] }' | sort |
Tweet