-
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
-
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.
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
-
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.
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|