Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-17503 unable to start instance on 10g

ORA-17503 unable to start instance on 10g

Hello Forum;

I have a oracle10g RAC with two nodes, I configure Dataguard and now srvctl is not able to start the instance with
srvctl start database -d oracle_name

I think the problem is a configuration issue from ASM alert log:
Errors in file /opt/oracle/admin/+ASM/udump/+asm2_ora_15700.trc:
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +FLASH/dudbdr/spfiledudbdr.ora
ORA-17503: ksfdopn:2 Failed to open file +FLASH/dudbdr/spfiledudbdr.ora
ORA-15173: entry 'spfiledudbdr.ora' does not exist in directory 'dudbdr'


The spfile is located on +DATA instead of +FLASH.

I am able to start the instance manually using sqlplus startup however RAC/ASM configuration is not able to find the correct spfile.

By the way the spfile from +FLASH is where it was originally created at installation time however I reconfigure it.

From Where does RAC/ASM gets the location of the spfile?
2 REPLIES
Jov
Honored Contributor

Re: ORA-17503 unable to start instance on 10g

Hi,

Start the touble instance manually and query the table X$KFFXP and see what you get.

If you can start the instance manually the issue might be else where.


Jov

Re: ORA-17503 unable to start instance on 10g

The problem was on the OCR configuration, Oracle support mentioned that OCR will remember the location of the spfile at creation time and a reconfiguration is required using srvctl command something like:
srvctl modify database -d -p

I run the command and it fixed my problem.
thanks for the help.