TNS-12541 - No Listener - Getting Error?
Sep 7, 2013
I am facing a problem
TNS-12541: TNS: no listener despite all the things in place.
Various commands are below. The sqlnet ,listener and tnsnames details are below:
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsname.ora:
[code]...
when i try to do lsnrctl start it gives me: Starting tnslsnr: please wait...
Service OracleOraDb11g_home1
TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
I am able to telnet on 1521. But while trying to connect with Java code i am getting error:
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
View 8 Replies
ADVERTISEMENT
Nov 1, 2010
My database link to the remote database used to work fine until the company VPN was updated for some security reasons. Now When I try to connect using the DBlink now, error comes up:
TNS 12541 no listener.
Checked the actual listener on the remote database(destination) and it is up and running fine. I am able to ping their machine.
ping <remote host> -works fine
tnsping<remte host> -fails
it comes back with error
TNS 12541: no listener
Nothing has been changed on both databases. The destination database can connect to our database without any issues(they can tnsping and use the dblinks to our database).
LISTENER ENTRY:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
[Code] ......
None of the above should be the cause because there was no change been made on any of these.
View 3 Replies
View Related
Mar 25, 2007
I have a problem on my PC when I try to connect Oracle-db with Designer .It,s Show this message
ORA-12541 :TNS:no Listener
View 2 Replies
View Related
Dec 24, 2007
We installed Oracle 10g on one of our servers and configured the listener to host=localhost. Here's our listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
[code]...
After restarting the listener, we could connect using the connect identifier from the local server. However, when trying to connect from a remote client we received the error of "no listener". In the remote client the identifier is defined with host=ip_address. TNSping from the client to the host was successful.
When we changed listener.ora to host=up_address we could connect ONLY from the remote computer. Only after changing the host in tnsnames.ora file to the IP as well - we could connect from both the local server and the remote client.
I usually use host=localhost in the listener file (and the local tnsnames file) and never had this problem before.
View 1 Replies
View Related
Sep 23, 2011
after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues.
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Starting /u01/app/oracle/product/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist
Listener failed to start. See the error message(s) above...
View 16 Replies
View Related
Jan 15, 2013
I use the "Media Resource" RESTful service type to generate custom JSON objects via CLOB-returning functions. This worked great in APEX Listener 1.1.3. However, on APEX Listener 2.0 I get status 500 on a RESTful service which works fine on 1.1.3 (which generates a clob > 4000 bytes), and the following in the server log:
SEVERE: ORA-22922: nonexistent LOB value
oracle.dbtools.common.UnrecoverableException: ORA-22922: nonexistent LOB valueThis seems to be the same issue as reported here:
APEX Listener EA2 Standalone CLOB error
As stated by thoechst in that thread:
>
It is as though the function is getting cast as a varchar2 somewhere. I verified that the function will correctly return a large result to other sources (dbms_output, for instance).
>
Versions:
APEX Listener 2.0
WebLogic 10.3.6 on Windows 2008 SE R2 x64
Oracle DB 11.2.0.3
View 1 Replies
View Related
Feb 4, 2011
I am having issue with configuring listner name on Oracle Server.My default listener is working,But I have stopped the default listener and tried to create another listener is differnt port,but no success,It always says The address of the specifed listener name is incorrect.Below is the listener.ora file
My db name and sid name are etl
LIST1=(DESCRIPTION=(ADDRESS=
(HOST=127.0.0.1)
(PROTOCOL=TCP)
(PORT=1530)
)
and the list1.log file says The address of the specified listener is incorrect.
View 12 Replies
View Related
Jul 29, 2013
I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:
jdbc:oracle:thin:@IP address:port:service_nameWhen service_name = orcl :
I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.
If I change the URL syntax to following, it works
jdbc:oracle:thin:@IP address:port/service_name
But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":" does not work and "/" works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same?
View 6 Replies
View Related
Feb 15, 2013
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin
myschema.rest(:p_out);
end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
View 0 Replies
View Related
Mar 11, 2010
I am using oracle 11.2.0 in linux platform.i have created a listener for the asm database. and i am using non default port of 1525 whenever i go for lsnrctl>status always shows for the port 1521. i don't want the default port 1521 and i have changed the local listener as listener1 with port 1525 protool tcp in spfile and registered with the asm database.Is there any option to change the default listener as listener1.
also,everytime when i give lsnrctl>show current_listener it is showing "listener"
i have set the current-listener to listener1 and save_config listener1 and reloaded.After exit and enter lsnrctl>status it will show for port 1521 When i attempt to start listener1 every time. it will prompt listener1 is already running.
View 8 Replies
View Related
Jul 5, 2010
In one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?
As we created another one new database in the database, where i need to add this SID in the listener.ora file to reload the listener.
View 4 Replies
View Related
Jun 29, 2012
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
View 2 Replies
View Related
Jul 24, 2012
We have a listener with the password set to it. We are trying to configure that listener to the OEM grid. However, its not getting configured. The status shows as down.
However, when we try to set up without the password, we are able to configure it on the OEM console.
Need to understand, that if passwords are set to the listener; then won't that get configured over the OEM. or is there something where we are lacking.
View 4 Replies
View Related
Feb 27, 2013
I am new to Oracle DB. I have installed Oracle 10g in XP Service Pack2 and was able to login using SYS/SYSTEM users and also was able to create a new user XYZ...
Once I restarted my system, I am facing a strange problem while login. It is continuously throwing the error "tns: listener does not currently know of service requested in connect descriptor". I do not understand the reason. I have checked the services and all oracle related services are running.
However, when I tried to login with the same userid/password from command prompt using 'sqlplus' command, I am able to login ! There was no error this time.
View 2 Replies
View Related
Dec 6, 2010
i have installed oracle 11g r2 rac with 2 nodes. i want to configure the client side load balancing and server side load balancing. For the client side load balancing the i have configured with the
(FAILOVER=ON) (CONNECT_TIMEOUT=5) (RETRY_COUNT =3).
and to configure server side load balancing i have modified the service as follows:
execute (DBMS_SERVICE.MODIFY_SERVICE (service_name=>'service_name', clb_goal=>DBMS_SERVICE.CLB_GOAL_SHORT);
now i have few questions:
1. for the server side load balancing do we have to configure the REMOTE_LISTENER on each node so that the instance on each node registers with the listeners on other node.
2. if we have 3 nodes does this mean that we have to configure the REMOTE_LISTENER on 3 nodes to register with the listeners on the other remaining 2 nodes.
3. does the listener have to be registered with the vip network address (where the clients usually use to connect).
View 2 Replies
View Related
Apr 25, 2011
I am unable to start the listener.When I start it I get this error
LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.20.221)(PORT = 1522))
)
[Code]....
When I try to start it is showing
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 25-APR-2011 10:55
:31
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start listener1
Starting tnslsnr: please wait...
Failed to start service, error 0.
View 4 Replies
View Related
Sep 18, 2012
I'm trying to get listener ports of database through a query. I have a third party tool, which connects to databases and runs select commands and get basic information like status, version, db name etc. I also need to see on which listern port that database is running?
View 1 Replies
View Related
Jan 18, 2010
I have on a Laptop, Oracle database 10g, and some applications on Forms 6i, but having problem to run Forms. Error: "ORA-12224: TNS - No listener."
how setting up Forms6i to work with 10g database? Do I need some Patch? What special configuration to make? What about the many TNSNAMES.ORA and SQLNET.ORA files in the Forms 6i Folder, versus those on the 10g Database Folder?
View 2 Replies
View Related
Mar 29, 2011
Our Oracle database was working fine up until last Thursday, now, for reasons unknown, Oracle is refusing connections. I have done a lot of reading about this error and I have performed all of the recommended actions to no avail. The actions I have performed are (see [URL])...
- Wait a moment and try to connect a second time. Yes, did that, probably 1,000 times - same results.
- Check which services are currently known by the listener by executing: lsnrctl services <listener name> And here are those results (I replaced some of the private stuff with x's)...
C:\Documents and Settings\xxxxx.xxxxx>lsnrctl services orcl
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 29-MAR-2011 06:26:01
Copyright © 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxx.xxxxx.com)(PORT=1521))(CONNEC
T_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
Services Summary...
[code]...
Why does the service PLSExtProc show up but not orcl? I don't get this but that's how its been since installation and as I said, it worked fine until last Thursday.
Here is what my TNSNAMES file looks like (again, replaced private info)...
# tnsnames.ora Network Configuration File: \oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx.xxxxx.com)(PORT = 1521))
[code]...
- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener. See above.
- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener. I don't know what this is.
- Check for an event in the listener.log file. There are a ton of them ... here is one of the entries...
29-MAR-2011 06:44:56 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)(CID=(PROGRAM=C:\Workspace\PDS\DS_App\DS_Engine\bin\Debug\DS_Engine.exe)(HOST=SPATCDT021)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.2.113.85)(PORT=2499)) * establish * ORCL * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
View 3 Replies
View Related
Mar 8, 2008
I have local development Oracle 9i database in my Windows XP. I see it uses TNS Listener port 1521. For some reason it must be using port 8080 also or in the background because it seems to not let my local web container (Apache Tomcat which uses Port 8080) on the same workstation work when it (TNS Listener) is turned on. how I edit the Listener port number and if I do change the port number what other things do I need to change such as the OEM login settings to the local database
View 1 Replies
View Related
Oct 28, 2013
11g RAC environment, I manually shutdown the database with "shutdown immediate" and stop the listener with "lsnrctl stop". Later I manually startup only the database but the listener is also started automatically at almost the same.
Why would this happen ? I just don't want the listener to startup automatically at that time. What can i do to prevent the listener from auto-starting when i startup the database manually.
View 0 Replies
View Related
Mar 11, 2013
i have created a database a make listener configuration and tns with netca.with netca configuration i used port 1525 then i need to change my database port with 1521 so i just moved to my listener.ora and tnsnames.ora and changed port setting to 1521 but after that also my database listening to both the locations.1521 and 1525..if i check connection with sql developer it says connect.how's it possible
View 3 Replies
View Related
Sep 20, 2012
I want to know the best practices about managing listener. Second how can i read log file of listener?
View 2 Replies
View Related
Feb 6, 2013
I faced a problem in our production primary DB like the listener was running but it was not connecting through the remote system, when i accessed the primary database.
But when i restarted the listener it started connecting. I want to know the reason for this crash/freeze.
Oracle version: Oracle Database 11g release 11.2.0.1.0 SE1 64 - bit production
View 3 Replies
View Related
Jan 11, 2013
I have configured MTS server with this parameters:
shared_servers : 42
max_shared_servers : 42
dispatchers : (protocol=tcp)(dispatchers=5)(LISTENER=MDB)
-bash-4.0$ lsnrctl service
LSNRCTL for HPUX: Version 11.2.0.1.0 - Production on 11-JAN-2013 12:21:51
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=offdb2)(PORT=1522)))
Services Summary...
Service "MDB" has 2 instance(s).
Instance "MDB", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:15388 refused:0
LOCAL SERVER
[code]....
From doc. I see that the "current" is the number of client connections it is handling, that is, its current load.It is not correlating with the sessions or processes in DB, so what does this means?
Does it show that more than 150 connections try to perform connection simultaneously?
View 8 Replies
View Related
Oct 31, 2012
We are upgrading 10.2.0.4 enterprise edition single instance to 11.2.0.3 enterprise edition single edition manually. What should the listener status while doing upgradation. This is my first upgradation project.
View 5 Replies
View Related
Aug 31, 2013
I've been trying to rebuild our Oracle 11g server. I started off by wiping Oracle completely and kicked off the install again. The install goes smoothly, but does not create the Listener. I've been trying to use netca to create it myself. The below is the output from netca:
Listner Control complete.
Listener start failed.
Looking in the netca trace file, I see the following error (note I'm only including the error with a few lines before):
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:91] NativeResult: The String obtained is1|SUCCESSFUL
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:99] The status string is: 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:112] The result string is: SUCCESSFUL 1
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:787] _WS_: deleting service2 OracleRemExecService on AUSYD5756 ignoreNotExist = true
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:793] _WS_ deleteService2: node AUSYD5756 Service OracleRemExecService result: 0|Access is denied.
[code]....
The OracleRemExecService services does not exist. I've tried re-installing the whole instance a number of times but each time I hit this error.
View 12 Replies
View Related
Oct 1, 2013
I'm using Oracle10G (10.1.0.2) Enterprise Edition. The size of the listener.log file approximately 2.46GB. Is this responsible for any performance problem of any service in my current instance...
View 9 Replies
View Related
Jan 31, 2013
Though I have it all configures:
On node1:
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.28.155.79)(PORT=1521))))
[code]....
View 9 Replies
View Related
Nov 30, 2012
in listener.ora, if i use localhost, or computer name, then everything is ok, but when i try to use ip address, then I got a error ORA-12541: TNS:no listener
the listener.ora file which working well
# listener.ora Network Configuration File: C:oracleproduct10.2.0db_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db_1)
(PROGRAM = extproc)
[code]....
the only change is use the ipaddress of the server 10.183.7.89 instead of localhost, and if I change the ip address to the computer name, then its also working well.
The server is running on visual box, i don't know if the vistual machine cause this problem, I just want to confirm: I can use the ip address directly right?
View 21 Replies
View Related
