Connection Refused Error 146 Solaris
Contents |
SAP on OracleWhere is this place located?All Places SAP on Oracle 3 Replies Latest reply: Jul 25, 2008 5:11 PM by mahesh chedde Tweet lsnrctl status : TNS-12560: TNS:protocol adapte mahesh
Oracle Solaris Error 146 Connection Refused
chedde Jul 25, 2008 3:20 PM Currently Being Moderated Hi All,When tns 12560 tns protocol adapter error i am starting the Listener it is showing SID status is unknown,STATUS of the LISTENER-Alias LISTENER1Version TNSLSNR for
Solaris Ftp Connection Refused
Solaris: Version 9.2.0.6.0 - ProductionStart Date 25-JUL-2008 18:53:51Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity OFFSNMP OFFListener Parameter File /oracle/
#226674] Mon, 26 March 2007 02:56 amit_raj Messages: 2Registered: March 2007 Location: Hyderabad Junior Member Hi, I have configured listerner.ora and tnsnames.ora for my database instance on the Solaris Server. I started
Linux Connection Refused
the listener successfully and I am also able to ping it using the unix connection refused "tnsping" command. But on executing the followin command, LSNRCTL> show trc_directory I got the following error: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcssun03.satyam.com)(PORT=1527))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Solaris Error: 146: Connection refused Can anyone please tell me the root of the problem and the possible solutions. Thanks Amit Report message https://scn.sap.com/thread/979265 to a moderator Re: Problem in Oracle Networking. [message #226677 is a reply to message #226674] Mon, 26 March 2007 03:10 Mohammad Taj Messages: 2412Registered: September 2006 Location: Dubai, UAE Senior Member Hi, Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcssun03.satyam.com)(PORT=1527))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Solaris Error: 146: Connection refused 1.check oracle service is start 2.database registration is DYNAMIC or STATIC... http://www.orafaq.com/forum/t/78943/ if dynamic then change STATIC. 3.after edit listner.ora file stop listener service and wait few minus then start ... let us know result regards Taj Report message to a moderator Re: Problem in Oracle Networking. [message #226683 is a reply to message #226677] Mon, 26 March 2007 03:32 amit_raj Messages: 2Registered: March 2007 Location: Hyderabad Junior Member Hi Taj, Thanks for replying. The port number my listener is listening to is 4007 and not 1527 which was shown in the error. Several users are using the same listener configuratin file for their instaces with port number 1527. I am able to connect to the database using sqlplus "system/manager@ORCDBTNS" Is the port number causing the problem? Regards Amit Report message to a moderator Re: Problem in Oracle Networking. [message #226691 is a reply to message #226683] Mon, 26 March 2007 03:52 Mohammad Taj Messages: 2412Registered: September 2006 Location: Dubai, UAE Senior Member Hi, Is the port number causing the problem? May be Yes... regards Taj Report message to a moderator Previous Topic: changing ip address of server which has oracle installed Next Topic:
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create https://www.experts-exchange.com/questions/22079390/Listener-start-error.html a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Listener start error Want to Advertise Here? Solved Listener start error Posted on 2006-12-01 Oracle Database 3 Verified Solutions 6 connection refused Comments 5,560 Views Last Modified: 2011-10-03 Hi, Im getting the following error while starting listener on Oracle 8i (8.1.7.0.0) LSNRCTL> start Starting /u01/app/oracle/product/8.1.7/bin/tnslsnr: please wait... TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Solaris Error: 32: Broken pipe LSNRCTL> This is a dev. database and it was down like for months. I took error 146 connection over this db. and brought it is online now but has no listener listening. I dont know as what was done previously with this database( i mean, whether there were any patches applied) or any other work, which might have corrupted the Network conf. files. When i first tried to start the listener i got this error "ld.so.1: lsnrctl: fatal: relocation error: file lsnrctl: symbol nlepeget: referenced symbol not found". I thought it might be because they have run some patch installation previously and ran the command to make the tnslsnr file again : "make -f ins_net_server.mk install". After running this when i tried to start the listener, im getting the error that i have pasted in the beginning. Following are the environment variables that have been set ORACLE_HOME=/u01/app/oracle/product/8.1.7 ORACLE_BASE=/u01/app/oracle ORACLE_PATH=/u01/app/oracle/product/8.1.7/bin TNS_ADMIN=/u01/app/oracle/product/8.1.7/network/admin LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.7/lib ORACLE_SID=DEV1 The evironment variables are set correctly, solaris file size has been set to unlimited (so, no problem with the listener.log file size). I have searched many documents but did not find any solution. Im requesting you to please provide your su