on 08-21-2007 9:41 AM
hi,
I was trying to install ides 4.7 with Oracle 8i. In the time of DB instance -> Database load (Post processing) - > Finished SAPView, there was an error with following log. Can anybody help me to solve this problem.
*************************
Tue Aug 21 13:50:56 2007
***LOG BY2=> sql error 1034 performing CON [dblink#1 @ 419] [dblink 0419 ]
***LOG BY0=> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist [dblink#1 @ 419] [dblink 0419 ]
(DB) ERROR: db_connect rc = 256
DbSl Trace: Logon as OPS$-user to get SAPERP's password
DbSl Trace: Connecting as /@ERP on connection 0 ...
DbSl Trace: Starting user session (con_hdl=0,svchp=0026D9F8,srvhp=0026D804,usrhp=002AF724)
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: Try to connect with default password
DbSl Trace: Connecting as SAPERP/<pwd>@ERP on connection 0 ...
DbSl Trace: Starting user session (con_hdl=0,svchp=0026D9F8,srvhp=0026D804,usrhp=002AF724)
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: DbSlErrorMsg rc = 99
C:\usr\sap\ERP\SYS\exe\run/R3load.exe: job finished with 1 error(s)
C:\usr\sap\ERP\SYS\exe\run/R3load.exe: END OF LOG: 20070821135056
**************
Thanks in Advance.,
Sridhar
Dear Sridhar
Please check the status of oracle instance is available.
If you can not start oracle manually, please reduce the oralce memory setting (etc. databuffer, shared_pool parameter)
Best regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HELO SRIDHAR
EVEN I AM ALSO GETTING THE SAME ERROR CAN U PLS LET ME KNOW HOW DID YOU GET THE PROBLEM SOLVED
PLS
DINESH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi sridhar
it seems the oracle has been shutdown start it manually and continue from the old installation this happens because of load
when u r doing installation u can give the parallel process as 1 to reduce the load
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi dinesh,
I changed the parallel process to 1 and continue the installation.
At last it shows the error as follows. I have posted the log datas of sapview.log and sapssex1.log. Kindly help me in this regard.
Thanks ,
Sridhar S
*************************
SAPVIEW.LOG
-
(DB) INFO: APPL_FUGR created
(DB) ERROR: DDL statement failed
(CREATE VIEW "APPL_FUGRG" ( "AREA" , "DEVCLASS" , "OBJ_NAME" ) AS SELECT T0001."AREA", T0002."DEVCLASS", T0002."OBJ_NAME" FROM "TLIBG" T0001, "TADIR" T0002 WHERE T0001."AREA" = T0002."OBJ_NAME" AND T0002."PGMID" = 'R3TR' AND T0002."OBJECT" = 'FUGR')
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=0026D9F0,usrhp=002AF724)
DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=0026D9F0,srvhp=0026D7FC)
DbSl Trace: Now I'm disconnected from ORACLE
(DB) INFO: disconnected from DB
C:\usr\sap\EEE\SYS\exe\run/R3load.exe: job finished with 1 error(s)
C:\usr\sap\EEE\SYS\exe\run/R3load.exe: END OF LOG: 20080825015932
***********************************************
SAPSSEX1.LOG
-
(DB) INFO: RODIR~0 created
(DB) INFO: RSMPTEXTS created
(RFF) ERROR: invalid checksum in data file "D:\47ides\db2\EXPORT2/DATA/SAPSSEX1.003"
current table was "RSMPTEXTS"
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=0026D9F0,usrhp=002AF724)
DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=0026D9F0,srvhp=0026D7FC)
DbSl Trace: Now I'm disconnected from ORACLE
(DB) INFO: disconnected from DB
C:\usr\sap\EEE\SYS\exe\run/R3load.exe: job finished with 1 error(s)
C:\usr\sap\EEE\SYS\exe\run/R3load.exe: END OF LOG: 20080824181911
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.