<<Back to DB Administration Main Page
There are instances when a DBA need to start the database using pfile, for example to trouble an instance startup error or to validate init file post parameter changes etc.
In such situations you can create a pfile from spfile and once you are done with your changes you can create spfile from updated/modified pfile to start the database.
How to Create Pfile from Spfile
As sysdba execute following command
SQL> create pfile='/tmp/initOrcl.ora' from spfile;
How to Create SPfile from Pfile
As sysdba execute following command
SQL> create spfile from pfile='/tmp/initOrcl.ora';
You can also create the pfile directly from memory
How to Create Pfile from Memory
As sysdba execute following command
SQL> create pfile='/tmp/initOrcl.ora' from memory;
If you have any spectrum Wi-Fi problem. you Can contact spectrum customer care number +1(888)-294-0885 they will guide you in this way.
ReplyDeletechange Wi-Fi name spectrum
spectrum Wi-Fi name change
spectrum support number
spectrum customer care number
I am not certain the place you are getting your information, however good topic. I must spend some time studying more or figuring out more. Thanks for fantastic info I was searching for this information for my mission. shipping container dimensions
ReplyDeletePromote Abhi में आपका स्वागत है Promote Abhi इंडिया की एकमात्र एसी कंपनी है जो आपको Responsive Website Designing, Mobile App Development, Digital Marketing Services, Website Development, Facebook Ads आदि सर्विसेस अफोर्डेबल Price पर देती है अगर आप अपने बिज़नेस को बढ़ाना चाहते है तो आज ही सम्पर्क करे ! Promote Abhi Responsive Website Designing Company in Delhi से +91-9899484839.
ReplyDelete