
Modern Oracle DBA
162 FOLLOWERS
Follow this blog to read articles on Oracle.
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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
Modern Oracle DBA
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