FNDCPASS:

http://www.shaiksameer.com/2012/07/r12-fndcpass-change-apps-sysadmin.html

http://balaoracledba.com/2014/05/15/r12-2-changing-apps-or-applsys-password-on-r12-2-instance/


How to change the Forms Server mode from Servlet to Socket Mode:

http://balaoracledba.com/2013/10/29/forms-servlet-mode-to-socket-mode-release-12-apps/


Concurrent Manager Issues:

http://balaoracledba.com/category/oracleappsr12/issues/concurrent-manager/

Refreshing Vs Cloning

Refreshing VS Cloning an e-Business Suite Environment

Just a quick note on refreshing vs cloning, what each of them means and when you should perform them.

What is Refreshing?

A refresh is where the data in the target environment has been synchronized with a copy of production. This is done by taking a copy of the production database and restoring it to the target environment.

What is Cloning?

Cloning means that an identical copy of production has been taken and restore to the target environment. This is done by taking both a copy of the production database as well as all of the application files.

When should you Clone or Refresh?

There are a couple of scenarios when cloning should be performed:

1. Building a new environment.
 
2. Patches or other configuration changes have been made to the target environment so that they are now out of sync.

3. Beginning of development cycles. Before major development efforts take place, its wise to re-clone dev, test environments so that your 100% positive that the environments are in sync.

There is only one scenario in which you should refresh an environment:

1. Your 100% confident that the environments are in sync and need an updated copy of the production data in order to reproduce issues.

Technically, if proper change control processes are being followed, test and production environments should be identical. So in the case of test, you should be able to get away with performing refreshes. However, to ease concerns and for comfort levels, test environments are usually re-cloned at the beginning of new development cycles as well.

Refresh the cloned apps

http://muneer2908.wordpress.com/2011/01/04/oracle-apps-cloning-refreshing-single-instance-test-database-with-rac-production-data/




http://muneer2908.wordpress.com/2011/01/04/oracle-apps-cloning-refreshing-single-instance-test-database-with-rac-production-data/

File System ARCHITECTURE

R12  File System COMPLETE ARCHITECTURE

INST_TOP in R12

INST TOP directory:

(applmgr) - ls
 

 admin/ appl/ certs/ logs/ ora/ out/ pids/ portal/ rgf/
 

(applmgr) -

The Whys and wherefores:

You may get a question why is the change??

There is a need to separate

Code
Data
Config

To ease maintenance of the system. To avoid NFS/MUTEX related issues. Above issue will get resolved if the configuration/lcck files are stored in local system. Another advantage is to gain performance accessing local file system is better than NFS file system.

This directory $INST_TOP got introduced newly in R12. Instance top contains all the config files, log files, ssl certificates, document root etc. Addition of this directory makes the middle-tier more organised, since data is kept separate from config/log files. Another advantage is that, multiple instances can easily share the same middle tier. To create a new instance that shares an existing middle-tier, just create a new instance_top with proper config files and NFS mount the middle tier in the server.

INSTANCE TOP - STRUCTURE
$INST_TOP: APPS_BASE/inst/apps/CONTEXT_NAME/
/admin
/scripts	ADMIN_SCRIPTS_HOME: Find all AD scripts here
/appl	APPL_CONFIG_HOME. For standalone envs, this is set to $APPL_TOP
/fnd/12.0.0/secure	FND_SECURE: dbc files here
/admin	All Env Config files here
/certs	SSL Certificates go here
/logs	LOG_HOME: Central log file location. All log files are placed here (except adconfig)
/ora	ORA_CONFIG_HOME
/10.1.2	'C' Oracle home config, Contains tnsnames and forms listener servlet config files
/10.1.3	Apache & OC4J config home, Apache, OC4J and opmn This is the 'Java' oracle home configuration for OPMN, Apache and OC4J
/pids	Apache/Forms server PID files here
/portal	Apache's DocumentRoot folder

AD SCRIPTS
$ADMIN_SCRIPTS_HOME: $INST_TOP/admin/scripts
adautocfg.sh	run autoconfig
adstpall.sh	stop all services
adstrtal.sh	start all services
adapcctl.sh	start/stop/status Apache only
adformsctl.sh	start/stop/status OC4J Forms
adoacorectl.sh	start/stop/status OC4J oacore
adopmnctl.sh	start/stop/status opmn
adalnctl.sh	start/stop RPC listeners (FNDFS/FNDSM)
adcmctl.sh	start/stop Concurrent Manager
gsmstart.sh	start/stop FNDSM
jtffmctl.sh	start/stop Fulfillment Server
adpreclone.pl	Cloning preparation script
adoafmctl.sh	adoafmctl.sh to start/stop/status OC4J oafm (webservice, mapviewer)
adexecsql.pl	Execute sql scripts that update the profiles in an AutoConfig run
java.sh	Call java executable with additional args, (used by opmn, Conc. Mgr)

LOG FILES
Location of various log files
AD Script log files (adapcctl.sh,...)	$INST_TOP/logs/appl/admin/log
CM Log Files ($APPLCSF/$APPLLOG)	$INST_TOP/logs/appl/conc/log
AD tools log files (adpatch, ...)	$APPL_CONFIG_HOME/admin/$TWO_TASK/log
OPMN Log Files (Text & ODL)	$INST_TOP/logs/ora/10.1.3/opmn
Apache Log Files (Text & ODL)	$INST_TOP/logs/ora/10.1.3/Apache
OC4J Log Files (Text)	$INST_TOP/logs/ora/10.1.3/j2ee/oacore/
OC4J Log Files (ODL)	$INST_TOP/logs/ora/10.1.3/j2ee/oacore/log/oacore_default_group_1/oc4j

SSL CERTIFICATES
$INST_TOP/certs
/Apache/ewallet.p12
/opmn/cwallet.sso
/opmn/ewallet.p12
certs is the default directory for SSL or any other certificate files used by this instance. To use a centrally staged certificate, change the appropriate context file and run autoconfig

All DBA Views

 DBA Views 

Storage Information

DBA_EXTENTS, DBA_FREE_SPACE, DBA_OBJECTS,

DBA_OBJECT_SIZE, DBA_SEGMENTS, DBA_TABLESPACES,

DBA_ROLLBACK_SEGS, DBA_UNDO_EXTENTS

Operating System

DBA_DATA_FILES, DBA_EXP_FILES, DBA_TEMP_FILES

Privileges

DBA_COL_PRIVS, DBA_PROFILES, DBA_ROLES,

DBA_ROLE_PRIVS, DBA_SYS_PRIVS, DBA_TAB_PRIVS,

DBA_UPDATABLE_COLUMNS

Indexes

DBA_INDEXES, DBA_IND_COLUMNS,

DBA_IND_EXPRESSIONS, DBA_IND_PARTITIONS

Tables/Views

DBA_TABLES, DBA_TAB_COLUMNS, DBA_TAB_PARTITIONS,

DBA_TAB_COMMENTS,

DBA_UNUSED_COL_TABS, DBA_VIEWS

Constraints

DBA_CONSTRAINTS, DBA_CONS_COLUMNS

Triggers

DBA_TRIGGERS, DBA_TRIGGER_COLS,

DBA_INTERNAL_TRIGGERS

Materialized Views

DBA_MVIEW_AGGREGATES, DBA_MVIEW_ANALYSIS,

DBA_MVIEW_DETAIL_RELATIONS, DBA_MVIEW_JOINS,

DBA_MVIEW_KEYS

Partitions

DBA_PART_COL_STATISTICS, DBA_PART_HISTOGRAMS,

DBA_PART_INDEXES, DBA_PART_KEY_COLUMNS,

DBA_PART_LOBS, DBA_PART_TABLES,

DBA_IND_SUBPARTITIONS, DBA_LOB_PARTITIONS,

DBA_LOB_SUBPARTITIONS

Objects, Methods and Types

DBA_OBJECT_TABLES, DBA_METHOD_PARAMS,

DBA_METHOD_RESULTS, DBA_TYPES, DBA_TYPE_ATTRS,

DBA_TYPE_METHODS, DBA_DIMENSIONS, DBA_LOBS

Operators

DBA_OPANCILLARY, DBA_OPARGUMENTS,

DBA_OPBINDINGS, DBA_OPERATORS

Summaries

DBA_SUMMARIES, DBA_SUMMARY_AGGREGATES,

DBA_SUMMARY_DETAIL_TABLES, DBA_SUMMARY_JOINS,

DBA_SUMMARY_KEYS

Miscellaneous

DBA_DB_LINKS, DBA_SOURCE, DBA_SEQUENCES,

DBA_SYNONYMS, DBA_USERS, DBA_OUTLINES,

DBA_JOBS, DBA_JOBS_RUNNING, DBA_LIBRARIES,

DBA_PENDING_TRANSACTIONS, DBA_RULESETS,

DBA_OUTLINE_HINTS, DBA_POLICIES,

DBA_SUBPART_KEY_COLUMNS, DBA_TS_QUOTAS,

DBA_JAVA_POLICY, USER_JAVA_POLICY

Dynamic Performance Views

Instance Level Tuning

v$GLOBAL_TRANSACTION, v$OBJECT_DEPENDENCY,

 v$SHARED_POOL_RESERVED, v$SORT_SEGMENT,

v$SYSTEM_CURSOR_CACHE, v$SORT_USAGE, v$STATNAME,

v$SYSSTAT, v$SYSTEM_EVENT, v$TRANSACTION, v$LATCH,

v$LIBRARYCACHE, v$ROLLSTAT, v$ROWCACHE,

vRSGASTAT, v$SQLAREA, v$SQLTEXT, v$WAITSTAT

Recovery Based Views

v$ARCHIVE, v$ARCHIVE_DEST, v$BACKUP_CORRUPTION,

v$BACKUP_DEVICE, v$BACKUP_REDOLOG,

v$DELETED_OBJECT, v$RECOVERY_LOG, v$RECOVER_FILE,

v$ARCHIVED_LOG, v$BACKUP, v$BACKUP_DATAFILE,

v$BACKUP_PIECE, v$BACKUP_SET,

v$RECOVERY_FILE_STATUS, v$RECOVERY_STATUS,

v$DATABASE_BLOCK_CORRUPTION,

v$DATABASE_INCARNATION

Cache Views

v$CACHE, 

v$LIBRARYCACHE, 

v$SUBCACHE,

v$DB_OBJECT_CACHE, 

v$ROWCACHE

Control File Views

v$CONTROLFILE, 

v$CONTROLFILE_RECORD_SELECTION

Cursor and SQL Views

v$SYSTEM_CURSOR_CACHE, v$OPEN_CURSOR, v$SQLAREA,

v$SQL, v$SQLTEXT, v$SQLTEXT_WITH_NEWLINES,

v$SQL_CURSOR, v$SQL_BIND_METADATA,

v$SQL_SHARED_MEMORY, v$SQL_BIND_DATA,

v$SQL_WORKAREA, v$SQL_WORKAREA_ACTIVE

Security Views

v$ENABLEDPRIVS, v$PWFILE_USERS

Session Views

v$ACCESS, v$MYSTAT, v$PROCESS, v$SESSION ,

v$SESSION_CONNECT_INFO, v$SESSION_CURSOR_CACHE,

v$SESSION_EVENT, v$SESSION_LONGOPS,

v$SESSION_OBJECT_CACHE, v$SESSION_WAIT, v$SESSTAT

(needs v$statname, v$session join), v$SESS_IO

Latch and Lock Views

v$BUFFER_POOL, v$CACHE_LOCK, v$CLASS_PING,

v$DLM_CONVERT_LOCAL, v$DLM_CONVERT_REMOTE,

v$DLM_LATCH, v$DLM_MISC, v$ENQUEUE_LOCK,

v$EVENT_NAME, v$FALSE_PING, v$FILE_PING, v$LATCH,

v$LATCHHOLDER, v$LATCHNAME, v$LATCH_CHILDREN,

v$LATCH_MISSES, v$LATCH_PARENT, v$LOCK,

v$LOCK_ACTIVITY, v$LOCK_ELEMENT, v$LOCKED_OBJECT,

v$LOCKS_WITH_COLLISIONS, v$PING, v$RESOURCE,

v$RESOURCE_LIMIT, v$TRANSACTION_ENQUEUE, v$LOCK

Instance Views

v$ACTIVE_INSTANCES, v$BGPROCESS, v$BH,

v$COMPATIBILITY, v$COMPATSEG, v$COPY_CORRUPTION,

v$DATABASE, v$DATAFILE, v$DATAFILE_COPY,

v$DATAFILE_HEADER, v$DBFILE, v$DBLINK, v$DB_PIPES,

v$INSTANCE, v$LICENSE, v$OFFLINE_RANGE, v$OPTION,

v$ROLLSTAT, v$SGA, v$SGA_STAT, v$TABLESPACE,

v$TRANSACTION, v$UNDOSTAT, v$VERSION

Fixed Views

v$FIXED_TABLE, v$FIXED_VIEW_DEFINITION,

v$INDEXED_FIXED_COLUMN

Miscellaneous Views

v$TIMER, v$TYPE_SIZE, v$SEQUENCES

MTS and Parallel Server Views

v$CIRCUIT, v$DISPATCHER, v$DISPATCHER_RATE, v$MTS,

v$QUEUE, v$REQDIST, v$SHARED_SERVER, v$THREAD

File Mapping

v$MAP_LIBRARY, v$MAP_FILE, v$MAP_FILE_EXTENT,

v$MAP_ELEMENT, v$MAP_EXT_ELEMENT,

v$MAP_SUBELEMENT, v$MAP_COMP_LIST,

v$MAP_FILE_IO_STACK

How to Apply an 11i Patch When adpatch is Already Running

How to Apply an 11i Patch When adpatch is Already Running

 

1. Using the adctrl utility, shutdown the workers.

a. adctrl
b. Select option 3 "Tell worker to shutdown/quit"

2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema

a. sqlplus applsys/
b. create table fnd_Install_processes_back
as select * from fnd_Install_processes;
c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes_back;
select count(*) from fnd_Install_processes;

3. Backup the AD_DEFERRED_JOBS table.

a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS_back as select * from AD_DEFERRED_JOBS;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;

4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory.
At this point, the adpatch session should have ended and the cursor should
be back at the Unix prompt.
a. cd $APPL_TOP/admin/
b. mv restart restart_back
c. mkdir restart

5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. drop table FND_INSTALL_PROCESSES;
c. drop table AD_DEFERRED_JOBS;

6. Apply the new patch.

7. Restore the .rf9 files located in $APPL_TOP/admin//restart_back
directory.

a. cd $APPL_TOP/admin/
b. mv restart restart_
c. mv restart_back restart

8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS
schema.

a. sqlplus applsys/
b. create table fnd_Install_processes
as select * from fnd_Install_processes_back;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes;
select count(*) from fnd_Install_processes_back;

9. Restore the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS
as select * from AD_DEFERRED_JOBS_back;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;

10. Re-create synonyms

a. sqlplus apps/apps
b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;
c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;

11. Start adpatch, it will resume where it stopped previously.

Note:175485.1

Oracle Apps DBA Interview Questions

              ARCHITECTURE RELATED QUESTIONS

Q)  What is session time out parameter & where all you define     these values?

Q)  How to determine Oracle Apps 11i Version?
 

Q)  What is your Oracle Apps 11i Webserver Version and how to find it ?            
 

Q)  What is forms server executable Name?
 

Q)  What is forms client executable Name?
 

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

Q)  What are different modes of forms in which you can start Forms Server and which one is default ?
 

Q)  Where is HTML Cache stored in Oracle Apps Server?
 

Q)  How will you find Invalid Objects in database ?
 

Q)  What is make program in Unix?
 

Q)  How can u change the log files location suppose CM log file location is APPLCSF
 

Q)  Conflict resolution managers resolves the conflicts yes, but hw it knows that there are conflicts ? why conflicts occur?
 

Q)  What is adovars.env file ?
 

Q)  Whats main concurrent Manager types.
 

Q)  Why should Apps & Applsys passwords always be the same ?
 

Q)  Explain Architecture of Oracle Apps 11i.
 

Q)  What are various components in Application/Middle Tier.   
 

Q)  Where is Concurrent Manager log file location.
 

Q)  Where is applications start/stop scripts stored ?
 

Q)  What are main configuration files in Web Server (Apache)?
 

Q)  What is use of Apps listener ?
 

Q)  How to start Apps listener ?
 

Q)  Whats is difference between two env files in <CONTEXT_NAME>.env and APPS<CONTEXT_NAME>.env under $APPL_TOP ?
 

Q)  How to confirm if Report Server is Up & Running ?
 

Q)  How to confirm if Apps Listener is Up & Running ?
 

Q)  Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored & why its used ?
 

Q)  What is .dbc file, where its stored, what’s use of .dbc file?

====================================================================================

             HOW TO FIND THE VERSIONS OF EBS COMPONENTS


1): How to find Forms Version in 11i ?
2): How to find Forms Version in Apps from command Line ?
3): How to find Jinitiator Version ?
4): How to find Version of any file in Oracle Apps 11i ?
5): How to find Operation System Version (Unix/Linux) ?
6): How to find if your Operating System is 32 bit or 64 Bit ?
7): Can I run 64 bit application on 32 bit Operating system ?
 

8) How to find if your database is 32 bit or 64 bit(Useful in applying Patches) ?
 

9): How to find OUI version ?
10): How to find Database version ?
11): How to find Oracle Workflow Cartridge Release Version ?
12): Determining the Current Version of OJSP ?
13): How to find opatch Version ?
14): How to find Version of Apps 11i ?
15): How to Discoverer Version installed with Apps ?
16): How to find Workflow Version embedded in Apps 11i ?
17): How to find version of JDK Installed on Apps ?
18): How to find out version of a package ?
19):How to find the database/sqlplus version?
      Ans : select banner from v$version;
20):How to find out what are the languages enabled in u r        applications?
     Ans : Query fnd_languages

kishoreappsdba.blogspot.in 

---కిషోర్ 

Important PRODUCT_TOPS and respective Directories

This Bloom Box for you people

Hai
 
    This is B. Venkata Kishore , Am the new Blogger.


   From Now onwards I will post my Oracle Appsdba Knowledge.



            ---Good Luck To All.