Failed To Connect To Remote Database Error Is Ora-12541
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss
Ora 12541 Tns No Listener But Listener Is Running
the workings and policies of this site About Us Learn more ora-12541 tns no listener 11g about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow
Tns No Listener Error In Oracle 11g
Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each ora-12541: tns:no listener linux other. Join them; it only takes a minute: Sign up Oracle client ORA-12541: TNS:no listener [closed] up vote 20 down vote favorite 1 I am new on Oracle database, but I have one issue, now on my Database server (server1) listener and database instance is run correctly and I can use sqlplus to connect to this DB, But ora 12541 tns no listener toad when I connect to database by using other server, I check the TNS configuration is correct but system said ERROR: ORA-12541: TNS:no listener My database is Oracle 10gR2 So how can I solve this issue? oracle listener share|improve this question edited Sep 23 '14 at 9:26 subhashis 1,55672430 asked Nov 13 '12 at 9:58 aliasosx 1332212 closed as off-topic by Jens Erat, Annjawn, Eric Brown, g00glen00b, showdev Feb 21 '14 at 23:30 This question appears to be off-topic. The users who voted to close gave this specific reason:"Questions on professional server- or networking-related infrastructure administration are off-topic for Stack Overflow unless they directly involve programming or programming tools. You may be able to get help on Server Fault." – Jens Erat, Annjawn, Eric Brown, g00glen00b, showdevIf this question can be reworded to fit the rules in the help center, please edit the question. 3 should be a serverfault.com / dba.stackexchange.com question –Raptor Nov 13 '12 at 10:01 But when I connect to database by using other server You me
listener (DB Options ISMAIL View
Tns-12560: Tns:protocol Adapter Error
Member Profile Dec 27 2008, 06:25 AM Post #1 Newbie Group: ora-12514 tns no listener Members Posts: 1 Joined: 27-December 08 Member No.: 39,268 Dear AllI have two instances on
Ora 12541 Tns No Listener Oracle 11g Client
racNMH.newsource.com_NMH1 30 1 8 +ASM1_nmhdb001.newsource.com NMH.newsource.com_NMH2 the second Instance it gave critical error that Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).then http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener that details giving asI got Critical Error in OEM that Jun 30, 2008 9:20:17 AM Agent is Unreachable (REASON = Connection refused) but the host is UP I tried to start listener but it said LSNRCTL> start LISTENER_nmhdb002TNS-01106: Listener using listener name LISTENER_nmhdb002 has already been started then status saysLSNRCTL> listener_nmhdb002 statusNL-00853: undefined http://dbaforums.org/oracle/index.php?showtopic=17139 command "listener_nmhdb002". Try "help"LSNRCTL> STATUSConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nmhdb002-vip)(PORT=1521)(IP=FIRST))STATUS of the LISTENER------------------------Alias LISTENER_nmhdb002Version TNSLSNR for Solaris: Version 10.2.0.2.0 - ProductionStart Date 30-JUN-2008 09:24:14Uptime 91 days 3 hr. 57 min. 4 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/oracle/oracle/product/10.2.0/db/network/admin/listener.oraListener Log File /u01/oracle/oracle/product/10.2.0/db/network/log/listener_nmhdb.logListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.212)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=178.1.2.205)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Services Summary...Service "+ASM" has 1 instance(s). Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...Service "+ASM_XPT" has 1 instance(s). Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...Service "NMH.newsource.com" has 2 instance(s). Instance "NMH1", status READY, has 1 handler(s) for this service... Instance "NMH2", status READY, has 2 handler(s) for this service...Service "NMHXDB.newsource.com" has 2 instance(s). Instance "NMH1", status READY, has 1 handler(s) for this service... Instance "NMH2", status READY, has 1 handler(s) for this service...Service "NMH_XPT.newsource.com" has 2 instance(s). Instance "NMH1", status READY, has 1 handler(s) for this service... Instance "NMH2", status READY, has 2 handler(s) for this service...Service "TEST.newsource.com" has 2 instance(s). Instance "TEST1", stat
Share: ← Previous article Next article→ How to troubleshoot Oracle remote database connection June 7, 2013 by Kirill Loifman 22 http://www.dadbm.com/how-to-troubleshoot-oracle-remote-database-connection/ Comments Many Oracle DBAs, developers and just end-users often encounter an https://docs.oracle.com/cd/B19306_01/network.102/b14212/connect.htm issue when they can not connect remotely to an Oracle database. There can be different reasons of the connection problems. I give below a short cookbook on resolving those database connection issues. But first let’s explore a bit Oracle connectivity concepts and terminology. Oracle NET Client no listener Server configuration An Oracle database is represented to clients as a service; that is, the database performs work on behalf of clients. The service name is included in the connect data part of the connect descriptor. To connect to a database service, clients use a connect descriptor that provides the location of the database and the name of tns no listener the database service. The address portion of the connect descriptor is actually the protocol address of the listener. To connect to a database service, clients first contact a listener process that typically resides on the database server. The listener receives incoming client connection requests and hands these requests to the database server. Once the connection is established, the client and database server communicate directly. Ping database host IP ping 11.222.333.44 If it works, go to the next step; If not, check the server availability Ping database hostname ping orcl.dadbm.com if it works, go to the next step; if not, something wrong with DNS /ACTIVE directory => try using hosts file Test if listener port is reachable/opened for your remote connection For that use telnet utility which is available on Unix and can be enabled on Windows. 1. Linux example: $ telnet orcl1.dadbm.com 1522
Trying 10.126.247.11...
Connected to orcl.dadbm.com (12.222.333.44).
Escape character is '^]'.
get
Connection closed by foreign host. 2. Windows example 1) First enable telnet o
a variety of tools to help you start, test, and control the listener and Oracle Connection Manager. This chapter outlines procedures to make a connection and test network components. This chapter contains these topics: Connecting to a Database Testing the Network Connecting to a Database Connecting to a database involves starting network components and entering a connect string with a net service name, such as the following: CONNECT username/password@connect_identifier This section contains these topics: Starting Oracle Net Services Components Entering a Connect String Connect Identifier and Connect Descriptor Syntax Characteristics Absolute Name Specification for Directory Naming Initiating Connections Starting Oracle Net Services Components Client workstations and other servers connect to a listener with a net service name when logging onto an Oracle database server. After installing and configuring all the network components, you need to start them to make the network functional. Following is an outline of the tasks you should perform to start the network components. Task 1: Start the Listener Task 2: Start the Database Task 3: Start Oracle Connection Manager Task 1: Start the Listener For Oracle Net to accept connections on the database server, start the listener with the Listener Control utility on the server: Determine the status of the listener. From the command line, enter: lsnrctl LSNRCTL> STATUS [listener_name] where listener_name is the name of the listener defined in the listener.ora file. It is not necessary to identify the listener if you are using the default listener, named LISTENER. If the STATUS command indicates that the listener is running, go to Step 2. If the listener is not running, go to Step 3. Even if the listener is running, stop the listener, and start it again before proceeding to Step 2. To stop the listener, enter: LSNRCTL> SET PASSWORD password LSNRCTL> STOP [listener_name] SET PASSWORD is only required if the password is set in the listener.ora file. The password defaults to ORACLE. Start the listener. Enter: LSNRCTL> START [listener_name] The Listener Control utility will display a status message indicating that the listener has started successfully. Check that all expected services for that listener are listed in the services summary in the status message. Exit from the Listener Control utility. Enter: LSNRCTL> EXIT On Windows, the listener can also be started through the Control Panel: Select the Services icon in the Control Panel window. Select the Oracle