Skip to content
Home » Oracle » How to Resolve ORA-48140: the specified ADR Base directory does not exist

How to Resolve ORA-48140: the specified ADR Base directory does not exist

ORA-48108 ORA-48140 ORA-48187 OSD-00002

Tried to startup a database on Windows, but it failed with several errors like ORA-48140.

SQL> startup nomount;
ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist [f:\oracle]
ORA-48187: specified directory does not exist
OSD-00002: additional error information
O/S-Error: (OS 3) The system cannot find the path specified.

ORA-48140 means that the destination you specified in the parameter file (SPFILE or PFILE) cannot be found. Most likely, the disk does not mount to the operating system.

In this case, drive f:\ has not failed over to the database server, we have to find out why and exclude the problem before starting the database again.

Leave a Reply

Your email address will not be published. Required fields are marked *