Posts Tagged ‘Oracle Application DBA’

« Older Entries
Newer Entries »

Find Concurrent Manager Jobs By Query

May 6th, 2018, posted in Oracle Queries
Share

Query :

 

select sess.sid,
 sess.sql_hash_value,
 oracle_process_id OS_PROCESS_ID,
 fusr.description user_name ,
 fcp.user_concurrent_program_name progName,
 to_char(actual_Start_date,'DD-MON-YYYY HH24:MI:SS') StartDate,
 request_id RequestId,
 (sysdate - actual_start_date)*24*60 ETime_in_Mins
from apps.fnd_concurrent_requests fcr,
 apps.fnd_concurrent_programs_tl fcp,
 apps.fnd_user fusr,
 v$session sess
where fcp.concurrent_program_id = fcr.concurrent_program_id
 and fcr.program_application_id = fcp.application_id
 and fcp.language = 'US'
 and fcr.phase_code = 'R'
 and fcr.status_code = 'R'
 and fcr.requested_by = fusr.user_id
 and fcr.oracle_session_id = sess.audsid (+)
-- and p.addr = sess.paddr
 order by 6 DESC
Share
read more no comments

FRM-92102 : A Network Error Has Occured

September 19th, 2017, posted in Oracle, Solaris
Share

FRM-92102 is Gerneric Error maybe occur for more than one reasons :

1-Network 
2-Proxy
3-http
4-Session Time 


But today i will discuss the problem On oracle Application server 10g .
Description for the problem like the following when you try to connect on your deploy application On OAS 10g it’s gives the above error from 1-5 minutes.

I will give you more than one solution maybe it will be related to the above problem and you try them separately to see which one will be valid for you : 

1-Netowrk Parameters :

You will find it $ORACLE_HOME/forms/server/default.env
Just increase the value .

2-do the following change in opmn.xml (under $ORACLE_HOME/opmn/conf/):

 

 

3-SET Inbound_connection_timeout In sqlnet.ora to ZERO .

Sqlnet.Inbound_connection_timeout = 0

Note : if your can’t find this parameter in the SQLNET.ORA you cant add it .

5- Change the following $ORACLE_HOME/opmn/conf/opmn.xml

 


Hope this will work 

Share
read more Comments Off on FRM-92102 : A Network Error Has Occured

Refresh Materialized View

February 16th, 2017, posted in Oracle
Share

Problem sys@standby> startup mount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2217952 bytes Variable Size 490735648 bytes Database Buffers 335544320 bytes Redo Buffers 6606848 bytes Database mounted. sys@standby> alter database recover managed standby database using current logfile disconnect; alter database recover managed standby database using current logfile disconnect * ERROR at line 1: ORA-01153: an incompatible media recovery is active Cause This indicates a currently running media recovery process. Action sys@standby> alter database recover managed standby database cancel; sys@standby> alter database recover managed standby database using current logfile disconnect; Note When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.

Refresh Materialized View

NAME: Refresh Materialized View
SHORT CODE: OZFEARNMV
MODULE: Oracle Trade Management

Description: Refresh Materialized Views for Promotional Payments and Indirect Inventorty Tracking
Navigation: Oracle Trade Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • mv_name : Name of the Materialized View
Share
read more no comments

Keyboard Shortcut Keys In Oracle Apps 11i

December 20th, 2015, posted in Oracle
Share

Below are keyboard shortcut keys in Oracle Apps 11i. Use these to flaunt your skills in apps.. Problem sys@standby> startup mount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2217952 bytes Variable Size 490735648 bytes Database Buffers 335544320 bytes Redo Buffers 6606848 bytes Database mounted. sys@standby> alter database recover managed standby database using current logfile disconnect; alter database recover managed standby database using current logfile disconnect * ERROR at line 1: ORA-01153: an incompatible media recovery is active Cause This indicates a currently running media recovery process. Action sys@standby> alter database recover managed standby database cancel; sys@standby> alter database recover managed standby database using current logfile disconnect; Note When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.
Trust me when you do this in front of clients it works like magic 🙂

  • F4 Exit
  • F5 Clear Field
  • F6 Clear Record
  • F7 Clear Block
  • F8 Clear Form
  • F11 Query Enter
  • F12 Count Query
  • Ctrl + S Save
  • Ctrl + L List of Values
  • Ctrl + F11 Query Run
  • Ctrl + E Edit
  • Ctrl + Up Delete Record
  • Ctrl + Down Insert Record
  • Ctrl + P Print
  • Ctrl + U Update Record
  • Ctrl + B Block Menu
  • Ctrl + K Display list of Keys
  • Shift + F5 Duplicate Field
  • Shift + F6 Duplicate Record
  • Shift + F8 Next Set of Records (Same as Page Down)
  • Shift + Page Down Next Block
  • Shift + Tab Previous Field
  • Shift + Page Up Previous Block
  • Shift + Ctrl + E Display Error
  • Page Down Scroll Down (Same as Shift + F8)
  • Page Up Scroll Up
  • Tab Next Field
  • Down Arrow Next Record
  • Up Arrow Previous Record
  • Return Return

 

Share
read more no comments
« Older Entries
Newer Entries »