Monday, October 10, 2011

How to generate Form Level Trace and AR Debug log for diagnoses

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to generate Form Level Trace and AR Debug log for diagnoses


Solution:



How to generate Form Level Trace and AR Debug log for diagnoses:

Step 1 Setup AR Debug log per Note 152164.1 How To Create A Debug Log File
In An AR Form.

Step 2 Setup Form Level trace

a) Navigate to the form where problem occurs. Begin duplication steps but
Stop steps just before problem occurs.

Goto menubar, Help/Diagnostics/Trace, Select 'With binds and waits'

b) Continue with steps to recreate problem/error. Then Immediately turn
off trace. Goto menubar, Help/Diagnostics/Trace, Select "No trace"

c) How to obtain Trace file if no location/filename were provided when
enabled Trace:

Run script in SQLPlus for trace file location:

SELECT value FROM v$parameter
WHERE name='user_dump_dest';

d) Upload raw and TKprof'd Trace and AR Debug log to this Service Request

References:


Note 152164.1

Get Oracle Certifications for all Exams
Free Online Exams.com

SBL-BPR-00158: Cannot execute workflow process definition 'DC EPG Batch Assignment'.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: SBL-BPR-00158: Cannot execute workflow process definition 'DC EPG Batch Assignment'.

Symptoms:
when we ran from UI, its in queue & when we ran from comd prompt & we got below error:
srvrmgr:sitsiebsrvr> run task for comp WfProcBatchMgr with SearchSpec = '[Status]="Submitted" AND [DC Security Rating] = "Special Profile"', ProcessName = 'DC EPG RR Declaration Assignment'

run task for comp WfProcBatchMgr with SearchSpec = '[Status]="Submitted" AND [DC Security Rating] = "Special Profile"', ProcessName = 'DC EPG RR Declaration Assignment'
SBL-ADM-60070: Error reported on server 'sitsiebsrvr' follows:
SBL-SVR-01042: Internal: Communication protocol error while instantiating new task SBL-OMS-00203: Error 6750366 invoking method "RunBatch" for Business Service "Workflow Process Manager"
SBL-OMS-00203: Error 6750366 invoking method "RunBatch" for Business Service "Workflow Process Manager"
SBL-OMS-00107: Object manager error: ([0] Cannot execute workflow process definition 'DC EPG RR Declaration Assignment'.(SBL-BPR-00158) (0x67009e))
SBL-OMS-00203: Error (null) invoking method "(null)" for Business Service "(null)"

Solution:




workflow might not be active.
Can you please check for any expiration date for the workflow.
More details can be found in the Doc ID:478671.1.

References:

Doc ID:478671.1.


Get Oracle Certifications for all Exams
Free Online Exams.com

How To Correct Misclassified Accounts in General Ledger in 11i

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How To Correct Misclassified Accounts in General Ledger in 11i

Inherit Segment Value Attributes’, which is completed with fatal errors PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_2020"."DETAIL_PO

On : 11.5.10.2 version, Setup forms and programs

When attempting to run the Program - Inherit Segment Value Attributes, the following error occurs.
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_2020"."DETAIL_PO

Symptoms:

The issue can be reproduced at will with the following steps:
1. Reports : Request : Standard

Log files:
LOG FILE
-----------------------
Filename = Program___Inherit_Segment_Valu_211210.txt
See the following error:
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_2020"."DETAIL_PO


Solution:



The problem could be occuring because the customer is missing some
values from the value set.

To check if values are missing from the value set, see the following script:
SELECT cc.code_combination_id, cc.segmentX
FROM gl_code_combinations cc
WHERE cc.chart_of_accounts_id =
AND cc.segmentX not in
(SELECT 1
FROM fnd_flex_valuesffv
WHERE ffv.flex_value_set_id =
AND ffv.summary_flag = decode(nvl(cc.template_id, -1), -1, 'N',
'Y')
AND ffv.flex_value = cc.segmentX)

segmentX = segment1, segment2, segment3....etc.

You can get the FLEX_VALUE_SET_ID by going to the Value Set form,
query up the segments and do the equivalent of
Help->Tools->Examine.

To Correct Misclassified Accounts in General Ledger in 11i
Please follow the below steps to accomplish your task --

This script is for situations where only a few values are affected but many combinations.
It should be used in its entirety. Copy and paste it into a text file
called comb.sql and ftp or copy it to the server you are running the sql from
and run it there. This is for versions up to 11i only.


REM Changing account types script by Simon Goddard 02-APRIL-2002
PROMPT To run this sql you will need to know the name of your Set of Books
PROMPT the name of the 'Natural account segment'
PROMPT and the Account Type you are changing from and to.
PROMPT WARNING: make sure your finance department have taken the initial steps 1- 7
PROMPT to correct the Misclassified Accounts for all sets of books according to the manual
PROMPT or the note 1050920.6.

select set_of_books_id books_id, name books_name, chart_of_accounts_id chart_id
from gl_sets_of_books;

PROMPT select the chart_id of the set of books you need to change from
PROMPT results above. Ensure journals have been posted for all sets of books affected.
ACCEPT chart_id number PROMPT 'Chart_id: '

select application_column_name segment_num, segment_name
from fnd_id_flex_segments_vl
where id_flex_num=&&chart_id
and (ID_FLEX_CODE='GL#')
and (APPLICATION_ID=101);

PROMPT This gives the column names for all segments.
PROMPT Enter the Account segment from segment_num above as SEGMENT#
ACCEPT segment_num Char PROMPT 'SEGMENT#: '

select code_combination_id ccid, account_type
from gl_code_combinations
where &&segment_num = '&&acct_value'
and chart_of_accounts_id = &&chart_id;

PROMPT This gives a list of what the account type is currently set to
PROMPT store these results as backup
PROMPT To update the combinations press enter else CTRL C
ACCEPT endbit PROMPT 'continue:'


Update gl_code_combinations
set account_type = '&&New_Account_Type'
where &&segment_num = '&&acct_value'
and chart_of_accounts_id = &&chart_id
and account_type= '&¤t_account_type';
commit;
select code_combination_id ccid, account_type
from gl_code_combinations
where &&segment_num = '&&acct_value'
and chart_of_accounts_id = &&chart_id;

Clear Buffer

References:

Note 248842.1 - Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program


Get Oracle Certifications for all Exams
Free Online Exams.com

Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program



Solution:




The Inherit Segment Value Attributes Program terminates with fatal errors.
The log file shows the following information:

...
>> glnupd() 11-SEP-2003 11:38:02
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("
GL"."GL_SEGVAL_INHERIT_INT_62997"."DETAIL_P

GSVI0004: The Segment Value Inheritance program terminated with fatal errors.
...

ORA-01407: cannot update mandatory (NOT NULL) column to NULL

Run the following queries and provide the information to Oracle Support.

1. Find the different accounting structures defined, use the following script:

select id_flex_structure_name, id_flex_num
from fnd_id_flex_structures_vl
where id_flex_code = 'GL#';


2. Find the identification (set_of_books_id) of corresponding set of books. Use
the following query:

col sob format 9999999
col coa format 9999999
col name format a35
col curr format a3
Select set_of_books_id sob, chart_of_accounts_id coa, name, currency_code curr
from gl_sets_of_books
order by 1;

3. Use the identification of the flexfield found in step 1 to execute the
following query. It gives the accounting structure and displays the name of
each part of the structure and its corresponding database column.:

col app_col format a12
col segment format a15
col num format 999
col value_set format a25
select s.segment_name segment
, s.application_column_name app_col
, s.segment_num num
, s.flex_value_set_id
, f.flex_value_set_name value_set
from fnd_id_flex_segments s
, fnd_flex_value_sets f
where s.id_flex_num = &id_flex_num
and s.application_id = 101
and s.id_flex_code = 'GL#'
and s.flex_value_set_id = f.flex_value_set_id
order by s.segment_num;

4. Check that every segment value used in an account combination exists in a
value set.
Replace segmentN and flex_value_set_id appropriately. This statement needs to be
executed for every segment in the chart of accounts.
SELECT cc.code_combination_id, cc.segmentN
FROM gl_code_combinations cc
WHERE cc.chart_of_accounts_id = &chart_of_accounts_id
AND NOT EXISTS (
SELECT ffv.flex_value
FROM fnd_flex_values ffv
WHERE ffv.flex_value_set_id = &flex_value_set_id_of_segmentN
AND ffv.flex_value = cc.segmentN);

5. Determine order of segment qualifiers.
SELECT rownum, value_attribute_type
FROM (
SELECT value_attribute_type
FROM fnd_flex_validation_qualifiers
WHERE id_flex_code = 'GL#'
AND id_flex_application_id = 101
AND flex_value_set_id = &flex_value_set_id_of_natural_account_segment
ORDER BY assignment_date, value_attribute_type);

6. Check that every segment value has a valid value for the detail posting
allowed and detail budgeting allowed qualifiers.
SELECT flex_value_set_id, flex_value
from fnd_flex_values
where flex_value_set_id in
(select flex_value_set_id
from fnd_id_flex_segments
where application_id = 101
and id_flex_code = 'GL#'
and id_flex_num = &chart_of_accounts_id)
and (substr(compiled_value_attributes, 1, 1) IS NULL
or substr(compiled_value_attributes, 3, 1) IS NULL);

7. Check that every segment value in an independent value set does not have a
parent segment value.
SELECT flex_value_set_id, flex_value
from fnd_flex_values
where flex_value_set_id in
(select fnd.flex_value_set_id
from fnd_id_flex_segments fnd, fnd_flex_value_sets fvs
where fnd.application_id = 101
and fnd.id_flex_code = 'GL#'
and fnd.id_flex_num = &chart_of_accounts_id
and fvs.flex_value_set_id = fnd.flex_value_set_id
and fvs.validation_type = 'I')
and parent_flex_value_low is not null;

8. Execute the programs $FND_TOP/sql/afffckff.sql and $FND_TOP/sql/afffcvst.sql.



References:


Scripts To Troubleshoot The Error ORA-1407 When Running The Inherit Segment Value Attributes Program [ID 248842.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

Siebel Version: 8.0.0.8, Statement Of Issue: Facing performance when navigating in eService Application.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:
Siebel Version: 8.0.0.8, Statement Of Issue: Facing performance when navigating in eService Application.

Symptoms:
Performance is causing when accessing following BCs:

DC ECR Request: 7 sec
Person: 2 sec
DC ECR Facility: 6 sec

All the threee BCs have in common:
1. Large number of columns queried in the sql
2. Sort order specified.

Log files:
Start time: 2011-01-18 11:20:21

Task Id: 22020428
Process Id and Thread Id: 16882 231
Process Id and Thread Id (Hex): 41f2 e7

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:20:21 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_enu 22020428 16882 231 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_enu_0021_22020428.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000000d24d3141f2:0 2011-01-18 11:20:21 The Parameters for the current task (22020428) are :

Last two lines of log:

ObjMgrBusServiceLog InvokeMethod 4 000037a74d3362d0:0 2011-01-18 11:21:25 Begin: Business Service 'Web Engine State Properties' invoke method: 'IsFrameless' at b5f0e30
ObjMgrBusServiceLog InvokeMethod 4 000037a74d3362d0:0 2011-01-18 11:21:25 Business Service 'Web Engine State Properties' invoke method 'IsFra


Longest running SQLs :

***** SQL Statement Execute Time for SQL Cursor with ID B6AD110: 3.829 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.762 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.037 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID B718470: 3.002 seconds *****

=================================


Log File name >>> New_Fac_PSeServiceObjMgr_ecr_enu_0029_30408760.log

Start time: 2011-01-18 11:53:59
End time: 0000-00-00 00:00:00

Task Id: 30408760
Process Id and Thread Id: 16952 47
Process Id and Thread Id (Hex): 4238 2f

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:53:59 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_ecr_enu 30408760 16952 47 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_ecr_enu_0029_30408760.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000000244d314238:0 2011-01-18 11:53:59 The Parameters for the current task (30408760) are :

Last two lines of log:

ProcessRequest ProcessRequestDetail 4 00007daa4d313276:0 2011-01-18 11:58:13 SWE Command Processor - Handle user request: SWECmd=GetCachedFrame;SWEACn=28194;SWEC=21;SWEFrame=top._sweclient._sweviewbar;
ProcessR

Longest running SQLs:
***** SQL Statement Execute Time for SQL Cursor with ID F5D8210: 6.753 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F557EF0: 6.584 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F557EF0: 6.580 seconds *****
***** SQL Statement Execute Time for SQL Cursor with ID F55B070: 6.576 seconds *****

EventContext >>

EventContext EvtCtxView 3 00007d9d4d313276:0 2011-01-18 11:57:02 DC ECR Amend Terms View
EventContext EvtCtxApplet 4 00007d9f4d313276:0 2011-01-18 11:57:17 DC ECR Amend Terms Conditions Applet (eService) (DCWriteRecord)
EventContext EvtCtxView 3 00007d9f4d313276:0 2011-01-18 11:57:17 DC ECR Amend Create Facilities View (eService)
EventContext EvtCtxApplet 4 00007e724d31327a:0 2011-01-18 11:57:45 DC ECR Amend Request Form Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 00007da84d313276:0 2011-01-18 11:58:00 DC ECR Amend Request Form Applet (eService) (Submit)
EventContext EvtCtxView 3 000000524d314238:0 2011-01-18 11:58:13 DC ECR Amend Confirmation View (eService)


================


Log File name >>> Track_Req_PSeServiceObjMgr_enu_0021_22020443.log

Start time: 2011-01-18 11:27:20

Task Id: 22020443
Process Id and Thread Id: 16882 241
Process Id and Thread Id (Hex): 41f2 f1

Version: 8.0.0.8 [20430] ENU

First two lines of log:

2021 2011-01-18 11:27:20 0000-00-00 00:00:00 +0400 00000000 001 003f 0001 09 PSeServiceObjMgr_enu 22020443 16882 241 /u01/app/siebel/product/8.0.0/siebsrvr/enterprises/uatsiebelent/pcrfap01/log/PSeServiceObjMgr_enu_0021_22020443.log 8.0.0.8 [20430] ENU
TaskConfig TaskCfgParamInit 3 000001494d3141f2:0 2011-01-18 11:27:20 The Parameters for the current task (22020443) are :

Last two lines of log:

ObjMgrBusServiceLog InvokeMethod 4 000038474d3362d0:0 2011-01-18 11:28:11 Business Service 'Web Engine State Properties' invoke method 'IsFrameless' Execute Time: 0.000 seconds.
ObjMgrBusServiceLog InvokeMethod 4 000038474d3362d0:0 2011-01-18 11:28:11 End: Bus


EventContext trace >>>

EventContext EvtCtxView 3 000038154d3362d0:0 2011-01-18 11:27:20 PUB GOV Home Page View (eService)
EventContext EvtCtxScreen 3 000038154d3362d0:0 2011-01-18 11:27:20 no accessible views found for screen PUB GOV Home Screen (eService)
EventContext EvtCtxView 3 000038324d3362d0:0 2011-01-18 11:27:43 DC ECR Amend Track Registration View (eService)
EventContext EvtCtxApplet 4 000038344d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (NewQuery)
EventContext EvtCtxApplet 4 000038354d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (ExecuteQuery)
EventContext EvtCtxApplet 4 000038364d3362d0:0 2011-01-18 11:27:51 DC ECR Amend Track Registration Applet (eService) (DCContinue)
EventContext EvtCtxView 3 000038364d3362d0:0 2011-01-18 11:27:51 DC ECR Amend User Creation Vew (eService)
EventContext EvtCtxApplet 4 0000383b4d3362d0:0 2011-01-18 11:27:54 DC ECR Amend New User Creation Applet (eService) (Drilldown)
EventContext EvtCtxView 3 0000383b4d3362d0:0 2011-01-18 11:27:54 DC ECR Amend User Creation Detail View (eService)
EventContext EvtCtxApplet 4 0000383f4d3362d0:0 2011-01-18 11:27:55 DC ECR Amend User Roles Creation List Applet (eService) (NewRecord)
EventContext EvtCtxApplet 4 000038404d3362d0:0 2011-01-18 11:27:55 DC ECR Amend User Roles Creation List Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 000038414d3362d0:0 2011-01-18 11:27:55 DC ECR Amend New User Creation Form Applet (eService) (WriteRecord)
EventContext EvtCtxView 3 000038414d3362d0:0 2011-01-18 11:27:56 DC ECR Amend User Creation Vew (eService)
EventContext EvtCtxApplet 4 000038444d3362d0:0 2011-01-18 11:27:59 DC ECR Amend Request Form Applet (eService) (WriteRecord)
EventContext EvtCtxApplet 4 000038454d3362d0:0 2011-01-18 11:27:59 DC ECR Amend Request Form Applet (eService) (Submit)
EventContext EvtCtxView 3 000001654d3141f2:0 2011-01-18 11:28:11 DC ECR Amend Confirmation View (eService)

Longest Running SQLs >>

Solution:



Facing performance when navigating in eService Application.
Issue is resolved now after creating indexes on the extension tables.



Get Oracle Certifications for all Exams
Free Online Exams.com

How to have a HA solution for Siebel Gateway

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to have a HA solution for Siebel Gateway

Symtoms:

We are planning to have HA solution for Siebel GW. the thing is that we dont have the cluster and here is what we are planning to do:

We have 2 Boxes and we are installing Gateway on both and having a switch set to Active/Passive mode for both, meaning one server would be my primary Gateway Server. i will configure the Siebel App Servers using the virtual ip of the switch.

if the my primary Gateway goes down, we will make the Gateway 2 as primary and manually synchronize the enterprise to update the siebelns.dat file and restart the Siebel servers. i assume doing so will give me a high availability solution.

Solution:



The only supported HA solution for the Gateway is using third party cluster software due to the nature of the service and customer is to engage the cluster software vendor for assistance on the setup.

Based on information provided in description, there is no cluster software used and you are trying to achieve HA for gateway with manual switch over using virtual ip of the switch and manual synchronize the enterprise to update the siebelns.dat file and restart the Siebel servers . This is unsupported from Oracle/Siebel Support perspective and thus we are not able to comment or confirm if this will achieve high availability for gateway. And do note in such implementation, it is important to ensure the gateway host / IP configured (in siebns.dat, Siebel server service entry, *.cfg etc) is pointing to the virtual IP and there might me annual steps and tuning required to correctly configure the servers.

On Windows platform specifically, we have seen a lot of customer using the unsupported method like building a Ghost image (or other machine replication image) of the Gateway and regularly backing up the siebns.dat file or virtualized the Gateway servers using some third party virtual machine software etc and make regular image back-ups of the virtual server. All these are unsupported but may work.

So in summary, for any HA implementing without using cluster software, customers are to test this thoroughly to ensure it is working as expected as the only supported HA solution is to use third party cluster software that is viable and reliable.



Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []

10.2.0.3/HP-UX Itanium /11.31
2 node cluster.
Failed to write to control files from one of node

Symptoms:
On 2 node RAC config , from one of the node, all the sessions were hanging when trying to write to the controlfile
Controlfile is placed in the cluster filesystem. At the same time from the other node writes to the controlfile was happening without any issue.

After some time, the arc process got aborted and the arc process was unable to respwan thus caused all sessions from second node to hang.

As a work around I have bounced the second instance.

srvctl couldnt bring up the second instance after bouncing
found that crs_stat was hanging. As a workaround killed the crs daemon. After this srvctl could bring up the second instance

Log files:
Alert Log File:
Sat Dec 25 17:31:36 2010
GES: Potential blocker (pid=12884) on resource CF-00000000-00000000;
enqueue info in file /u01/app/admin/prdsbl/bdump/prdsbl2_lmd0_10853.trc and DIAG trace file
Killing enqueue blocker (pid=12884) on resource CF-00000000-00000000
by killing session 170.21747


Sat Dec 25 17:31:36 2010
Errors in file /u01/app/admin/prdsbl/bdump/prdsbl2_arc0_11225.trc:
ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []
Sat Dec 25 17:31:36 2010

/* ORA 600 triggered */
Sat Dec 25 17:31:36 2010
Errors in file /u01/app/admin/prdsbl/bdump/prdsbl2_arc0_11225.trc:
ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []
Sat Dec 25 17:31:36 2010
Errors in file /u01/app/admin/prdsbl/bdump/prdsbl2_arc1_11231.trc:
ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []
Sat Dec 25 17:31:38 2010
Trace dumping is performing id=[cdmp_20101225173138]
Sat Dec 25 17:31:38 2010
Errors in file /u01/app/admin/prdsbl/bdump/prdsbl2_arc0_11225.trc:
ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []
Sat Dec 25 17:31:38 2010
Errors in file /u01/app/admin/prdsbl/bdump/prdsbl2_arc1_11231.trc:
ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []


Solution:



There could be two reasons.


1. Someone is holding CF enqueue on node1 and not allowing others. But this looks very remote condition because if someone is holding CF enqueue then no one on entire database should be able to get the CF enqueue. But here we are able to access (read/write) controlfile from node1.


2. I/O is blocked at the OS level. This looks the most probable cause as I/O calls were failing at the time of problem. This got resolved after instance restart. Was there any node reboot performed at this time?

Workaround is to bounce the instance.




Get Oracle Certifications for all Exams
Free Online Exams.com