Which init.ora

If you use Database Configuration Assistant to create a database, then the initialization parameter file is automatically created for you. Parent topic: Overview of Initialization Parameter File. To customize Oracle Database functions, you may be required to edit the initialization parameter file. Oracle does not recognize the renamed file as an initialization parameter file, and it is not used after the instance is started.

Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Regards, JG. Regars, JG. Elaine Hacklander Posted August 25, 0 Comments. Register or Login. Here is a sample init. If we want to start a remote db we need a local pfile.

RMAN Recovery manager which helps in data backup recovery process does not keep the backup of pfile or init. We do not need a local copy in case of spfile if we need to start a remote database. As this file is maintained by the server the parameters are validated before they are accepted.

RMAN keeps the backup of spfile. Improve this answer. Thanks for the explanation. The difference between init. However for init. When an Oracle database is started, the process will always use spfile. If the spfile. Problem on init 0, execution is the same with init 6. When I do init 0 to shutdown the machine to go to ok prompt, what it did was shutdown and reboot like an init 6 command do. I did check the corresponding rc scripts that were involved with init 0 and compared with rc Hi all, Am intermittently getting the following errors on one of my databases.

How to I change init levels after typing init 1. How do I change the init back to 3? Everytime when i issue command init 6 OR init 0 it just logout and prompt for login again instead of rebooting the server when run init 6 and system shutdown when run init I can only reboot the system using reboot RedHat Commands. OpenSolaris Commands. Linux Commands. SunOS Commands. FreeBSD Commands. Full Man Repository.

Advanced Search. Contact Us.