|
|
|
|
|
|
|
|
|
|
|
|
| Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66766 is a reply to message #66552] |
Sat, 28 December 2002 06:45   |
Kashif Sattar
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
Hi;
I am from Pakistan.I have a problem with my database. When i am trying to login in SQLPLUS or SQL worksheet it gives me following error:
ERROR:
ORA-01034:ORACLE not available
ORA-27101:Shared memory realm does not exist
When i connect as sysdba it connects to the idle database and i have to start the database using startup. But i have to do it everytime when i start Oracle. Please tell me a permanent solution for this.
Thanks
Kash
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66864 is a reply to message #66552] |
Fri, 14 February 2003 01:19 |
Hazel Seow
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Hi all,
I was also encountering the same problem as the rest. When I create 2 listeners(SID=db1), and configure 1 of it to connect to mts. However, in client's tnsanames.ora I have set the connect data for db1 as (SERVICE_NAME=DB_MTS) === > which I have set in the initSID.ora file.
Somehow when I tried to connect to the DB using the delicated the listener(the one with NO mts), it does not work and return that ora--ERRCode. But if I dont put the connect string, eg: sqlplus username/passwd I managed to connect from local machine. If I am from remote server and do sqlplus username/passwd@db_ded I am not able to connect. So what should be the correct ways?
|
|
|
|
| ERROR ORA-01034 and ORA-12560 not-available/protocol error [message #66882 is a reply to message #66552] |
Thu, 27 February 2003 04:03 |
George
Messages: 68
Registered: April 2001
|
Member |
|
|
CONNECTION PROBLEMS- 8i STANDARD EDITION (ora-01034 / ora-12560)
I GOT ORACLE 8i STANDARD EDITION TO WORK ON WINDOWS XP (COULDN'T GET PERSONAL EDITION TO WORK ON IT, TRIED EVERYTHING) BUT WHEN YOU RESTART THE COMPUTER & THEN TRY TO GO INTO SQL, FORMS OR REPORTS IT WON'T LET YOU CONNECT. THE REASON IS THAT ON THE PERSONAL EDITION YOU HAVE A "START DATABASE" OPTION THAT STARTS THE DATABASE FIRST & THEN YOU WON'T GET THE ora-01034 ERROR, BUT ON THE STANDARD EDITION YOU DON'T HAVE THIS "START DATABASE" OPTION. THEREFORE.........TWO OPTIONS WHEN YOU START/REBOOT (I PREFER OPTION 1)......
1. GO TO THE "svrmgrl" file (in a 'BIN' file - do a search for files if not sure where it is). Double-click on it and a dos_style prompt will open. Type "connect internal" (without the quotes!) and press enter. Then type "startup open". Then wait a short while and the database will be opened. You will then be able to connect to sql, etc without getting this error. It is a good idea to copy this file onto your desktop as a shortcut so that when you boot/restart you can access it straight away.
2. Via the start menu, programs, go to "Database Configuration Assistant" via 'Database Administration' - Choose 'Change Database Configuration', click next - click next again - after a short wait choose one of the options & click next - Then click Finish. Again if using this method it might be better to have it as a shortcut on the desktop.
BY THE WAY IF YOU ARE GETTING THE ora-12560 "PROTOCOL ADAPTER ERROR" THIS IS PROB DUE TO THAT YOU HAVENT GOT THE ORACLESERVICEORCL SET TO START AS "AUTOMATIC". GO TO YOUR "SERVICE FOLDER" (IN WINDOWS XP, RIGHT-CLICK ON THE 'MY COMPUTER' FILE AND CHOOSE 'MANAGE', THEN GO INTO 'SERVICES AND APPLICATIONS' AND THE GO INTO 'SERVICES' & SCROLL DOWN TO THE 'OracleServiceORCL' (That's what it's called on mine), DOUBLE-CLICK ON IT/CHOOSE IT AND CHANGE THE 'STARTUP TYPE' TO "AUTOMATIC". THEN WHEN REBOOTING YOU'LL PRBABLY GET THE ABOVE ERROR WHICH MEANS YOU NEED TO CONNECT YOURSELF ONTO THE DATABASE VIA ONE OF THE OPTIONS.
|
|
|
|
| ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67112 is a reply to message #66552] |
Wed, 08 October 2003 07:31 |
Nykolaj
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
Hi,
>
> the ORA-01034 problem was not solved yet using the specifiactino in
here,...acording to this description I did not solve enything yet.
> Can you send me more infos about this "Hot" fix?
> So I've still get this output when I try to
> connect sytem@mydb
> in SqlPlus8 in Oracle version 8.0.6...afer changing some
passwords,..and maybe some process (service) has crasshed after rebooting the
PC(WINNT).
>
> Thanks,
> Nykolaj
>
> Best regards.
> Nicolae
|
|
|
|
|
|
|
|
| Solution ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67164 is a reply to message #66552] |
Wed, 07 January 2004 21:45 |
Postman
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
Solution
Using oracle 817, under NT(W2000)
after restarting the database, and trying to connect, getting:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
probably you should change
sqlnet.ora (located in $(ORA_HOME)networkadmin)
parameter:
SQLNET.AUTHENTICATION_SERVICES = (NONE)
Then restart the databases (or the server)
Worked for me.
|
|
|
|
| Re: ERROR ORA-01034 ORACLE not available,Not able to create ORACLE database ? [message #67211 is a reply to message #66552] |
Tue, 10 February 2004 22:16 |
Rajiv
Messages: 14
Registered: April 2001
|
Junior Member |
|
|
Here i am sending one of my problem.I am installing oracle 8i on TRU64 Unix.I am able to install oracle but when i tried to create database the message i got is "Oracle Not Available".I tried it through SVRMGRL but the same message "Oracle Not Available".
I tried to start oracle services through lsnrctl but at this time message is "Permission Denied".So please reply for my problem as early as possible.Also let me know what is the procedure for starting oracle services.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ERROR ORA-01034 and ORA-12560 not-available/protocol error [message #67384 is a reply to message #66882] |
Mon, 14 June 2004 16:31 |
marc k
Messages: 1
Registered: June 2004
|
Junior Member |
|
|
I had the same issue on Win2k. The database installed and all systems worked fine until shutdown/restart. I was getting ORA 01034 ORACLE not available and
ORA 27101 shared memory realm does not exist.
I tried option 1 and found it to work like a charm! Thanks for the tip.
Gratefully - marc k
"1. GO TO THE "svrmgrl" file (in a 'BIN' file - do a search for files if not sure where it is). Double-click on it and a dos_style prompt will open. Type "connect internal" (without the quotes!) and press enter. Then type "startup open". Then wait a short while and the database will be opened. You will then be able to connect to sql, etc without getting this error. It is a good idea to copy this file onto your desktop as a shortcut so that when you boot/restart you can access it straight away.
"
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
) 2 Votes
] 
Blog
Search
Help
Members
Register
Login
Home
