on 10-02-2010 8:59 AM
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
Hi,
Check whether ur DB is up and running and then repeat the patch update.
Regards,
Varadharajan M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.