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.
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
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.
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).
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).
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
Reply With Quote
Bookmarks