Saturday, 14 October 2017

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 !!

No comments:

Post a comment