We sometimes need to run Autoconfig on Patch system in R12.2 in the current edition only. But if you to try connect Database from patch filesystem, you will get below error $ sqlplus apps/apps SQL*Plus: Release 10.1.0.5.0 – Production on Wed Jan 2 14:17:46 2019 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-00604: […]
Admin scripts in R12.2 Ebuisness Suite
In this section,we will telling about various Oracle EBS 12.2 start stop scripts in the latest release of Oracle Apps by Oracle corporation. Here are the main script and how they are used to stop /start the application Start Component Command Node Manager $adnodemgrctl.sh start Enter Weblogic Admin Password: Weblogic Admin Server $adadminsrvctl.sh start Enter Weblogic Admin Password: Application Listener […]
Timezone settings in Oracle database
I am presenting here the some of the good queries on timezone settings how to check timezone version in oracle database/how to check dst patch in oracle SQL> select * from v$timezone_file; FILENAME VERSION ———— ———- timezlrg.dat 4 or SELECT tz_version FROM registry$database; or COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A20 SELECT property_name, property_value […]
how to enable trace in oracle apps r12
Some time user get performance issue during various pages in Oracle Apps application.We need to take the trace of the problem in order to identify the bottleneck We can execute below steps to generate the database level trace for the issue and find out the culprit sql or statement.Here is how to enable trace in […]
Transparent Data Encryption Queries
In this post, we will checking out mostly commonly used oracle wallet queries how to open wallet in oracle 12c We have different command with different versions. With 12c Non CDB ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY <wallet password> ; With 12c CDB For all PDB in the Container ADMINISTER KEY MANAGEMENT SET […]
Oracle 12c pluggable database commands
Here are very useful Oracle 12c pluggable database commands which will very helpful in day to day DBA administration for Container and Pluggable database Query to check if the database is CDB or non-CDB SELECT NAME, CDB, CON_ID FROM V$DATABASE; NAME CDB CON_ID ————————— ——— ———- CDB01 YES 0 how to check container database in […]
