Techgoeasy

How to change Oracle WebLogic User Password in R12.2

How to change the weblogic password post-TXK 7 The below command is available only if TXK 7 is applied. 1. Shut down all application tier services except the Admin Server. On the primary node, run the command:$ <ADMIN_SCRIPTS_HOME>/adstpall.sh -skipNM -skipAdminOn all secondary nodes, run the command:$ <ADMIN_SCRIPTS_HOME>/adstpall.sh 2. Change the Oracle WebLogic Server Administration User …

How to change Oracle WebLogic User Password in R12.2 Read More »

Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL

Oracle, Oracle Database

What is Table Monitoring in Oracle Table monitoring is checking for how many updates, deletes, and inserts happened in the tables so that we can find out if the statistics are stale or good for the table. It is a very useful functionality in gathering stats for the tables in Oracle How to Set the …

Table Monitoring in Oracle and Relationship with STATISTICS_LEVEL Read More »

How to check all constraints on a table in Oracle

Oracle, Oracle Sql

Constraints on a table in Oracle can be found using the below viewsuser_constraints: It provides information about constraints owned by the current user.all_constraints: shows information about constraints accessible to the current user, including those owned by other users.dba_constraints: provides information about all constraints in the database and requires DBA privileges.User_cons_columns: it provides information about columns …

How to check all constraints on a table in Oracle Read More »

FNDLOAD command

Oracle, Oracle Ebuisness Suite

INTRODUCTION TO FNDLOAD CONFIGURATION FILE The contents of the configuration file are at the heart of the loader operation since they specify the structure of the data and the access methods to use to move the data between the data file and a database. A configuration file has the form: configuration_file ::= item { item …

FNDLOAD command Read More »

40 question you must know about R12.2

Interviews questions, Oracle, Oracle Ebuisness Suite

R12.2 is the latest release in Oracle EBS area. The latest Patchset available is 12.2.13 We are presenting here the most sought over 40 question you must know about R12.2 Question 1: What is Online Patching? Answer: Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while …

40 question you must know about R12.2 Read More »

How to perform Installation of an EBS 12.2 Vision Instance

Oracle, Oracle Ebuisness Suite

Step-by-Step Installation of an EBS 12.2 Vision Instance R12.2 is the latest release in Oracle applications. Here we will be giving the snapshots and steps for the R12.2.0 installation. I will be giving here steps for multi-node installation of an EBS 12.2 Vision Instance The installation is similar to the previous release except for some …

How to perform Installation of an EBS 12.2 Vision Instance Read More »