This discussion is archived
1 2 3 Previous Next 42 Replies Latest reply: Jul 4, 2013 1:26 AM by Maahjoor Go to original post RSS
  • 30. Re: 1000 concurent users connection problem.
    Maahjoor Newbie
    Currently Being Moderated

    sorry,

    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
  • 31. Re: 1000 concurent users connection problem.
    Maahjoor Newbie
    Currently Being Moderated

    did you see the reply i give to Explorer ?

    i think the problem is there. no?

  • 32. Re: 1000 concurent users connection problem.
    Hemant K Chitale Oracle ACE
    Currently Being Moderated

    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,

    not c:\pfile.ora

     

    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


  • 33. Re: 1000 concurent users connection problem.
    JohnWatson Guru
    Currently Being Moderated

    I've already told you to raise your sessions and processes parameters to 1000, as have other people. Do it now! In the pfile. Some idiot has tried to enable parallel processing, and there are not enough processes available for all the required background processes.

  • 34. Re: 1000 concurent users connection problem.
    Maahjoor Newbie
    Currently Being Moderated

    okay sir, but the normal shutdown is not working, it give the follwoing error

    
    SQL> shutdown  
    ORA-01034: ORACLE not available  
    ORA-27101: shared memory realm does not exist 

    i know the drawback of shutdown abort.

    thanks anyway.

  • 35. Re: 1000 concurent users connection problem.
    TusharThakker Explorer
    Currently Being Moderated

    Try starting the service and instance using oradim utility.

     

    You would already know but just to confirm the command. On command prompt run following.

    oradim -startup -sid orcl1 -starttype srvc,inst

     

    Let us know if you are able to start with this.

  • 36. Re: 1000 concurent users connection problem.
    JohnWatson Guru
    Currently Being Moderated

    No, man. Starting the instance through Windows services is just going to confuse the issue: OP won't know what parameter file he is using, and error messages may be suppressed. Use SQL*Plus.

  • 37. Re: 1000 concurent users connection problem.
    Maahjoor Newbie
    Currently Being Moderated

    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 Expert   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.

    regards.

  • 38. Re: 1000 concurent users connection problem.
    TusharThakker Explorer
    Currently Being Moderated

    Yes you have set parallel_max_servers 320 while sessions to 300. Sessions was the first parameter you were to increase to 1000 but seems it is not done yet.

  • 39. Re: 1000 concurent users connection problem.
    TusharThakker Explorer
    Currently Being Moderated

    glad it worked for you.

  • 40. Re: 1000 concurent users connection problem.
    Maahjoor Newbie
    Currently Being Moderated

    thank you so much thaukker.

    now to my probelm, i want to increase the sga and sessions.

    how to do, i am afaid of touching it without your recomendation.

    please dont give links, i already has follow some links and got the problem.

    regards.

  • 41. Re: 1000 concurent users connection problem.
    JohnWatson Guru
    Currently Being Moderated

    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.

  • 42. Re: 1000 concurent users connection problem.
    Maahjoor Newbie
    Currently Being Moderated

    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.

    regards.

1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points