We have an init.ora file points to the spfile:
oracle@pind41(PROD1/DBTier):$ cat initPROD1.ora
spfile='+DSKGRP1/PROD/PARAMETERFILE/spfilePROD.ora'
we started up the database using the actual initPROD1.ora.final file
oracle@pind41(PROD1/DBTier):$ ls -l initPROD1.ora.final
-rw-r--r-- 1 oracle oinstall 5438 Feb 21 08:07 initPROD1.ora.final
Then create spfile using following command:
SQL> create spfile='+DSKGRP1/PROD/PARAMETERFILE/spfilePROD.ora' using pfile;
SQL> shutdown immediate;
SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DSKGRP1/PROD/PARAMETERFILE/spfilePROD.ora'
ORA-17503: ksfdopn:2 Failed to open file +DSKGRP1/PROD/PARAMETERFILE/spfilePROD.ora
ORA-01000: maximum open cursors exceeded
The above issue is due to creating spfile without specify the pfile so the default pfile was used to create the spfile. The default pfile is a pointer to the spfile.
Two ways to avoid the problem:
1. Follow Metalink Note 419509.1, specify the pfile with full path and file name when creating spfile.
2. rename initPROD1.ora to be initPROD1.ora.spfile and copy initPROD1.ora.final to initPROD1.ora, then startup database and create spfile. Copy initPROD1.ora.spfile to initPROD1.ora and then startup force.
REF:
ORA-01565 on database STARTUP due to failure to pen SPFILE[ID 419509.1].
Subscribe to:
Post Comments (Atom)
“Benjamin Briel Lee was very professional at all times, keeping me aware of everything that was happening, If I had any questions he was always available to answer. This was my first home purchase, I didn’t know much about the loan process, he made it very easy to understand the things I had questions about. I really enjoyed working with him.”
ReplyDeleteHe's a loan officer working with a group of investor's who are willing to fund any project or loan you any amount with a very low interest.Contact Benjamin Briel Lee E-Mail: lfdsloans@outlook.com Whats-App Number: +1-989-394-3740.