No great genius has ever existed without some touch of madness.

Saturday 21 November 2015


0509-036 Cannot load program 0712-001 0712-002 AIX Oracle DB 12.1.0.2




Cause:


IOCP module not enabled on the server.


To check if the IOCP module is enabled, run the lsdev command.

The following sample output shows the IOCP status is set to Defined and hence not enabled:



Solution:

Enable the "iocp" option and  relink the oracle binaries.

To enable IOCP, set IOCP to Available using the following procedure:

Log in as root and run the following command:

# smitty iocp
Select Change / Show Characteristics of I/O Completion Ports.

Change configured state at system restart from Defined to Available.

Run the lsdev command to confirm the IOCP status is set to Available:



Perform a system restart to make the changes permanent.

Relink the binaries using " relink all " and then root.sh as root user.

Oracle Rules Manager

Rules Manager is a feature of Oracle Database that uses the Expression Filter and object relational features to provide the features of a special-purpose rules engine with greater scalability and better operational characteristics.

Rules Manager and Expression Filter provide a SQL schema and PL/SQL and Java packages that store, retrieve, update, and query collections of expressions (rule conditions) in an Oracle Database. All these objects are created in a dedicated schema named EXFSYS.

Rules Manager and Expression Filter are installed automatically with Oracle Database Standard Edition and Oracle Database Enterprise Edition and higher.

Oracle Expression Filter, a feature beginning in Oracle Database 10g, is a component of Rules Manager that allows application developers to store, index, and evaluate conditional expressions (expressions) in one or more columns of a relational table. Expressions are a useful way to describe interests in expected data.

 



·        The script to install Rules Manager is named  :
catrul.sql under $ORACLE_HOME/rdbms/admin/directory.

·        Rules Manager can be uninstalled using :
catnorul.sql script in the same directory

·        The script to install the Expression Filter is named :
catexf.sql under $ORACLE_HOME/rdbms/admin/directory.

·        Expression Filter can be uninstalled using :
catnoexf.sql script in the same directory

·        Rules Manager  RUL and Expression Filter  EXF components :

SQL>select comp_id from dba_registry where comp_id in('EXF','RUL');
SQL> select comp_id, comp_name, version, status from dba_registry ;

NOTE: These scripts should be executed from a SQL*Plus session while connected as SYSDBA. Uninstalling Expression Filter implicitly uninstalls Rules Manager.


The Rules Manager and Expression Filter features are the same in the Standard and Enterprise Editions. Support for indexing expressions is available only in the Enterprise Edition because it requires bitmap index support.




OPatch failed with error code 73



If $ opatch apply fails due to below error:





Then check for /oradba/app/oracle/product/12102/cfgtoollogs/opatch/opatch2015-09-18_00-23-57AM_1.log and if you find below under logs:




       Find the process, kill it and run “opatch apply” again.




.




ERROR: Suspended on broken target (OEM 12c)



If you encounter such error for scheduled backup job of database into OEM:






SOLUTION:

If you get this error while running jobs via cloud control on a particular database – “suspended on broken target”

We just need to configure the target again – in case of this error.

No need to remove the target beforehand, simply click on targets/databases, choose the database and click configure – uses already saved XXXXXX password , simply click Next and proceed.

Run job again – it should go through.
ORA-20500 ORA-06512 ORA-06512 (Error while adding target into OEM)


ERROR:

testab1 (oracle_database)
ORA-20500: Target Already exists: testab1:oracle_database:oracle.linux.net:https://oracle.linux.net:3872/emd/main/:3:0
ORA-06512: at "SYSMAN.EM_TARGET", line 3998
ORA-06512: at line 1

SOLUTION:

Log in to the EM console.
Select Setup > Add targets > Auto Discovery Results.
Select the database (from the Ignored Targets tab)








Now, try to add database and at the last step while saving, you won’t be getting an error.






Reference: 

Enterprise Manager Cloud Control 12c - Manually adding a database target fails with ORA-20500 (Doc ID 1523394.1)