problem in starting Oracle ORA-1034 and ORA-27101
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: problem in starting Oracle ORA-1034 and ORA-27101

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    109

    problem in starting Oracle ORA-1034 and ORA-27101

    Hi when I am trying to connect Oracle ,getting the message
    ORA-1034- Oracle noty availabale
    ORA-27101- shared memory realm does not exits.
    Services are made automatice.

    regards
    praveen

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    OS ? Windows or Unix ?

    If windows, go to control panel and check if the service is started.

    What version of Oracle ?

    Go the sqlplus, connect as sysdba and give 'startup'.

    HTH.

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Windows OS? Try to stop the service at first, or reboot it.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  4. #4
    Join Date
    Oct 2002
    Posts
    109

    problem in starting oracle

    Originally posted by ggnanaraj
    OS ? Windows or Unix ?

    If windows, go to control panel and check if the service is started.

    What version of Oracle ?

    Go the sqlplus, connect as sysdba and give 'startup'.

    HTH.
    Thanks
    I have made the services automatic.
    If I give startup then it will start.But I need that whenever I start the system ,I can login system/manager.

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: problem in starting oracle

    Originally posted by prav_saras
    If I give startup then it will start.But I need that whenever I start the system ,I can login system/manager.
    If the service is 'automatic', then it will start accordingly, unless any errors occur, for which you can check the alert log.

    On the other hand, I think you need to give some time (after switching on the system), before the system makes the database available. (start instance, mount database, open database).

    HTH.

  6. #6
    Join Date
    Oct 2002
    Posts
    109

    Re: Re: problem in starting oracle

    Originally posted by ggnanaraj
    If the service is 'automatic', then it will start accordingly, unless any errors occur, for which you can check the alert log.

    On the other hand, I think you need to give some time (after switching on the system), before the system makes the database available. (start instance, mount database, open database).

    HTH.
    HI
    Thanks
    Is there any problem with Sql net?

    regards
    praveen

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Re: problem in starting oracle

    Originally posted by ggnanaraj
    I think you need to give some time (after switching on the system), before the system makes the database available.
    This is an argument for making the whole startup fully automatic or fully manual. (I chose manual, i.e. executing batch files, using: net start "OracleServiceORCL" - only disadvantage is that you can't do an unattended re-boot - but then I've never had to in over 4 years.)
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width