Oracle Database Administration, Oracle Developer Suite, Oracle JDeveloper, Oracle BI Publisher, Oracle Forms/Reports,Oracle SQL Developer

Data Center Consolidation

Data center consolidation is the process of reducing the volume of physical IT assets through highly efficient and scalable technologies. Organizations leverage data center consolidation to reduce operating costs.

[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...

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...

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...

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 ...

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...

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...

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')...

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, ...