error while installing ECC6.0with PI

[Former Member]

SAPinst ADMINISTRATOR@system:SAP ERP 2005 Support Release2 > SAP Systems > Oracle > central instance >central system installation.

in the step 4:-Execute service;phase 19 of 95----

---

import ABAP.

THIS IS THE ERROR IN LOG BROWSER

CJS-30022 PROGRAM 'MIGRATION MONITOR' EXITS WITH ERROR CODE 103.FOR DETAILS SEE LOG FILE(S) IMPORT_MONITOR.JAVA.LOG,IMPORT_MONITOR.LOG.

FC0-00011 THE STEP runMigrationMonitor with step key |NW_0neHost|ind|ind|ind|ind|0|0|NW_0nehost_system|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR.

and in the log file

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)

Import Monitor jobs: running 1, waiting 18, completed 0, failed 0, total 19.

Import Monitor jobs: running 2, waiting 17, completed 0, failed 0, total 19.

Import Monitor jobs: running 3, waiting 16, completed 0, failed 0, total 19.

Loading of 'SAPAPPL0' import package: OK

Import Monitor jobs: running 2, waiting 16, completed 1, failed 0, total 19.

Import Monitor jobs: running 3, waiting 15, completed 1, failed 0, total 19.

Loading of 'SAPAPPL1' import package: OK

Import Monitor jobs: running 2, waiting 15, completed 2, failed 0, total 19.

Import Monitor jobs: running 3, waiting 14, completed 2, failed 0, total 19.

Loading of 'SAPSDIC' import package: OK

Import Monitor jobs: running 2, waiting 14, completed 3, failed 0, total 19.

Import Monitor jobs: running 3, waiting 13, completed 3, failed 0, total 19.

Loading of 'SAPCLUST' import package: OK

Import Monitor jobs: running 2, waiting 13, completed 4, failed 0, total 19.

Import Monitor jobs: running 3, waiting 12, completed 4, failed 0, total 19.

Loading of 'SAPSLEXC' import package: OK

Import Monitor jobs: running 2, waiting 12, completed 5, failed 0, total 19.

Import Monitor jobs: running 3, waiting 11, completed 5, failed 0, total 19.

Loading of 'SAPSSRC' import package: OK

Import Monitor jobs: running 2, waiting 11, completed 6, failed 0, total 19.

Import Monitor jobs: running 3, waiting 10, completed 6, failed 0, total 19.

Loading of 'SAPPOOL' import package: OK

Import Monitor jobs: running 2, waiting 10, completed 7, failed 0, total 19.

Import Monitor jobs: running 3, waiting 9, completed 7, failed 0, total 19.

Loading of 'SAPSDOCU' import package: OK

Import Monitor jobs: running 2, waiting 9, completed 8, failed 0, total 19.

Import Monitor jobs: running 3, waiting 8, completed 8, failed 0, total 19.

Loading of 'SAPSPROT' import package: OK

Import Monitor jobs: running 2, waiting 8, completed 9, failed 0, total 19.

Import Monitor jobs: running 3, waiting 7, completed 9, failed 0, total 19.

Loading of 'SAPSLOAD' import package: OK

Import Monitor jobs: running 2, waiting 7, completed 10, failed 0, total 19.

Import Monitor jobs: running 3, waiting 6, completed 10, failed 0, total 19.

Loading of 'SAPUSER' import package: OK

Import Monitor jobs: running 2, waiting 6, completed 11, failed 0, total 19.

Import Monitor jobs: running 3, waiting 5, completed 11, failed 0, total 19.

Loading of 'SAPDDIM' import package: OK

Import Monitor jobs: running 2, waiting 5, completed 12, failed 0, total 19.

Import Monitor jobs: running 3, waiting 4, completed 12, failed 0, total 19.

Loading of 'SAPDFACT' import package: OK

Import Monitor jobs: running 2, waiting 4, completed 13, failed 0, total 19.

Import Monitor jobs: running 3, waiting 3, completed 13, failed 0, total 19.

Loading of 'SAPDODS' import package: OK

Import Monitor jobs: running 2, waiting 3, completed 14, failed 0, total 19.

Import Monitor jobs: running 3, waiting 2, completed 14, failed 0, total 19.

Loading of 'SAPUSER1' import package: OK

Import Monitor jobs: running 2, waiting 2, completed 15, failed 0, total 19.

Import Monitor jobs: running 3, waiting 1, completed 15, failed 0, total 19.

Loading of 'SAP0000' import package: OK

Import Monitor jobs: running 2, waiting 1, completed 16, failed 0, total 19.

Loading of 'SAPAPPL2' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 16, failed 1, total 19.

Loading of 'SAPSSEXC' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 16, failed 2, total 19.

[Former Member]

hi EXPERTS,

i want to configure PI using ECC6.0.

my hard disk space is 250gb---233 net.

RAM -

---

2GB.

PROCESSOR -

---

2.8 DUAL CORE INTEL

OPERATING SYSTEM:-WINDOWS 2003 ENTERPRISE EDITION.

PARTITIONS:-

C:-5GB 2046-3950 VIRTUAL MEMORY

D:-228GB 5000-5500 VIRTUAL MEMORY

MY SYSTEM NAME IS -

---

SYSTEM.

I CONFIGURED MICROSOFT LOOPBACK ADAPTER.

THEN INSTALLED j2sdk-1_4_2_12-windows-i586-p AND PUT ENVIRONMENT VARIABLES.

AFTER I INSTALLED ORACLE 10G WITH DATABASE NAME "ORCL".

AFTER THAT SELECT InsMaster\IM_WINDOWS_I386->SAPINST.EXE

THEN SAPERP2005 SUPPORT RELEASE 1->SAP SYSTEM --> ORACLE > CENTRAL SYSTEM> CENTRAL INSTANCE INSTALLATION.

AFTER THAT IN STEP 2 , I SELECTED ECC , AS ABAP , AS JAVA , PI.

ASKED FOR JAVA COMPONENTS AND I GAVE THAT ONE.

THEN JCE POLICY AND I GAVE THAT ONE.

SAP SID-->ERP.

INSTALLATION DRIVE :-D:

MASTER PASSWORD.

DB ID :--AND I GAVE THIS AS ORC.

DB HOST:- IT TAKE AUTOMATICALLY(SYSTEM-NAME OF THE SYSTEM)

THEN I GAVE THE EXPORT1 PATH

THEN EXPORT6 PATH

THEN EXPORT 2,3,4&5.

THEN IT ASKED FOR ORACLE CLIENT,KERNAL AND BS2005 AND I GAVE ALL THE DETAILS.

IT ASKED FOR TO CONFIGURE SLD AND I SELECT RADIO BUTTON " REGISTER IN EXISTING CENTRAL SLD(DEFAULT)"

THEN IN SLD:-

SELF REGISTRATION OF JAVA ENGINE IN CENTRAL SLD

SLD HTTP HOST:- SYSTEM (I GAVE MY SYSTEM NAME)

SLD HTTP PORT:- 50100 (I GIVE THAT PORT AS 50000)

SLD DATA SUPPLIER USER :-SLDDSUSER(AUTOMATICALLY GENERATED).

PASSWORD:-GENERATED.

SELF REGISTRATION OF ABAP ENGINE IN CENTRAL SLD:-

SLD GATEWAY HOST:-SYSTEM (I GAVE MY SYSTEM NAME)

SLD GATEWAY INSTANCE NUMBER:-02COMMUNICATION WITH CENTRAL SLD:-

SLD ABAPAPIUSER:-SLDAPIUSER(GENERATED)

PASSWORD:-(GENERATED)

AFTER THAT IT ASKED FOR SOLUTION MANAGER KEY AND I GIVE THAT ONE .

IN IMPORT ABAP PHASE I GOT AN ERROR. I HAVE DONE ALL THE PREVIOUS SUGGESTIONS WHICH WERE GIVEN BY EXPERTS AND I GOT THAT SAME ERROR ONCE AGAIN SO IAM POSTING THESE DETAILS TO GET THE CORRECT SOLUTION.

[markus_doehr2]

> AFTER I INSTALLED ORACLE 10G WITH DATABASE NAME "ORCL".

this is wrong. Read the installation guide! The database must not be created before. Did you install the latest patchset and the interim patch/minipatch after you installed the database software and before continuing?

Since there is no SLD to register you should create an SLD rather to register in one than is not yet existing.

And: writing in CAPITAL lettes means SHOUTING at people.

Markus

[Former Member]

what isa meant by this:-

sqlplus /nolog

sqlplus "/ as sysdba"

Shutdown immediate; :- is this shut down oracle or shut down windows.

startup mount; :- what is meant by mount.

exit :- what is this?

will i relogin to administrator to start installation or continue with <sid>adm.

iam selecting radio button continue from the previous installation

[markus_doehr2]

what isa meant by this:-

sqlplus /nolog

sqlplus "/ as sysdba"

Shutdown immediate; :- is this shut down oracle or shut down windows.

startup mount; :- what is meant by mount.

exit :- what is this?

I HIGHLY suggest you first get an Oracle class before you fiddle with the database (no offense!). It´s audacious to run a system without even knowing some basics about the database. Running an Oracle system is not point-and-click, you need some background to understand what you are doing.

Check

http://68.142.116.68/docs/cd/B19306_01/server.102/b14196/toc.htm

Markus

[Former Member]

i tried with spfile<sid>.ora also.

but still i got the same error.

i changed the value of shared pool size to 600 mb(629145600 bytes) and

SGA_MAX_SIZE TO 1 GB(1073741824 BYTES).

THEN ALSO I GOT THE SAME ERROR.

PLZ HELP ME TO RESOLVE THE ERROR.

[Former Member]

i logged in to <sid>adm and login to to sql and shut down immediatly.

also change the shared_pool_size to 412345678.

then restarted the computer.

then run the installation again and select the radio button:-(continue from the previous installation ).

then also the same error.

it shows me total:-19 completed:-16 failed:-2 waiting:-1

can you send solution for this.

[Former Member]

You changed the shared_pool_size by editing the init<SID>.ora?

Is there any spfile.ora at the same folder? Which one do you use to open your database?

If you use the spfile.ora, then you have to change this one instead of init<SID>.ora.

[Former Member]

Still the same error , i can not resolve it,can u send me related answer.

[Former Member]

You are logged in as user "administrator"?

If so, please log off and login again as <sid>adm and run the commands to restart your database.

[former_member204746]

first, start service SAPserviceSID service

second, change shared_pool_size to 412345678

[Former Member]

i started that tns listner service and still it is not working.

sysdba.

[Former Member]

What do you mean?

Which is the error now? Still the same? something new?

[Former Member]

hi

when i try to connect sqlplus "/ as sysdba" -

---

iam getting ERROR as

ora 12560 TNS protocol adapter.

could you plz resolve this.

[Former Member]

Well, it looks like your listener is not running.

Check the Windows service "OracleSID102tnslistener". Start it and try to run again the sqlplus command.

[Former Member]

that master password is not working.

could anyone tell me password for sysdba.

i tried scott/tiger and system manager. both are not acepting.

then sysdba with my master password---but still not working.

[Former Member]

Hi,

you don' t need a password. You just need to put it into quotes. Just do the following:

Open cmd.exe and run:

sqlplus "/ as sysdba"

shutdown immediate

startup

exit

Then try to continue your installation.

Regards,

Konstantina

[former_member201054]

Hi ,

the system got shutdown in the middle (or )Are you trying the installation one more time?...

you need to give a password for sysdba

Just follow the below steps

Logon as ora<SID> at os level

then

sqlplus /nolog

sqlplus "/ as sysdba"

Shutdown immediate;

startup mount;

exit

[Former Member]

hi

currently my shared_pool_size is 160274841.

10% shared pool size current.

how much should i increase to overcome the problem

share_pool_reserve size---16027484.

log buffer------1048576

which value should i increase and how much?

plz reply me.

[former_member204746]

go to directory X:\oracle\SID\102\database

then, edit file initSID.ora

save file

restart Oracle.

sounds easy?

[Former Member]

the user name sysdba is asking for password.

and i dont know the password.

does any one tell me the password for sysdba?

[Former Member]

then the password will be the same that you have given at the time of installing oracle.

Regards

Ashok

[Former Member]

how to do this

increase "shared_pool_size" in init*.ora

explain to me in detail .

[Former Member]

what is the password for sysdba

[Former Member]

Hi,

is it asking for password,i think it does not require a password.

Regards

Ashok

[former_member204746]

before shutting down database, increase "shared_pool_size" in init*.ora

then, restart database

[Former Member]

hi markus,

i didnt understand what u r saying?

could u plz tell the detail explanation of what u say

open cmd.exe

what is the password for sysdba.

then what is startup.

plz tell me those.

[markus_doehr2]

Start - execute - cmd.exe

Then enter the commands as given.

Markus

[Former Member]

SAPAPPL2.LOG FILE

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "T77PP_HEAD~0" ON "T77PP_HEAD" ( "MANDT", "OTYPE", "HEADID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select o.owner#,o.name,o.nam...","Typecheck","kgghtInit")

(DB) INFO: disconnected from DB

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

D:\usr\sap\ERP\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20140919073836

[markus_doehr2]

> ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select o.owner#,o.name,o.nam...","Typecheck","kgghtInit")

This is a common problem.

A quick fix can be a restart of the database:

open cmd.exe

sqlplus / as sysdba
shutdown immediate
startup

Then retry the installation.

Markus

[markus_doehr2]

Do not duplicate posts:

Markus

[shabeer]

Can you paste the SAPAPPL2.log file here.. few last lines only