Interview Questions

Interview question on cloning
Interview questions on mobile server.
Interview question on adutilities and others
Interview questions on listener!!!!

1)How to find database version?

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

PL/SQL Release 11.1.0.7.0 - Production

CORE    11.1.0.7.0      Production

TNS for Linux: Version 11.1.0.7.0 - Production

NLSRTL Version 11.1.0.7.0 - Production

SQL>

2)How to find Opatch version?

/u01/db/tech_st/11.1.0/OPatch

[oracle@apps OPatch]$ opatch version

Invoking OPatch 11.1.0.6.2

OPatch Version: 11.1.0.6.2

OPatch succeeded.

[oracle@apps OPatch]$

3)How to find operating system version?

[oracle@apps OPatch]$ cat /etc/*release*

Enterprise Linux Enterprise Linux AS release 4 (October Update 6)

Its mean you are on operating system version 4.

Solaris:

======

isainfo -v

Uname -X

Click here to check in details for operating system commands.

http://abduulwasiq.blogspot.in/p/linuxunix.html

4)How to find operating system isw 32 bit or 64 bit?

[oracle@apps OPatch]$ uname -m

i686

[oracle@apps OPatch]$

i386 or i686 then it is 32 bit

x86_64 is 64bit

5)How to check jdbc connection?

select count(*),module from v$session where program like %jdbc% group by module;

6)what is the location of context file in 11i/r12?

Database side: $ORACLE_HOME/appsutit/<sid>.<hostname>.xml

 11i *:  $APPL_TOP/admin/<sid>_<hostname>.xml

 R12*: $INST_TOP/appl/admin

7)How to run autoconfig in 11i/R12?

The procdure is same in 11i and R12 but the location is different.

cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

in the above location you will find adautocfg.sh file.just give filename and hit enter it will ask for apps password.

R12

===

cd $ADMIN_SCRIPTS_HOME (OR) cd $INST_TOP/admin/scripts

in the above location you will find adautocfg.sh file.just give filename and hit enter it will ask for apps password.

if you run adautocfg.sh file which in turn call adconfig.sh file which further call adconfig.pl.you should not worry about the later two script its only for information.

8)what if my context file itself corrupted,can i create a new one?

yes you can we have utility called adblxml to build context file.

but in R12 we don't have this.

9)if we run autoconfig which files will get effected?

cd $AD_TOP/bin

ls -tlrh adchkcfg.sh ===>run this file it will ask for apps password ,you can use it in 11i/r12

adchkcfg.sh ===> It will generate HTML report.

This report will list all files and profile options going to change when you run autoconfig.

10)what is the difference between xml file and autoconfig?

Xml file is repositary of all configuration files.

Autoconfig picks configuration and update related files.

11)How do you reduce the patch timings?

Mering patches using admrgpch.

use default file.

Use various adpatch options like nocompiledb or nocompilejsp etc.

12)what do you do if patch fails.?

Review adpatch logfile to determine the cause of the error.

fix the issue.

Restart the patch.

when adpatch asks if you want you continue with your previous sessions.

adpatch will skip already completed jobs,and pick up from where it left.

13)where would i find .rf9 file,and what exactly it does?

 cd $APPL_TOP/admin/<SID>/restart

.rf9 file used during the restart of the patch incase of patch failure because of some reason.

14)while applying apps patch ,if you want to hide apps password.how will that possible?

adpatch flags=hidepw

15)when you apply c driver patch does it require database to be up and why?

Yes,database and database listener should be up and running when you apply any dirver patch in apps.Even if driver is not updating any database objects connection is required to validate apps &

other schema and to upload patch history information in database tables.

16)Can 'C' driver in apps patch create invalid objects in database?

No.'C' driver only copies files from patch top to appl top.

Database object might be invalided during 'D' driver when these objects are created/dropped/modified.

17)Difference between adpatch and opatch?

adpatch is a utility to apply oracle apps patches.

Opatch is a ulility to apply database patches.

18)what is the pre requisite to apply Opatch?

Database should be down.

19)How do you find out what patches have been applied on database?

opatch lsinventory.

20)How to rollback the Opatch?

opatch rollback

21)How to apply database patch?

opatch apply

22)How to go for help on Opatch?

opatch help

23)How do you know the kernel version?

uname -r.

[oracle@apps ~]$ uname -r

2.6.9-67.0.0.0.1.ELhugemem

[oracle@apps ~]$

24)How do you know the database has invalid objects?

select count(*) from dba_objects where status='INVALID';

25)what happens when you give open resetlogs.?

log sequence number will be re set.

26)In multinode intallation,how you will find which node is running what services?

use fnd_nodes to get the details.

27)what is the utility to upgrade database from one version to another version.

dbua.

28)How to find if your database is 32 bit or 64 bit (useful while applying patches)?

[oracle@apps ~]$ cd $ORACLE_HOME/bin

[oracle@apps bin]$ file oracle

oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped

[oracle@apps bin]$

29)How to find version of any file in oracle apps?

/u02/apps/apps_st/appl/au/12.0.0/forms/US

[applmgr@apps US]$ adident Header IGSPR004.fmb

IGSPR004.fmb:

$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship                                                                                $

$Header IGSPR004.fmb 120.0 2005/07/05 12:49 appldev noship                                                                                 $

[applmgr@apps US]

      (OR)

[applmgr@apps US]$ strings -a /u02/apps/apps_st/appl/au/12.0.0/forms/US/ZXGLXST.fmb|grep -i 'Header'

  FDRCSID('$Header: APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                                  $');

$Header: APPSTAND.fmb 120.6 2006/03/06 09:59 mzasowsk ship                                                                                                                                                       $

FDRCSID('$Header: ZXGLXST.fmb 120.28.12010000.1 2008/07/28 05:15  appldev ship                                                                                                                                                               $');

$Header: ZXGLXST.fmb 120.28.12010000.1 2008/07/28 05:15  appldev ship

30)How to find any reports versoin?

Use adident Header <Report filename>

31)How to find oracle apps version?

SQL> select release_name from fnd_product_groups;

RELEASE_NAME

--------------------------------------------------

12.1.1

SQL> select name from v$database;

NAME

---------

PROD

SQL>

32)adident utility used for what?

To find the version of any file.

33)what is multinode system?

If the database and application services are maintained on different servers,then it is said to be mutli node.

34)what is single node system?

If the database and application services maintained on only one server ,then it is said to be single node.

35)How to check if a patch is applied or not?

select bug_number,creation_date from apps.ad_bugs where bug_number='&bug_number';

36)what are various types of oracle a patches?
Click on the below link to check in details.

48)How to check my workflow version  in oracle R12 EBS?

SQLPLUS>@$FND_TOP/sql/wfver.sql


101) What URL you use to access Disco viewer & Disco plus .
http://hostname.domain/discoverer4i/viewer
http://hostname.domainname:port/discoverer/viewer (10gAS)
http://hostname.domainname:http_port/discoverer/viewer ( R12)
http://hostname.domainname:port/discoverer/plus (10gAS)

if any pre requisite patches are to applied.
OR
If the worker tries to drop a package,but already package is locked.
@$AD_TOP/sql/adcompsc.sql AR AR%
cd $COMMON_TOP/admin/install/$CONTEXT_NAME

Click on the below link to check in details.

http://abduulwasiq.blogspot.in/p/errorssolutions.html

37)How to  compile jsp in 11i/R12?

http://abduulwasiq.blogspot.in/2013/04/to-compile-jsp-as-soon-as-you-access.html

38)How to compile invalid object in the database?

               (OR)

How to compile package/procdure and funcation?

Click on the below link to check in details.

http://abduulwasiq.blogspot.in/2013/04/how-to-compile-invalid-objects-with.html

39)what is the diference between ICM,Standard manager and CM in concurrent manager?

Click on the below link to check in details.

http://abduulwasiq.blogspot.in/p/concurrent-manager-issues.html

40)How can you determine if an Oracle instance is up from the operating system level?

[oracle@apps ~]$ ps -ef|grep -i pmon

oracle   26829     1  0 18:18 ?        00:00:00 ora_pmon_PROD

oracle   31937 31839  0 19:18 pts/3    00:00:00 grep -i pmon

[oracle@apps ~]$

41)How to check database listener is up and running  from the operating system level?

[oracle@apps bin]$ ps -ef|grep -i lsnr

oracle   26949     1  0 18:25 ?        00:00:00 /u01/db/tech_st/11.1.0/bin/tnsls nr LISTENER -inherit

oracle   27191 26799  0 19:10 pts/1    00:00:00 grep -i lsnr

42)Where would you look for errors from the database engine?

 alert logfile.

43)How to check how many instances are running in your server?

[oracle@apps ~]$ ps -ef|grep -i pmon|wc -l

5

44)What command would you use to create a backup control file?

SQL> alter database backup controlfile to trace as '/u02/oracle/control.sql';

Database altered.

SQL>

45)How to find the used/free and total size of the database?

SQL> select sum(bytes/1024/1024/1024) "Used size of the db in GB" from dba_segments;

Used size of the db in GB

-------------------------

               28.8906403

SQL> select sum(bytes/1024/1024/1024) "Free size of the db in GB" from dba_free_space;

Free size of the db in GB

-------------------------

               7.14793396

SQL> select sum(bytes/1024/1024/1024) "Total size of the db in GB" from dba_data_files;

Total size of the db in GB

--------------------------

                36.0429077

46)How do you switch from an init.ora file to a spfile?

SQL>create pfile from spfile.

File created.

SQL>

47)How do you add a data file to a tablespace?

How do you resize a data file?

How to add a tempfile?

Click on the below link to check in details.

http://abduulwasiq.blogspot.in/p/fresher-alerts-monitoring.html

48)50)How to check my java version in R12 EBS?

[applmgr@apps US]$ $ORACLE_HOME/jdk/bin/java -fullversion

java full version "1.4.2_14-b05"

[applmgr@apps US]$

49)How to check my forms version in R12 ebs?

[applmgr@apps ~]$ $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

[applmgr@apps ~]$

50)How to check my Apache version in R12 EBS?

[applmgr@apps ~]$ $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server

Server built:   Jul  7 2008 14:58:00

[applmgr@apps ~]$

51)How to check my pl/sql version in R12 EBS?

[applmgr@apps ~]$ $ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

PL/SQL Version 10.1.0.5.0 (Production)

[applmgr@apps ~]$

52)How to check my jre version R12 EBS?

[applmgr@apps ~]$ cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version

sun_plugin_version=1.6.0_07

[applmgr@apps ~]$

53)How to find workflow version in oracle apps R12?

SQL> select TEXT from WF_RESOURCES where

NAME='WF_VERSION';  2

TEXT

--------------------------------------------------------------------------------

2.6.0

54)How to check whether forms are in servlet mode/Socket mode?

By default forms are running in servlet in R12.

[applmgr@apps US]$ grep -i s_frmConnectMode $CONTEXT_FILE

         <forms_connect oa_var="s_frmConnectMode">servlet</forms_connect>

[applmgr@apps US]$

OR

[applmgr@apps US]$ grep connectMode $FORMS_WEB_CONFIG_FILE

connectMode=servlet

[applmgr@apps US]$

[applmgr@apps US]$ cat $FORMS_WEB_CONFIG_FILE|grep serverURL=

serverURL=/forms/lservlet

[applmgr@apps US]$

55)What do we have in FND_NODES?

FND_NODES table contains  information about node_names and services enabled on a node.

In multinode instance if you want to know which node is running what services, You can query the fnd_nodes and get that information.

56)What is the meaning QA,SIT,DEV,UAT,PRE-PROD,PROD Instance?

QA - Tesing Instance

SIT - System Integration Testing

DEV - Developement

UAT- User Acceptence Testing

STAGE - Pre-production Instance

Prod - Production/actuall instance where the business is running.

57)How to verify the sysadmin password from command line?

This utility can be used to verify the GUEST/ORACLE password

SQL>select fnd_web_sec.validate_login('SYSADMIN','<sysadmin_password>')from dual;

If it returns Y then sysadmin password is correct.

If it returns N then sysadmin password is incorrect.

Ex:

SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN123') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN123')

--------------------------------------------------------------------------------

N

SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN')

--------------------------------------------------------------------------------

Y

58)What is the Significancy of US Folder?

It is nothing but language specification by default it is in american language. We can have multiple languages folders  based on installed languages. We can find the details from fnd_languages tables.

FND_LANGUAGES -- COL --INSTALLED_FLAG I,B,D

I--INSTALLED,

B--BASE,

D--DISABLE

select language_code,nls_language from fnd_languages where installed_flag like 'B';

59) What is meant by Custom Top and what is the Purpose?

Custom Top is nothing but Customer Top, which is created for customer only. we can have multiple custom tops based on client requirement. It is used to store developed & customized components. whenever we apply application patches it will over ride on all the modules except custom top. that's why we will use custom top.

 60)What is US folder in the Custom Top?

 It is a language specific folder used to store the G.U.I like reports and forms.

61)How to find latest patchset level for module installed?

select APP_SHORT_NAME, max(PATCH_LEVEL) from AD_PATCH_DRIVER_MINIPKS GROUP BY APP_SHORT_NAME;

 62)What are the tables adpatch will create and when?

 Adpatch will create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table when it will apply d,g and u drivers.

63)I am applying a patch, can I open another session in another node and run adpatch?

No.

64)How you will know what are the files the patch is going to change just my unzipping the patch?

When we unzip a patch it will keep all the files related to a particular product under that directory inside you are patch directory for example if the patch delivering files related to GL product then it will create a sub directory under the patch directory with the name GL in which it will put all related files to that product.

65)What is the significance of backup directory under patch directory?

When we apply a patch it will take the backup of the files which it is going to change during patching and it is done under backup directory of the patch.

66)How to skip copy portion while applying a patch?

 adpatch options=nocopyportion

 67)What is the significance of FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table?

 FND_INSTALL_PROCESSES table will store the worker information like what job is assigned to which worker and its status. AD_DEFERRED_JOBS will come into picture when some worker is failed, it will be moved to AD_DEFERRED_JOBS table, from where again adpatch will take that job and try to resign, after doing this 3 times if still that worker is failing, then adpatch will stop patching and throw the error that particular worker has failed. We need to troubleshoot and restart the worker.

68)What is iAS Patch ?

iAS Patch are patches released to fix bugs associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shipped as Shell scripts & you apply iAS patches by executing Shell script.

69)Where is Concurrent Manager Log file location?

By default standard location is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well.

70)What is adsplice utility?

adsplice in oracle apps is utility to add a new product to EBS.

71) What is GWYUID?

 GWYUID stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB

72) Where GWYUID defined & why is it used in Oracle Applications?

GWYUID is defined in dbc i.e. Database Connect Descriptor file. It is used to connect thin clients to database.

73)  What is difference between GUEST_USER_PWD (GUEST/ORACLE) & GWYUID?

GUEST_USER_PWD(Guest/Oracle) is used by JDBC Thin Client where as GWYUID is used by Thick Clients like via Forms Connections.

74)What is the executable to generate jar files?

adjava

75)How do you relink an executable of a product?

By relinking option in adadmin or adrelink

76)  How do you relink AD product executable and usage?

adrelink.sh and adrelink.sh force=y "ad adsplice"

 77) When do you relinking?

When you miss an executable file.

When there is a problem with any executable file.

When any product executable gets corrupted.

78)How do you know whether apps listener is up or not?

[applmgr@apps scripts]$ lsnrctl status APPS_PROD

LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 13-MAY-2013 10:43:03

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=apps)(Port=1626))

STATUS of the LISTENER

------------------------

Alias                     APPS_PROD

Version                   TNSLSNR for Linux: Version 10.1.0.5.0 - Production

Start Date                13-MAY-2013 10:35:35

Uptime                    0 days 0 hr. 7 min. 28 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u02/inst/apps/PROD_apps/ora/10.1.2/network/admin/list ener.ora

Listener Log File         /u02/inst/apps/PROD_apps/logs/ora/10.1.2/network/apps_ prod.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.user.com)(PORT=1626)))

Services Summary...

Service "FNDFS" has 1 instance(s).

  Instance "FNDFS", status UNKNOWN, has 1 handler(s) for this service...

Service "FNDSM" has 1 instance(s).

  Instance "FNDSM", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[applmgr@apps scripts]$

OR

[applmgr@apps scripts]$ adalnctl.sh status

adalnctl.sh version 120.3

Checking status for listener process APPS_PROD.

LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 13-MAY-2013 10:45:02

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=apps)(Port=1626))

STATUS of the LISTENER

------------------------

Alias                     APPS_PROD

Version                   TNSLSNR for Linux: Version 10.1.0.5.0 - Production

Start Date                13-MAY-2013 10:35:35

Uptime                    0 days 0 hr. 9 min. 26 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u02/inst/apps/PROD_apps/ora/10.1.2/network/admin/listener.ora

Listener Log File         /u02/inst/apps/PROD_apps/logs/ora/10.1.2/network/apps_prod.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.user.com)(PORT=1626)))

Services Summary...

Service "FNDFS" has 1 instance(s).

  Instance "FNDFS", status UNKNOWN, has 1 handler(s) for this service...

Service "FNDSM" has 1 instance(s).

  Instance "FNDSM", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /u02/inst/apps/PROD_apps/logs/appl/admin/log/adalnctl.txt for more information ...

[applmgr@apps scripts]$

79)How to start apps listener?

syntax:lsnrctl <options> APPS_SID

[applmgr@apps scripts]$ lsnrctl start APPS_PROD

LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 13-MAY-2013 10:46:13

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting /u02/apps/tech_st/10.1.2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.5.0 - Production

System parameter file is /u02/inst/apps/PROD_apps/ora/10.1.2/network/admin/listener.ora

Log messages written to /u02/inst/apps/PROD_apps/logs/ora/10.1.2/network/apps_prod.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.user.com)(PORT=1626)))

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=apps)(Port=1626))

STATUS of the LISTENER

------------------------

Alias                     APPS_PROD

Version                   TNSLSNR for Linux: Version 10.1.0.5.0 - Production

Start Date                13-MAY-2013 10:46:13

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u02/inst/apps/PROD_apps/ora/10.1.2/network/admin/listener.ora

Listener Log File         /u02/inst/apps/PROD_apps/logs/ora/10.1.2/network/apps_prod.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.user.com)(PORT=1626)))

Services Summary...

Service "FNDFS" has 1 instance(s).

  Instance "FNDFS", status UNKNOWN, has 1 handler(s) for this service...

Service "FNDSM" has 1 instance(s).

  Instance "FNDSM", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[applmgr@apps scripts]$

80)what are the two tables will create while applying the patches?

FND_INSTALL_PROCESSES and AD_DEFERED_JOBS

81)How do you know whether concurrent manager is up and running?

 [applmgr@apps scripts]$ ps -fu applmgr|grep -i fnd|wc -l

      12

 [applmgr@apps scripts]$

  82)List some ad utilities and their functions?

  adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker.

  83)How to find patch level of product or minipack level?

  select application_id,oracle_id,patch_level from fnd_product_installations where patch_level like '%GL%';

  84)When we use hot patch?

  if we want to apply adpatch without enabling maintenance mode.

  85)When do you run preclone on producton?

  if any changes made to either techstack,database or any patches are applied.

 86)Are the existing DB connections dropped if the DB listener is restarted ?

No existing users will be able to continue their work. Any new connection will not be able to go through.

87)Whats the need to adpreclone.pl?

ADPRECLONE is a feature provided in Oracle Applications 11i/R12 to clone the system i.e create a replica of source system for testing purpose.

ADPRECLONE — Used as a pre-requisite before starting the cloning procedure

adpreclone creates a staging directory under $COMMON_TOP

for e.g : $COMMON_TOP/clone

adpreclone.pl captures all the drivers and templates required to clone the target system using the source systems information.

88)Suppose we need to apply AR and AP patches – can we merge the patches together and apply ?

Yes we can merge them and apply as they belong to the same family ( Finance Module ).

89)FNDFS and FNDSM – Difference and whats the significance?.

FNDFS — Also known as RRA(Report Review Agent) is the default text viewer within Oracle Applications, which allows users to view report output and log files.

FNDSM — Executable and a service required for GSM(Generic Service Management). It is initiated by starting Oracle Apps Listener.

90)Which table stores the Application URL ? (http://hostname.domain.port)?

SQL> select home_url from icx_parameters;

HOME_URL

--------------------------------------------------------------------------------http://apps.user.com:8000/OA_HTML/AppsLogin

SQL>

91)What is APPLSYSPUB ?

Applsyspub schema is responsible for password checking.The default password is pub.Applsyspub is used for authentication by having read only views.

92) Which two parameters are required when we do clone using RMAN ?

db_file_name_convert and log_file_name_convert.

93) What is APPS and APPLSYS users ?

APPS :

======

 Owns all the applications code in thedatabase. APPS Schema Contains Synonyms to the objects of All Products (AP,AR, GLetc ) and Triggers, views, packages, procedures, functions but the owner of all GL tables is GL user , AP tables is AP , and AR tables is AR Schema. Apps is a schema which does not contain any tables of itself. The default password is apps.

APPLSYS  :

==========

Applsys schema contains all the tables required for administarative purpose. The default password is apps.

APPLSYS schema contains shared APPS foundation objects like FND,AD,WF related data like tables and Indexes.

94)Why do we keep the same password for APPS & APPLSYS ?

This is required during Oracle Applications Login. The process is as follows :

a) Initial Sign on (http://hostname.domain.com:port)

This uses APPLSYSPUB schema to authenticate and validate AOL username & password (OPERATIONS/WELCOME using GUEST user account).

Once this aunthentication is validated successfully we get to see the responsibility page.

b) Selecting the assigned responsbility requires APPLSYS schema validation and then it connects to APPS schema.

c) Since it uses both applsys and apps during signon process this expects both the password to be identical. Try changing apps password to something else and try to login, the validation at the last stage would fail.

95)What would happen if you change the passwords for APPS, APPLSYS with “alter user” command?.

Changing the apps password using “alter user” corrupts the password

Oracle Application stores passwords in FND_USER and FND_ORACLE_USERID

Column Value Keys

FND_USER APPS password username/password

FND_ORACLE_USERID user password APPS password

The APPLSYS.FND_ORACLE_USERID table contains all the Oracle Applications related database accounts – there is one database account for each Oracle Applications module (i.e., GL = General Ledger). The application needs access to these database schemas to perform various functions, thus it must have access to the database account password. All the passwords in the FND_ORACLE_USERID table are encrypted using the APPS password as the key.

Thus changing the password using “Alter User” command will not reflect the password in FND_ORACLE_USERID.

96)How to clean fnd_nodes table?

 exec fnd_conc_clone.setup_clean;

97)Where custom top information will be there ?

/u01erpapp/appl/APPLSYS.env file.

98)After applying patch why we need to take snapshot and what is the use of it ?

Snapshot is a view of the system at specific time. In apps, Patch Wizard uses Global snapshot to determine which patches have been applied to the system and Autopatch uses APPL_TOP snapshot to determine what patches have been applied to that APPL_TOP.

Snapshot actually records the list of files,file versions and bug fixes. Both snapshot are views, they are created once during installation and then updated during patching. APPL_TOP snapshot information is stored in the AD_SNAPSHOTS, AD_SNAPSHOT_FILES, and AD_SNAPSHOT_BUGFIXES tables.

99)what happen after running adcfgclone.pl?

it will take input and build xml file.

after building xml file,it runs autoconfig.

It register the ORACLE_HOME with GLOBAL INVENTORY.

Note: it is not going to update the inventory incase of manual clone.

100)Why we need to put maintenance mode when we are applying a patch ?******

pre requisite to apply a patch.

Oracle recomendation.

To improve the performance by minimizing the down time.

=========

Enabling the maintenance mode feature shuts down the Workflow Business Events System and sets up function security so that no Oracle Applications functions are available to users. Used only during AutoPatch sessions, maintenance mode ensures 

optimal performance and reduces downtime when applying a patch. 

  Main reason:

  Meta link id [ID 233044.1]  ==> check for heading Maintenance Mode

102)How to Compile JSP’s without using adadmin in oracle application 11i?

perl -x $JTF_TOP/admin/scripts/ojspCompile.pl –-compile

103)When we required to compile a menu?

when we change menu.

104)How database knows which pre requsite patch to apply?

b<patch number>.ldt which tells the database to apply the pre requisite patch.

105)How do we know impact of the patch?

check for .lgi file.

cd $APPL_TOP/admin/SID/log.

106)How worker fails?

unable to find the target object.

space issue in object.

locks in any object.

if any invalid.

If the worker creating an object, but already exists.

Login information is incorrect.

107)How do we compile a specific schema in oracle apps?

syntax: @$AD_TOP/sql/adcompsc.sql <username> <password>%

108)How do we migrate concurrent programs from dev to production?

FNDLOAD.

Workflow related components we use WFLOAD.

109)How can we skip a worker?

BY using adctrl ==>8th hidden options.

110)what is the reason for the workers to be running long?

May be locks on the object.

111)can we skip running workers?

Yes,but it is not recommended.

112)why adconfig.txt changes?

When we run autoconfig.

when we apply any technology related patches.

113)How can we change the structure of oracle apps?

By applying the patches.

114)How can we generate dbc file?.

By running autoconfig.

cd $INST_TOP/admin/install

By executing a file adgendbc.sh file.

Its better to run adgendbc.sh file as it will take less than a minute to create dbc file where as autoconfig will take more than 5mins.

As a dba we have to save the time.

115) What is forms server executable Name ?

f60srvm

116)How to check number of forms users at any time ?

Forms Connections initiate f60webmx connections so you can use

[applmgr] ps -ef | grep f60webmx | wc -l

10

117)What are .odf file in apps patch ?

odf stands for Object Description Files used to create tables & other database objects.

118)What is GWYUID ?

GWYUID , stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB

119)Where GWYUID defined & what is its used in Oracle Applications ?

GWYUID is defined in dbc i.e. Database Connect Descriptor file . It is used to connect to database by thin clients.

120)What is consilidated patch?

Consolidated patches will come into pictures after upgrades from one version of applications to anoter, all post upgrade patches will a consolidated and given as 

consolidated patch.

121)What are the table u r adpatch will create and when?

Adpatch will create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table when it will apply d,g and u drivers

122)Which table you will query to check the temp tablespace space issues?

 dba_temp_files

123)In how many phases autoconfig will run?

 Autoconfig will run in 3 phases.

1.INIT – Instantiate the drivers and templates

2.SETUP – Fill the templated with values from xml and create files

3.PROFILE – Update the profile values in database.

124)Is it possiable to restore a autoconfig run?

Partially. Adconfig will create a restore.sh script at $APPL_TOP/admin//out/. This restore.sh will copy the backed up files before autoconfig run to its original 

locations. But the profile values updated in the database can’t be restored back.

125)How to run autoconfig in test mode?

 adchkcfg.sh script at AD_TOP/bin. This script will run autoconfig in test mode and create the difference file which tells us what is going to change , when u actually 

run autoconfig.

126)What is “compile apps schema” option in adadmin?

It will compile the invalid database objects.

127)How to enable trace at database level?

 set init.ora parameter sql_trace

128)How to enable trace for a session?

 Alter system set sql_trace=true;

Execute the sql query

Alter system set sql_trace=false;

This will create a trace file at

$RDBMS_ORACLE_HOME/admin/contextname/udump with the spid of the current sql session.

129)What is a database link? How to create it?

If we want to access objects of another database from this database then we need a database link from this database to the other.

1.Login as oracle user

2.sqlplus “/as sysdba”

3. create database link connect to identified by using ”;

Ex

SQL> create database link DEV1_TO_DEV2 connect to apps identified by apps using ‘DEV2';

Database link created.

SQL> select name from v$database@ DEV1_TO_DEV2;

NAME

———

DEV2

SQL>select db_link from dba_db_links;

4. Add destination database tns entry in tnsnames.ora

130)What is formserver url?

http://hostname.domain:/dev60cgi/f60cgi

131)What is jinitiator?

Oracle jinitiator is the one which provide the required jvm to run forms interface/applet. When we access forms applet first time , oracle jinitiator will be installed automatically.

132)What is adsplicer?

 Adsplicer is a uitility used to register off cycle products.

133)What is licence manager?

Licence manager(adlicmgr) utility is used to licence/unlicence , enable new languages,enbale country specific functionality.

134)What is tnsping?

tnsping is command used to check the connectivity to the database server node from other nodes.

135)How to find out oracle application framework version?

 1. Through aoljtest

2. cd $COMMON_TOP/html/

3. adident Header OA.jsp

136)What is the command line utility to submit a concurrent request?

 CONSUB

137)How to find out whether a language patch is applied for a particular patch?

Query ad_patch_driver_langs.

138)How to validate that sysadmin password is correct or not from backend?

select fnd_web_sec.validate_login(‘SYSADMIN’,'Pa66word') from dual;

139)How to findout XML Parser Version?

SQL> select WF_EVENT_XML.XMLVersion() XML_VERSION from sys.dual;

140)can you apply a patch without putting oracle application in maintenance mode 11i/r12?
Yes,we can using adpatch optoins=hotpatch

141)How to start the apache server?

 adapcctl.sh start

142)What happens when you delete alert log file?

[oracle@devuser bdump]$ ls -ltrh alert*.log
-rw-r-----  1 oracle dba 45K Feb 22 15:21 alert_PROD.log

Now i will remove alert logfile.

[oracle@devuser bdump]$ rm alert_PROD.log

let's do something so that it will write to alert log file.

[oracle@devuser bdump]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 22 15:23:53 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area  188743680 bytes
Fixed Size                  1218412 bytes
Variable Size              67111060 bytes
Database Buffers          113246208 bytes
Redo Buffers                7168000 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Now check alert logfile it will get created.

[oracle@devuser bdump]$ ls -ltrh *.log
-rw-r--r--  1 oracle dba 4.5K Feb 22 15:24 alert_PROD.log
[oracle@devuser bdump]$

143)Which process will write to alert logfile?

Server process.

144)How to check whether your database startup with the pfile or spfile  ?


SQL> startup
ORACLE instance started.

Total System Global Area  188743680 bytes
Fixed Size                  1218412 bytes
Variable Size              67111060 bytes
Database Buffers          113246208 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/home/oracle/product/10.2.
                                                 0/db_1/dbs/spfilePROD.ora

SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/home/oracle/product/10.2.
                                                 0/db_1/dbs/spfilePROD.ora
SQL>

You can also check by usin below command

SQL> select name,value from v$parameter2 where name like '%spfile%';

NAME                                                                             VALUE
-------------------------------------------------------------------------------- --------------------------------------------------
spfile                                                                           /u01/home/oracle/product/10.2.0/db_1/dbs/spfilePRO
                                                                                 D.ora

145)How to put the database in archivelog mode ?


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area  188743680 bytes
Fixed Size                  1218412 bytes
Variable Size              67111060 bytes
Database Buffers          113246208 bytes
Redo Buffers                7168000 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


[oracle@devuser bdump]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 22 15:26:49 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/home/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     0
Current log sequence           1

To put the database in archive log mode use below command.

SQL> alter database archivelog;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/home/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     0
Next log sequence to archive   1
Current log sequence           1

Also you can check with below commands.

SQL> select archiver from v$instance;

ARCHIVE
-------
STARTED

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

146)How to change the dbid ?

1)shutdown immediate
2)startup mount
3) os level nid target=/ (/ means operating system authentication or sysdba privileges)

Current dbid is 219858109.

SQL> select name,dbid from v$database;

NAME            DBID
--------- ----------
EBSOFDP    219858109

SQL>

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.
Total System Global Area  188743680 bytes
Fixed Size                  1218412 bytes
Variable Size              67111060 bytes
Database Buffers          113246208 bytes
Redo Buffers                7168000 bytes
Database mounted.
SQL>

nid is utility to change the dbid/dname .for help use nid help=y.
TO change dbid/dbname you need to have sysdba privileges.

[oracle@devuser PROD]$ nid help=y

DBNEWID: Release 10.2.0.1.0 - Production on Fri Feb 22 18:00:31 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Keyword     Description                    (Default)
----------------------------------------------------
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO

[oracle@devuser PROD]$ nid target=/

DBNEWID: Release 10.2.0.1.0 - Production on Fri Feb 22 18:00:41 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to database EBSOFDP (DBID=219858109)

Connected to server version 10.2.0

Control Files in database:
    /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control01.ctl
    /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control02.ctl
    /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control03.ctl

Change database ID of database EBSOFDP? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 219858109 to 631773769
    Control File /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control01.ctl - modified
    Control File /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control02.ctl - modified
    Control File /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control03.ctl - modified
    Datafile /u01/home/oracle/product/10.2.0/db_1/PROD/system01.dbf - dbid changed
    Datafile /u01/home/oracle/product/10.2.0/db_1/PROD/undotbs01.dbf - dbid changed
    Datafile /u01/home/oracle/product/10.2.0/db_1/PROD/sysaux01.dbf - dbid changed
    Datafile /u01/home/oracle/product/10.2.0/db_1/PROD/users01.dbf - dbid changed
    Datafile /u01/home/oracle/product/10.2.0/db_1/PROD/temp01.dbf - dbid changed
    Control File /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control01.ctl - dbid changed
    Control File /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control02.ctl - dbid changed
    Control File /u01/home/oracle/product/10.2.0/db_1/ebsofdp/control03.ctl - dbid changed
    Instance shut down

Database ID for database EBSOFDP changed to 631773769.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.


above steps are very important which are highlighted in yellow color and in pink .

[oracle@devuser PROD]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 22 18:01:49 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  188743680 bytes
Fixed Size                  1218412 bytes
Variable Size              62916756 bytes
Database Buffers          117440512 bytes
Redo Buffers                7168000 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/home/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           1

Now dbid changed successfully.

SQL> select name,dbid from v$database;

NAME            DBID
--------- ----------
EBSOFDP    631773769

SQL>1)shutdown immediate

2)startup mount
3) os level nid target=/ (/ means operating system authentication or sysdba privileges)

Current dbid is 219858109.

SQL> select name,dbid from v$database;

NAME            DBID
--------- ----------
EBSOFDP    219858109

SQL>

147)what are different modes of forms in which you can start form server and which is the default in oracle apps 11i/R12?

There are two modes of forms.
1)Servlet
2)Socket

We can switch from servlet to socket and socket to servlet and it depends on the business what they
like it.

By defalut forms are running in servlet mode in oracle apps R12.

Can we create Tables in the Apps Schema?

How to confirm if report server is up and running?

what are the varios option available with adpatch?

what is load balancing?

what is oraInventory?

where is OraInst.loc file located?

what is the admin server?

how do you apply the patch?and what are the steps?

what is APPLCSF means?

what is the location of dbc file?

where is the adpatch logfile?

how you will apply a patch when it is not in maintenance mode?

where to check for log files after autoconfig is executed?

How to find OUI version?