Oct 05, 2018
Application does not have any Components in it
323

Application does not have any Components in it

Error:  Weblogic Custom Application was in Prepared state and when tried to re-deploy, it throws above error in <domain>.log or AdminServer.log Fix: It’s a known issue in Weblogic 12.2.x and it’s because the Application name and Data Source name are same.  Re-create the Data Source with the different name, but...
Aug 13, 2018
Launch EC2 Instance using Ansible
451

Launch EC2 Instance using Ansible

In my previous POST , I did publish on installing Ansible in your local ec2 machine.   Now we can spin up an EC2 Machine using Ansible script.   1. Export AWS CLI Authentication Keys Get your access keys by logging into your AWS Console and export them: Login to Console >...
Aug 09, 2018
Install Ansible on AWS Red Hat Enterprise Linux
616

Install Ansible on AWS Red Hat Enterprise Linux

1.  Ansible will not be installed as part of RedHat repositories. An extra package needs to be downloaded and installed, go to http://fedoraproject.org/wiki/EPEL and download the version (epel-release) specific to you and install using “rpm -ivh filename” or else directly through yum, in my case I am using Redhat 7.5...
Apr 03, 2018
ORA-12012 ORA-20001 ORA-06512: at “SYS.DBMS_STATS”
1.4K

ORA-12012 ORA-20001 ORA-06512: at “SYS.DBMS_STATS”

Error in alert log crashing database: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_88″ ORA-20001: Statistics Advisor: Invalid Task Name For the current user <== Note it ORA-06512: at “SYS.DBMS_STATS”, line 46861 ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 734 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 19930 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 21934 ORA-06512: at “SYS.DBMS_STATS”,...
Jan 30, 2018
PKIX path building failed, unable to find valid certification path
1.2K

PKIX path building failed, unable to find valid certification path

Oracle Data Integrator 12c Issue: javax.xml.ws.WebServiceException: javax.xml.soap.SOAPException: javax.xml.soap.SOAPException: Message send failed: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target ===== reqeust ======== Cause:  SSL for the ODI Standalone Agent is incorrectly configured. Solution:  Follow below Note ID to resolve the issue. How To Enable...
Dec 19, 2017
ORA-16057: server not in Data Guard configuration
1.8K

ORA-16057: server not in Data Guard configuration

Error:  ORA-16057: server not in Data Guard configuration Solution:  Make sure your log_archive_config and log_archive_dest_2 parameters are set on both Primary and Standby Databases. In my case: alter system set log_archive_config=’dg_config=(PROD,PROD_stby)’; alter system set log_archive_dest_2=’service=PROD_stby lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=PROD_stby’;
Dec 13, 2017
ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
1.5K

ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

Issue:  Unable to change DB_UNIQUE_NAME after failover from PRIMARY TO STANDBY SQL> alter system set db_unique_name=MWMPPROD scope=spfile; alter system set db_unique_name=MWMPPROD scope=spfile * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-65500: could not modify DB_UNIQUE_NAME, resource exists Solution: We need to switch back to PRIMARY instead of making a...
Dec 13, 2017
OPW-00019: Failed to update the CRS resource with DB password file location
1.8K

OPW-00019: Failed to update the CRS resource with DB password file location

Error:  I was facing below error while creating password file on standby side as part of Oracle Data Guard (standby) Configuration [oracle@app admin]$ orapwd file=’+DATA1/orapwdb/orapwPROD’ password=PwdFile force=y dbuniquename=PROD_stby OPW-00019: Failed to update the CRS resource with DB password file location Solution: There seems to be a bug in 12.1.0.2.  As...
Dec 13, 2017
ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
1.6K

ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Error:   While registering Primary and Standby with Data Guard Broker: DGMGRL> CREATE CONFIGURATION ‘my_dg_conf’ AS PRIMARY DATABASE IS ‘SOAPROD’ CONNECT IDENTIFIER IS ‘SOAPROD’; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Failed. Solution:  Update LOG_ARCHIVE_DEST_2 with no value and try creating data guard configuration. SQL> show parameter LOG_ARCHIVE_DEST_2 NAME                                 TYPE       ...
Oct 21, 2017
ORA-39142: incompatible version number 5.1 in dump file
3.3K

ORA-39142: incompatible version number 5.1 in dump file

Error:  ORA-39142: incompatible version number 5.1 in dump file. I did get this error while I was importing a schema. I did export a schema from Oracle Database 12.2.x and trying to import it to Oracle Database 12.2.x (version mismatch) Solution: User “Version” option while exporting from 12.2.x as below expdp...
WP to LinkedIn Auto Publish Powered By : XYZScripts.com