PLS-00801: internal error [hshuid:LU invalid] when compiling a package body

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    

Read More...

OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring

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

Read More...

Configuring Oracle Reports Server Job Queue Monitoring

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

Read More...

Data Guard “CORRUPTION DETECTED: In redo blocks starting at block…” issues

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

Read More...

Navigating to a server alias locally (from itself) in Windows

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,

Read More...

Writing tips and techniques

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

Read More...

DBMS_SCHEDULER jobs running an hour late – DST/BST issues!

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

Read More...

EM12c agent installation for Windows hosts…without Cygwin!

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

Read More...

Cannot show requested dialog. (SqlMgmt) Property Owner is not available…

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

Read More...

Which SQL Server instance is consuming all my CPU/memory?

For anyone running Windows 2008 (or above), you can simply add the “Command Line” column to the Task Manager view. From there, the instance name will follow the “-s” startup option, for example: C:\…\Binn\sqlservr.exe” –sPREPROD If you’re on Windows 2000/2003 then it’s not quite as straight forward. You can either get the Process ID from

Read More...