tag:blogger.com,1999:blog-6850817271941197798.post6949572387925084374..comments2009-12-21T06:30:58.083-08:00Comments on Oracle DBA and RAC DBA Expert: How to Change Static parameters in SPFILE and PFIL...Satishbabu Gunukulahttp://www.blogger.com/profile/02630966486825083489noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6850817271941197798.post-58379669596522031272009-12-21T06:30:58.083-08:002009-12-21T06:30:58.083-08:00A PFILE is a static, client-side text file that mu...A PFILE is a static, client-side text file that must be updated with a standard text editor like "notepad" or "vi". This file normally reside on the server, however, you need a local copy if you want to start Oracle from a remote machine. DBA's commonly refer to this file as the INIT.ORA file. An SPFILE is a persistent server-side binary file that can only be modified with the "ALTER SYSTEM SET" command. This means you no longer need a local copy of the pfile to start the database from a remote machine. Editing an SPFILE will corrupt it, and you will not be able to start your database anymore.<br /><br /><a href="http://www.zoombits.de/speicherkarten/micro-sd-transflash/transcend-2gb-micro-sdhc-speicherkarte/17866" rel="nofollow">2gb micro sd karte</a>Sara Reidhttp://www.blogger.com/profile/18373862159812719999noreply@blogger.com