In this post, I’m going to insert a bunch of dummy records into a test collection, remove some (accidentally!) and then recover them from the online oplog. First of all, let’s setup a basic directory structure, then start a stand-alone MongoDB instance for the test (Windows environment): C:\Users\Administrator>mkdir d:\TestRepSet\db d:\TestRepSet\log d:\TestRepSet\backup C:\Users\Administrator>start mongod –port 27020 –dbpath…
This was a strange one. Attempts at recompiling the following package body resulted in this PLS-00801 error. COL owner FOR A20 COL object_name FOR A40 BREAK ON object_name SELECT owner, object_name, object_type, status, created, last_ddl_time FROM dba_objects WHERE object_name = ‘PKG_FINANCIALS_WORK’ ORDER BY status, object_type / OWNER OBJECT_NAME …
Before I start, what’s this all about you might be thinking? Well, Tim Hall recently floated the idea of an unofficial “OTN Appreciation Day” so everyone could create a short post about their favourite Oracle features. So I figured I’d join in…and he thought it would help me “get back on the horse” with my…
The Oracle Reports Services handle incoming client requests to run reports using a job queue mechanism, which are then submitted to the report engines. This Report Server job queue information is stored on disk, in binary format, in the Report Server instance’s persistence file .i.e. $ORACLE_INSTANCE/reports/server/<reports server name>.dat Now querying this information can easily be…
I’ve been pulling my hair out over this one, so hopefully this post will prove useful to someone else experiencing similar problems with Data Guard traffic. One of our Cloud hosted environments (IaaS) has an Oracle 11.2.0.4 Data Guard (physical standby) setup on Windows. Recently, the standby database started logging the following errors in it’s alert log: Fri…
I stumbled across this problem the other day whilst trying to setup a new Log Shipping configuration in SQL Server. The big difference in this environment, was that this implementation had DNS records in place to route the DR (Disaster Recovery) traffic via it’s own dedicated link. So for example, when specifying the database backup location,…
It’s been a while since I’ve posted anything on my blog, and this is a slightly different post to the rest, as it’s not technical in any way… Instead it’s a quick post about a series of fantastic writing tips and techniques posted recently, from my good friend Tim Hall at ORACLE-BASE. I’ve tweeted a few of these…
This week one of our developers highlighted the fact that the DBMS_SCHEDULER on one of our 11.2.0.3 databases was running jobs an hour later than scheduled until just recently, when the clocks went back (26/10/2014) for British Summer Time (BST) …and now they’re running on-time again! I’d not seen this before, and at first I thought we…
The majority of Enterprise Manager 12c Cloud Control agent installations are pretty straight forward, just do the usual checks, ensuring firewalls are open etc. and then deploy from the EM console. The Windows installations are not as straight forward these days, as the deployment method uses SSH connectivity which requires the installation and configuration of Cygwin as a…
I hit the following issue this morning when I tried viewing the properties of a SQL Server database using SSMS: Microsoft SQL Server Management Studio Cannot show requested dialog. ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) Property Owner is not available for Database ‘[databasename]’. This property may not exist for this object, or may not…