cancel
Showing results for 
Search instead for 
Did you mean: 

error getting while adding BI patch (SQL error 1089 accessing)

Former Member
0 Kudos

Dear Experts ,

here i faced one problem while adding BI patch to newely installed system

the error is at phase import_proper below are shown error log

***************************************************************************************************************************************************************

/usr/sap/trans/log/SAPI-704IFINBICONT.LBD

ERROR LOG

***************************************************************************************************************************************************************

Start import R3TRFUGR/POSDW/CONVERSION_XML ...

1 entry for TADIR updated (R3TRFUGR/POSDW/CONVERSION_XML ).

2 entries from TFTIT deleted (pname /POSDW/SAPLCONVERSION_XML)

7 entries from FUPARAREF deleted (pname /POSDW/SAPLCONVERSION_XML)

2 entries from ENLFDIR deleted (pname /POSDW/SAPLCONVERSION_XML)

2 entries from TFDIR deleted (pname /POSDW/SAPLCONVERSION_XML)

dev trc ,00000 Fri Oct 1 10:28:27 2010 -649694573 88072.488603

dev trc ,00000 OCI-call failed with -1=OCI_ERROR 44 88072.488647

dev trc ,00000 SQL error 1089: 'ORA-01089: immediate shutdown in progress - no operations are permitted'

50 88072.488697

http://dbsloci. ,00000 *** ERROR => Error 1089 in stmt_fetch() from oci_execute_stmt(), orpc=0

59 88072.488756

http://dbsloci. ,00000 *** ERROR => ORA-1089 occurred when executing SQL stmt (parse error offset=0)

50 88072.488806

dev trc ,00000 sc_p=0x110f364a8,no=27,idc_p=0x110f4ece0,con=0,act=1,slen=68,smax=256,#vars=1,stmt=0x111799cc0,table=D010INC

57 88072.488863

dev trc ,00000 SELECT MASTER FROM D010INC WHERE INCLUDE = :A0 ORDER BY MASTER;

47 88072.488910

dev trc ,00000 sc_p=0x110f364a8,no=27,idc_p=0x110f4ece0,con=0,act=1,slen=68,smax=256,#vars=1,stmt=0x111799cc0,table=D010INC

113 88072.489023

dev trc ,00000 prep=0,lit=0,nsql=0,lobret=0,#exec=972,dbcnt=0,upsh_p=(nil),ocistmth_p=0x11179a658

50 88072.489073

dev trc ,00000 IN : cols=1,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=80,vmax=32,bound=1,iobuf_p=0x111083a40,v

69 88072.489142

dev trc ,00000 lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0

46 88072.489188

dev trc ,00000 OUT: cols=1,rmax=792,xcnt=792,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=80,vmax=32,bound=1,iobuf_p=0x111225e

54 88072.489242

dev trc ,00000 lobs=0,lmax=0,lpcnt=0,larr=(nil),lcurr_p=(nil),rret=0

46 88072.489288

dev trc ,00000 SELECT MASTER FROM D010INC WHERE INCLUDE = :A0 ORDER BY MASTER;

46 88072.489334

dbrepo ,06599 ***LOG BY4=>sql error 1089 performing FET on table D010INC dbrepo#4 @ 6599

72 88072.489406

dbrepo ,06599 ***LOG BY0=>ORA-01089: immediate shutdown in progress - no operations are permitted dbrepo#4 @ 6599

50 88072.489456

sap_dext called with msgnr 1:

db call info

function: db_report_interface

fcode: READ_MASTERS

tabname: SOURCE

len (char): 40

key: /POSDW/LCONVERSION_XML$01

retcode: 1

SQL error 1089 accessing : ORA-01089: immediate shutdown in progress - no ope

Main import

End date and time : 20101001102827

Ended with return code: ===> 12 <===

please clarefy me how can i solve this my issue

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Check whether ur DB is up and running and then repeat the patch update.

Regards,

Varadharajan M

Answers (1)

Answers (1)

JPReyes
Active Contributor
0 Kudos

ORA-01089 means that your DB received a shutdown immediate command and its on the way down, check your DB and resume the SP.

Regards

Juan