Error by installing SolMan 4.0 on Wind x64/Oracle - Phase ABAP Inport

[Former Member]

Hello,

I'm trying to install Solution Manager on a 2GB Virtual Machine with Windows 2003 x64 and Oracle 10.2.0.2. The installation stops by the ABAP Import:

The Log File SAPAPPL2.log ends with:

(DB) INFO: MOB_DEVCFG created #20151127222241

(IMP) INFO: import of MOB_DEVCFG completed (96 rows) #20151127222241

(DB) INFO: MOB_DEVCFG~0 created #20151127222241

(DB) INFO: MOB_DEVPFE created #20151127222241

(IMP) INFO: import of MOB_DEVPFE completed (50 rows) #20151127222241

DbSl Trace: Error 604 in exec_immediate() from oci_execute_stmt(), orpc=0

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

(DB) ERROR: DDL statement failed
 ( ALTER INDEX "MOB_DEVPFE~0" LOGGING )
 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 4136 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","Typecheck","seg:kggfaAllocSeg")
(DB) INFO: disconnected from DB

C:usrsapSM0SYSexeucNTAMD64R3load.exe: job finished with 1 error(s)
C:usrsapSM0SYSexeucNTAMD64R3load.exe: END OF LOG: 20151127222242

I tried to decrease the parallel processes from 3 to 1 and I increased the variable shared_pool_size in the file init.ora from 67MB (proposed by the installer) to 350MB, but I get the same error.

Any idea?

Thanks and best wishes,

Tommaso

[Former Member · Accepted solution]

Hi,

As you already stated.

You don't have enough memory in the Oracle shared pool due to:

1) The shared pool may be fragmented

2) You really don't have enough space

You may be able to get pass this specific error by manually flushing the pool and then retrying the sapinst phase.

sqlplus / as sysdba

alter system flush shared_pool;

If that doesn't work you can generally increase your shared_pool on the fly:

1) decrease your db buffer cache

alter system set db_cache_size = new_sizem (new_sizem would be 500m for 500 mb)

2) alter system set shared_pool_size - new_sizem;

[Former Member · Accepted solution]

Hi,

<b>Thanks! </b>

Now the import has finished.

After rebooting the database couldn't really start (although the services were up!).

For the people who may have the same problem:

C:Documents and Settingssm0adm>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Nov 28 22:21:17 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  301989888 bytes
Fixed Size                  2053112 bytes
Variable Size             159386632 bytes
Database Buffers          134217728 bytes
Redo Buffers                6332416 bytes


SQL> alter system flush shared_pool;

System altered.


SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.


SQL> startup open
ORACLE instance started.

Total System Global Area  301989888 bytes
Fixed Size                  2053112 bytes
Variable Size             159386632 bytes
Database Buffers          134217728 bytes
Redo Buffers                6332416 bytes
Database mounted.
Database opened.



SQL> alter system flush shared_pool;

System altered.

[salah_zinet]

Hi,

Thank you very much Tommaso and somckit,

I had the same problem, and that resolved my issue,

Regards.