Alter system set Processes=2 SCOPE=SPFILE;After this when the system was restarted I have not been able to connect to Oracle. It gives me the error:
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not existI searched the whole globe for a solution. From a forum I found a solution that told to start Oracle from pfile. But the problem that I am facing here is that I couldn't even go to the SQL prompt because of the errors mentioned above.
You need to modify your SPFILE's contents. Unfortunately, you cannot start the instance. So try this little trick:
- STARTUP NOMOUNT the instance
- CREATE PFILE FROM SPFILE;
- Using a text editor, modify the pfile to have more than two processes. The pfile will be in the default location.
- CREATE SPFILE FROM PFILE;
- ALTER DATABASE OPEN;
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.