Search This Blog

Tuesday, September 27, 2011

Reset ORACLE_HOME in Windows

From command prompt: echo %ORACLE_HOME%
This should return %ORACLE_HOME%, meaning it's just echoing what you typed in and there is not set value for ORACLE_HOME. If there is a value for ORACLE_HOME, then: setx ORACLE_HOME ""
That will set ORACLE_HOME to nothing. Remember you need to close the command prompt and open a new one to have it read the change you just made.

Wednesday, September 21, 2011

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [

sqlplus
/ as sysdba
shutdown abort
startup mount;
recover database;
alter database open;
connect scott/tiger

Wednesday, September 7, 2011

Getting mailer service available in the instance


SELECT b.component_name,
       c.parameter_name,
       a.parameter_value
FROM fnd_svc_comp_param_vals a,
     fnd_svc_components b,
     fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
     AND b.component_type = c.component_type
     AND c.parameter_id = a.parameter_id
     AND c.encrypted_flag = 'N'
     AND b.component_name like '%Mailer%'
     AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')
ORDER BY c.parameter_name;



select component_status
    from apps.fnd_svc_components
   where component_id =
        (select component_id
           From Apps.Fnd_Svc_Components
          where component_name = 'Workflow Notification Mailer');
         
select running_processes
    from apps.fnd_concurrent_queues
   Where Concurrent_Queue_Name = 'WFMLRSVC';



select message_type, mail_status, count(*) from wf_notifications
where status = 'OPEN'
Group By Message_Type, Mail_Status