What to do if the binary spfile is wrong for the default instance?
- 1 Answers
- 1147 Views
- I also Faced
- E-Mail Answers
Answer Posted / Nivedita
If the binary SPFILE for the default instance is wrong, you can create a new one or restore it from a backup. To create a new one, follow these steps:
1. Connect to the database as SYSDBA: `sqlplus / as sysdba`
2. Create a new SPFILE using the CREATE SPFILE FROM DBA_REGISTER_FILE command: `CREATE SPFILE FROM DBA_REGISTER_FILE;`
3. Check the location and content of the newly created SPFILE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
How to select all columns of all rows from a table in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Design database draw er diagram for a certain scenario ?
How to start an oracle instance?
How to write a left outer join with the where clause in oracle?
What is oracle latest version?
How to put more than 1000 values into an oracle in clause?
