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@xxxxxxxxx>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@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. > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l