ORA-012621 and ORA-01262 Errors in Oracle Database | Oracle 11g

ORA-012621 and ORA-01262 Errors in Oracle Database | Oracle 11g

ORA-012621 and ORA-01262 Oracle Errors

These errors came when I tried to bring the instance up using PFILE. Although the parameters were defined properly in the pfile but still I got the below mentioned error.

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 13 06:30:32 2017

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

Connected to an idle instance.

SQL> startup nomount pfile=/home/oracle/pfilekol_12Oct17.ora

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated

ORA-01262: Stat failed on a file destination directory

IBM AIX RISC System/6000 Error: 2: No such file or directory

SQL> quit

Disconnected

$

Solution:

The main reason was described here in "IBM AIX RISC System/6000 Error: 2: No such file or directory" where I came to know that the db_recovery_file_dest destination which I had provided in the PFILE was not physically available to be accessed. So I created one and then retried mounting the database, This time it was successful.

I hop this helps !!