RE: adapters showing no protocols enabled

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Thu, 8 Nov 2007 11:09:24 -0600
Message-ID: <D40740337A3B524FA81DB598D2D7EBB30C3919E5@x6009a.umb.corp.umb.com>

Check the sticky bit on the oracle executable in $ORACLE_HOME/bin

Should look like this:

-rwsr-sr-x

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Hallas Sent: Thursday, November 08, 2007 8:49 AM To: oracle-l_at_freelists.org
Subject: adapters showing no protocols enabled

Oracle 10.2.0.2 on Solaris X86

Installed Oracle and non DBA group users cannot use sqlplus imp exp etc. Patch 4516865 for fixing incorrect Oracle permissions after install is available but not for X86 chipset.

I got the utilities working by chmod -R 755 from O_H down then relinked. Lsnrctl worked prior to that but it is not working now.

Lsnrctl start gives

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521)))

TNS-12547: TNS:lost contact

TNS-12560: TNS:protocol adapter error

TNS-00517: Lost contact

Solaris Error: 131: Connection reset by peer

I have traced the issue to be because the adapters command does not give any output. I have another 10.2.0.2 installation on X86 which is working OK. I have compared permissions on all files and servers and they seem to match.

I have searched Metalink and Google with no success.

I have installed another O_H and that has the same problem. I have changed ports and tried relink option known to man

Has anybody got any ideas please

+44 (0)113 223 2274 (direct)

+44 (0)113 297 9797

BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW. Registered in England with company number 2777575. http://www.bjss.co.uk

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

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

Received on Thu Nov 08 2007 - 11:09:24 CST