Monday, July 27, 2020

Security Benefits of Oracle Autonomous Database

List of  security benefits of Oracle’s Autonomous Database 

1. There is no DBA access, no root access, no Operating System access… Still you can create users, roles, etc. just as before. But certain the commands are blacklisted.


2. There are no customer-managed keys: Oracle manages the keys.


3. Oracle automatically applies all security updates/patches to ensure data is not vulnerable to known attack vectors.


4. All data is encrypted using transparent data encryption.


5. Still database security features such as Virtual Private Database and Data Redaction are available.


6. Network connections from clients to the Autonomous Database are also encrypted using the client credentials wallet.


7. Data is encrypted everywhere: SQL*Net traffic, data in tablespaces and data in backups.


8. It is now possible to specify an access control list that blocks all IP addresses that are not in the list from accessing the database.


9. Oracle has been engaging with external assessment entities and independent auditors to meet a broad set of international and industry-specific compliance standards for service deployments in Oracle Cloud such as ISO 27001, SOC1, SOC2, PCI DSS, HIPAA/HITECH, and FedRAMP.


10. All operations are being audited.


Ref -:  Security ADB

Thursday, July 23, 2020

Upgrading Oracle EBS Database from 12c to 19c

Upgrading Oracle EBS Database from 12c to 19c 


Important Documents – EBS 12.2

  • Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1) 
  • Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (Doc ID 2530665.1) 
  • Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Oracle Database 19c (Doc ID 2608030.1)
  • Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Logical Host Names (Doc ID 2617788.1) 
  • Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names (Doc ID 2617787.1) 
  • Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1) 
  • Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1)

Wednesday, July 22, 2020

Fixing performance issues in WLS patching (bsu.sh slowness)

Faced performace Issues while running WLS 10.3.6 (weblogic) patch through bsu.sh. 


 Download patch p27238412_1036_Generic.zip.
 Weblogic Version : 10.3.6
 
Copy patch files bsu_update and bsu_update.sh to $FMW_HOME/utils/bsu

 Unzip patch p27238412_1036_Generic.zip

 Archive: p27238412_1036_Generic.zip creating:
 bsu_update/ inflating: bsu_update.bat inflating: 
bsu_update.sh creating:
 bsu_update/GA/ inflating: 
bsu_update/GA/com.bea.cie.comdev_6.1.3.0.jar 
 inflating: bsu_update/GA/com.bea.cie.patch-client_3.3.0.0.jar
 inflating: bsu_update/GA/com.bea.cie.patch-client_3.3.0.0.xml 
 creating: bsu_update/Patch/ 
 nflating: bsu_update/Patch/com.bea.cie.comdev_6.1.3.1.jar 
 inflating: bsu_update/Patch/com.bea.cie.patch-client_3.3.0.0.jar
 inflating: bsu_update/Patch/com.bea.cie.patch-client_3.3.0.0.xml 
 inflating: README.txt 

 Apply patch :-


 bash-3.2$ . ./bsu_update.sh install Installing…
 Updating bsu modules 
 Update was successful. 

 Retest Patching through bsu