Apr 24, 2013
HOW TO CHECK HIDDEN PARAMETERS IN ORACLE 11G
5.5K

HOW TO CHECK HIDDEN PARAMETERS IN ORACLE 11G

Using below SQL we can check hidden parameters from Oracle 11g We should not change these parameters without the consent of Oracle Support. set linesize 200 col “Parameter” for a30 col “Session Value” for a10 col “Instance Value” for a10 col “Default value” for a5 col SESSMOD for a7 col...
Apr 22, 2013
File server needs to be reinitialized
869

File server needs to be reinitialized

While opening log and out files from concurrent processing server, I faced following error:  File server needs to be reinitialized. Cause ===== FNDFS was unable to verify the value for $TWO_TASK in the APPLFSTT security parameter. Solution ======= Get $TNS_ADMIN/listener.ora from the $ORACLE_HOME (806) forms server. Open the file. Search...
Apr 22, 2013
Oracle Apps FNDLOAD Examples
836

Oracle Apps FNDLOAD Examples

Oracle Apps FNDLOAD Examples Lookups ======= FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”XXCUST” LOOKUP_TYPE=”XX_LOOKUP_TYPE” FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE Concurrent Program ================= FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME=”XXCUST” CONCURRENT_PROGRAM_NAME=”XX_CONCURRENT_PROGRAM” FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt – WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE Profile...
Apr 17, 2013
Oracle Apps 11i and R12 Environment Variables
3.8K

Oracle Apps 11i and R12 Environment Variables

Oracle Apps 11i and R12 Environment Variables list: Important File Locations  File Oracle Apps 11i Oracle Apps R12 Environment Source file APPSORA.env APPS<SID>_<hostname>.env Context File (Middle tier) $APPL_TOP/admin/$TWO_TASK.xml $INST_TOP/appl/admin/$TWO_TASK_<hostname>.xml tnsnames.ora (OH) $ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.2/network/admin listener.ora $ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.2/network/admin appsweb.cfg $OA_HTML/bin $INST_TOP/ora/10.1.2/forms/server tnsnames.ora (Apache) $IAS_ORACLE_HOME/network/admin/<CONTEXT> $INST_TOP/ora/10.1.3/network/admin jsev.properties $IAS_ORACLE_HOME/Apache/Jserv/etc $INST_TOP/ora/10.1.3/opmn/conf/opmn.xml httpd.conf $IAS_ORACLE_HOME/Apache/Apache/conf $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf apps.conf...
Apr 13, 2013
Access Oracle Apps 11i/R12 forms from Linux Mozilla Browser
2.4K

Access Oracle Apps 11i/R12 forms from Linux Mozilla Browser

How to access Oracle Apps 11i/R12 forms from Linux Mozilla Browser? My configuration is: Oracle Apps 12.1.1 64-bit Installed on OEL-5.7 64-bit Mozilla Firefox Version 1.5.0.12 When I tried to open forms through Mozilla, it says unknown plugin. We need to follow below steps to install Oracle Apps plugin for...
Apr 12, 2013
Create Oracle database in silent mode
554

Create Oracle database in silent mode

How to create Oracle database in silent mode? COMMAND ========= dbca -silent -gdname dbname -sid dbname -responsefile NO_VALUE -createDatabase -templateName General_purpose.dbc -characterset AL32UTF8 -memorypercentage 30 -emconfiguration LOCAL OUTPUT ======= Enter SYSTEM user password: password Enter SYS user password: password Copying database files 1% complete 3% complete
Apr 12, 2013
Oracle RAC Background Processes in 11g
1.5K

Oracle RAC Background Processes in 11g

Oracle RAC Background Processes in 11g Oracle RAC 11g has come up with some good new background processes. Which we will discuss in this session ABMR – auto block media recovery background process – Filters duplicate BMR requests and performs flood control. When a request of block media recovery comes...
Apr 11, 2013
RMAN Restore and Recovery Scenarios
802

RMAN Restore and Recovery Scenarios

RMAN Restore and Recovery Scenarios: RESTORE AND RECOVERY SCENARIOS: Full Database Restore $ORACLE_HOME/bin/rman target / nocatalog RMAN> shutdown abort; RMAN> startup mount; RMAN> restore database; RMAN> recover database; RMAN> alter database open; Tablespace Restore (online) $rman target / nocatalog RMAN> sql ‘alter tablespace users offline’; RMAN> restore tablespace users; RMAN>...
Apr 11, 2013
Data guard Interview Question and Answers
2.1K

Data guard Interview Question and Answers

Data guard Interview Question and Answers: Data guard Interview Question and Answers 1. Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync? In Oracle Standard Edition, it is possible to be a standby database, and...
Apr 11, 2013
Oracle Apps FND and Concurrent Manager Key Tables
1.8K

Oracle Apps FND and Concurrent Manager Key Tables

Oracle Apps FND and Concurrent Manager Key Tables Concurrent Manager key Tables FND_CONCURRENT_QUEUES FND_CONCURRENT_PROGRAMS FND_CONCURRENT_REQUESTS FND_CONCURRENT_PROCESSES FND_CONCURRENT_QUEUE_SIZE FND_EXECUTABLES FND_CP_SERVICES FND_CONCURRENT_QUEUE_CONTENT FND_CONCURRENT_PROGRAM_SERIAL FND_CONCURRENT_TIME_PERIODS FND_CONCURRENT_PROCESSORS FND key Tables FND_APPL_TOPS FND_LOGINS FND_USER FND_DM_NODES FND_TNS_ALIASES FND_NODES FND_RESPONSIBILITY FND_DATABASES FND_UNSUCCESSFUL_LOGINS FND_LANGUAGES FND_PROFILE_OPTION_VALUES FND_APPLICATIONS FND key Tables AD_APPLIED_PATCHES AD_PATCH_DRIVERS AD_BUGS AD_INSTALL_PROCESSES AD_SESSIONS AD_APPL_TOPS CONCURRENT PROCESSING SERVER...