If concurrent ma nagers are running then see the process using ps- ef | grep FND : Normally can take upto 5 minutes to kill all processes so be patient.
To abort all procsses = kill -9 `ps -ef | grep FND | awk `{print $2}’`
Status of each concurrent requests are hosted at FND_Concurrent_requests & Fnd_concurrent_queues. Running is R and complegted is set as C in this tables. Read more…
All checks are done using aoljtest.jsp. The app front end connects to database suing $INST_TOP/fnd/secure/DBC- Database connector file
LINUX user required: oracle & applmgr
Oracle database : apps schema
In release 12 (12.1.1) te oracle concurrent manager uses the rwcall to start reports
Hierarchy : One off Patch -> Mini pack -> Family pack & Finally Maintenance Pack
Maintenance pack : Upgrade from one version to another . 12.0.2 -> 12.0.4
Family pack – Fixing the functional modules.FIN.B – Latest family pack for release 12 . FIN is financial B where B denotes the version -. For 11i HRPF.K – K is level of Module.
One off – One off issue
Mini Pack : Small functionality
Enhance functionality like VAT change. – One off else MINI pack. Apps patch is done by adpatch utility. Also look into readme file. “adpatch” is like opatch so can be copied from CD.
[applmgr@ebs scripts]$ pwd
/oracle/u01/VIS/inst/apps/VIS_ebs/admin/scripts
[applmgr@ebs scripts]$ adapcctl.sh stop
You are running adapcctl.sh version 120.6.12000000.2
Stopping OPMN managed Oracle HTTP Server (OHS) instance …
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /oracle/u01/VIS/inst/apps/VIS_ebs/logs/appl/admin/log/adapcctl.txt for more information …
[applmgr@ebs scripts]$ adapcctl.sh status
You are running adapcctl.sh version 120.6.12000000.2 Read more…
There are 5 backup types. All these backups can be carried out online. databases. Offline backups require SQLSERVER be stopped. Offline backups are useful for the master, msdb and model databases
1. Full : This takes a complete copy of the database and logs.
2. Differential : This takes a copy of all changed pages since the last full backup (for database and logs.)
3. Transaction Log : This takes a copy of the transactions logs and clears its contents on completion.
4. File or File group : This copies only the specified file or group.
5. File differential : This takes a copy of all changed pages in file since the last file backup. In situations when the backup is too big for a backup window. Read more…
Maintenance Plans are only displayed to those users who are connected to the SQL Server using Windows Authentication Mode.
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..
Maks sure AGENT_HOME is set and EMCTL is not running from ORACLE_DATABASE_HOME than AGENT_HOME
Prerequisite :
Here I am going to log replicate AdventureWorks database from T-B0399254ED744 to TVLX4686
This morning I installed a new instance of SQL server and while connecting remotely it sent me an error message.
Please navigate to Management ->Activity Monitor -> Double Click
The architecture of the AWR is quite simple. The MMON background process polls the x$ fixed tables from the SGA region and stores them in the AWR tables. From there, the performance data is instantly available for analysis. The Enterprise Manager can be used for graphical data display. Alternatively, the Automatic Database Diagnostic Monitor (ADDM) can be used for automated tuning analysis, or SQL*Plus can be used if customized Oracle tuning size reports are desired. Read more…
Tweet