cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

NW 2004s Installation Error

Former Member

on ‎02-15-2008 7:29 AM

0 Kudos

Hi

i was trying to install SAP NW 2004s. i was properly configured input parametes and it goes well.......

But the Step 19 of 45, i got a error. i will post a log details below.

SAPVIEW.LOG

DbSl Trace: ORA-604 occurred when executing SQL statement (parse error offset=233)

(DB) ERROR: DDL statement failed

(CREATE VIEW "V_S_SCRN" ( "EXIT_NAME" , "SCR_A_PROG" , "SCR_A_NUM" , "SCR_A_SSCR" , "SPRSL" , "SCR_TEXT" ) AS SELECT T0001."EXIT_NAME", T0001."SCR_A_PROG", T0001."SCR_A_NUM", T0001."SCR_A_SSCR", T0002."SPRSL", T0002."SCR_TEXT" FROM "SXS_SCRN" T0001, "SXS_SCRNT" T0002 WHERE T0001."SCR_A_PROG" = T0002."SCR_A_PROG" AND T0001."SCR_A_NUM" = T0002."SCR_A_NUM" AND T0001."SCR_A_SSCR" = T0002."SCR_A_SSCR" AND T0001."EXIT_NAME" = T0002."EXIT_NAME")

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select con#,obj#,rcon#,enabl...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080215112637

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080215113011

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:38:35

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

DbSl Trace: Failed to register client info: orc=4031

DbSl Trace: ORA-1403 when accessing table SAPUSER

DbSl Trace: Failed to register client info: orc=4031

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP VIEW "V_S_SCRN")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: V_S_SCRN created #20080215113015

(DB) INFO: V_S_TABLE created #20080215113016

(DB) INFO: V_T77OMATTOT created #20080215113016

(DB) INFO: V_T77OMATTUS created #20080215113016

(DB) INFO: V_T77OMATTUSD created #20080215113016

(DB) INFO: V_T77PR_H created #20080215113016

(DB) INFO: V_T77PR_P created #20080215113016

DbSl Trace: ORA-604 occurred when executing SQL statement (parse error offset=189)

(DB) ERROR: DDL statement failed

(CREATE VIEW "V_T78NR_TA" ( "LEAD_NR" , "SRCSYSTEM" , "SYSID_LOC" , "MANDT" , "DEVCLASS" ) AS SELECT T0002."LEAD_NR", T0001."SRCSYSTEM", T0002."SYSID", T0002."MANDT", T0001."DEVCLASS" FROM "TADIR" T0001, "T78NR" T0002 WHERE T0001."OBJ_NAME" = T0002."LEAD_NR" AND T0001."PGMID" = 'R3TR' AND T0001."OBJECT" = 'HRNR')

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select con#,obj#,rcon#,enabl...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080215113017

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080215113046

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:38:35

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

DbSl Trace: Failed to register client info: orc=4031

DbSl Trace: ORA-1403 when accessing table SAPUSER

DbSl Trace: Failed to register client info: orc=4031

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP VIEW "V_T78NR_TA")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: V_T78NR_TA created #20080215113050

(DB) INFO: V_TAR_DYN created #20080215113051

(DB) INFO: V_TB038A_STD created #20080215113051

(DB) INFO: V_TBANK_CD_FDCD created #20080215113051

DbSl Trace: ORA-604 occurred when executing SQL statement (parse error offset=296)

(DB) ERROR: DDL statement failed

(CREATE VIEW "V_TBANK_CD_FDCT" ( "DDLANGUAGE" , "DDTEXT" , "TABNAME" , "FIELDNAME" , "KEYFLAG" , "ROLLNAME" , "CHECKTABLE" , "LOGFLAG" ) AS SELECT T0003."DDLANGUAGE", T0003."DDTEXT", T0001."TABNAME", T0001."FIELDNAME", T0001."KEYFLAG", T0001."ROLLNAME", T0001."CHECKTABLE", T0002."LOGFLAG" FROM "DD03L" T0001, "DD04L" T0002, "DD04T" T0003 WHERE T0002."ROLLNAME" = T0001."ROLLNAME" AND T0002."AS4LOCAL" = T0001."AS4LOCAL" AND T0002."ROLLNAME" = T0003."ROLLNAME" AND T0002."AS4LOCAL" = T0003."AS4LOCAL" AND T0001."CHECKTABLE" <> '' AND T0002."LOGFLAG" = 'X')

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select ts#,file#,block#,nvl(...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080215113051

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080215113428

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:38:35

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 4031

DbSl Trace: CONNECT failed with sql error '4031'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 4031

DbSl Trace: CONNECT failed with sql error '4031'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 4031

DbSl Trace: CONNECT failed with sql error '4031'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 4031

DbSl Trace: CONNECT failed with sql error '4031'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080215113433

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080215114717

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:38:35

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080215114722

import_monitor.log

TRACE: 2008-02-15 11:47:16 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPVIEW' import package into database:

D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

ERROR: 2008-02-15 11:47:22 com.sap.inst.migmon.LoadTask run

Loading of 'SAPVIEW' import package is interrupted with R3load error.

Process 'D:\usr\sap\EP2\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error' exited with return code 2.

For mode details see 'SAPVIEW.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

INFO: 2008-02-15 11:47:45

All import packages are processed.

WARNING: 2008-02-15 11:47:45

1 error(s) during processing of packages.

INFO: 2008-02-15 11:47:45

Import Monitor is stopped.

kindly give me the solution...... i will provide a points.

regards

raghu

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎05-23-2008 5:20 AM
0 Kudos

hi!

i was installed sucessfully......

thanks and regards

raghu

Show replies
Show replies
Former Member
‎02-15-2008 8:29 AM
0 Kudos

i hope this error is in import abap phase?

check whether you find any .bck files in your installation directory. if found then reply with that file name.

Regards,

Mahesh

Show replies
Show replies
Former Member
‎02-15-2008 8:45 AM
0 Kudos

Hi mahesh!

u ar right! i hav prob with "Import Abap".

i will check it whether that .bck files are available or not and tell u.

regards

raghu

Former Member
‎02-15-2008 12:24 PM
0 Kudos

Hi Mahesh!

The .bck file contain in installation directory. file name is DDLORA.TPL.bck.

What i have to do?????? give me solutions.......

regards

raghu

Former Member
‎02-15-2008 8:17 AM
0 Kudos

Hi Raghubalan

ORA-04031: unable to allocate 4108 bytes of shared memory

I guess you set your db memory too low (< 1gb). This is resulting in your shared_pool_size beeing too small. Try to increase it and retry.

Regards, Michael

Show replies
Show replies
Former Member
‎02-15-2008 8:41 AM
0 Kudos

hi!

Thanks for ur reply..............

Can u tell me how to set DB memory????????? i used c,d,e drive 4095mb of swap space.

can u explain me briefly pls............

regards

raghu

Former Member
‎02-15-2008 8:51 AM
0 Kudos

To check the actual setting:

C:\Documents and Settings\sidadm>sqlplus "/ as sysdba"

SQL> show parameter shared_pool_size
NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------------
shared_pool_size                     big integer 318767104

To change it to a higher value, procedure can be different if sga_target/sga_max_size is used.

SQL> alter system set shared_pool_size = 400M scope = both;

If scope = both does not work, then use scope = spfile and restart your database.

Best regards, Michael

Former Member
‎02-15-2008 12:29 PM
0 Kudos

Hi Michael!

i used to log in as sidadm users as OS level. from command prompt, i used "sqlpus". it asking for User and Password. i tried System, sys, sapsid(schema) users. but it will not connect.

what will do?? can u explain me step by step pls............

regards

raghu

JPReyes
Active Contributor
‎02-15-2008 2:44 PM
0 Kudos

As specified above...

Use command:

sqlplus "/as sysdba"

You can also change the size of shared_pool_size directly on the oracle spfile.

Regards

Juan

Ask a Question