Showing posts with label EBS. Show all posts
Showing posts with label EBS. Show all posts
Tuesday, September 17, 2024

Where does an Oracle EBS 12.2 appserver save logs from the concurrent worker processes?

›
Look in the directory $ADOP_LOG_HOME In here, every session will create its own subfolder. In my case 10 11 2 3 4 5 6 7 8 9 In ...
Thursday, February 29, 2024

What does it mean to run autoconfig on an EBS DB tier?

›
In a nutshell, it means running adautocfg.sh on the database server. This is what I did when the listener.ora was missing on one of my EBS...
Saturday, January 27, 2024

Solution to ERRORMSG: Invalid SYSTEM database user credential when running txkPostPDBCreationTasks.pl as a part of an EBS database upgrade

›
When upgrading an EBS database from version 12c to 19c, you have to convert to the mulitenant architechture. Oracle supplies script for t...
Friday, January 26, 2024

How to find installed patches through SQL in an EBS database

›
During an EBS upgrade, I had to check whether or not a specific patch, 8796558, still needed to be applied. Turned out is no longer releva...
Wednesday, January 3, 2024

Workaround for error adstpall.sh: too few arguments specified when stopping the EBS 12.2 server processes

›
ebs@ebsserver1.oric.no 35642926]$ $ADMIN_SCRIPTS_HOME/adstpall.sh –skipNM -skipAdmin You are running adstpall.sh version 120.22.1202000...
Friday, December 8, 2023

Syntax for applying and removing a patch on the WLS server Home in an EBS 12.2 installation

›
The bsu (or "Smart update") utility: cd $MW_HOME/utils/bsu bsu.sh -version Oracle Smart Update. Version: 3.3.0.0 Here's a...
Thursday, November 23, 2023

How to use strace to figure out what files are being accessed by a shell script

›
I had a situation where an ebs-supplied script adstrtal.sh would not start - it kept throwing error ORA-12541: TNS:no listener Although ...
Friday, November 10, 2023

What are EBS snapshots?

›
I found this info in the document Oracle® Applications Maintenance Utilities Release 12.1 Part No. E13676-02 There are two types of snap...
Friday, February 24, 2023

Getting ORA-01722 when running adstats.sql after an EBS database upgrade to 19c

›
An old error from 2015 surfaced today , when we were trying to upgrade a 12.1 EBS database to 19c. The problem occured during the running...
1 comment:
Tuesday, January 24, 2023

How to avoid error Perl lib version (5.28.1) doesn't match executable version (5.36.0)

›
When trying to use clone.pl to clone the latest version of the Oracle 19c database, the following error stopped me from proceeding: /sw/or...
Thursday, January 19, 2023

What is the ifile directive sometimes used in tnsnames.ora?

›
My customer is using Oracle E-Business Suite, and during a so-called "autoconfig", some files in the Oracle RDBMS home on the dat...
Friday, December 9, 2022

How to solve "Can't locate TXK/ARGS.pm in @INC (you may need to install the TXK::ARGS module)" when running txkChkPDBCompatability.pl

›
Background: As a part of converting your non-CDB Oracle database to a pluggable database, you are supposed to run the perl script txkChkP...
Tuesday, October 11, 2022

How to check the code level currently in use in an EBS database

›
To find the E-Business Suite and AD/TXK patch levels, log into the EBS container and use the following two queries: col abbreviation forma...
Friday, August 12, 2022

Workaround for ORA-65011 in an upgraded EBS database running multitenant

›
If you are converting a non-cdb EBS database to a pdb in a multitenant setup, and your non-cdb had a name that used lower case ("pdb1...
Wednesday, June 5, 2019

How to solve "FAILED: file csrrsreg.sql on worker " when applying RPC5 to an EBS 12.1.3 installation

›
During a patching of EBS 12.1.3 to RPC5, I encountered an unexpected problem. A while into the patching, the patching procedure failed w...
Tuesday, June 4, 2019

What is the admsi.pl utility that is used during EBS patching?

›
Thanks to the blog post by Atul Kumar for explain this. It's a tool for generating instance-specific patch installation instructions...
Friday, December 15, 2017

A list of eBS users

›
To view the users that are installed as a part of an eBS installation, use the following query: SELECT EBS.ORACLE_USERNAME,U.PROFILE FROM...
Friday, December 16, 2016

How to change passwords for eBS schemas in an Oracle database

›
In an Oracle database supporting eBS, there are a number of schemas that supports the different modules in eBS. Everything is installed and ...
1 comment:
Monday, November 2, 2015

ORA-01722 when running ausy1120.sql during preparation of new target database for EBS

›
If you are following note Doc ID 741818.1 "Export/import process for 12.0 or 12.1 using 11gR1 or 11gR2" and run into the follwing ...