Step-by-Step Guide to Creating a New Forms Server in EBS R12.2
Modern Oracle DBA
by
1w ago
In this guide, we will walk you through the steps to add and manage a new managed server in Oracle E-Business Suite (EBS). This process involves creating the managed server, updating configuration files, and starting the server. 1. Creating a Managed Server To create a new managed server, execute the following command. This will create the managed server and add a new entry to the context file, enabling you to start and stop the server using the adstrtal and adstpall scripts: Copy $ perl /patch/115/bin/adProvisionEBS.pl \ ebs-create-managedserver -contextfile=$CONTEXT_FILE \ -managedsrvname=M ..read more
Visit website
What Happens When You Use ALTER USER Command To Change EBS User Passwords
Modern Oracle DBA
by
1M ago
The Problem with ALTER USER When you change a EBS applicatation user's password directly at the database level using the ALTER USER command: The new password is updated only in the database. The password remains unchanged in the EBS application's FND tables. Why This Matters The FND tables store encrypted versions of user passwords, and they must be synchronized with the database. If the passwords between the FND tables and the database are out of sync: The EBS application won't recognize the new password. Login failures occur. Application functionality is disrupted. The Correct ..read more
Visit website
How to Start and Stop Oracle Data Guard Server 19c
Modern Oracle DBA
by
1M ago
Oracle Data Guard for data protection and high availability. Knowing how to start and stop the Oracle Data Guard server is essential for database administrators. This document will explain the process step-by-step. Steps to Stop the DR Database Stop the Listener Copy lsnrctl stop <listener_name> Replace <listener_name> with the name of your database listener. This command stops the listener service that facilitates client connections to the database.  Cancel Managed Recovery Connect to the database using SQL*Plus and cancel the managed recovery process: Copy SQL> ..read more
Visit website
How to Verify Standby Database Sync with Primary Database in 19c
Modern Oracle DBA
by
1M ago
 To check if your standby database is in sync with the primary database, follow these steps: 1.     Compare Sequence Numbers: Look at the latest sequence number generated on the primary database and the latest sequence number applied on the standby database. 2.     Check for Gaps: Ensure there are no missing sequence numbers on the standby database. The sequence numbers on both databases should match, and there should be no gaps in the sequence on the standby database. If they do match and there are no gaps, the databases are in sync. Verifying t ..read more
Visit website
Top 10 Linux Commands for Monitoring and Troubleshooting Your System
Modern Oracle DBA
by
2M ago
1. Disk and File System Checks Objective: Monitor disk usage and verify file system configurations. Commands and Steps:   View Disk Space Usage: Command: df -h Verify the available and used space in a human-readable format.   Check File System Configurations: Command: cat /etc/fstab Ensure all required file systems are configured to mount at boot.   Verify Permissions of fstab File: Command: ls -ld /etc/fstab Check permissions to ensure security and avoid unauthorized changes. 2. Network Configuration and Connectivity Objective: Validate DNS configurat ..read more
Visit website
How to Grant Privileges in Oracle EBS R12.2 Using AD_ZD.GRANT_PRIVS
Modern Oracle DBA
by
4M ago
When working with Oracle E-Business Suite (EBS) R12.2, granting privileges to applicatation objects requires special care to avoid invalidating objects in the current edition.  Grants cannot be performed in the run edition when the application is being used. A direct GRANT (DDL) command can potentially cause object invalidation when the application is actively being used. To handle this in a more controlled manner, Oracle introduced the AD_ZD.GRANT_PRIVS utility. Why Use AD_ZD.GRANT_PRIVS? In Oracle EBS R12.2, all grants should be performed using the AD_ZD.GRANT_PRIVS procedure rather tha ..read more
Visit website
OCI: Cloud Service Models OCI Basis Part-1
Modern Oracle DBA
by
7M ago
Cloud services Models  Here we will see the simple definaltion and concepts for cloud service models. Saas Software as a services Paas Platform as a service Iaas Infrastructure as a service.   Exactly how each service differs from the other is shown in the diagram below. Traditional on-premises Everything is handled by the client. For example, we need to manage complete servers and applications, networks, operating systems, and so on. Infrastructure as a service Infrastructure side managed by the cloud vendor ex(Oracle, azure, aws) and application data Middleware and OS clint re ..read more
Visit website
[Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 3
Modern Oracle DBA
by
8M ago
Sometimes I am facing this error after cutover phase in my envirnoment. Solution:  Go to config.xml locatation and take backup for the "config.xml" file cd /apps/applmgr/r12/fs1/FMW_Home/user_projects/domains/EBS_domain/config/ ls -ltr config.xml cp config.xml config.xml_bkp Search the config.xml file in "connection-filter-rule"  Change the value “deny” to “allow” [applmgr@vtebstest config]$diff config.xml_bkp config.xml 33d32 <     <OTM >vtebstest.appl.com * * allow</connection-filter-rule> 35d33 <     <connection-filter-rule&g ..read more
Visit website
OEM 13C ASH Analytics Page Is Blank
Modern Oracle DBA
by
8M ago
 Login to the DB Server and execute below commands SQL> select count(*) from WRH$_ACTIVE_SESSION_HISTORY;    COUNT(*) ------------------          0 SQL> alter system set "_ash_enable"=false; System altered.   SQL> alter system set "_ash_enable"=true; System altered.   SQL> alter system set "_ash_enable"=true sid ='*'; System altered. SQL> Login in to OEM and Retest the issue Reference:- OEM Top Activity Graphs Are Not Displayed (Doc ID 2229483.1 ..read more
Visit website
R12.2 EBS Login Flow
Modern Oracle DBA
by
9M ago
User Enters the Application URL http://<URL_HOSTNAME>:<PORT> In the http.conf file, locate DocumentRoot. The DocumentRoot is the base location for where the first access the apache file is stored. Locatation:  $FMW_HOME/webtier/instances/EBS_WEB_OHS/config/OHS/EBS_web/httpd.conf Ex:- DocumentRoot: "/u01/applmgr/DEV/fs1/inst/apps/dev_ebsvis/portal" Under this DocumentRoot folder, index.html will redirect to the application login page. http://<URL_HOSTNAME>:<PORT>/OA_HTML/AppsLogin The application identified the context in OA_HTML and redirected the connection to the ..read more
Visit website

Follow Modern Oracle DBA on FeedSpot

Continue with Google
Continue with Apple
OR