cancel
Showing results for 
Search instead for 
Did you mean: 

Error in IDES 4.7 installation

former_member727126
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

former_member727126
Participant
0 Kudos

Hi..

Thank u for ur reply Baek..

I checked the status. Oracle instance is available. Please tell me how to reduce the oracle memory ? .

Thank you.

Former Member
0 Kudos

To reduce Oracle memory check initSID.ora file and reduce all pool size parameters ralated to SGA and PGA.

Regards

Vinod

Former Member
0 Kudos

Dear Sridhar

Your oracle instance is running now ?

that error message is Oracle status is shutdown ,

so you have to start oracle instance.

if oracle is runinng, you don't need to reduce the memory parameter.

then, it need to anlyze the root cause again.

Best regards

JangHyun.

Former Member
0 Kudos

LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist [dblink#1 @ 419] [dblink 0419 ]

=> it means oracle is not open. you have to start oracle instance

former_member727126
Participant
0 Kudos

Thank you Vinod.

former_member727126
Participant
0 Kudos

Thank you Baek. I check it over. If problems persist I'll post the log.

Thanks again.

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member727126
Participant
0 Kudos

Hi dinesh.,

Thank you for ur reply. I checked the status. Oracle is started and running.

Also please tell me how to give parallel process as 1 ?.

Thank you.

former_member727126
Participant
0 Kudos

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