Oracle EBS DBA 12.2 Command Worksheet

1. Checking EBS Version

sh


sqlplus apps/apps@<DB_SID>

SELECT release_name FROM apps.fnd_product_groups;


2. Start/Stop EBS Services

Start Services

sh


$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps_pwd


Stop Services

sh


$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps_pwd


Start Only Web Services

sh


$ADMIN_SCRIPTS_HOME/adapcctl.sh start


Start Only Forms Services

sh


$ADMIN_SCRIPTS_HOME/adformsctl.sh start


Start Concurrent Manager

sh


$ADMIN_SCRIPTS_HOME/adcmctl.sh start apps/apps_pwd


3. Checking EBS Services Status

sh


$ADMIN_SCRIPTS_HOME/adstpall.sh status


4. Start/Stop Database

sh


sqlplus / as sysdba

shutdown immediate;

startup;


5. Checking EBS Log Files

Application Logs

  • $LOG_HOME/ora/10.1.3/Apache/logs/error_log

  • $LOG_HOME/ora/10.1.3/Apache/logs/access_log

  • $LOG_HOME/ora/10.1.3/opmn/logs/default_group~oacore~default_group~1.log

Concurrent Manager Logs

sh


$APPLCSF/$APPLLOG/


Database Alert Log

sh


$ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/alert.log


6. Default Ports in EBS 12.2

Service

Default Port

Web Server (OHS)

8000, 8080

Forms Server

9000

Reports Server

7001

Concurrent Processing

1521 (DB)

Workflow Mailer

25 (SMTP)

Admin Console (WLS)

7001

7. EBS Default URLs

Component

URL Format

EBS Home Page

http://<hostname>:8000

Forms Services

http://<hostname>:8000/forms/frmservlet

WebLogic Console

http://<hostname>:7001/console

OAM Login

http://<hostname>:8000/OA_HTML/AppsLogin

8. Administering WebLogic Server

Start WebLogic Admin Server

sh


$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start


Stop WebLogic Admin Server

sh


$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop


Check WebLogic Status

sh


$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh status


9. Checking Concurrent Manager Status

sh


$ADMIN_SCRIPTS_HOME/adcmctl.sh status apps/apps_pwd


10. Running ADADMIN (Application Maintenance)

sh


cd $INST_TOP/admin/scripts

adadmin


11. Running ADOP (Online Patching)

Check Current Patch Cycle Status

sh


adop -status


Start a New Patch Cycle

sh


adop phase=prepare


Apply Patch

sh


adop phase=apply patches=<patch_number>


Finalize Patch Cycle

sh


adop phase=finalize


Cleanup Old Patches

sh


adop phase=cleanup


Abort Patch Cycle

sh


adop phase=abort


12. Checking Active Users in EBS

sh


SELECT fnd.user_id, fu.user_name, fu.description, fu.email_address

FROM fnd_user fu, fnd_sessions fnd

WHERE fu.user_id = fnd.user_id;


13. Identifying Workflow Mailer Issues

sh


SELECT component_status FROM fnd_svc_components WHERE component_name='Workflow Notification Mailer';


14. Clearing Cache in EBS

sh


$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start


15. Checking Patch History

sh


SELECT bug_number, patch_type, applied_date FROM ad_bugs;


16. Backup & Restore

Backup Database

sh


rman target /

backup database plus archivelog;


Restore Database

sh


rman target /

restore database;

recover database;


17. Reset EBS User Password

sh


SQL> UPDATE fnd_user SET encrypted_password = fnd_web_sec.encrypt('WELCOME123') WHERE user_name = 'SYSADMIN';

COMMIT;


This worksheet provides a quick reference for common Oracle EBS 12.2 DBA tasks. Let me know if you need any modifications or additional commands! 🚀


 

Comments

Post a Comment

Popular posts from this blog

HANA certification questions

Here are 100 **SAP HANA Cloud Administration** certification questions with answers to help you prepare for the **C_HANACLOUD_2022** exam. --- ## **SAP HANA Cloud Administration – Practice Questions and Answers** ### **Section 1: HANA Cloud Architecture and Provisioning** 1. **What is SAP HANA Cloud?** - A fully managed in-memory database-as-a-service (DBaaS) running in **SAP Business Technology Platform (BTP)**. 2. **Which tool is used to provision an SAP HANA Cloud instance?** - **SAP BTP Cockpit**. 3. **What are the key components of SAP HANA Cloud?** - **HANA Database, Data Lake, and Data Lake Relational Engine**. 4. **How do you access SAP HANA Cloud after provisioning?** - Through the **SAP BTP Cockpit** or **SAP HANA Cloud Central**. 5. **Which deployment model is used in SAP HANA Cloud?** - **Cloud-only**, provided as a **managed service** by SAP. 6. **Can you install SAP HANA Cloud on-premise?** - No, SAP HANA Cloud is a **fully managed ser...
Read more

Troubleshoot Oracle performance issue

  Identifying performance issues in an Oracle Database 19c environment requires a structured approach to pinpoint bottlenecks and optimize the system. Below is a step-by-step guide to help you identify and resolve performance issues: Step 1: Gather Baseline Information Understand the Symptoms: Is the database slow for all users or specific applications? Are there specific queries or processes that are slow? When did the performance degradation start? Check the Alert Log: Review the alert log ( alert_<SID>.log ) for errors or warnings. Locatio n:  $ORACLE_BASE/diag/rdbms/<DB_NAME>/<SID>/trace/alert_<SID>.log . Check Recent Changes: Were there any recent changes (e.g., schema changes, parameter changes, patches)? Query  DBA_REGISTRY_HISTORY  for recent updates. Step 2: Monitor Database Activity Check Active Sessions: Identify active sessions and their wait events: sql Copy SELECT sid , serial #, username, sql_id, event, blocking_session FROM ...
Read more