Re: Serious listener problem - can anyone help?

From: David Barbour <david.barbour1_at_gmail.com>
Date: Fri, 10 May 2013 12:35:59 -0500
Message-ID: <CAFH+ifcoc5FKUCc-gTZwu83pJgGeu5vgQEohYf4Dy_u-Xy=DyA_at_mail.gmail.com>

Probably not the answer, but you may have an extra slash in your oratab entry.
Your blog entry shows:

orcl11g:/opt/oracle/product/11.2.0.3/db_1/:N

Think it should be:

orcl11g:/opt/oracle/product/11.2.0.3/db_1:N

On Fri, May 10, 2013 at 12:28 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com>wrote:

> As you know, that 'shared memory' thing is usually the combination of
> ORACLE_HOME & ORACLE_SID to which the listener resolves the service.
>
> Not happy about the listener reporting status 'UNKNOWN' for the instance
> - means you are manually registering via the listener.ora, which leads
> me to suspect the ORACLE_HOME setting in that registration.
>
> Afterthought, low likelyhood: Is there a firewall that might be blocking
> the connection redirect port 12633?
>
> /Hans
>
> On 10/05/2013 10:49 AM, Norman Dunbar wrote:
> > Afternoon all.
> >
> > I've been working on a listener problem all day. Because there is quite
> > a bit of evidence, I've posted the problem on my blog at
> > http://t.co/ss0KHSbfSd - if you care to take a look and make any
> > suggestions back here, I'd be very grateful!
> >
> > The link above is a short form of
> >
> http://qdosmsq.dunbar-it.co.uk/blog/2013/05/this-listener-problem-is-driving-me-mad/
> > - in case you are suspicious of short form links.
> >
> > In summary, a database is running and so is the listener.
> >
> > $ . oraenv<EOF
> > orcl11g
> > EOF
> >
> > $ sqlplus user/password
> > ...
> > SQL> select 'It Worked!' from dual
> > ...
> >
> > However, connecting via the listener results in carnage:
> >
> > $ . oraenv<EOF
> > orcl11g
> > EOF
> >
> > $ sqlplus user/password_at_orcl11g
> >
> > 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
> >
> > I have Googled and MOS'd until I'm blue in the face. Just about
> > everything says to start the database. Or, relates to a RAC SCAN - and
> > this is a single instance database, no RAC in use.
> >
> > Appreciate any info, as it is, driving me mad! However, please don;t
> > respond until you have seen what I've already done at the above URL.
> > Thanks. (And sorry! But I know someone will tell me to make sure
> > ORACLE_HOME in listener.ora is correct and such like, trust me, I've
> > been and done all that. I resolved this error yesterday on another
> > server by exactly that method!)
> >
> >
> > Cheers,
> > Norm.
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 10 2013 - 19:35:59 CEST