Fix Solaris Error 146 Connection Refused Lsnrctl TutorialHome > Solaris Error > Solaris Error 146 Connection Refused Lsnrctl
Solaris Error 146 Connection Refused Lsnrctl
Alright. HTML Reply With Quote 08-06-2003,04:33 AM #6 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Up s**t creek Posts 1,525 What are the errors? Thanks, Harris. 0 LVL 76 Overall: Level 76 Oracle Database 74 Message Active today Accepted Solution by:slightwv (䄆 Netminder)2006-12-04 First: It's been years since I've been on UNIX and about Finally, to summarize our checkpoint here, we should remember that if something is not working properly, the most common reasons are hidden in: Improperly owned directories of Oracle installation (refer to this content
All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Root role is used very rare, mostly for operating system purposes and not the Oracle Database itself – with significant exception during Oracle Universal Installer part, when we have to execute EdgeWave Microsoft View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database Security For discussion on Oracle Database Security , what should i do now..shall i rename the file ... https://scn.sap.com/thread/979265
Now we're ready for part 8. Add comment Name (required) E-mail (required, but will not display) Website Notify me of follow-up comments Refresh Send Cancel JComments Powered by Joomla!® What was really nice, during the last two months I received some emails and comments with your suggestions and opinions on this series. 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 Improperly defined or not set and exported Oracle Database environment variables – refer to the .bash_profile (this part) and double check you have all required variables and correctly defined paths.
In such cases, please delete this mail from your records. and brought it is online now but has no listener listening. Thanks Amit Report message 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: Solved Listener start error Posted on 2006-12-01 Oracle Database 3 Verified Solutions 6 Comments 5,577 Views Last Modified: 2011-10-03 Hi, Im getting the following error while starting listener on
Be sure we are using oracle account – for example: [email protected]:~$ su - oraclePassword:Oracle Corporation SunOS 5.11 11.1 September 2012-bash-4.1$ Then, run sqlplus: -bash-4.1$ sqlplus /nolog When sqlplus is The time now is 09:37 PM. Are you aComputer / IT professional?Join Tek-Tips Forums! Show: Today's Messages :: Show Polls :: Message Navigator E-mail to friend Problem in Oracle Networking. [message #226674] Mon, 26 March 2007 02:56 amit_raj Messages: 2Registered: March 2007 Location: Hyderabad
Now, we're back to finish with our experiments with Oracle Database 11gR2 on Solaris 11.1. All your responses prompted me to identifiy it.The permissions on the directory /var/tmp where not correct.The permissions on /var/tmp/oracle where ok but this was a show stopper not having the above Yes startup in SQL*Plus will do it. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.
- Total System Global Area 835104768 bytesFixed Size 2215624 bytesVariable Size 562037048 bytesDatabase Buffers 268435456 bytesRedo Buffers 2416640 bytesDatabase mounted.Database opened.SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME--------------- ----------------HOST_NAME----------------------------------------------------------------VERSION STARTUP_ STATUS PAR THREAD#
- You may have to register before you can post: click the register link above to proceed.
- Welcome to LSNRCTL, type "help" for information. LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=turingsman)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Solaris Error: 146: Connection refused Connecting
- Service "TURINGSMAN" has 1 instance(s). Instance "TURINGSMAN", status UNKNOWN, has 1 handler(s) for this service...
I took over this db. http://www.dbasupport.com/forums/showthread.php?38068-Listener Please set the environment correct and start the listener. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... If once started you do show parameter background_dump_dest and look in that directory there will be an alert log file that should give you a clue as to why it stopped.
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com Follow-Ups: news LSNRCTL> set log_status off Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) TNS-12224: TNS:no listener TNS-12541: TNS:no listener TNS-12560: TNSrotocol adapter error TNS-00511: No listener Solaris Error: 146: Connection refused Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=muso001 TNS-12224: TNS:no listener Shouldn't that be the IP address of your host? Suggested Solutions Title # Comments Views Activity Oracle update with CASE statement -- using IN and OR 32 71 85d Password Hashing vs Encryption for long term viability 3 77 81d
I have searched many documents but did not find any solution. The Oracle Database Security group is no longer active. Covered by US Patent. have a peek at these guys Click Here to join Tek-Tips and talk with other members!
Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Please login to the oracle user account and execute the following command: [email protected]:~$ vi /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora You should see something similar to this: LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=turingsman)(PORT=1521)) Is there a corrupt listener.log file in there if so you may want to rename it and try the process again A temporary fix will be to either disable logging or
Oracle Database Advertise Here 745 members asked questions and received personalized solutions in the past 7 days.
Im requesting you to please provide your suggestion on this. The port number my listener is listening to is 4007 and not 1527 which was shown in the error. All rights reserved. Thank you, Harris. 0 Question by:harris2107 Facebook Twitter LinkedIn Google LVL 76 Active today Best Solution byslightwv (䄆 Netminder) First: It's been years since I've been on UNIX and about as
Advanced Search Forum Oracle Forums Oracle Database Administration Listener If this is your first visit, be sure to check out the FAQ by clicking the link above. Puzzle similar to 15-puzzle but more moveable pieces? Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Solaris Error: 146: Connection refused mv listener_$SERVER.log listener_$SERVER.old mv: cannot access listener_phx09db1.log lsnrctl set log_status on LSNRCTL for http://unordic.com/solaris-error/solaris-error-145-connection-timed-out.html Also, we will present some basic administration tools for Oracle.
You're now being signed in. All rights reserved. files. please need step to start listner...
Enter LSNRCTL> trace admin LSNRCTL> save_config LSNRCTL> start Then if it crashes again, you'll know why. 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. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. ps -ef returns nothing related with oracle user.
All product names are trademarks of their respective companies. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this 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". in this case it seems oracle instance has stopped. –Olgun Kaya Apr 5 '11 at 5:55 would it be enough for me to use >startup commmand or do I
Join UsClose current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the If yes, but you can't – for example – invoke the tools presented in this part, maybe you should reload .bash_profile or – which is quite common – remember to use And I notice solaris error messagesSolaris Error: 2: No such file or directorySolaris Error: 146: Connection refused[/colorAre you starting listener as user oracle?
mouazir replied Nov 20, 2011 You have to check the listner.log file and listner status , so if you found it as started and the problem still shown so there is I will restart the server ( not oracle )and try to start the db instance again.