Asif's Oracle Repository

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

 Startup sequence of Grid Infrastructure daemons and its resources in 11gR2 RAC. OHASD Phase OHASD Agent Phase CRSD Agent Phase CRSD Agent Phase crsd.bin starts two more agents (crsd orarootagent(Oracle root agent) and crsd oraagent(Oracle Agent)) 1. When a node of an Oracle Clusterware cluster start/restarts, OHASD is started by platform-specific means. OHASD is the root for bringing up Oracle Clusterware. OHASD has access to the OLR (Oracle Local Registry) stored on the local file system. OLR provides needed data to complete OHASD initialization. 2. OHASD brings up GPNPD and CSSD. CSSD has access to the GPNP Profile stored on the local file system. This profile contains the following vital bootstrap data; a. ASM Diskgroup Discovery String b. ASM SPFILE location (Diskgroup name) c. Name of the ASM Diskgroup containing the Voting Files 3. The Voting Files locations on ASM Disks are accessed by CSSD with well-known pointers in the ASM Disk headers and CSSD...

   While running adcfgclone.pl as oracle user, the session just hangs without giving any error in the log file. The issue was that it wasn’t able to connect to the database as : sqlplus "/as sysdbaa This can be  occur due to improper shutdown of the database. While in the course of a database shutdown, if any of the oracle process is not completed killed and it holds a large shared memory segment, such issues can occur which would prevent from normal database operation. So next time when an instance tries to start it is not able to grab a large chunk of memory to get started. This can be checked as follows: After the database has been shut down , there shouldn’t be any processes running as oracle on the server level: ipcs -m | grep <oracle user> eg: ipcs -m | grep oracle key              shmid          owner   perms ...

How To Audit An Oracle Applications' User? in R12 How To Audit An Oracle Applications' User?   Note: The concurrent program " Purge Signon Audit Data " should be used regularly to purge old sign on data. Sign-On:Audit Level allows you to select a level at which to audit users who sign on to Oracle Applications.  Four audit levels increase in functionality: None, User, Responsibility, and Form.  None is the default value, and means do not audit any users who sign on to Oracle Applications. Auditing at the User level tracks: Who signs on to the system The times users log on and off Auditing at the Responsibility level performs the User level audit functions and tracks: - The responsibilities users choose - How much time users spend using each responsibility Auditing at the Form level performs the Responsibility level audit functions and tracks: The forms users choose How long users spend using each form System Administrator visible, r...

Oracle E-Business Suite environment with IE8 and higher, When  cloning the EBS envitorment or you are logging out from your DEV Instance and want to login to  PROD-Instance it happens “Unable to authenticate session” Go to all programs, Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging (shown below) 1)  Start -> Program Files 2)  Right click on the Internet Explorer icon and select Properties 3)  Add -nomerge to the end of the link in the Target field i.e. “C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging 4)  Click the OK button to close the window 5) Stop all Browser sessions. 6) Start a new Browser session and logon to the Instance

  Doc ID …   Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1) Welcome to the world of EBS Analyzers. The scripts are meant to be part of your Production maintenance program by your Sysadmin, or are to be used by designated end users. The result set is an easy to read html output that provides recommendations, solutions and early warnings about items that should be reviewed and corrected. Each analyzer can be run on demand or scheduled for repeatability and emailed to critical reviewers. Check out the EBS Analyzer Bundle Menu Tool (Note 1939637.1) to manage your Analyzers. The Analyzer Bundle Menu Tool is a perl menu system to easily run analyzers, install as concurrent programs, assign to request groups, and check for new and updated analyzers. Take advantage of these tools from Oracle Premium Support. E-Business Suite Core Analyzers Applications Login Analyzer — Take Action The E...