Asif's Oracle Repository

issue:txkGenADOPWrapper.pl    INSTE8_APPLY       1 WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is:       <filename>  <phase>  <return code where appropriate>   [APPLY PHASE]   AutoConfig could not successfully execute the following scripts:     Directory: /u01/applprod/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/applprod/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/applprod/fs2/inst/apps/PRODDB_epc-apps12-node41v/admin/install       txkGenADOPWrapper.pl    ...

Error: [EVENT]     Creating database patch edition.     [PROCEDURE] [START 2018/12/03 11:05:43] Creating patch edition if it does not exist     Existing patch edition found, so no need to create.     [PROCEDURE] [END   2018/12/03 11:05:43] Creating patch edition if it does not exist [PROCEDURE] [START 2018/12/03 11:05:43] Performing steps for CLONE from run file system to patch file system [PROCEDURE] [START 2018/12/03 11:05:43] Preparing seed data tables [STATEMENT] Sourcing Patch edition environment /u01/applprod/fs1/EBSapps/appl/APPSPREPROD2_preprodapp.env [ERROR]     Cannot connect to database [ERROR]     Error Message: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach) [ERROR]     Error calling ad_zd_log. Refer to log file for details. [ERROR]     Error callin...

Background:  When we run, the following SQL Query/Script will provide the profile option values set at different levels. That is Site, Application, Responsibility, User.  So, this script lists ALL Users/Responsibilities/Applications set against a particular Profile option SQL Script:   Enter 'Profile Option Name' as need to check  Eg. FND: Debug Log Enabled [You can get the exact name from table fnd_profile_options_tl]    SELECT fpo.profile_option_name SHORT_NAME,          fpot.user_profile_option_name NAME,          DECODE (fpov.level_id,                  10001, 'Site',                  10002, 'Application',                  10...

SELECT s.inst_id, NVL (s.username, 'Internal') "Database User", m.SID, s.serial#, p.spid "DB OS Process", m.TYPE, DECODE (m.lmode, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4, 'Share', 5, 'S/Row Excl.', 6, 'Exclusive', lmode, LTRIM (TO_CHAR (lmode, '990')) ) "Lock Type", DECODE (m.request, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4, 'Share', 5, 'S/Row Excl.', 6, 'Exclusive', request, LTRIM (TO_CHAR (m.request, '990')) ) "Lock Request", DECODE (command, 0, 'None', DECODE (m.id2, 0, dusr.username || '.' || SUBSTR (dobj.NAME, 1, 30), 'Rollback Segment' ) ) "Object", s.machine "Application Server", s.process "Apps OS process", m.ctime, NVL (NVL (usr.description, s.action), 'Database Session' ) "Online User,Concurrent", N...

  The Internal Workflow of an E-Business Suite Concurrent Manager Process                       Concurrent processing is one of the key elements of any E-Business Suite system. It provides scheduling and queuing functionality for background jobs, and it’s used by most of the application modules. As many things depend on concurrent processing, it’s important to make sure that the configuration is tuned for your requirements and hardware specification. This is the first article in a series about the performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance, and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading! There are few things...

Perform the following to clone an Oracle home: Verify that the installation of Oracle Database to clone is successful. You can do this by reviewing the installActions date_time .log file for the installation session, which is typically located in the / orainventory_location /logs directory. If you install patches, then check their status using the following: $ cd $ORACLE_HOME/OPatch Include $ORACLE_HOME/OPatch in $PATH $ opatch lsinventory Stop all processes related to the Oracle home. See "Stopping Existing Oracle Processes" for more information about stopping the processes for an Oracle home. Create a ZIP file with the Oracle home (but not the Oracle base) directory. For example, if the source Oracle installation is in the /u01/app/oracle/product/11.2.0/dbhome_1 , then you zip the dbhome_1 directory by using the following command: # zip -r dbhome_1.zip /u01/app/oracle/product/11.2.0/dbhome_1 Do not include the admin , fast_recovery_area , and oradata dir...

      Oracle Database 18c is Oracle 12c Release 2 (12.2.0.2) In the old terms, Oracle Database 18c is a patchset for Oracle 12.2.(18c = 12.2.0.2)   Release Version Numbering Changes Beginning in 2018, a new numbering schema for the database software is implemented. Instead of a legacy nomenclature such as 12.2.0.2, a three (3) field format consisting of: Year. Update. Revision is used, such as 18.1.0. This allows clear indication of: •the feature release designation of the database software (the first field) •the quarterly Update (the second field) •the quarterly Revision (the third field)   18c released as : •1-Mar-2018 - 18c released in OCI and OCI-C Database services (note: we earlier indicated in error these were released 16-Feb) •16-Feb-2018 - 18c is released for Exadata and LiveSQL.oracle.com   Release 12.2: New releases will be annual and the version will be the last two digits of the release year. The release originally planned as...