Whenever some instance is up (imean startup has been issued and databse is up) how can I identify which init.ora file was used by that instance.
I ask this because in 9i we also have spfile in adition to pfile.
So if some instance is up then which file was used by the instance for its parameters??
Was it the pfile or the spfile ??
How can I find this.
I have one database named PROD but its init file is initbgatod1.ora
After searching the contents of the initbgatod1 file i realised that this is the init file for the PROD instance.
How can i find this information when the database is up from the database itself as to which file was used tin the startup ??