Sponsored Content
Full Discussion: Ora-27603:ora-27626:
Operating Systems Linux Red Hat Ora-27603:ora-27626: Post 303001458 by Maddy123 on Thursday 3rd of August 2017 08:24:14 PM
Old 08-03-2017
Ora-27603:ora-27626:

Hi,

User claim that job is running slow from their end.
I DBA found in database the below errors in alert log file.

Code:
ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576
ORA-27626: Exadata error: 2201 (IO cancelled due to slow/hung disk)

This error looks like some issue with server end.
Could someone please tell me the checks to perform in server as this server is managed by DBA team. So I cannot ask Unix team to look into it.

OS -- Linux

Regards,
Maddy


Moderator's Comments:
Mod Comment
Please wrap all code, files, input & output/errors in CODE tags.
It makes them easier to read and preserves multiple spaces for indenting and fixed-width data.

Last edited by rbatte1; 08-04-2017 at 05:32 AM.. Reason: Added CODE tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

path of init.ora

hi i would like to know the path of init.ora in AIX Server i tried with find command but i could not find it. can somebody help me with that. (8 Replies)
Discussion started by: matrixmadhan
8 Replies

2. Solaris

init.ora

what is the function of the init.ora file and suppose by mistake it gets deleted , what will be the consequences on the server (1 Reply)
Discussion started by: asalman.qazi
1 Replies

3. Solaris

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

Hi all, Am intermittently getting the following errors on one of my databases. Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302:... (1 Reply)
Discussion started by: newbie_01
1 Replies

4. UNIX for Advanced & Expert Users

grep all ORA errors except one ORA error

Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command? In following "grep" command I want to exclude "ORA-01653" error grep -i ORA alert.log >>/tmp/ora_errors.txt ... (7 Replies)
Discussion started by: Mansoor8810
7 Replies

5. HP-UX

ORA-27300 error because of hp ux

Dear All, i am not able to start the 9i oracle database because of the following problems. I log in into unix and then into sqlplus export oracle_sid=SATEST startup nomount i am getting the following errors ORA-27300: OS system dependent operation:semget failed with... (3 Replies)
Discussion started by: alokpattar
3 Replies

6. Shell Programming and Scripting

editing init.ora

Hi all- i am having some hiccups while writing a korn shell to edit init.ora file for automating latest PSU patchset.(Oracle) I am trying to edit(add) the ._fix_control and .event with certain parameters. if anyone has any idea that will be helpful. thanks. (1 Reply)
Discussion started by: sub
1 Replies

7. Shell Programming and Scripting

Tnsnames.ora

Hi, I would like to modify, in script schell, the line right above (DESCRIPTION and check three cases : if line contain ".world" then line=line-".world" concat "," concat line if line dont contain ".world" then line=line concat "," concat line concat".world" else line=line Keep in... (10 Replies)
Discussion started by: elcaro
10 Replies

8. Shell Programming and Scripting

Check for “errors” or “ORA-”

I want to check for "errors" or "ORA-" in Y.if there is an error then exit Y=`sqlplus -s user/passwd<< EOF exec test_Proc; exit; EOF` if ; then exit 1 fi but this doesnt work (6 Replies)
Discussion started by: haadiya
6 Replies

9. Shell Programming and Scripting

Parsing Listener.ora

Anymore have any code to easily parse the listener.ora to update the ORACLE_HOME for a specific sid? thanks. (1 Reply)
Discussion started by: nugent
1 Replies

10. Shell Programming and Scripting

Tnanames.ora parser

Dears How can I use shell to parser this file? PRI = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.3.7)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.3.17)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) ... (6 Replies)
Discussion started by: eric0826
6 Replies
wrap_log_reader(3erl)					     Erlang Module Definition					     wrap_log_reader(3erl)

NAME
wrap_log_reader - A function to read internally formatted wrap disk logs DESCRIPTION
wrap_log_reader is a function to read internally formatted wrap disk logs, refer to disk_log(3erl). wrap_log_reader does not interfere with disk_log activities; there is however a known bug in this version of the wrap_log_reader , see chapter bugs below. A wrap disk log file consists of several files, called index files. A log file can be opened and closed. It is also possible to open just one index file separately. If an non-existent or a non-internally formatted file is opened, an error message is returned. If the file is corrupt, no attempt to repair it will be done but an error message is returned. If a log is configured to be distributed, there is a possibility that all items are not loggen on all nodes. wrap_log_reader does only read the log on the called node, it is entirely up to the user to be sure that all items are read. EXPORTS
chunk(Continuation) chunk(Continuation, N) -> {Continuation2, Terms} | {Continuation2, Terms, Badbytes} | {Continuation2, eof} | {error, Reason} Types Continuation = continuation() N = int() > 0 | infinity Continuation2 = continuation() Terms= [term()] Badbytes = integer() This function makes it possible to efficiently read the terms which have been appended to a log. It minimises disk I/O by reading large 8K chunks from the file. The first time chunk is called an initial continuation returned from the open/1 , open/2 must be provided. When chunk/3 is called, N controls the maximum number of terms that are read from the log in each chunk. Default is infinity , which means that all the terms contained in the 8K chunk are read. If less than N terms are returned, this does not necessarily mean that end of file is reached. The chunk function returns a tuple {Continuation2, Terms} , where Terms is a list of terms found in the log. Continuation2 is yet another continuation which must be passed on into any subsequent calls to chunk . With a series of calls to chunk it is then possi- ble to extract all terms from a log. The chunk function returns a tuple {Continuation2, Terms, Badbytes} if the log is opened in read only mode and the read chunk is corrupt. Badbytes indicates the number of non-Erlang terms found in the chunk. Note also that the log is not repaired. chunk returns {Continuation2, eof} when the end of the log is reached, and {error, Reason} if an error occurs. The returned continuation may or may not be valid in the next call to chunk . This is because the log may wrap and delete the file into which the continuation points. To make sure this does not happen, the log can be blocked during the search. close(Continuation) -> ok Types Continuation = continuation() This function closes a log file properly. open(Filename) -> OpenRet open(Filename, N) -> OpenRet Types File = string() | atom() N = integer() OpenRet = {ok, Continuation} | {error, Reason} Continuation = continuation() Filename specifies the name of the file which is to be read. N specifies the index of the file which is to be read. If N is omitted the whole wrap log file will be read; if it is specified only the specified index file will be read. The open function returns {ok, Continuation} if the log/index file was successfully opened. The Continuation is to be used when chunking or closing the file. The function returns {error, Reason} for all errors. BUGS
This version of the wrap_log_reader does not detect if the disk_log wraps to a new index file between a wrap_log_reader:open and the first wrap_log_reader:chunk . In this case the chuck will actually read the last logged items in the log file, because the opened index file was truncated by the disk_log . SEE ALSO
disk_log(3erl) Ericsson AB kernel 2.14.3 wrap_log_reader(3erl)
All times are GMT -4. The time now is 09:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy