LRM-00101: unknown parameter name 'diagnostic_dest

[former_member250429]

Dear SAP Gurus

I am performing NWCE 711 installation on windows serevr 2008 R2 Platform with Oracle DB.I installed Oracle DB successfully and patched it to Patchset 10.2.0.5 and applied Generic patches as well

Finally i started with SAPinst and during the DATABASE CREATION PHASE  my installation got struck with below error

ORA-01078: failure in processing system parameters

LRM-00101: unknown parameter name 'diagnostic_dest'

I checked some SDN links and SAP notes which suggests that thsi paremeter is available for Oracle 11g

Below is the log for Ora_sql_results

================================================================================
2012-04-13, 16:51:06 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Apr 13 16:51:06 2012

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

Connected to an idle instance.

ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name 'diagnostic_dest'
Disconnected

SAPINST: End of output of SQL executing program D:\ORACLE\MID\102_64/bin/sqlplus.

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

2012-04-13, 16:51:07 SAPINST ORACLE stop logging

____________________________________________________________________________________________

Please suggest  me the way to proceed or  anySAP note ,it is really urgent for us.

Attached is the file for SAPINST_DEV.LOG

Regards

[former_member250429 · Accepted solution]

Hello

I made a miskte while giving SAPINST input thats why we were getting this issue.

During Database input parameters by Default SAPINST will show DB version as 112 i.e 11G

their we have to select 102 i.e 10G using drop down.

Regards

[former_member182034]

hi Basis,

You are getting issue during SQL startup and some parameters are also not correct in initSID.ora.

try to start with pfile.

SQL>startup <Path\Init<sid>.ora>

if you still get issue then use the ORADIM utility to recreate it.

Regards,

[former_member189546]

Hello,

Please check Windows paging file size needs to be at least 20Gb

Also check note  830576 Parameter recommendations for Oracle 10g

regards,

John Feely

[former_member250429]

Thaks John for your update !!!

Swap size is already 22GB  for our system and The SAP note you mentioend is definately for 10g.

But in our case SAPInst created initsid.ora file along with some parametrs for 11g.

I have raised issue to SAP.And they also confirmed that it is Pointing to 11g.

I am still waiting for the exact soluton from them.Once i will come to know i will upadte it here.

Regards