Oracle Apps : Oracle Apps Basics

5)How to check jdbc connection?

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

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.

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

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>

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.

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

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

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]$

[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')

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

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

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

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

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

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]$

[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

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

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

[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.

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.

112)why adconfig.txt changes?

When we run autoconfig.

when we apply any technology related patches.

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.

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.

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

which proces writes to alert log
server process

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

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

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

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?

Oracle Apps

Menu

Thursday, April 19, 2018

Oracle Apps Basics

No comments:

Post a Comment

Contributors