ORA-01034: ORACLE not available
ORA-01034 oracle not avaible,ORA-27101:shared memory realm does not exist
Всем добрый вечер! Oracle я устанавливаю в первый раз. По сути он мне нужен для реализации работы.
Поиск причины ошибки Ora-01034 в Oracle XE по рекомендациям пользователей cyberforum.ru
Причину отсутствия соединения, я, возможно, нашёл. Будет много букв, возможно совсем лишних букв.
ORA-01031, ORA-01034, ORA-27101
Доброе утро! Я вообще ни раз не базист, но появилась необходимость поставить oracle БД. Выбор.
После перезагрузки ошибка ORA-01034
Плиз..плизз.. поможите люди добры. одна программа использует Oracle, я делаю копию всего с.
при запуске команды netca выходить такая ошибка:
Ты вообще с Linux не работал? В сообщении дана четкая инструкция, что делать.
PS
Это уже вопросы не по Oracle
ORA-01033: ORACLE initialization or shutdown in progress
Поставил Oracle 11g express, чтобы близко ознакомиться с этим продуктом. При установке никаких.
ORA-01578: ORACLE data block corrupted
Добрый день. ОС: Windows 7 64 bit Base: Oracle 11g Express Edition 32 bit Столкнулся вот с такой.
Oracle 8.1.7 на Windows 2000 ORA-12560: TNS:protocol adapter errorError
Oracle 8.1.7 на Windows 2000 ORA-12560: TNS:protocol adapter errorError Помогите, проблема.
Hello all,
The database was working fine (11g) but 2 days ago suddenly I got this error:
An error was encountered performing the requested operation:
Unfortunately I am not familiar with the oracle very much I just developing some application using the data storing in oracle, and the server responsible will not be around in weeks!
I looked up the forum and found no proper answer, I shouted down the server and start it up again and used these solution: set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup
but it did not worked either.
Please guide me how this problem can be solved.
Best Answer
I finally fixed it. Thanks for your help my friends
Answers
>
Unfortunately I am not familiar with the oracle very much I just developing some application using the data storing in oracle, and the server responsible will not be around in weeks!
I looked up the forum and found no proper answer, I shouted down the server and start it up again and used these solution: set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup
but it did not worked either.
If you are ‘not familiar with the oracle very much’ you should NOT be making changes to Oracle or performing shutdowns or startups. Those operations should ONLY be performed by someone that IS familiar with Oracle and knows what will actually happen when you do those operations. Not only what will happen when you do the ops properly but, more importantly, what might happen if you do them improperly.
Saying you shutdown the server has NO meaning. Post the exact command you used to do the shutdown and what account you were connected as when you ran it.
Also any information in the alert log from just before to just after you shutdown the database.
Do NOT make any more changes until you know what changes to make and what the result might be if you make them wrong.
1004201 wrote:
Hello all,
The database was working fine (11g) but 2 days ago suddenly I got this error:
An error was encountered performing the requested operation:
Unfortunately I am not familiar with the oracle very much I just developing some application using the data storing in oracle, and the server responsible will not be around in weeks!
I looked up the forum and found no proper answer, I shouted down the server and start it up again and used these solution: set oracle_sid = grms
sqlplus /nolog
conn system/manager as sysdba
startup
but it did not worked either.
Please guide me how this problem can be solved.
if you have sys password try like as below.
Unix :
$export ORACLE_SID=GRMS
$sqlplus sys/[email protected] as sysdba
SQL> startup
Window :
C:\> set ORACLE_SID=GRMS
C:\> sqlplus sys/[email protected] as sysdba
C:\> startup
ORA-01034:Oracle not available
I have Oracle 11g release 2 installed on linux redhat 5, big learning curve since i am use to windows, but linux i hear is much bettter. so anyways i have installed oracle 11g release but, but ran into some errors when installing which are bleow:
Hard limit: maximum open file descriptors
OS Kernal Parameter: ip_local_port_range
OS Kernal Parameter: aio-max-nr
also:
Package: libaio-devel-0.3.106
Package: sysstat-7.0.2
Package:unitODBC-2.2.11
Package:unixODBC-devel-2.2.11
I fixed the top three when i googled each error, then i did the fix, but when i go to re-run the install the top 3 errors still came, not sure why, so i hit ignore them and continue install. So now when i log into sysdba, using command on oracle account i type in terminal:
sqlplus / as sysdba
then i type select * from v$version;
but when i do it says:
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Does anyone know why i am getting this, is it because of the error message from the install? and if you need logs where can i locate them at on this linux pc? was it a good idea to go and install oracle on a linux box, or would windows be just as good?
thanks in advance all
sorry i am a noob (but a network engineer) wanting to become a dba 
Answers
awesome thanks for your reply,
here is the results for the command you requested:
root 3578 3560 0 06:58 pts/1 00:00:00 grep smon
thats it. nothing else, was there anything else that should have appeared? ya your right, i was too anxious just to install oracle that i should have just took care of all the errors.
can i still fix it or should i uninstall oracle and reinstall?
let me know if there is anything else you need to assist me.
Also yes i do get connected to an idle instance, this is exactly what i type out and see on the terminal:
]$ sqlplus / as sysdba*
SQLPlus: Release 11.2.0.1.0 Production on Sat Jul 9 07:01:13 2011*
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select from v$version;*
select from v$version*
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
again thanks in advance for your help
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Does anyone know why i am getting this, is it because of the error message from the install?
ORA-01034 happens when the Database is shutdown. So you may try to start it as previously posted.
Else, are you sure that all the prerequisites are respected. You’ll find much more details on the documentation below:
The following Note of MOS may be useful too: Hope this help.
Best regards,
Jean-Valentin
Please provide the output of the below command.
See if you are meeting the requirements as below.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
thanks for all your posts, ok stupid question, how do you start the oracle service/process etc,? maybe thats why its shutdown, so maybe i have to start it up, how do i do that?
Let me know if there is anything else, i should try, and again maybe its shutdown and i need to start oracle, how do i do that?
again noob here trying to become an oracle DBA
As root you can find out if Oracle is running by using the below command.
If you see any process starting with ora_ then there is an oracle process running. There is no particular way to start an oracle process. To start the database, use will need to start as below
First set the Oracle home and the oracle SID by using the below command.
Once you have set the above variables, start the database as below.
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
Below is my listener.ora
Please tell me what to do?
17 Answers 17
Open command prompt and execute the below commands:
Sometimes, the database will not be mounted correctly, so we need to mount it manually. For that, shut it down and start it up then mount. Log in as oracle user, then run the following commands:
ORA-01034 and ORA-27101 normally indicate that the database instance you’re attempting to connect to is shut down and that you’re not connected as a user who has permission to start it up. Log on to the server 192.168.1.53 and start up the orcl instance, or ask your DBA to do this for you.
Make sure that your ORACLE_HOME and ORACLE_SID are correct To see the current values in windows, at the command prompt type
If the values are not your current oracle home and SID you need to correct them. This can be done in Windows environment variables.
Remove sga_target line in init.ora file, then:
This same error occurred to me even though the ORACLE_HOME and ORACLE_SID seemed to be correctly set up.
So, even if it seems everything is configured fine, check your variables for this.
I faced the same issue while creating the connection on SQLDeveloper «ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist»
1.Update the listene.ora file to include the SID.
The Oraclexe directory may have the permission set to «ReadOnly», Change the directory/sub-directory permission to read/write and restart the listener services. Problem is solved.
I hit the same shared memory realm does not exist symptom (on Windows) but for a different reason. I had just installed Oracle (XE) and after some troubleshooting, established that my installation was corrupt due to the presence of an ORACLE_HOME environment property at the time I installed it.
If this is TLDR, skip to ‘So to resolve:’!
My initial symptom was:
Apparently the Windows install reads the ORACLE_HOME from the registry and doesn’t need (and certainly in my case shouldn’t have. ) an environment property.
Remove it, as follows:
Following the restart I was then able to get error messages other than ‘No message file. ‘ and could start looking at what the issue was. Setting the ORACLE_SID to XE and connecting @XE I got as far as the errors in this page, namely the following symptoms:
Another symptom was: When launching the ‘Get started’ page it failed to connect, giving a not found error (if I recall correctly), despite the Windows listener & XE services being started. As noted in another answer, this could be due to the windows services not being started. In my case those services were started, so something else was misconfigured.
At this point, I figured maybe my install had just gone so badly wrong due to the presence of my bad ORACLE_HOME environment property that I should reinstall. (Previous reinstalls hadn’t helped, but those had all been before I noticed the ORACLE_HOME system environment property (probably set up by me a year ago!).
So to resolve:
ORA-01034 oracle not avaible,ORA-27101:shared memory realm does not exist
Всем добрый вечер! Oracle я устанавливаю в первый раз. По сути он мне нужен для реализации работы другой базы данных. Oracle я устанавливаю на виртуальную машину с ос Windows Server 2003 R2 (service pack 2). Дело в том, что после установки самого Oracle(версия 10g),все вроде норм (проверяю функцией sqlplus system в командной строке), однако дальше, в процессе установки других программ,после перезагрузки машины,при вызове функции sqlplus system возникает ошибка
ORA-01034 oracle not avaible,ORA-27101: shared memory realm does not exist. Не могу понять причину этой ошибки? На форумах народ писали,что такая ошибка уже возникала,однако как я понял у них немного другая ситуация и то что там писали мне не помогло. Вобщем, помогите решить эту проблему!
Добавлено через 2 минуты
Вроде бы нашел вот такое решение:
1)раскомментил в sqlnet.ora «SQLNET.AUTHENTICATION_SERVICES=(NTS)» иначе вылезала ошибка «ORA-01031 insufficient privileges» при SQL>connect /as sysdba
2) в командной строке вбиваю
set ORACLE_HOME=c:\oracle\product\10.2.0\db_1
set ORACLE_SID=UNF
sqlplus /nolog
SQL> connect /as sysdba
«Connected to an idle instance»
и он нас подключает, проверяю потом sqlplus system, все норм.
Т.е вручную мы можем исправить ошибки и нормально подключиться. Однако после перезагрузки ошибки снова появляются,и необходимо вручную все снова прописывать.
