Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Author: Syed Saad Ali

December 2, 2022 How to Get Apps Password From Backend
APPS DBAAppsDBA ScriptsInstallations/Configurations-ApplicationsOracle APPS DBAScripts

How to Get Apps Password From Backend

 

STEP 1.  First login to Database through Command Prompt

sqlplus / as sysdba

 

STEP 2 : Create Function From Below Script to decrypt the encrypted password

create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,
in_chr_encrypted_pin IN VARCHAR2)  
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;

 

STEP 3 : Run the Below Query for Retrieving AppsPassword

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873
AB2FFFA3B302AEE6EBD1

 

 

STEP 4:  Run the Below Query to get the Password

SELECT apps.decrypt_pin_func(‘GUEST/ORACLE123′,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1’) from dual;

APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1′)
——————————————————————————–
APPS

 

STEP 5:  Now Login With the Password Retrieved.

SQL> conn apps/APPS;
Connected.

 

November 17, 2022 Oracle E-Business Suite on Autonomous Database on Dedicated Exadata Infrastructure
APPS DBA

 

 Oracle E-Business Suite (EBS) Release 12.2 is now certified for Autonomous Database on Dedicated Exadata Infrastructure. Oracle runs best on Oracle. So, running Oracle applications on the Autonomous Database Dedicated is the obvious choice because it uses groundbreaking machine learning (ML)-backed automation to accelerate innovation, reduce costs, and reduce risks.

Autonomous Database on Dedicated Exadata Infrastructure

Before we dive into why you should run EBS on Autonomous Database Dedicated, let’s provide an overview of the Autonomous Database and its deployment on Dedicated Exadata Infrastructure. The Autonomous Database service takes a 19c converged database and runs it on Exadata, the world’s most optimized platform for running an Oracle database. Then we use artificial intelligence (AI), which allows Oracle to make decisions on how to optimize performance, security, resource efficiency, availability, and other aspects of the database.

These processes happen without the need for human intervention so all those routine tasks traditionally performed by database administrators (DBAs), like creating, running and maintaining backup scripts, installing updates, managing security, and optimizing performance are done by the Autonomous Database. Autonomous Database Dedicated is a specific type of deployment on Autonomous Database where you get an entire Exadata Cloud Infrastructure dedicated to you so only your workloads run on this infrastructure.

Benefits of running EBS on an Autonomous Database Dedicated

Now that we have a better understanding of Autonomous Database Dedicated, let’s get into why it’s the best way to run EBS. EBS is an enterprise application that runs your business and helps you meet financial reporting and regulatory requirements. It is business critical and, depending on your application architecture and which modules you’re using, it can be mission critical. So you want to be on dedicated Exadata infrastructure because it provides isolation and security that comes from being on single-tenant infrastructure. With this isolation, you also get predictable performance because you’re the only one using these resources. Plus, you get flexible maintenance where you can choose your own window for maintenance operations, although Oracle is responsible for performing the successful applications of the patches.

You get all these features and the benefits that come with being an autonomous database. You get improved personal efficiency with all those tasks like provisioning, patching, monitoring, tuning automated, which frees up developers and DBAs to innovate more. Automated tasks are quarterly database and other security patching, including operating system patching, which minimizes security vulnerabilities and reduces risk. The self-recovery, rolling self-updates, and scheduled maintenance features help maximize system availability. These features allow us to guarantee a service level agreement (SLA) of 99.995% for both planned and unplanned downtime.

The benefits of running EBS on Autonomous Database Dedicated aren’t limited to operational or technical but include business benefits too. You can close the books faster each month because with Autonomous Database Dedicated on Oracle Exadata Cloud Infrastructure X9M, you can complete those jobs in 33–50% less time. By closing the books faster, you get superior business insights that let you make timely and informed decisions to help give your company that competitive advantage. You can be better equipped to solve those complex, challenging problems to support the business. All your analytics queries (more efficient with Autonomous Database Dedicated’s self-tuning capabilities), database cloning, and much more can improve speed too.

So, with EBS on Autonomous Database Dedicated, you get more information faster, enabling your business to act more rapidly at significantly lower costs. Aside from staying in compliance with SOX, GDPR, and any other regulatory compliance framework, you also eliminate internal audit findings. You can rest assured that you’re up to date since patches are applied on time every quarter.

What’s covered

This initial certification announcement is for limited availability and includes specialized procedures to migrate existing EBS environments to Autonomous Database Dedicated. With EBS environments that have been migrated, you can back up, restore, clone, and patch Autonomous Database and integrate with Oracle Identity and Access Management (IAM) service.

As we continue to add more EBS support for Autonomous Database Dedicated, we plan to include the following features:

  • Support for larger capacity Exadata systems

  • Support for alternative file systems to provide optimal environment-specific performance

  • Ability to opt for a specific EBS Autonomous Database release update

  • Capability to perform EBS Autonomous Database upgrades

  • Higher system availability during scheduled maintenance

  • Support for disaster recovery procedures

Get started today

After learning about the benefits of running EBS on Autonomous Database Dedicated, you must want to how you can get started. We’re in the limited availability program, where we cater to early adopters to ensure that they have the best experience.

To join this program, you must meet the following requirements:

  • Be on or willing to move to the latest (specified) EBS code levels and to Oracle Database 19c
  • Be willing to deploy on Autonomous Database on Dedicated Exadata Infrastructure
  • Be an Oracle customer with an “early adopter” personality and don’t have a fixed or urgent deadline
  • Complete the qualification questionnaire available through the EBS on Autonomous Database program office

 

Source: https://blogs.oracle.com/cloud-infrastructure/post/ebs-adb-dedicated-exadata-infrastructure?_escaped_fragment_=

 

November 11, 2022 Oracle ACE Associate Award To Syed Saad Ali
APPS DBA

ORACLE ACE ASSOCIATE AWARD

 

Syed SaadAli ACE Associate

 

 

October 11, 2022 How to FIND Oracle EBS R12 Component Versions
APPS DBA

How to FIND Oracle EBS R12 Component Versions

 

 1.  How to Find Oracle EBS Application Version Release?

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
12.2.8

2 : How to Find Oracle Database Version Release?

SQL>  SELECT * FROM V$VERSION;

BANNER  CON_ID
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production         0
PL/SQL Release 12.1.0.2.0 – Production         0
CORE    12.1.0.2.0      Production         0
TNS for Linux: Version 12.1.0.2.0 – Production         0
NLSRTL Version 12.1.0.2.0 – Production         0

 

3: How to FIND Operating System Version?

 

OPERATING SYSTEM COMMANDS
SOLARIS cat /etc/release
RED HAT ENTERPRISE LINUX cat /etc/redhat-release
ORACLE LINUX cat /etc/oracle-release

 

4:  How to FIND Apache, Forms, Java, Reports, Perl, and Weblogic Version?

COMPONENTS COMMANDS
APACHE

$IAS_ORACLE_HOME/ohs/bin/httpd -v

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

FORMS

frmcmp_batch | grep Version | grep Forms

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

REPORTS

$ORACLE_HOME/bin/rwrun | grep Release

JAVA

#sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print$2}’ $ADMIN_SCRIPTS_HOME/java.sh` -version;”

#java -version

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

PERL

$IAS_ORACLE_HOME/perl/bin/perl -v | grep built

WEBLOGIC

cd $FMW_HOME/wlserver_10.3/server/lib

#java -cp weblogic.jar weblogic.version