Apr 16

libasmclntsh12.so missing after OPatch failed in Oracle 12c

Those days, I was trying to apply the latest Oracle Grid Infrastructure PSU over my 12.1.0.2 Clusterware. During the apply phase, the OPatch failed because the gcc was not available for execution. Actually, someone gave chmod 700 to /usr/bin/gcc for protection. /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: /usr/bin/gcc: Permission denied /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: exec: /usr/bin/gcc: cannot execute: Permission denied make[2]: …

Continue reading

Mar 10

ORA-00600: internal error code, arguments: [kpdbSwitchPreRestore: txn] in Oracle Database 12c

On several Oracle DB in 12.1.0.2 version I started receiving some strange ORA-00600 and ORA-07445 errors in the alert file. In ORA-00600, the first parameter was "[kpdbSwitchPreRestore: txn]": Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFAC8] [PC:0x7A1FA6E, qksanEndSession()+30] [flags: 0x0, count: 1] Errors in file /u02/diag/rdbms/cdbtim01/cdbtim01/trace/cdbtim01_j004_21773.trc (incident=57639): ORA-07445: exception encountered: core dump [qksanEndSession()+30] [SIGSEGV] [ADDR:0xFAC8] [PC:0x7A1FA6E] …

Continue reading

Mar 08

Cannot delete service template. Service instance(s) are associated to this template.

This week I was trying to delete a "Service Template" in Oracle Enterprise Manager Cloud Control 12c that I used to create a "Schema as a Service" scenario. Before doing that, I deleted all the Service Instances associated and my EM showed none associated, like the picture below. However, even though when I tried to delete it I …

Continue reading

Feb 16

New Oracle Certified Master Profiles space!

After a long time, Oracle has finally moved the portal where publishes the professionals who are Oracle Certified Master and their Profiles. In the past, it used to be in this page: https://education.oracle.com/education/otn/ The new address is: https://community.oracle.com/community/technology_network_community/certification/ocm Oracle says: Posting OCM profiles in the Oracle Certified Masters Profile Community offers a more professional look and feel, streamlines …

Continue reading

Jan 04

Change RMAN configuration using DBMS_BACKUP_RESTORE

In this article I will show how to change the RMAN configuration when you are connect inside an Oracle DB, using the package DBMS_BACKUP_RESTORE and its procedures. Modifying those RMAN attributes is an easy task when you are connected via Oracle RMAN utility. You can simply use the CONFIGURE syntax to change it. However, what a few people know …

Continue reading