[UNEXPECTED]Master node for the current patching cycle is node_name.

Error:Checking for existing adop sessions.    Continuing with existing session [Session ID: 13].    [UNEXPECTED]Master node for the current patching cycle is Node_name.    [UNEXPECTED]Options such as "allnodes=yes" or "allnodes=no action=db" must be run from the master node.    [UNEXPECTED]Unrecoverable error...

Read More

adop phase=prepare ORA-20008: No Concurrent Manager is running that can run concurrent program

ErrorError while running command: adop phase=prepareSQL> SQL> Connected.SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(10847151) from dual       *ERROR at line 1:ORA-20008: No Concurrent Manager is running that can run concurrent programADZDPATCHORA-06512: at "APPS.AD_ZD_ADOP", line 282Disconnected from Oracle Database 11g...

Read More

ADOP Prepare Phase Fails With "Error calling runFSSanityValidateConfig"

Error[UNEXPECTED]Error occurred running "perl /u01/app/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl -contextfile=/u01/app/fs1/inst/apps/QA_erpqa/appl/admin/QA_erpqa.xml -patchcontextfile=/u01/app/fs2/inst/apps/QA_erpqa/appl/admin/QA_erpqa.xml -promptmsg=hide -mode=update -console=off -sessionid=7 -timestamp=20180211_103444...

Read More

Error 1 occurred while Executing txkADOPValidation script on host

ErrorLines #(78-83):    [PROCEDURE] Calling: /u01/app/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl    [EVENT]     Log: /u01/app/fs_ne/EBSapps/log/adop/7/20180211_102321/prepare/validate/erpqa    [UNEXPECTED]Error occurred running "perl /u01/app/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl ...

Read More

Temporary Tablespaces Group

Large transactions can sometimes run out of temporary space. Large sort jobs, especially those involving tables with many partitions, lead to heavy use of the temporary tablespaces, thus potentially leading to a performance issue. Oracle Database 10g introduced the concept...

Read More

Configuring Active Directory as the Authentication Provider (OBIEE 11.1.1.9)

Configuring Active Directory as the Authentication Provider (OBIEE 11.1.1.9)Purpose:Connecting the OBIEE WebLogic LDAP server to Microsoft Active Directory, so users can log-into the dashboard using their Windows Active Directory username and password, and retrieve group membership.Whilst...

Read More

Check Profile Options Level: Site/Responsibility/User

selectb.user_profile_option_name "Long Name", a.profile_option_name "Short Name", decode(to_char(c.level_id),'10001','Site','10002','Application','10003','Responsibility','10004','User','Unknown') "Level", decode(to_char(c.level_id),'10001','Site','10002',nvl(h.application_short_name,to_char(c.level_value)),'10003',nvl(g.responsibility_name,to_char(c.level_value)),'10004',nvl(e.user_name,to_char(c.level_value)),'Unknown')...

Read More

Identify Long running Concurrent programs

-- Identify Long running Concurrent programs with child details and run time Parametersselect /*+ ORDERED USE_NL(x fcr fcp fcptl)*/       fcr.request_id    "Request ID",       fcr.requested_by "User",       substr(DECODE (FCR.DESCRIPTION,  NULL,       FCPTL.USER_CONCURRENT_PROGRAM_NAME, ...

Read More