spfile is created in folder DB_UNKNOWN

Using Linux RH4 64Bit with Oracle 10.2.0.3 with OMF on ASM
when we tried to "create spfile from pfile;" the spfile was located in a wrong location:

+DATA1/DB_UNKNOWN/PARAMETERFILE/SPFILE.185.634235343
The link was pointing to the right location.

After some struggles we found the solution in Note: 393932.1
We even managed to fix it by the note instructions:

1. Create a pfile
   SQL> create pfile='/tmp/pfile' from spfile'+DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.272.622486851';

2.
Shutdown and startup mount using the restored spfile
   SQL> startup mount force pfile=/tmp/pfile

3. Restore
the spfile again to the correct location as DB_NAME is correctly set this time.
   RMAN> restore spfile;

4. Startup again using the spfile
   SQL> startup force



UNTIL the next time we had to use "create spfile ...;" the nightmare got back again. L
Eventually we decided to give up this solution and we are using spfile in a regular file system.

Comments

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP

Oracle 18c - New Features for Active Data Guard