Getting ORA-01034 and ORA-27101 error even though Oracle is u p... 2005-07-19 - By Magnus Andersen
Found the problem. I had the ORACLE_SID exported in lowercase and the SID =
set to upper case in my listener.ora file. Changed the listener file to
match the exported value and everything works.
Thanks,
Magnus
-- --Original Message-- --
From: Magnus Andersen [mailto:Magnus.Andersen@(protected)]
Sent: Tuesday, July 19, 2005 10:06 PM
To: Oracle-L (E-mail)
Subject: Getting ORA-01034 (See ORA-01034.ora-code.com) and ORA-27101 (See ORA-27101.ora-code.com) error even though Oracle is up...
When I try to connect remotely I receive these errors. I can connect
locally without problems and if I run ipcs I see the shared memory. I'm
running Oracle 9.2.0.6 on RedHat EL 3 AS
Any help is appreciated.
Sincerely,
Magnus Andersen
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=514553302-20072005><FONT face=Arial color=#0000ff size=2>Found
the problem. I had the ORACLE_SID exported in lowercase and the SID = set
to upper case in my listener.ora file. Changed the listener file to match
the exported value and everything works.</FONT></SPAN></DIV>
<DIV><SPAN class=514553302-20072005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=514553302-20072005><FONT face=Arial color=#0000ff
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=514553302-20072005><FONT face=Arial color=#0000ff
size=2>Magnus</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B> Magnus Andersen
[mailto:Magnus.Andersen@(protected)]<BR><B>Sent:</B> Tuesday, July 19,
2005 10:06 PM<BR><B>To:</B> Oracle-L (E-mail)<BR><B>Subject:</B> Getting
ORA-01034 (See ORA-01034.ora-code.com) and ORA-27101 (See ORA-27101.ora-code.com) error even though Oracle is up...<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=298165801-20072005>When I try to
connect remotely I receive these errors. I can connect locally without
problems and if I run ipcs I see the shared memory. I'm running Oracle
9.2.0.6 on RedHat EL 3 AS</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=298165801-20072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=298165801-20072005>Any help is
appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=298165801-20072005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=298165801-20072005>Sincerely,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=298165801-20072005>Magnus
Andersen</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face=Arial
size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>
|
|
