hyperion workaround

http://forums.oracle.com/forums/thread.jspa?messageID=9175141

Hi

Please following the following steps:

1. Check if the account (say hyp_docm) is there in Admin group of all the HFM boxes.
2. Ensure DOCM is not stopped in any HFM boxes.
3. Windows Fix

- Execute on HFM Servers
Note – this change is made because of performance / stability issues, in accordance to Microsoft article KB899148 (http://support.microsoft.com/kb/899148/en-us).

- Open registry ‘Start -> Run “regedit”’
- Navigate to ‘HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Rpc’
Note – you may have to create the Rpc key under Windows NT key

To create key
Navigate to ‘HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT’
Right-click, select ‘New’
Select ‘Key’
Set name to Rpc
- Right-click on the right-hand pane, navigate ‘New >DWORD Value’
Set name to ‘Server2003NegotiateDisable’
- Double-click ‘Server2003NegotiateDisable’
Value Data: 1
- Select ‘OK’
- Close Registry editor
- Reboot the server (Must)

4. Dcom permission

Set Local Policy Permissions
=> Open Local Security Settings applet, ‘Start -> Run “secpol.msc”’
=> Navigate to ‘Local Policies -> User Rights Assignments’
=> Double-click ‘Act as Part of Operating System’
=> Select ‘Add User or Group’
Enter object name ‘domain\hyp_docm’
Select ‘Check Names’
Select ‘OK’
=> Select ‘Apply’
=> Select ‘OK’

=> Double-click ‘Bypass Traverse Checking’
=> Select ‘Add User or Group’
Enter object name ‘domain\hyp_docm’
Select ‘Check Names’
Select ‘OK’
=> Select ‘Apply’
=> Select ‘OK’

=> Double-click ‘Log on as Batch Job’
=> Select ‘Add User or Group’
Enter object name ‘domain\hyp_docm'
Select ‘Check Names’
Select ‘OK’
=> Select ‘Apply’
=> Select ‘OK’

=> Double-click ‘Log on as Service’
=> Select ‘Add User or Group’
Enter object name ‘domain\hyp_docm'
Select ‘Check Names’
Select ‘OK’
=> Select ‘Apply’
=> Select ‘OK’
=> Close Local Security Settings applet

5. Rotate the config log and re-configure all HFM steps using EPM Confihurator. Don't forget to confin Workssoace web

Regards
Rupak
Mantra to Win | winmantras.com

http://forums.oracle.com/forums/thread.jspa?messageID=9175141

Enable Database Enterprise Manager Console on R12

Enable Database Enterprise Manager Console on R12
First login as applmgr user, shutdown all application tier process using adstpall.sh.
Login as oracle user to linux. Source the database environment.
Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the init.ora for the database using this command: SQL> show parameter REMOTE_LOGIN_PASSWORDFILE;
Create a password file using this command on linux: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=change_on_install entries=5
Then execute this command: emca -config dbcontrol db -repos recreate -SID ITB -PORT 1521 -DBCONTROL_HTTP_PORT 5500
(remember to change SID and port if needed).
You will be asked some question:
SYS password: the default is change_on_install
DBSNMP password: dbsnmp
SYSMAN password: sysman
Email: enter your email address (optional)
SMTP server: enter your smtp server
SYSMAN schema will be dropped and recreate.
While dropping the scema, database will be quisced. Database sessions that blocking the quiescing process must be killed.
Use sqlplus to identify the sessions:
SQL> select bl.sid, serial#, user, osuser, type, program from v$blocking_quiesce bl, v$session se where bl.sid = se.sid;
Make note on SID and SERIAL#.
Kill the session using this sql command:
SQL> alter system kill session 'SID,SERIAL#' immediate;
(don't forget to change SID and SERIAL#).
On create schema process you may need to increase the size of SYSAUX tablespace.
After the process completed you can access the enterprise manager on internet browser using this URL:
http://hostname:5500/em
You may also have to run $ORACLE_HOME/root.sh as root to avoid ERROR: NMO not setuid-root. Just answer no if overwrite is asked

PROMPT cost manager and worker requests that have not completed

select wrk.request_id ,
decode(wrk.phase_code,
'C','Complete',
'I','Inactive',
'P','Pending',
'R','Running',
'Unknown')
phase_code,
decode(wrk.status_code,
'C','Normal',
'D','Cancelled',
'E','Error',
'F','Scheduled',
'I','Normal',
'M','No Manager',
'Q','Standby',
'R','Normal',
'S','Suspended',
'T','Terminating',
'U','Disabled',
'W','Paused',
'Z','Waiting'
,'Unknown') status_code,
prg.concurrent_program_name,
substr(argument1,1,10) arg1,
substr(argument2,1,10) arg2,
substr(argument3,1,10) arg3
from fnd_concurrent_programs prg,
fnd_concurrent_requests wrk
where prg.application_id = wrk.program_application_id
and prg.concurrent_program_id =
wrk.concurrent_program_id
and prg.concurrent_program_name IN ('CMCICU','CMCMCW','CMCTCM','CMCACW','CMCCTW','CMCOCW')
and phase_code <> 'C'