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
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
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
In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.4) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus
I hit the following problem with a 9.2.0.8 database running on Windows 2003 this morning (info pulled from the alert log). The database had failed to restart after a client’s cold backup process 🙄 ALTER DATABASE MOUNT Wed Jan 15 22:32:08 2014 ORA-09341: scumnt: unable to mount database OSD-04400: unable to acquire internal semaphore for
In this example, I’ve already installed the Oracle Database 12c software on one of my Linux 6.4 machines. Using the DBCA tool (in advanced mode), I’m going to create a new container database named “cdb” and at the same time create a pluggable database named “pdb”. The idea behind this new “pluggable databases” feature in
In this post, I’m installing the Oracle Database 12c Release 1 (12.1.0.1.0) software on Oracle Linux 6.4. Only the software is being installed at this point, in preparation for a single database installation which I’ll create later on using the DBCA tool. First and foremost, before you start, make sure your Linux server meets the minimum
In this example, I’ve already installed the Oracle Database 11gR2 software (11.2.0.4 in this example) on one of my Linux 6.4 machines, and I’m going to create a new database instance simply called ’emrep’ (as it’s going to be used for my EM12c database repository) using the DBCA tool. The data files will be stored under
In this post, I’m installing the Oracle Database 11g Release 2 (11.2.0.3) software on Oracle Linux 6.4, along with optional instructions on how to apply the latest Patch Set Update (PSU) to your new Oracle home. First and foremost, before you start, make sure your Linux server meets the minimum hardware requirements: 1GB of RAM (plus
In this example, I’m creating a simple Oracle Listener service called ‘LISTENER’ using the default port of 1521. Start the Oracle Net Configuration Assistant (NETCA) Open an X-Windows session to the server as the ‘oracle’ user. Set your ORACLE_HOME environment variable appropriately, then start the assistant by running the following: export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3 $ORACLE_HOME/bin/netca Once the GUI