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
Printable View
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
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.
Windows OS? Try to stop the service at first, or reboot it.
ThanksQuote:
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.
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.
If the service is 'automatic', then it will start accordingly, unless any errors occur, for which you can check the alert log.Quote:
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.
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.
HIQuote:
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.
Thanks
Is there any problem with Sql net?
regards
praveen
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.)Quote:
Originally posted by ggnanaraj
I think you need to give some time (after switching on the system), before the system makes the database available.