ORA-48108/ORA-48140/ORA-48187 - Oracle 12c

[Former Member]

Hello Experts,

An error occurred while processing option SAP NetWeaver 7.4 Support Release 2 > Oracle > SAP Systems > Application Server ABAP > Standard System > Standard System( Last error reported by the step:

SQL statement or script failed. DIAGNOSIS: Error message: ORA-48108: invalid value given for the diagnostic_dest init.ora parameter

ORA-48140: the specified ADR Base directory does not exist []

ORA-48187: specified directory does not exist OSD-00002: additional error information O/S-Error: (OS 5) Access is denied. Disconnected.

We are getting this issue while we install Oracle 12C and currently we are in 13of41 phase " Create/Check tablespaces".

Please help us to resolve this issue and to proceed further.

Thanks in advance.

Regards,

Arun K Murugesan

[Former Member]

Hello,

By referring this note 1915302 - Database Software 12.1.0.2 Installation on Windows, I can start the database now.

Read/Modify access has been given to the Oracle folders for the Oracle user(It should not be an admin user and it should not be same as the Installation user), which is clearly explained in the above said note.

But now am facing another issue which is shown below,

SAPINST ORACLE start logging for

STARTUP;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 4 20:23:35 2015

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 2634022912 bytes

Fixed Size            3835496 bytes

Variable Size         1325402520 bytes

Database Buffers     1291845632 bytes

Redo Buffers           12939264 bytes

ORA-00205: error in identifying control file, check alert log for more info

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.

Please advice.

Thanks

Arun K Murugesan.

[Sriram2009]

Hi Arun

Thanks for your information.

I think you have to raise the incident to SAP support. this is first installation error in Oracle 12.1.0.2.0 while raising the message to SAP you have to follow the template for installation issue which has mention in the SAP Note - 1915299 - Troubleshooting Software Installation for 12.1.0.2

BR

SS

[Reagan]

>>ORA-00205: error in identifying control file, check alert log for more info<<

Have you followed this? Check the Oracle alert log to know more.

[Former Member]

>> ORA-00205: error in identifying control file, check alert log for more info

Check that the control files exists in the default location. control_files parameter tells you about that.

If the control files exists, then look after the permissions because I see that you have assigned the permissions manually (Read/Modify access has been given to the Oracle folders for the Oracle user).

Do check the alertlog if that doesn't help.

regards,

pavan

[Sriram2009]

Hi Arun

Could you check the SAP PAM for Oracle 12 supported on SAP NW 7.4 ? as per the PAM its shows only Oracle 11.2 not on Oracle 12.

Could you check the PAM link (Require the SAP S-user id)

https://service.sap.com/sap/support/pam?hash=s%3DSAP%2520NW%25207.4%26o%3Dmost_viewed%257Cdesc%26st%...

BR

SS

[Former Member]

Hello Sriram,

Thanks for your prominent reply.

Request to view this link where I can see Oracle 12.1 is available for NW7.4 Abap stack systems.

Please advice.

https://apps.support.sap.com/sap(bD1lbiZjPTAwMQ==)/support/pam/pam.html?smpsrv=https%3a%2f%2fwebsmp1...

Regards,

Arun K Murugesan