Monthly Archives: January 2013

How to manually modify DB initialization parameters by creating pfile from spfile

pfile is the initialization parameters of DB in plain text, while spfile is the binary one, so to be able to change it, you have to: Extract the pfile from the spfile: “create pfile=’my_path/file_name.ora‘ from spfile;” Shutdown the DB: “shutdown … Continue reading

Posted in Oracle | Tagged , , , , , , | Leave a comment