This ‘Incrementally Updated Backups’ feature was introduced in Oracle 10g. It allows you to create image copies of your datafiles, and then roll forward the image copies with incremental backups of the database. Changes made between the SCN of your image copy and the SCN of when your incremental backup was taken, are then applied
I’ve hit this problem a couple of times lately where a developer is trying to recompile a PL/SQL package and their session hangs until they eventually get this error: SQL> @new_pkg CREATE OR REPLACE PACKAGE BODY test_package * ERROR at line 1: ORA-04021: timeout occurred while waiting to lock object Basically, whilst someone or something else (a
Recently, I found myself in a situation whereby multiple database instances were running on a HP-UX clustered environment to ensure high availability, each with their own Serviceguard package, on an agent per package basis. Now on the plus side, if the SG package is failed over to another node, the agent goes with it, and
Put simply, when you install and configure an Management Agent in a clustered environment to monitor your targets through Enterprise Manager Cloud/Grid Control, then that primary node fails, your Oracle services are moved to a secondary node as part of the clustering…but your OMS isn’t aware of the change in nodes. Now if your agent
It’s been years since I stumbled across this, but today I was trying to launch a GUI from new Linux server and got this instead 🙁 X11 connection rejected because of wrong authentication. Error: cannot open display: localhost:12.0 So, I dug out my notes and thought it would make sense to then blog it for
EMCLI is a Java based Command Line Interface that can be used to communicate with your OMS (Oracle Management Server) as an alternative to the GUI for some operations. Installation is pretty straight forward, and the toolkit can be installed anywhere as long as you have a Java JDK installed (1.6 or higher at the time of
The “Refresh From My Oracle Support” job in EM12c runs daily at 00:00 (midnight) by default. If the OMS host is under load at that time (backups etc.) then this can cause the refresh job to run past the 10 minutes StuckThreadMaxTime limit, which leads to a stuck thread being detected within WebLogic, and EM raising the
After deploying a number of Cloud Control agents recently, a few of the agents started generating critical events with a nasty looking (and unhelpful) error message: Host=[host] Target type=Agent Target name=[host]:[port] Categories=Diagnostics Message=Internal error detected: java.lang.IllegalStateException:oracle.sysman.gcagent.target.interaction.execution.ConfigStateMgr:798. Severity=Critical Whilst the error above isn’t too friendly, it stems from errors with the collection of storage metrics. Further
I’ve just applied PSU1 to our Oracle Enterprise Manager Cloud Control 12c Release 2 (12.1.0.2) Production environment in a matter of minutes, so I thought I’d post how straight forward it was 🙂 Download patch 14840279 (PSU) and 6880880 (latest OPatch v11.1.0.0.0) to a convenient location on your OMS server(s), such as /tmp. Set your
This procedure has been disabled from SQL Server 2005 onwards, when the ‘Surface Area Configuration’ tool was introduced as part of security enhancements within SQL Server. SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component ‘xp_cmdshell’ because this component is turned off as part of the security configuration for this server. A system administrator can