Home » RDBMS Server » Networking and Gateways » ERROR ORA-01034 ORACLE not available, ORACLE database is not started ?  () 2 Votes
ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66552] Tue, 30 July 2002 02:24 Go to next message
Muhammad Irfan Aslam Kian
Messages: 5
Registered: July 2002
Junior Member
ERROR : ORA-01034 ORACLE not avaiable.....
All Services are running (Start)....
but Local Database is not opening ?

How i can got my data in Local DATABASE ?
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66614 is a reply to message #66552] Thu, 29 August 2002 13:07 Go to previous messageGo to next message
sanaullah khan
Messages: 1
Registered: August 2002
Junior Member
ASSLAM ALIKUM,

I am from india i am SQL DBA but i started ORACLE when i am trying to login in SQLPLUS it give me ERROR:

ERROR:
ORA-01034:ORACLE not available
ORA-27101:Shared memory realm does not exist

Pls give me Solution for that.

thankh,
sana
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66623 is a reply to message #66552] Thu, 05 September 2002 03:46 Go to previous messageGo to next message
Deepak
Messages: 111
Registered: December 1999
Senior Member
ORA-01034: ORACLE not available
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66635 is a reply to message #66552] Wed, 18 September 2002 22:22 Go to previous messageGo to next message
Naresh
Messages: 27
Registered: March 2001
Junior Member
everything was working fine i had restarted the system after that oracle is not getting connected..it gives following error mesg.
ORA-01034: ORACLE not available
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66639 is a reply to message #66552] Wed, 25 September 2002 07:02 Go to previous messageGo to next message
JAMES OYEE
Messages: 1
Registered: September 2002
Junior Member
Hi, I have been having the same problem for long time.
At first when it happened, i had to restart ma computer. and it would work.
But now I tried so many times it has failed. i just used it yesterday and it has jammed.
cuould you send a solotion if u get one.
THANKS
JAMES OYEE
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66736 is a reply to message #66552] Wed, 27 November 2002 00:53 Go to previous messageGo to next message
E. Marsham
Messages: 1
Registered: November 2002
Junior Member
I am too having the same problem.."ORACLE not available". I had a bit of trouble while installing where it was saying that I was low on virtual memory. Not sure if that had anything to do with it?!?! Please help!!
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 Go to previous messageGo to next message
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 #66788 is a reply to message #66552] Sun, 12 January 2003 05:18 Go to previous messageGo to next message
kulsum
Messages: 3
Registered: January 2003
Junior Member
hi
well am a bcsb student doin final project ..plz help me as its a crucuial time for me indeed...
im geting eror
01034: oracle not available
tell where problem ca be ???
hopfuly u answer me as soon as poosible on my address
kkj47040@yahoo.com
regards
ERROR ORA-01034 ORACLE not available,ORA-27101:Shared memory realm does not exist [message #66789 is a reply to message #66552] Mon, 13 January 2003 01:25 Go to previous messageGo to next message
Sanjay R.Shantagiri
Messages: 1
Registered: January 2003
Junior Member
Hi,

I'am trying to connect to the Oracle databse from the SQL Plus.I'am unable to connect & I get an error

ERROR ORA-01034 ORACLE not available &
ORA-27101:Shared memory realm does not exist

Please help

Thanks in advance !
Sanjay R.S.
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #66834 is a reply to message #66552] Wed, 29 January 2003 04:24 Go to previous messageGo to next message
Jo
Messages: 16
Registered: September 1999
Junior Member
How do I resolve the problem?
Re: ERROR ORA-01034 ORACLE not available,ORA-27101:Shared memory realm does not exist [message #66845 is a reply to message #66552] Mon, 03 February 2003 03:55 Go to previous messageGo to next message
Frank Gonzales
Messages: 1
Registered: February 2003
Junior Member
Hi,
I'am trying to connect to a Sun 8.1.7 Oracle database from SQL Plus. I'am unable to connect & I get the error message

ERROR ORA-01034 ORACLE not available
ORA-27101:Shared memory realm does not exist

How can I solve this problem ?
Please help!
Frank
Re: ERROR ORA-01034 ORACLE not available,ORA-27101:Shared memory realm does not exist [message #66853 is a reply to message #66845] Wed, 05 February 2003 22:16 Go to previous messageGo to next message
S.Saravanamoorthy
Messages: 1
Registered: February 2003
Junior Member
Hi,
The same error i got. I restarted the server, then i could access my database. Go ahead.
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67154 is a reply to message #66552] Sun, 21 December 2003 12:46 Go to previous messageGo to next message
Eman
Messages: 2
Registered: December 2003
Junior Member
im getting the same msg..plzzzzzz help me & tell me what to do to solve this cos i have projects that i must submit them....
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67155 is a reply to message #66864] Mon, 29 December 2003 03:40 Go to previous messageGo to next message
Wendry
Messages: 3
Registered: December 2003
Junior Member
My gush, I also have the same problem. Please anyone tell us what's going on here...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #67223 is a reply to message #66882] Tue, 17 February 2004 13:44 Go to previous messageGo to next message
Rha7
Messages: 1
Registered: February 2004
Junior Member
I will kiss your feet if i ever meet you, thanks a lot.
solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist." [message #67232 is a reply to message #67164] Mon, 23 February 2004 21:43 Go to previous messageGo to next message
chakri
Messages: 2
Registered: October 2003
Junior Member
hi all
i am getting the error

Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist."

can any body give me solution

i am in ORacle 8i
and Win2000 proff

bye
thanks in advance.
chakri
Re: solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exis [message #67240 is a reply to message #67232] Fri, 27 February 2004 10:45 Go to previous messageGo to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Chakri,

I had the same problem. Go into %ORA_HOME%networkADMINsqlnet.ora and change the following line:

SQLNET.AUTHENTICATION_SERVICES=(NTS)
to
SQLNET.AUTHENTICATION_SERVICES=(NONE)

Restart your database service and you should be good to go.

John
Re: Solution ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67265 is a reply to message #67164] Wed, 17 March 2004 16:21 Go to previous messageGo to next message
hifly
Messages: 1
Registered: March 2004
Junior Member
Thanks.
I solved problem by your method.
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67267 is a reply to message #66552] Fri, 19 March 2004 01:10 Go to previous messageGo to next message
B Calvert Mutale
Messages: 2
Registered: March 2004
Junior Member
Open Services in Control Panel
Select TNSListener
Open properties
On the 'Log On' tab, put your operating system login name and password.
Save the changes.

Do the same for Oracleservice.

Restart the services or computer and you'll be up and running.

Good luck.

Calvie
Re: ERROR ORA-01034 and ORA-12560 not-available/protocol error [message #67271 is a reply to message #66882] Thu, 25 March 2004 18:55 Go to previous messageGo to next message
Gaurav
Messages: 20
Registered: February 2002
Junior Member
Thanks George,
I got my problem fixed with your guidelines, but isn't there a permanent solution.
Gaurav
Re: Solution ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67276 is a reply to message #67265] Mon, 29 March 2004 08:07 Go to previous messageGo to next message
Jolly
Messages: 20
Registered: February 2003
Junior Member
Thanx a lot.

The solution worked for me too.
Re: solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exis [message #67313 is a reply to message #67232] Fri, 23 April 2004 00:07 Go to previous messageGo to next message
Mr S K Das
Messages: 1
Registered: April 2004
Junior Member
Dear Sir
We are having a problem as mentioned. All the jobs are pending.This on NT 4.0.

Expecting quick soloution.

S K Das
Re: ERROR ORA-01034 and ORA-12560 not-available/protocol error [message #67314 is a reply to message #66882] Fri, 23 April 2004 07:11 Go to previous messageGo to next message
robert shaikh
Messages: 1
Registered: April 2004
Junior Member
i pray uve got 4 wives..............
ORACLE not available,Not able to create ORACLE database ? [message #67336 is a reply to message #67211] Sat, 15 May 2004 20:09 Go to previous messageGo to next message
Mr. Hassan
Messages: 1
Registered: May 2004
Junior Member
Problem ORACLE not available for Oracle8i Enterprise Edition, Operating System Windows 2000 Advanced Server
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67379 is a reply to message #66552] Thu, 10 June 2004 03:00 Go to previous messageGo to next message
Rahul
Messages: 94
Registered: December 1998
Member
i guess the problem with 01034, oracle not availble should with the operating sytem.. i too got the same problem on my win XP O.S..i am not sure but i think, the problem is with O.S and it works well on win 2000 professional..
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 Go to previous messageGo to next message
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.

"
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67387 is a reply to message #66552] Thu, 17 June 2004 02:26 Go to previous messageGo to next message
Shabana Anjum
Messages: 1
Registered: June 2004
Junior Member
Solution :You need to start the database instance.
Re: solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exis [message #67397 is a reply to message #67232] Wed, 23 June 2004 01:52 Go to previous messageGo to next message
falswaroop
Messages: 1
Registered: June 2004
Junior Member
hello sir

i want help from you,

the problem is , i have istalled oracle 8i,it has installed completely,after installation i loged successfully with user name"scott" password"tiger"
.But when i restart computer ,
opensql plus i unable to login and error prompt that is
"ORA-01034: ORACLE not available "
sir please kindly solve my this promblem

thanks
Re: solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exis [message #67419 is a reply to message #67240] Tue, 13 July 2004 00:52 Go to previous messageGo to next message
Aravind
Messages: 41
Registered: January 2002
Member
Worked for me too.Thanks a lot!
Re: solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exis [message #67421 is a reply to message #67240] Tue, 13 July 2004 23:17 Go to previous messageGo to next message
Anand Patel(Bardoli)
Messages: 1
Registered: July 2004
Junior Member
I had the same problem.
Go into %ORA_HOME%networkADMINsqlnet.ora and change the following line:

SQLNET.AUTHENTICATION_SERVICES=(NTS)
to
SQLNET.AUTHENTICATION_SERVICES=(NONE)

Restart your database service from Administrative tool
> Services or Restart your compurter and then try again to login to Oracl.

Thaks to Arvind that have provide me this solution
Re: Solution ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67459 is a reply to message #67164] Fri, 06 August 2004 10:43 Go to previous messageGo to next message
Md. Faisal kabir
Messages: 3
Registered: August 2004
Junior Member
ORA-01034:ORACLE not available
ORA-27101:Shared memory realm does not exist
Re: Solution ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67460 is a reply to message #67164] Fri, 06 August 2004 10:46 Go to previous messageGo to next message
Md. Faisal kabir
Messages: 3
Registered: August 2004
Junior Member
Problem:
ORA-01034:ORACLE not available
ORA-27101:Shared memory realm does not exist
Re: solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exis [message #67461 is a reply to message #67397] Fri, 06 August 2004 10:53 Go to previous messageGo to next message
Md. Faisal kabir
Messages: 3
Registered: August 2004
Junior Member
Sir,

I'v installed oracle 8i.
It was OK.Yesterday it also Ok.
But now it is not unable to open.
The following messege arrises whenever I write scott/tiger:

ORA-01034:ORACLE not available
ORA-27101:Shared memory realm does not exist

Thanks
Re: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ? [message #67472 is a reply to message #67387] Sun, 15 August 2004 01:58 Go to previous messageGo to next message
amany
Messages: 1
Registered: August 2004
Junior Member
عند الدخول الى اوراكل وكتابة اسم المستخدم و كلمة السر واسم قاعدة البيانات تظهر الرسالة التالية و ذلك عند النقر على زر الاتصال
الرسالة
ora-01034:oracle not available
Re: solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory [message #67475 is a reply to message #67461] Mon, 16 August 2004 22:19 Go to previous messageGo to previous message
sunil kanti malik
Messages: 2
Registered: August 2004
Junior Member
"ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist."

Please send me the solution as soon as possible.
Previous Topic: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform.
Next Topic: ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Sat Dec 10 07:22:25 CST 2016

Total time taken to generate the page: 0.13968 seconds