Error install Solman 7.0 on import abap step

[putinan_suramarna]

Hi Expert,

I found the error form " import abap " step as below, How to check and solve it,

Please advice me.

importmonitor.java.log_

java version "1.4.2.21"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2.21-081211-23:19)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2 1.4.2.21-081212-03:09-PA_RISC2.0W

PA2.0W (aCC_AP), mixed mode)

Import Monitor jobs: running 1, waiting 0, completed 28, failed 0, total 29.

Loading of 'SAPVIEW' import package: ERROR

Import Monitor jobs: running 0, waiting 0, completed 28, failed 1, total 29.

ERROR: 2009-08-07 12:23:39 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/SOL/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPV

IEW.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: 2009-08-07 12:24:02

All import packages are processed.

WARNING: 2009-08-07 12:24:02

1 error(s) during processing of packages.

INFO: 2009-08-07 12:24:02

Import Monitor is stopped.

/usr/sap/SOL/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -

stop_on_error

- SAPVIEW.log -

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/SOL/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20090807122339

Thank you,

[putinan_suramarna]

Hi All,

After reduce the sga size and try to manaul R3load command and then return the screen as below.

soladm 21> /usr/sap/SOL/SYS/exe/run/R3load -i /tmp/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/SAPVIEW.cmd -dbcodepage 4102 -l /tmp/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/SAPVIEW.log -stop_on_error

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

I not sure this is true command to used.

soladm 33> ll

total 4

-rw-rr 1 soladm sapsys 1095 Jul 1 00:02 DEFAULT.PFL

drwxr-xr-x 2 soladm sapsys 96 Jul 29 12:48 oracle

soladm 34> more DEFAULT.PFL

SAPDBHOST = xxxx

j2ee/dbtype = ora

j2ee/dbname = SOL

j2ee/dbhost = xxxx

SAPSYSTEMNAME = SOL

SAPGLOBALHOST = xxxx

rdisp/bufrefmode = sendoff,exeauto

DIR_PUT = /usr/sap/$(SAPSYSTEMNAME)/put

#----

---

1. SAP Message Server for ABAP

#----

---

rdisp/mshost = xxxx

rdisp/msserv = sapmsSOL

rdisp/msserv_internal = 3900

#----

---

1. SAP Central Service Instance for J2EE

#----

---

j2ee/scs/host = xxxx

j2ee/scs/system = 01

j2ee/ms/port = 3901

#----

---

1. SAP Message Server for ABAP

#----

---

#----

---

1. SAP Central Service Instance for J2EE

#----

---

login/system_client = 001

Please advice me.

Thank you for your help.

Putinans.

[markus_doehr2]

> soladm 21> /usr/sap/SOL/SYS/exe/run/R3load -i /tmp/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/SAPVIEW.cmd -dbcodepage 4102 -l /tmp/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/SAPVIEW.log -stop_on_error

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

> sapparam(1c): No Profile used.

> sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

>

> I not sure this is true command to used.

You have to read the LOGFILE (SAPVIEW.log) that you just entered where the output is to be written to.

Markus

[putinan_suramarna]

Hi,

The result after change is not work.

SQL> alter system set sga_target=512M;

System altered.

SQL> show parameter SGA_TARGET

NAME TYPE VALUE

-

---

-

---

-

---

sga_target big integer 1728M

The SAPVIEW.log from sapinst directory

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20090814132951

/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/SOL/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 20:28:43

/usr/sap/SOL/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP VIEW "/CEM/V_PCRCMAP_D")

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 "/CEM/V_PCRCMAP_D" ( "CLIENT" , "APPLICATION" , "PROCESS_CODE" , "PC_DESCRIPTION" , "REASON_CODE" , "RC_DESCRIPTION" ,

"LANGU" ) AS SELECT T0001."CLIENT", T0001."APPLICATION", T0001."PROCESS_CODE", T0002."DESCRIPTION", T0001."REASON_CODE", T0003."D

ESCRIPTION", T0002."LANGU" FROM "/CEM/C_PCRCMAP" T0001, "/CEM/C_PR_CODE_T" T0002, "/CEM/C_RESCODE_T" T0003 WHERE T0002."LANGU" = T00

03."LANGUAGE" AND T0002."PROCESS_CODE" = T0001."PROCESS_CODE" AND T0003."REASON_CODE" = T0001."REASON_CODE" AND T0002."APPLICATION"

= T0003."APPLICATION" AND T0003."CLIENT" = T0001."CLIENT" AND T0002."APPLICATION" = T0001."APPLICATION")

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]

HI

Now value assigned previously target value was 0.

Also log giving meaningful error

see the url

http://www.saptechies.com/sap-47-installation-error-ora00942-table-or-view-does-not-exist/

Surendra

[putinan_suramarna]

Hi Surendra,

The result for your question.

Total System Global Area 1795162112 bytes

Fixed Size 2069912 bytes

Variable Size 905972328 bytes

Database Buffers 872415232 bytes

Redo Buffers 14704640 bytes

NAME TYPE VALUE

-

---

-

---

-

---

resource_manager_plan string

resumable_timeout integer 0

rollback_segments string

serial_reuse string disable

service_names string SOL

session_cached_cursors integer 20

session_max_open_files integer 10

sessions integer 96

sga_max_size big integer 1712M

sga_target big integer 0

shadow_core_dump string partial

NAME TYPE VALUE

-

---

-

---

-

---

shared_memory_address integer 0

shared_pool_reserved_size big integer 86973087

shared_pool_size big integer 832M

shared_server_sessions integer

shared_servers integer 0

skip_unusable_indexes boolean TRUE

smtp_out_server string

sort_area_retained_size integer 0

sort_area_size integer 2097152

spfile string

sql92_security boolean FALSE

Thank you for your help.

Putinans.

[rsil_team]

Can U increase SGA_target atleast 512M then

try to restart ur process

[Former Member]

Sorry

i'h replied by my official ID Hemant nagar

Kindly update as suugested above what is the error message after increasing sga target 512M

Surendra Jain

[putinan_suramarna]

The status

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

COMP_NAME

-

---

VERSION STATUS

-

---

-

---

Oracle Database Catalog Views

10.2.0.4.0 VALID

Oracle Database Packages and Types

10.2.0.4.0 VALID

2 rows selected.

SQL> select status from v$instance;

STATUS

-

---

OPEN

1 row selected.

[Former Member]

Hi,

What is SGA Size ??

Surendra

[markus_doehr2]

> What is SGA Size ?

No offense - but I HIGHLY suggest attending an Oracle class before you continue.

Oracle is a very complex software and if you don't know even basic things about database memory management and how the database works internally the whole installation and maintenance thing will become a very frustrating experience for you.

Again - no offense - just a recommendation.

Markus

[rsil_team]

Dear markus,

Oracle 10g having one background process that is MMAN(Memory Manager)..

MMAN is responsible sizing the memory components and scheduling resizing operations. MMAN continues

check and used best memory distrubition.

If Sga_Target set to zero then have to calculate some other memory parameter like

shared_pool,java_pool,cache etc ... all these r depends on sga_target and target value can not exceed max size.

in above case sga target assigned almost all sga max ,it should not.

Sap not recommend to change target .

anyway ur suggestion always welcome.

Surendra

[Former Member]

Dear Markus,

reply of "hemant nagar" is my thread.Some probelm in single sing-on.

YS ,it was wrong i suggest 512M while its not possible

it should be sga_target > shared_pool+log buffer ....

Surendra

Edited by: Surendrajain2003 on Aug 14, 2009 5:29 PM

[Former Member]

Hi

Check the status of your database as markus said

sqlplus "/as sysdba"

sql>select status from v$instance;

check is your database open

Regards

Uday

[putinan_suramarna]

Yes, it's same error. ( I run ./sapinst as root user)

[markus_doehr2]

Please check if your Oracle database is available (or restart the database).

Markus

[putinan_suramarna]

The result for test from user soladm

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = xxxx) (PORT = 1527))) (CONNECT_DATA = (SID = SOL) (GLOBAL_NAME = SOL.WORLD)))

OK (60 msec)

xxx:soladm 3> lsnrctl status

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 13-AUG-2009 17:52:04

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SOL.WORLD))

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production

Start Date 13-AUG-2009 02:05:18

Uptime 0 days 15 hr. 46 min. 46 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/SOL/102_64/network/admin/listener.ora

Listener Log File /oracle/SOL/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SOL.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SOL)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxx)(PORT=1527)))

Services Summary...

Service "SOL" has 1 instance(s).

Instance "SOL", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

Regards,

[markus_doehr2]

And if you now repeat the installation (continue old) - does the same error come up again?

Markus

[putinan_suramarna]

Hi ,

I has already start it after finish install oracle patch.

Regards,

[markus_doehr2]

Can you execute (as <sid>adm user)

tnsping <SID>

Markus

[putinan_suramarna]

Hi all,

I follow up to install ora patch to 10.2.0.4 set3 and run install agains.

It's not work( look like the same error). How to solve it.

Please advice me.

[markus_doehr2]

> I follow up to install ora patch to 10.2.0.4 set3 and run install agains.

> It's not work( look like the same error). How to solve it.

After you updated to 10.2.0.4, did you start your listener?

Markus

[putinan_suramarna]

Hi All,

The listener is already start before reinstallation but still has same error form the console.

Oracle version is 10.2.0.1.0 I not sure it's must update the patch before run it's again.

Please advice me.

Thank you.

[markus_doehr2]

Read the installation guide!

10.2.0.1 is not supported. According to the installation guide you have to

- install the version delivered with the DVD set (10.2.0.1)

- instal the latest patch (10.2.0.2. or 10.2.0.4)

- install the latest interim/mini patch

and THEN continue with the installation (sapinst).

Markus

[markus_doehr2]

It seems, as already suggested, that your listener crashed.

What database patchlevel are you using?

Markus

[sunny_pahuja2]

Hi,

Check listener should be running.

Also, Check SAP Note 491174 - Composite SAP note for ORA-01034

Thanks

Sunny