Serious listener problem - can anyone help?
- From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 May 2013 17:49:48 +0100
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.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
--
//www.freelists.org/webpage/oracle-l
Other related posts:
