Soumya's Database Blog
1,685 FOLLOWERS
A blog related to Different Databases i.e. Oracle, SQL Server , Mysql , Postgresql , Mongodb , Hadoop.
Soumya's Database Blog
2d ago
How to disable audit trail in E Business suite R12.2
There could a situation where you want to stop auditing, then you must set the audit group state to either “Disable-prepare for archive” or
“Disable-Interrupt Audit” and run the “AuditTrail Update Tables” report.
1. Disable Prepare for Archive
Copies the current value of all rows in the audited table into the shadow table and then disables the auditing triggers. There is no
longer any recording of any changes. The shadow table should be archived at this point.
2. Disable Interrupt Audit
Modifies the triggers to store one "final" row i ..read more
Soumya's Database Blog
1w ago
Recently I came across a requirement from a customer where they wanted to enable audit trail on EBS Application. Today I will show how to enable it.
Step 1.
As an example, I will be enabling auditing on table AP_CHECKS_ALL
Navigate to Responsibility: System Administrator
Navigation: Profile > System
Query Profile: 'AuditTrail:Activate'. Click FIND
Set it to 'Yes' at Site level.
Step 2.
We will be enabling Audit Installations for username. In this case it will be AP.
Navigate ..read more
Soumya's Database Blog
1w ago
In this post I will describe the installation of Oracle Database 19c 64-bit on Oracle Linux 8 (OL8) 64-bit. The installation require a minimum of 2g swap memory and secure Linux set to permissive.
· Download Software
Oracle Database 19c (19.3) Software (64-bit)
Add hosts entry in hosts file
[oracle@ocisoumya-2 PDB1]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.0.0.14 ..read more
Soumya's Database Blog
2w ago
How to change admin password in Apex 23.2
In apex , admin password can be changed using two methods such as
Method 1. By executing apxchpwd.sql
Method 2. By executing sql command
Method 1. By executing apxchpwd.sql
Login to Database server and navigate to apex installation folder and execute apxchpwd.sql as sys user.
[oracle@ocisoumya-2 ~]$ cd /u01/apex/apex/
[oracle@ocisoumya-2 apex]$ sqlplus / as sysdba
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to chan ..read more
Soumya's Database Blog
1M ago
Oracle Application Express 23.2 Installation Steps
Before installing Oracle Application Express, you must verify your configuration meets the minimum installation requirements.
• Oracle Database Requirements
Oracle Application Express release 23.2 requires an Oracle Database release 19c or later, including Enterprise Edition and Standard Edition (SE) and Database 23c Free. Oracle Application Express can be installed in single-instance database and in Oracle Real Application Clusters ..read more
Soumya's Database Blog
1M ago
Steps to Fix Output Post Processor Startup
In Oracle E-Business Suite, there are occasions when we encounter issues such as the Output Post Processor failing to start up, resulting in a mismatch between the actual number of processes and the target number of processes. Consequently, many concurrent programs end up completing with errors or warnings.
Solution: To resolve such issues, follow these steps:
Restart the manager called "Output Post Processor" from the frontend:
Log in to Oracle Applications with sysadmin responsibility.
Navigate to: Concurrent -> Managers -> Administer ..read more
Soumya's Database Blog
2M ago
Issue:- We had a situation for a customer where his server was shutdown abruptly due to power cut at datacenter. After resuming the power, when he tried to start his database he encountered following error“ORA-00742: Log read detects lost write in thread 1 sequence 5789 block 805653”
Environment :- Windows 2019
DB Version:- 12.2.0.1
Solution: -
Login to database and shutdown cleanly
D:\oracle\product\12.2.0\dbhome\bin>sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 11 10:26:27 2024
Copyright (c) 1982, 2016, Orac ..read more
Soumya's Database Blog
3M ago
In this comprehensive guide, we'll walk you through the process of converting a Non-CDB (Non-Container Database) to a Pluggable Database (PDB) using an existing CDB (Container Database). Follow these clear and concise steps for a seamless transformation:
Assumption: Before converting a Non-CDB oracle instance into CDB , it is assumed an oracle CDB instance is already running.
Step 1: Cleanly Shutdown the Non-CDB Database(orcl)
Execute the following commands to gracefully shut down the Non-CDB Database named "orcl":
Invoke environment for orcl
[oracle@ocisoumya ~]$ . oraenv ..read more
Soumya's Database Blog
4M ago
In this post I will be showing step by step guide to apply CPU patch on oracle database 19c. I will be applying CPU patch for December 2023(Patch no :- 35643107)
Activity Steps:
1. Check Opatch Tool Version:
Verify the current version of the Opatch tool. As per read me of Patch 35643107 , minimum required Opatch version should be 12.2.0.1.37 or later
2.Download Opatch Tool (if needed):
Upgrade the Opatch utility if the current version is outdated. Download Opatch latest version or as mentioned in patch readme. In this case I will be installing 12.2.0.1.40 (Patch no 6 ..read more
Soumya's Database Blog
4M ago
We often require to extract information such as User DDL and all privileges granted including roles, system and object privileges, tablespace quota etc. Using the following method we can extract it easily.
Create a .sql file and paste the following code inside.
Note:- While executing this sql make sure to enter the username in UPPERCASE.
vi info.sql
-- Connect to target database and execute with a user that has DBA privileges
-- Example for user "CRPDTA" - Make sure to put the username in uppercase.
SET LONGCHUNKSIZE 20000 PAGESIZE 0 FEEDBACK OFF VERIFY OFF TRIMPOOL ON
COLUMN ..read more