today i have restarted the database server (11gR2) after that database service is not starting, the error message is
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
My problem is if i start sudo /etc/init.d/oracle-xe configure i get Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for detailsI use a plain installed Ubuntu 12.04 and try the instructions of the Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto. Also i installed Ubuntu 11.10 and tryed is, but the same error happens.
On the install script i get:
toxsox@vm3:~/Disk1$ sudo dpkg --install ./oracle-xe_11.2.0-2_amd64.debVormals abgewähltes Paket oracle-xe wird gewählt.
(Lese Datenbank ... 23051 Dateien und Verzeichnisse sind derzeit installiert.)
Entpacken von oracle-xe (aus ./oracle-xe_11.2.0-2_amd64.deb) ...
oracle-xe (11.2.0-2) wird eingerichtet ...
Executing post-install steps...
/var/lib/dpkg/info/oracle-xe.postinst: line 77: bc: command not found
/var/lib/dpkg/info/oracle-xe.postinst: line 78: bc: command not found
[code]....
I had changed the /etc/init.d/oracle-shm so how Dude wrote it to mount --move /run/shm /dev/shmmount -B /dev/shm /run/shm>
free -m
total used free shared buffers cachedMem: 3961 1045 2916 0 15 921
-/+ buffers/cache: 109 3852
Swap: 2383 0 2383>
i also tryed some other instuctions for 12.04 and Oracle XE but without success. I never hat the ORA-00845: MEMORY_TARGET but everytime the ORA-27101: shared memory realm does not exist Error.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
connected as- / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>
ORACLE_HOME is - E:\oracle\product\10.2.0\db_2
ORACLE_SID is - orcl11
I'm using Oracle 10.2.0 in windows 7.When i installed oralce it worked properly for 1 week, now throwing an error ora-01034 and ora-27101.
I just perform CRUD Operations with database as a java dev by connecting via MYEclipse, but it is not at all allowing me to connect.
when i start the Oracle database, the database is mounted. Then when i issue the "alter database open resetlogs" command, i got the below error.
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oracle/NYP15S1D/data03/SYSTEM_01.dbf'
So i added the parameter "_allow_resetlogs_corruption=TRUE" in "init.ORA" file to force open the database but the Oracle instance crashed with following message.
In the alert log the following error is there:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4000], [2], [], [], [], [], [], []
How can i resolve the issue?
Please note: the database is Oracle 9i, installed in UNIX AIX OS.
I am trying to login to 10g sqlplus , gives below error:
ORA-01034:Oracle not available
ORA-27101-shared memory does not exist
I have installed oracle 11g few week ago, it running fine but now it giving following error
ORA-01034: ORACLE not available
Process ID: 0
Session ID:0 Serial number: 0
I using Ubuntu 9.04 on Pentium 4 machine 1GB RAM, 40GB HD.
here is what I did actually...
C:>oradim -new -sid Test100 -srvc OracleServiceTest100 -startmode a -pfile 'c:oracleora92databaseinittest100.ora'
C:>orapwd file=c:oracleora92databasePWDtest100.ora password=sys entries=2
C:>set oracle_sid=test100
C:>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 10 22:42:43 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL> conn sys/sys as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01031: insufficient privileges
SQL> @f:oracle estdb.sql
create database TEST100
*
ERROR at line 1:
ORA-01034: ORACLE not available
i just tried to set up a new database called Test100 manually.but i could not do anything here for these messages. my OS is winxp sp2.
[oracle@localhost ~]$ sqlplus system/password
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:20:09 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
But when i am using SID name while connecting to database i am able to connect...
[oracle@localhost ~]$ sqlplus system/password@apple
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:21:42 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
I have only one database...
TNS.......
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
APPLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 72.0.0.11)(PORT = 1521))
[code]...
I am facing ORA-01034: ORACLE not available ORA-27102 error.
View 5 Replies View RelatedI need some support on older version of oracle. Its 7.1 and it runs on alpha 2100 with open vms 6.1 OS. I was looking at option of alpha virtualization in sometime soon. I have set of backup hdd and one set of alpha 2100 spare machine.
But lately, just the oracle processes keeps shutting down soon unexpectly. It was complaining about couple of bad block , SO i found that objects(tables) , dropped them and created them.
After few days, it does the same thing again...The log says 'File 2 at .....needs media recovery'.....I wanted to recovery that datafile but When I try to connect using 'sqlplus' , it says
'ora: 01034: oracle not available'
'0ra-0765:$msget :$mgblsc failure'
--- no such global section
How do one recovery database or datafile without connecting to SQLPLUS?
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 ?
I installed Oracle database 11g enterprise edition. I can connect it through sql plus but Database control is not starting. I have checked dbconsole service which is running.
the address is [URL]...
but mozilla and chrome both are unable to start the application. after installation it started only once. but it is not starting now.
second thing is how can i confirm what is the port of my listener is it 1158 or something else.
I am getting an error regarding Starting Database Control. I have multiple databases on the same server but every time I am trying to create a new database I am getting the same error again and again.
View 1 Replies View RelatedI'm trying to create a database using DBCA, but before it completes i recieve the following error:
enterprise manager configuration failed due to the following error - Error starting database control refer to the log file at
E:oracleproduct10.2.0db_2cfgtoollogsdbcaorcl30emconfig.log - for mote details you can retry configuring this database with enterprise manager later by manually running E:oracleproduct10.2.0db_2inemca script
I'm using oracle 10g version 10.2.0.5, and my operating system is windows 7
I recently installed 2 node Oracle 11g RAC on RHEL5. While creating Clustered Database, database creation on second node (racnode2) failed. So, I connected */ as sysdba* on the node and executed startup only to get this error message:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RACDB_DATA/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RACDB_DATA/RACDB/spfileRACDB.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 13: Permission denied
Additional information: 196612
Additional information: 10
SQL>But, *'+RACDB_DATA/RACDB/spfileRACDB.ora'* is present.
I strongly believe it is a permission issue that ORACLE owned processes are not able to access disks owned by GRID user. I checked the permission of disks:
[oracle@racnode2 ~]$ cd /dev/oracleasm/disks
[oracle@racnode2 disks]$ ls -l
total 0
brw-rw---- 1 grid asmadmin 8, 65 Nov 19 19:15 CRSVOL1
brw-rw---- 1 grid asmadmin 8, 49 Nov 19 19:15 DATAVOL1
brw-rw---- 1 grid asmadmin 8, 81 Nov 19 19:15 FRAVOL1
[oracle@racnode2 disks]$And also, ORACLE user has asmdba among other privileges.
[oracle@racnode2 disks]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper) context=user_u:system_r:unconfined_t
I am willing to furnish further data.
I am getting problem while starting the CRS. Below is the necessary details:
1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2
2) I have 3 diskgroup named DATA, DATA1, DATA2
3) OCR and voting disks are stored on ASM diskgroup
On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1
On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2
Please note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.
Now I am trying to repair the OCR on the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.
ocrconfig -repair -replace +DAT2 -replacement +DATA1
but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.
I cloned the oracle VM, was able to recreate the repository for em.
But its failing when i try to start it with following trace of errors
2011-09-02 17:22:59,502 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ias.ias.IASIntegration
2011-09-02 17:22:59,753 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
2011-09-02 17:22:59,830 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration
2011-09-02 17:22:59,898 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg
2011-09-02 17:22:59,908 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg
2011-09-02 17:22:59,910 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.PortalIntegration
2011-09-02 17:22:59,911 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.SSOIntegration
2011-09-02 17:22:59,912 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.reports.em.RepIntg
I'm using Oracle 11g running over a Windows 7 OS. The service OracleServiceORCL doesn't start. Listener.log has the following registry:
23-OCT-2012 19:45:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MBA-DB$))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49445)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
When I try to start in services, is returned the OS error 1067. This error starts to occur when I did the follow. I executed a PLSQL command to fill a (big) table with a lot of data. More than 1 day after and while the program still running, I broke the program. After that, Oracle was consuming lot of disk. I broke the process (using taskkill /f) and, after that, the database stopped working.
What I can do to recover my database?Below I list my listener.ora and tnsnames.ora
mbentoalves
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
[code]...
I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.
-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:oracleproduct10.2.0db_1
etworkadminlistener.or
a
Log messages written to D:oracleproduct10.2.0db_1
[code]..
Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
[code]...
I saw this thread:[URL]....
and checked to see if I could start:[URL]........
using Firefox 8.0 and found that I was "unable to connect". I found that although my OracleDBConsoleorcl service was set to automatic, it was not started. So, I attempted to start it from the Windows services menu, but received a message that Windows could not start it and it said to see the System Event Log. So, I checked the Windows System Event Log and found:
"The OracleDBConsoleorcl service terminated with service-specific error The system cannot find the file specified."but it does not tell me the name of the file or directory path. So, where do I go from here? I did not want to hijack the other thread, so I started a new one, especially since the original poster was able to start this service. Is there a different way to try to start the service that might provide more information?
I have been using this installation for a long time and seem to remember this working once upon a time, but I could be wrong. I don't usually use Enterprise Manager, so this is not something critical, just a curiosity, and something that I might like to explore. I have provided version and system info below.
-- Oracle version info:
SCOTT@orcl_11gR2> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
5 rows selected.
-- partial systeminfo (some lines like product key removed):
C:>systeminfo
OS Name: Microsoft Windows 7 Professional
OS Version: 6.1.7601 Service Pack 1 Build 7601
[code]...
When I am trying to enter to the enterprise manager of oracle 11g, but it is not working. In my services list the 'oracledbconsoleorcl' is assigned as automatically to start with windows. But it is not starting. When I tried to start it manually the following message is displayed repeatedly even after restarting the pc.
'Windows could not start the oracledbconsoleorcl on Local computer. For more information, view the system event log. If this is a non-Microsoft services, contact the service vendor, and refer to service-specific error code 2.'
In the event log the following error messages are displayed:The OracleDBConsoleorcl service terminated with service-specific error 2 (0x2). and
The OracleCSService service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
I download Oracle Database Express Edition 11g EX.install in my windows XP laptop.run SQL command (following the start guide)
try to connect to database.
I go the error message.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 serial number: 0
I keep getting the error message- ORA-27101 shared memory realm does not exist...... what is the root cause of this issue and how is it fixed?
View 2 Replies View RelatedI have 2-node rac database, I lost the disks(+data) which belongs to the rac database.I want to restore the spfile, its giving below error.
RMAN> restore spfile from autobackup;
Starting restore at 15-JAN-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/15/2013 12:20:52
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
when xp is installing oracle 10.1 display a error ORA-01034...windows xp:memory 1.7G
View 8 Replies View RelatedI hv created a database VAHAN with SID VAHAN , now I want to create another database in it with name SARATHI SID SARATHI.VAHAN db is running perfectly but everytime i tried to create the db with dbca it shows error "ORA-01034: ORACLE not avaiable."
I ran dbstart,lsnrctl start - getting same error..i dbshut the db and use startup nomount - getting same error.
i did this step
C:UsersAdministrator>sqlplus
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 17 15:59:33 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: sys@orcl as sysdba
Enter password:
Connected to an idle instance.
SQL> create pfile from spfile;
[code].....
here its my init.ora file
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
[code].....
All of a sudden my oracle application has stopped functioning.When I try to log in I get the following messages:
ORA-27101 SHARED MEMORY REALM DOES NOT EXIST
ORA-01034 ORACLE NOT AVAILABLE
From the command line when I try to connect as sysdba and startup the following message appears: "oracle instance terminated.Disconnection forced"
How we can resolve :
Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
I am getting problem while starting the CRS. Below is the necessary details:
1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2
2) I have 3 diskgroup named DATA, DATA1, DATA2
3) OCR and voting disks are stored on ASM diskgroup
On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1
On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2
note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.
Now I am trying to repair the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.
ocrconfig -repair -replace +DAT2 -replacement +DATA1
but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.