but the message are allthe same, afer editing the pfile,
SQL> startup pfile='c:\pfile.ora'; ORA-27100: shared memory realm already exists SQL> shutdown abort; ORACLE instance shut down. SQL> startup pfile='c:\pfile.ora'; ORA-27100: shared memory realm already exists SQL> shutdown ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SQL> create spfile from pfile='c:\pfile.ora'; File created. SQL> statup SP2-0042: unknown command "statup" - rest of line ignored. SQL> startup ORA-27100: shared memory realm already exists SQL> shutdown abort; ORACLE instance shut down. SQL> startup ORA-27100: shared memory realm already exists
Here's a suggestion :
On Windows the database can be restarted as a service. You should be able to restart it from the services control panel.
However, the default for that restart would be to expect the parameter file to be call initorcl1.ora in %ORACLE_HOME%\database,
Check if you have a paramete file in %ORACLE_HOME%\database. Make a backup of it and then copy your updated c:\pfile.ora to the expected file name initorcl1.ora (if your ORACLE_SID is orcl1)
Then restart the Oracle services using the Windows Control Panel
Hemant K Chitale
there is spfile there in the %ORACLE_HOME%\database, lcoation. not the pfile.
i just delete the spfile
update my pfile and increase the processes parameter to 1000 as JohnWatson said.
and recreate the spfile from that pfile which i edited.
and start the service from control panel.
and it up.
what was the reason?
i dont know how to choose words to thank you guys?
you are really very very extreamly kind and humble and have patient to listen to us.
oracle forums have the world best personalities in their field.
thank you so much gurus.
I have already told you to increase the SESSIONS parameter. However, by default it will have moved with PROCESSES, so probably no problem.
You have no reason to increase the SGA, but anyway, you can't. You can go above 1.7G total PGA+SGA on a pure 32bit system by setting up PAE, but you can't do that with 64bit Windows. So you need to convert your database to 64bit.
Moving from 32bit to 64 bit Oracle is easy, if you can download the 64bit software. However, You are using release 10.2.0.3 which (I think) was the publicly available release. That implies that you do not have an extended support contract, and therefore any upgrade would be illegal. If you do have an extended support contract, then contact Oracle Support for the appropriate software.
thank you jhon watson,
i was just discussing the help you guys provided to me with my other coleages, and your behaviour, not being engry by posting incomplete or wrong information, humble and kind.
we have a license, and we have a license of 11g. we are moving to it after vacation which is happening after 1 week(2 months vacation).
i will install and configure 11g database then.
and finally , i thank to you specially, and to all the kind personalities here, who just care about our problems and help us to overcome it without even knowing us.
thank you much all of you.