oracleappsdbasstuff

[oracleappsdbasstuff]

Linux Commands -3

File Operations: Find the Largest File: To find the largest file in the current directory and subdirectories, use the following command: find . -type f -exec ls -s {} \; | sort -n -r | head -1 Find the Smallest File: To find the smallest file in the current directory and subdirectories, you can use either of the following commands: find . -type f -exec ls -s {} \; | sort -n -r | tail…

[oracleappsdbasstuff]

Linux Commands -2

These commands are valuable for managing and manipulating files and directories efficiently. Here’s a summary of the commands and their functionalities: File Creation Commands: vim filename: Create and edit a file using the Vim text editor, with various Vim commands for navigation, editing, and saving. cat > filename.txt: Create a new file and input data. Save the data to the file. cat…

[oracleappsdbasstuff]

Linux Commands -1

These commands are essential for system administrators and users who need to gather information about their system and network. Here’s a brief explanation of each command: System Information Commands: date: Displays the current system date and time. hostname: Shows the system’s hostname. uname: Displays the operating system name. uname -a: Provides detailed system information, including OS…

[oracleappsdbasstuff]

expdp and impdp question and answers

Here are concise answers to your questions about Oracle Data Pump (expdp and impdp): What is expdp and impdp? expdp (Data Pump Export) and impdp (Data Pump Import) are Oracle utilities used for efficiently moving data and metadata between Oracle databases. They are an enhancement of the original exp and imp utilities.What are the Pros and Cons of exp & imp Vs expdp & impdp? exp & imp:Pros:…

[oracleappsdbasstuff]

 Listeners questions

These are a lot of questions related to Oracle database listeners. Let’s address each one: Do we need to configure a separate LISTENER for all these PDBs? and HOW to connect to PDBs? No, you don’t need to configure a separate listener for each PDB. In a Container Database (CDB), there’s typically one listener configured at the CDB level that can handle connections to all PDBs. To connect to a…

[oracleappsdbasstuff]

How to Enable Discovery Cache To Avoid Long Delay During Login To Fusion Middleware Control

SYMPTOMS Logging into Enterprise Manager Fusion Middleware Control (fmwc) takes a long time. Sometimes as long as 45-60 seconds.This is often viewed as slow response time, performance or hanging issues. This applies to fmwc 11g and 12c. Root Cause: fmwc discovery is always performed as part of login. For installations with thousands of targets, fmwc discovery may take 45-60 seconds. This time…

[oracleappsdbasstuff]

Getting Error 'weblogic.management.ManagementException: Unable to obtain lock on SERVER_NAME.lok.' on Starting UIM Server

SYMPTOMS UIM Server fails to start with following error: Following error might also be observed: Root Cause: There can be 2 reasons for this issue: The [server name].lok indicates that the server with name [server name] is running. This is used to prevent a server from being booted twice. This error indicates that server user tried to restart is already up & running.This issue can come up if…

[oracleappsdbasstuff]

adpreclone.pl Fails on Applications Tier With Error Message "Edit session is enabled in domain

adpreclone.pl Fails on Applications Tier With Error Message “Edit session is enabled in domain

adpreclone.pl fails on Applications Tier with below error:perl adpreclone.pl appsTier Copyright (c) 2011, 2014 Oracle CorporationRedwood Shores, California, USA Oracle E-Business Suite Rapid Clone Version 12.2 adpreclone Version 120.31.12020000.18 Enter the APPS User Password:Enter the Weblogic AdminServer password : Checking the status of the Oracle WebLogic Administration…

[oracleappsdbasstuff]

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone, command 'perl adcfgclone.pl appsTier dualfs' fails with the below error

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone, command ‘perl adcfgclone.pl appsTier dualfs’ fails with the below error

Error While Creating new WLS domain When Performing a Clone Of EBS R 12.2 When attempting to clone of EBS 12.2.6 the following error occurs. START: Creating new WLS domain.Running /XXXX/XXXX/fs1/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /XXXX/XXXX//fs1/EBSapps/comn/util/jdk64 -al /XXXX/XXXX/fs1/EBSapps/comn/adopclone_XXXX/FMW/WLS/EBSdomain.jar -tdl…

[oracleappsdbasstuff]

R12.2 OHS was not coming up after unclean shutdown or due to server crash.

R12.2 OHS was not coming up after unclean shutdown or due to server crash.

R12.2 OHS was not coming up after unclean shutdown or due to server crash.Issue: R12.2 OHS was not coming up after unclean shutdown or due to server crash. Processes in Instance: EBS_web_OHS1———————————+——————–+———+———ias-component | process-type | pid | status———————————+——————–+———+———EBS_web | OHS | 9214 | stop OHS was in STOP state and we were not able to either bring down or bring up. It…

[oracleappsdbasstuff]

ADOP- Online Patching Cycle

ADOP- Online Patching Cycle

The online patching cycle is divided into five phases: Patching Cycle Overview The key actions in the various stages of the online patching cycle can be summarized as follows Prepare Synchronizes patch edition and run edition on the file system.Creates a new patch edition in the database. Apply Executes patch drivers to update patch edition.Patches applied: can be one or many, including…

[oracleappsdbasstuff]

'adop -status' Command Produces a "FATAL ERROR"

@oracleebs @oracleappsdba #oracle #oracleappsdba #oracleebs #oracleerp

ERROR path=../~/$ adop -status Enter the password:FATAL ERRORPROGRAM : (…/R12/fs1/dir=/appl/ad/12.0.0/bin/adzdoptl.pl)TIME : Thu Feb 21 09:33:54 2019FUNCTION: TXK::SQLPLUS::setConnectInfo [ Level 2 ]MESSAGES:Argument must be a scalar STACK TRACEat /ofpr02/R12/fs1/dir=/appl/au/12.0.0/perl/TXK/Error.pm line 168TXK::Error::abort(‘TXK::Error’, ‘HASH(0x103b6da60)’) called at…

[oracleappsdbasstuff]

12.2 E-Business Suite ADOP Patching Fails Due To ETCC Error During The Apply Phase ' [ERROR] ETCC not run in the database node

@oracle @oracleebs @oracleerp #oracle #oracleebs #oracleerp #appsdba #appsdba #ebsdba

E-Business Suite 12.2.x, Online Patching ADOP Utilities issues ETCC errors when applying a patch in Apply phase. Receiving an ETCC error while executing the following ADOP command: $ adop phase=apply apply_mode=downtime patches=xxxxxxxxx ERROR Validating credentials. Initializing.Run Edition context :/d01/oracle/inst/fs1/inst/apps/odbdev_oadev/appl/admin/odbdev_oadev.xmlPatch edition…

[oracleappsdbasstuff]

Basic File Navigation

Basic File Navigation: df command in Linux provides disk space usage information of your file systems.$ df –h (in human readable format) [oracle@db-uat trace]$ df -hFilesystem Size Used Avail Use% Mounted ondevtmpfs 16G 0 16G 0% /devtmpfs 16G 12K 16G 1% /dev/shmtmpfs 16G 258M 16G 2% /runtmpfs 16G 0 16G 0% /sys/fs/cgroup/dev/mapper/OSVG-rootlv 10G 253M 9.8G 3% //dev/mapper/OSVG-usrlv 30G 5.4G…

[oracleappsdbasstuff]

Adop Phase=prepare Failed While Synchronizing Snapshots

#oracleebs #oracleerp #ebs #ebs #oracleappsdba #ebsdba #applicationDBA #oracledba

Orace Applications 12.2.4 version,when attempting to run adop phase=prepare, the following error occurs: Steps to reproduce the problem: Set the environment variables.Execute the command adop phase=prepare.The error is shown in the adop log file. Synchronizing Snapshots failed and that is the root cause for prepare phase failure. SOLUTION: Execute the following steps to resolve the…

[oracleappsdbasstuff]

Rewind a Purchase Order EBS R12.2

@oracle @ebs #oracleebs, #ebs, #erp #oracleebs #oracleapps #oracleappsdba, #oracle dba, #EBSr12.2

to provide the steps to rewind a purchase order completed in error status Login into Oracle application as SYSADMIN userGo the following directories: Workflow administrator -> Administrator Workflow -> Status Monitor 3.Enter the PO number in “User Key” and type of the workflow in “Workflow type” 4.Select the PO which is completed in Error and chose active history option to view the history of…

[oracleappsdbasstuff]

Error: Edit session is enabled in domain.Please activate all of your changes before proceed clone

Error: Edit session is enabled in domain.Please activate all of your changes before proceed clone

perl adpreclone.pl appsTier Error: Edit session is enabled in domain.Please activate all of your changes before proceed clone go to /devapps/applmgr/fs2/FMW_Home/user_projects/domains/EBS_domain cd /devapps/applmgr/fs2/FMW_Home/user_projects/domains/EBS_domain ls -lrt $ cd $ADMIN_SCRIPT_HOME Bounce the Admin server adadminsrvctl.sh stop and start Next Re-try the preclone