Oracle database Listener Basic commands

Listener process running the database node that listen for incoming the connection on database.
The name of the listener listener.ora file
Listener file default location “$ORACLE_HOME/network/admin
Listener process listen for more than one database.
listener.ora file:
The default settings for the listener.ora file contains the below parameters
Listener name
Port number
SID name
Host name
Listener commands:
lsnrctl start <listener_name> Starting the listener
lsnrctl stop <listener_name> Stops the listener
lsnrctl status <listener_name> Display the status information about the listener.
lsnrctl reload We can use add/change without stopping the listener.
lsnrctl help Display the list of all listener commands
lsnrctl version Display the current listener version
lsnrctl services Display the detailed information about services and instance registred and service handlers allocated each instance
Enable trace on listener
Change below parameter in listener level

Oracle Apps DBA Interview Questions Part-4

1)How to restore the datafile asm to non-asm?
2)What happened alter database begin backup mode?
3)Why need to enable maintenance mode in adpatch?
4)Why we are using appsutil directory in under database home?
5)What is TWO_TASK parameter?
6)What is different adop prepare phase and fs_clone?
7)What is US directory in $AD_TOP?
8)How to troubleshoot long running concurrent program and sql query?
9)How to apply pre-request patch when patch running?
10)Explain weblogic patching steps?
11)Explain RMAN block change tracking?

Oracle Apps DBA Interview questions Part -1àClick hear Oracle Apps DBA Interview questions Part -2àClick hear Oracle Apps DBA Interview questions Part -3àClick hear

How to compile the invalid objects in R12.2

Find the invalid objects: 1. Find the number of invalid objects     Select count(*) from dba_objects where status=’INVALID’;
2. Find the object name /type     Select owner,object_type from dba_objects where status =’INVALID’;
Compile the invalid objects in apps schema:
Application Side:
Login the application services
Check the invalid object
In application side use ADadmin utlity and give below options
adadminà option3 Compile/Reload Applications Database Entities menuà1: Compile APPS schema
It will compile the all invalid objects in application side.
Database Side:
Login Database server
cd /oracle/PROD/db/11.2.0/rdbms/admin/
run utlrp.sql script in sqlplus
Manual Method:
Alter package <owner>,<package_name> compile; Alter package <owner>,<package_name> compile body; Alter view <owner>,<view_name> compile; Alter materialized view <owner>.<Package_name> Compile; Alter procedure <owner>,<procedure_name> compile; Alter function <owner>,<func…

Oracle Apps DBA Interview Questions Part-3

What is apps listener and why it used?
Apps listener is combination of FNDFS&FNDSM it’s running all apps node with listener alias name. It’s mainly used for listening the request for services like FNDFS&FNDSM
What is difference between Socket & Servlet Mode in Apps Forms?
When forms run SOCKET Mode these are dedicated connection between Client Machine & Form Server (Started by
When Forms run in servlet mode the forms requests are fulfilled by Jserv in Apache . There will be additional JVM for Forms Request in that case and you won't start form via
What is batch size in adpatch?
Batch size is how many table performed same time. If example I give batch size 1000 means 1000 tables will perform same time in patching activity.
What is (.lgi) file ?
Lgi files are created with patching along with patch log file (.log) it’s contain information related to patch
Patch will create two tables what are the content of the tables?
Fnd_install_processes and ad_di…

Oracle Apps DBA Interview Questions Part-2

For in this post will see the scenario based interview questions and answers
How to change the apps password in R12.2? ·        Down the application services

  FNDCPASS APPS/[apps_pass] 0 Y SYSTEM/[system_pass] ORACLE APPLSYSPUB [new_passs]

Start the services

Login weblogic services

Go to datasourceàconnection poolsàEnter the new password

Run Autoconfig

Start the application services.
How to change the weblogic Admin password in R12.2? · Before change the password take the backup of boot.proprties files

  Go to weblogic console DomainàSecurityàAdvanceàChange the Node manger password

  Go to security Realms àmyrealmàUser and groupsà Weblogic(Change the weblogic password)

Finally we need to manually change the boot.propertices password and start all services
Explain the Cloning steps? · Prepare the source system

Difference between local inventory and global inventory in R12.2

The Inventory very important part of Oracle universal installer.
The inventory keeps all information about oracle product like oracle_home and locations,etc.
The inventory in the ORACLE_HOME(Local Inventory)
The central inventory outside the oracle_home (Global inventory) Location: /var/opt/oraInst.loc /etc/oraInst.loc (AIX,Linux)
Local Inventory
The inventory directory inside the oracle home called local inventory
Physical Location $ORACLE_HOME/inventory
The local inventory gets updated whenever patch is applied oracle_home like:OPATCH
If Local inventory corrupted/Loss difficult to recover need to reinstall the oracle home.
Global Inventory
Global Inventory directory outside of the oracle_home called local inventory
Physical Location /var/opt/oraInst.loc, /etc/oraInst.loc (AIX,Linux)
Global inventory gets update every time install/De-install/Clone the ORACLE_HOME

How to find EBS URL in R12.2

There are different way to find the EBS URL

Method 1

Login the R12.2 application server
Source the Env File

[oracle@san ~]$ grep login $CONTEXT_FILE
         <login_page oa_var="s_login_page"></login_page>

Method 2:

Connect sql plus apps user

SQL> SELECT home_url  FROM icx_parameters;


How to find Weblogic URL and PORT number:
Login the R12.2 application server
Source the Env File
[oracle@sanprod ~]$ grep s_wls_adminport $CONTEXT_FILE          <wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7002</wls_adminport> [oracle@sanprod ~]$

Weblogic Port Number:7002  Weblogic URL:http://<Hostname>7002/console