| Oracle 11g Ora error ORACLE not available [message #607389] |
Wed, 05 February 2014 07:43  |
 |
Dylz
Messages: 5
Registered: February 2014
Location: Cape Town
|
Junior Member |
|
|
Hi
I am having a problem connecting to our database, we use an Oracle tool called Oracle Enterprise Data Quality(OEDQ), which we just did an upgrade on, and after the upgrade we ran some data through for testing and it froze halfway through the process when i checked the OEDQ logs i see there was an error connecting to the database, and when i try to connect to the database via sqlplus i get the following error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
sorry I am not a DBA, and don't know where to start looking at how to fix this issue, i have searched on google but non of the solutions i find are working. some help would be much appreciated.
many thanks
|
|
|
|
|
|
|
|
| Re: Oracle 11g Ora error ORACLE not available [message #607398 is a reply to message #607391] |
Wed, 05 February 2014 08:49  |
|
Dylz
Messages: 5
Registered: February 2014
Location: Cape Town
|
Junior Member |
|
|
lsnrctl start:
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 05-FEB-2014 16:18:36
Copyright (c) 1991, 2010, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
lsnrctl status:
LSNRCTL for 64-bit windows: Version 11.2.0.1.0 - Production on 05-FEB-2014 16:23:08
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Server2)(PORT=1521)))
STATUS of the LISTENER
-----------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 05-Feb-2014 14:49:07
Uptime 0 days 1 hr. 34min. 1sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\Oracle\product\11.2.0\network\admin\listener.ora
Listener Log File c:\oracle\product\11.2.0\log\diag\tnslsnr\Server2\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server2)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status READY, has 2 handler(s) for this service...
Service "cwhdqdev" has 1 instance(s).
Instance "cwhdqdev", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
lsnrctl service:
LSNRCTL for 64-bit windows: Version 11.2.0.1.0 - Production on 05-FEB-2014 16:35:48
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Server2)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s)
Instance "CLRExtProc", status READY, has 2 handlers(s) for this service...
Handler(s):
"ORACLE SERVER" established:0 refused:0 current:0 max:25 state ready
CLRExtProc
(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_2BEC_6693E230.ORA))
"ORACLE SERVER" established:0 refused:0 current:0 max:25 state ready
CLRExtProc
(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_2BEC_6693E230.ORA))
Service "cwhdqdev" has 1 instance(s)
Instance "cwhdqdev", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
listener.ora File:
# listener.ora Network Configuration File: C:\Oracle\product\11.2.0\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cwhdqdev)
(ORACLE_HOME = C:\Oracle\product\11.2.0)
(SID_NAME = cwhdqdev)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server2)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\Oracle\product\11.2.0\log
tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\Oracle\product\11.2.0\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
CWHDQDEV_LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cwhdqdev)
)
)
INFOBLUE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = infoblue)
)
)
|
|
|
|
|
|
|
|
| Re: Oracle 11g Ora error ORACLE not available [message #607401 is a reply to message #607400] |
Wed, 05 February 2014 09:09 |
|
Dylz
Messages: 5
Registered: February 2014
Location: Cape Town
|
Junior Member |
|
|
I have change both in the tnsnames.ora file now and i still get the same ora error
# tnsnames.ora Network Configuration File: C:\Oracle\product\11.2.0\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
CWHDQDEV_LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cwhdqdev)
)
)
INFOBLUE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = infoblue)
)
)
[Updated on: Wed, 05 February 2014 09:10] Report message to a moderator |
|
|
|
|
|
| Re: Oracle 11g Ora error ORACLE not available [message #607413 is a reply to message #607402] |
Thu, 06 February 2014 00:24 |
|
Dylz
Messages: 5
Registered: February 2014
Location: Cape Town
|
Junior Member |
|
|
Well all i am trying to do is connect to the database, using: sqlplus sysdba/ sysdba
What i have noticed is that this error normally comes up when trying to install Oracle, but that is not the case here, we where running data through the Oracle Data Quality tool (OEDQ) and the process froze and the log files for OEDQ said cannot connect to database and when i tried to connect to the database with the sysdba user or another user DQ_STAGING we get this error.
if i type sqlplus scott/tiger@CWHDQDEV_LOCAL I get:
Microsoft Windows [Version 6.1.7600]
C:\Users\Administrator>sqlplus scott/tiger@CWHDQDEV_LOCAL
SQL*PLUS: Release 11.2.0.1.0 Production on Thu Feb 6 08:18:50 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12518: TNS:listener count not hand off client connection
Enter user-name:
I hope that helps?
[Updated on: Thu, 06 February 2014 00:41] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
