solman ides installation error

[Former Member]

hi experts

i am trying to solman ides installation i get import aba error.Any one kindly help to solve this issue.i sopy the import monitor log and  sapview.log

Import monitor log:

ERROR: 2012-05-17 17:38:11 com.sap.inst.migmon.LoadTask run

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

Process 'C:\usr\sap\MAN\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: 2012-05-17 17:38:33

All import packages are processed.

WARNING: 2012-05-17 17:38:33

1 error(s) during processing of packages.

INFO: 2012-05-17 17:38:33

Import Monitor is stopped.

sapview log:

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP VIEW "/SAPCND/D04V681F")

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) ERROR: DDL statement failed

(CREATE VIEW "/SAPCND/D04V681F" ( "ROLLNAME" , "AS4LOCAL" , "AS4VERS" , "DDLANGUAGE" , "DATATYPE" , "LENG" , "OUTPUTLEN" , "CONVEXIT" , "SCRTEXT_S" , "SCRTEXT_M" , "SCRTEXT_L" , "DDTEXT" , "LOWERCASE" , "VALEXI" , "ENTITYTAB" , "DOMNAME"  ) AS SELECT T0002."ROLLNAME", T0002."AS4LOCAL", T0002."AS4VERS", T0003."DDLANGUAGE", T0002."DATATYPE",  T0002."LENG", T0002."OUTPUTLEN", T0002."CONVEXIT", T0003."SCRTEXT_S", T0003."SCRTEXT_M", T0003."SCRTEXT_L", T0003."DDTEXT", T0002."LOWERCASE", T0002."VALEXI", T0002."ENTITYTAB", T0002."DOMNAME" FROM "/SAPCND/T681F" T0001, "DD04L" T0002, "DD04T" T0003 WHERE T0001."ROLLNAME" = T0002."ROLLNAME" AND T0002."ROLLNAME" = T0003."ROLLNAME" AND T0002."AS4LOCAL" = T0003."AS4LOCAL" AND T0002."AS4VERS" = T0003."AS4VERS" AND T0002."AS4LOCAL" = 'A' AND T0002."AS4VERS" = '0000')

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

[Former Member · Accepted solution]

Hi,

Kindly go through this note:

Note 709389 - Problems during load of SAPVIEW

Let me know if it solves your problem.

Regards,

Sonia

[Former Member · Accepted solution]

But i dnt have service market place id.give me another solution

[Former Member · Accepted solution]

hi sonia,

  thank you very much for your quick and help full replay.i did solve the issue but i got now import java dump error please help to solve this issue i am expecting quick replay.

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

May 17, 2012 6:45:08 PM com.sap.inst.jload.Jload main

INFO: Jload -sec MAN,jdbc/pool/MAN,\\sapbasis/sapmnt/MAN/SYS/global/security/data/SecStore.properties,\\sapbasis/sapmnt/MAN/SYS/global/security/data/SecStore.key -dataDir E:/solamon/SOLMAN 4.0 Java Component717\JAVA_EXPORT\JDMP -job C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\IMPORT.XML -log jload.log

May 17, 2012 6:45:09 PM com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

May 17, 2012 6:45:09 PM com.sap.inst.jload.Jload logStackTrace

SEVERE: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)

    at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:293)

    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)

    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

    at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

    at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

    at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

    at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)

    at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)

    at com.sap.inst.jload.Jload.main(Jload.java:580)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:324)

    at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

[Former Member · Accepted solution]

Hello,

Your database seems to be down. Please bring it up.

Regards,

Sonia

[Former Member · Accepted solution]

Hello,

How did you solve your import abap error.

Which step of the note did you perform.

Regards,

Sonia

[Former Member · Accepted solution]

Thank you but i dnt know how to up the db.kindly help me

[Former Member · Accepted solution]

i modify the import_monitor_cmd.properties add the stop_on_error -merge_only sapview.tsk

[Former Member · Accepted solution]

Hi,

Go to command prompt. type command :

sqlplus '/as sysdba'

It might ask user name and pwd, give the username as system and password the one you have given for system id. If you get sqlplus not found error, set the environmental variables ORACLE_HOME to the oracle home path and also include the oracle home path to PATH variable.

startup;

The above command should start you DB. In case you get any errors, post it.

Regards,

Sonia

[Former Member · Accepted solution]

which password ihave give for db. In my system id password was india123 but that not working its shows tns protocol error.

[Former Member · Accepted solution]

Hello,

Can you please check if entries in you tnsnames.ora file is correct.

Also check if listener is running.

What is you SID? Please paste the details of tnsnames.ora file here.

Regards,

Sonia

[Former Member · Accepted solution]

hi sonia,

           I am getting error in perform post load activities in 22 phase. My database is up and listener working fine but i getting problem kindly help to solve this issue.

ora_sql results:

2012-05-18, 18:38:14 SAPINST ORACLE start logging for

SHUTDOWN ABORT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 18 18:38:15 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

SAPINST: End of output of SQL executing program C:\oracle\ECC\102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2012-05-18, 18:38:15 SAPINST ORACLE stop logging

sapinst_ora_environment.log:

NLS_LANG=AMERICAN_AMERICA.UTF8

NUMBER_OF_PROCESSORS=1

ORACLE_HOME=C:\oracle\ECC\102

ORACLE_SID=ECC

OS=Windows_NT

Path=C:\oracle\ECC\102\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;bin

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PERL5LIB=C:\oracle\ECC\102\perl\5.8.3\lib\MSWin32-x86;C:\oracle\ECC\102\perl\5.8.3\lib;C:\oracle\ECC\102\perl\5.8.3\lib\MSWin32-x86;C:\oracle\ECC\102\perl\site\5.8.3;C:\oracle\ECC\102\perl\site\5.8.3\lib;C:\oracle\ECC\102\sysman\admin\scripts;C:\oracle\ECC\102\perl\5.8.3\lib\MSWin32-x86;C:\oracle\ECC\102\perl\5.8.3\lib;C:\oracle\ECC\102\perl\5.8.3\lib\MSWin32-x86;C:\oracle\ECC\102\perl\site\5.8.3;C:\oracle\ECC\102\perl\site\5.8.3\lib;C:\oracle\ECC\102\sysman\admin\scripts;

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 10, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=170a

ProgramFiles=C:\Program Files

SAPDATA_HOME=C:\oracle\ECC

SAPEXE=C:\usr\sap\ERP\SYS\exe\uc\NTI386

SAPINST_EXEDIR_CD=E:/solamon/InsMaser/IM_WINDOWS_I386

SAPLOCALHOST=sapbasis

SAPSYSTEMNAME=ERP

SESSIONNAME=Console

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp

TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp

TNS_ADMIN=C:\usr\sap\ERP\SYS\profile\oracle

USERDOMAIN=SAPBASIS

USERNAME=Administrator

USERPROFILE=C:\Documents and Settings\erpadm.SAPBASIS

windir=C:\WINDOWS

SAPINST: End of current process environment.

Further environment variables that where set (possibly overwriting the previous ones):

ORACLE_HOME=C:\oracle\ECC\102

ORACLE_SID=ECC

SAPINST: End of environment log.

sapinst log:

ERROR 2012-05-18 19:54:18

CJS-00084  SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'APPL1'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'APPL2'

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'CLUST'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'DDIM'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'DFACT'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'DODS'

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'POOL'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'SDIC'

  ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'SDOCU'

  ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3700' WHERE TABART = 'SLDEF'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3700' WHERE TABART = 'SLEXC'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'SLOAD'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'SPROT'

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3700' WHERE TABART = 'SSDEF'

              *

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3700' WHERE TABART = 'SSEXC'

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'SSRC'

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3' WHERE TABART = 'TEMP'

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3USR' WHERE TABART = 'USER'

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPSR3.iaora SET TABSPACE = 'PSAPSR3USR' WHERE TABART = 'USER1'

ERROR at line 1:

ORA-00942: table or view does not exist

DELETE FROM SAPSR3.tsora

  ERROR at line 1:

ORA-00942: table or view does not exist

INSERT INTO SAPSR3.tsora  (TABSPACE, INDSPACE) VALUES ('PSAPSR3', 'PSAPSR3')

ERROR at line 1:

ORA-00942: table or view does not exist

INSERT INTO SAPSR3.tsora  (TABSPACE, INDSPACE) VALUES ('PSAPSR3700', 'PSAPSR3700')

ERROR at line 1:

ORA-00942: table or view does not exist

INSERT INTO SAPSR3.tsora  (TABSPACE, INDSPACE) VALUES ('PSAPSR3USR', 'PSAPSR3USR')

ERROR at line 1:

ORA-00942: table or view does not exist

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2012-05-18 19:54:18

MUT-03025  Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2012-05-18 19:54:18

FCO-00011  The step runDdicoraSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_ORA|ind|ind|ind|ind|0|0|runDdicoraSql was executed with status ERROR .

[Former Member · Accepted solution]

hi expert sonia,

           please help to solve this issue. I am waiting  2 days for your replay.

[former_member189725 · Accepted solution]

Can you please paste the ora_sql_results.log ??

Can give a an idea . The tables mentioned should be present in the system.

Regards

Ratnajit

[Former Member · Accepted solution]

Hello,

The logs that you have pasted shows that the table tsora and iaora does not exist in your DB.

Can you check manually if these tables exist?

Login to DB and execute the following command:

desc sapsr3.iaora;

desc sapsr3.tsora;

Is the table structure displayed?

Regards

Sonia

[Former Member · Accepted solution]

Hi sonia,I also got same error.I excuted that commands but its showing iaora doesnot exist.Now what i have to do

[Former Member · Accepted solution]

Hi Chandra,

Have you skipped any installation steps, mostly "import abap" step?

Regards,

Sonia

[former_member189725 · Accepted solution]

execute the commands in upper case

desc SAPSR3.TAORA

desc SAPSR3.IAORA

These tables should exist in the system and they are modified during the installation.

Regards

Ratnajit

[former_member189725 · Accepted solution]

execute the commands in upper case

desc SAPSR3.TAORA

desc SAPSR3.IAORA

These tables should exist in the system and they are modified during the installation.

Regards

Ratnajit

[Former Member · Accepted solution]

Yes.i skipped

[Former Member · Accepted solution]

Hi ratnajit,i excuted that cmds but its showing doesnot exist

[former_member189725 · Accepted solution]

Which step did you skip ??

[Former Member · Accepted solution]

Hi Ratnajit,

            How can execute the command please tell me step by step.

desc SAPSR3.TAORA

desc SAPSR3.IAORA

[former_member189725 · Accepted solution]

Login as user ora<sid>.

run :  sqlplus "/as sysdba"

sql> desc SAPSR3.TAORA

sql> desc SAPSR3.IAORA

Regards

Ratnajit

[Former Member · Accepted solution]

Hi Ratnajit,

            Thanks for your quick replay. I login what you mention above like that but i am getting this error. kindly help to solve this problem

ORA-01034 ORACLE NOT AVAILABLE

ORA-27101  SHARED MEMORY REALM DOES NOT EXIST

I am expecting your quick replay.

[former_member189725 · Accepted solution]

can you do a shutdown of the database and startup again

sql > shutdown immediate ;

sql> startup

Regards

Ratnajit

[Former Member · Accepted solution]

thanks for your quick replay,

                 I am able to shutdown that,because its asking user name password,i given /as sysdba, my sid password its working shows

ORA-01034 ORACLE NOT AVAILABLE

ORA-27101  SHARED MEMORY REALM DOES NOT EXIST

like this which password i have to give.

[Former Member · Accepted solution]

Hi ratnajit,

i am loging into sql, i gien tha command desc sapsr3.taora,its shows the table there tabsapce not Null

varchar2<15> like this what can i do now?

[former_member189725 · Accepted solution]

Can you retry from the point SAPINST failed ?

I believe these tables exist .

[Former Member · Accepted solution]

Hi Ratnajit,I skipped import ABAP step.

[Former Member · Accepted solution]

Hi Agbarsha,

This shows that the table exists in SAPSR3 tablespace.

Do the same for iaora table, if you get similar display, jsut resume your installation from the point it stopped.

Regards,

Sonia

[Former Member · Accepted solution]

I am trying but the same error coming...