Ora 00530 Protocol Adapter Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and tns-00530 protocol adapter error reload this page. Please enter a title. You can not post
Tns-12560 Tns-00530
a blank message. Please type your message and try again. More discussions in Database Installation All PlacesDatabaseGeneral tns-00530 protocol adapter error windows 7 Database DiscussionsDatabase Installation This discussion is archived 1 2 Previous Next 17 Replies Latest reply on Dec 14, 2008 6:38 AM by OrionNet TNS-12560: TNS:protocol adapter error and
Ora 12560 Tns Protocol Adapter Error Windows
TNS-00530: Protocol adapter error 673322 Dec 14, 2008 4:59 AM i just installed oracle 11g on my windows xp professional box. Which user and password shall i use. What username and password should i be using to login to sql plus? when i use "Scott" "Tiger" it gives me ORA-12560: TNS:protocol adapter error occurred errorwhen i 64-bit windows error: 61: unknown error try to start service i get LSNRCTL> start Starting tnslsnr: please wait... Failed to open service
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
Tns 00511 No Listener
Discuss the workings and policies of this site About Us Learn more
Unable To Openscmanager Err=5
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack disabledcomponents ipv6 Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping https://community.oracle.com/thread/839386 each other. Join them; it only takes a minute: Sign up Oracle listener not running and won't start up vote 5 down vote favorite 3 I am getting the following errors while from the lsnrctl status command: C:\Users\pna105>lsnrctl stat LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 17:53 :55 Copyright (c) 1991, 2010, Oracle. All http://stackoverflow.com/questions/26236967/oracle-listener-not-running-and-wont-start rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error It was working fine before restart but now it is not working and I also can't access my Oracle homepage. My tnsnames.ora is: ORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORACLE) ) ) LISTENER_ORACLE = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) My listener.ora is: (Here were error due to brackets misplaced adding few spaces resolved the problem TNS-12518) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORACLE) (ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1) ) (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\app\PNA105\product\11.2.0\dbhome_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtPr
[message #223981] Mon, 12 March 2007 09:16 ddkdhar Messages: 68Registered: February 2007 Member my isqlplus running properly whereas command prompt sqlplus showing error like this SQL> conn http://www.orafaq.com/forum/t/78239/ scott/tiger ERROR: ORA-12560: TNS:protocol adapter error SQL> conn scott/tiger@oracle ERROR: ORA-12154: http://www.club-oracle.com/threads/ora-12541-tns-no-listener-tns-12560-tns-protocol-adapter-error.3663/ TNS:could not resolve the connect identifier specified but isqlplus running properly i can able to login in isqlplus my databae Personal Oracle Database 10g Release 10.1.0.2.0 - Production PL/SQL Release 10.1.0.2.0 - Production CORE 10.1.0.2.0 Production TNS for 32-bit Windows: Version 10.1.0.2.0 - Production NLSRTL protocol adapter Version 10.1.0.2.0 - Production operating system is windows xp sp2 thanks in advance [Updated on: Mon, 12 March 2007 09:19]Report message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #224015 is a reply to message #223981] Mon, 12 March 2007 11:21 Mohammad Taj Messages: 2412Registered: September 2006 Location: Dubai, UAE Senior Member protocol adapter error Hi, SQL> conn scott/tiger ERROR: ORA-12560: TNS:protocol adapter error possible you have more than one database on your machine. and isqlplus connect with different machine. becuase most possible clause of above error is DATABASE SERVICES IS NOT START. you should start first database services and try to connect. ORA-12154: TNS:could not resolve the connect identifier specified lsnrctl status ... you database service_names is register.. and point to right services names. also post your lsnrctl status or tnsnames.ora file regards Taj Report message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #224020 is a reply to message #223981] Mon, 12 March 2007 12:07 ddkdhar Messages: 68Registered: February 2007 Member lsnr after start LSNRCTL> start Starting tnslsnr: please wait... Service OracleOraDb10g_home4TNSListener already running. TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error 32-bit Windows Error: 1056: Unknown error LSNRCTL> services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=karimojj-c876e5)(PORT=15 21))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LO
TNS: no listener/ TNS-12560:TNS:Protocol adapter error Discussion in 'General' started by Albkane, Feb 12, 2011. Albkane Premium Member Messages: 22 Likes Received: 0 Trophy Points: 100 Ladies and gentlemen, I am newbie to Oracle BI. I installed Oracle 10g DB and OBIEE 10G on my Pc to do some practice using OBE. I am stuck trying to establish the Connection pool. First, I received the ORA-12541 error message - No listener. I then tried to start up the listener using the cmd prompt. Then came this response: LSNRCTL> start Starting tnslsnr: please wait... TNS-12560: TNS: protocol adapter error TNS-00530: Protocol adapter error Can someone help? What should I do to fix this ? Albkane, Feb 12, 2011 #1 zargon Community Moderator Forum Guru Messages: 2,294 Likes Received: 340 Trophy Points: 1,430 Location: Aurora, CO Albkane said: ↑ Ladies and gentlemen, I am newbie to Oracle BI. I installed Oracle 10g DB and OBIEE 10G on my Pc to do some practice using OBE. I am stuck trying to establish the Connection pool. First, I received the ORA-12541 error message - No listener. I then tried to start up the listener using the cmd prompt. Then came this response: LSNRCTL> start Starting tnslsnr: please wait... TNS-12560: TNS: protocol adapter error TNS-00530: Protocol adapter error Can someone help? What should I do to fix this ?Click to expand... Without any details on which operating system you're running Oracle on the best information I can give you is to run the Net Configuration Assistant to configure your listener. Please read here: http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/cnfg_prd.htm#sthref220 for UNIX/Linux and here: http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/admintools.htm#sthref534 for Windows. zargon, Feb 14, 2011 #2 Albkane Premium Member Messages: 22 Likes Received: 0 Trophy Points: 100 Dave, Thanks. I got it. The problem has been resolved. Great help. Albkane, Feb 14, 2011 #3 (You must log in or sign up to