Networking And Gateways :: Add SID In Listener.ora File To Reload Listener?
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.
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.
Which parameters are required in init file for 'Dynamic Listener Registration'? (for default port/ protocol). I understand that Local_listener is required only if we are using not default protocol, port.
Also which cases we need listener.ora file? I understand we need it for 'Duplicate Database' using RMAN as well as for 'Data Guard'. what else will need it?
I am having a problem getting my listener to start.
[oracle@jhlinux ~]$ lsnrctl start LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 01-MAR-2011 23:26:30 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.1.0.6.0 - Production System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521))) [code]...
When i configure a listener using net manager,if found that the red text box in the picture can fill "the value of the global name " or "the value of the service_names".
I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.
----------------------------------------------------------------- TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production System parameter file is D:oracleproduct10.2.0db_1 etworkadminlistener.or a Log messages written to D:oracleproduct10.2.0db_1
[code]..
Contents of my listener.ora file are below -------------------------------------------------------------- LISTENERSQLODBC = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST=
I just installed oracle 11g on a fresh RHEL 5.2 installation on virtual box.
The database is up, but the listener (LISTENER) hangs after a minute from starting it, and then any lsnrctl command just hangs without showing any error messages, when I restart the virtual machine and then start the DB and listener, it works for a minute and it hangs again!
TNSLSNR for Linux: Version 11.1.0.6.0 - Production System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/list/alert/log.xml TNS-01151: Missing listener name, list, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
Should i have to do some changes in sqlnet.ora for overriding the default settings?
Is it possible to bind an Oracle Listener on 2 different interfaces on the same host?
My initial situation: I've set up a new VLAN in eth1.8 on our database server. There are 2 Oracle instances on this host. One instance was set up for the new VLAN, this works fine. The other listener stayed in the old network, because an other customer also needs to access this instance.
Now the customer wo was set up for 2 new VLAN can't access the other instance listenig on the interface eth0.
In short I have the following setup: customer1: eth0 customer2: eth1.8 (VLAN)
listener1: LST1 listener2: LST2
SSID1: SID1 SSID2: SID2
listener1 is listening on eth0 for SID1 listener2 is listening on eth1.8 for SID2 This works fine.
Now customer2 needs to access SID1, which is configured on eth0, but customer2 is configured for eth1.8
So I need a listener for SID2, that is configured for both interfaces eth0 AND eth1.8.
i have created a listener for my db and register the service to it some 2 years back now i have checked it and it display as follows
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production Start Date 24-JAN-2012 13:45:44 Uptime 0 days 0 hr. 3 min. 59 sec Trace Level off Security ON: Local OS Authentication SNMP OFF [code]....
now i have stop and then restart but same status? so how can i manually register it again or anyother solution as i cant run netmgr
I have a database up and running (including listener) on machine A. From that machine, everything seems fine. However, when I try to connect to it from another machine (say, machine B) on the network, the connection cannot be established (exact message: connection to database failed: The Network adapter cannot establish the connection).
I can successfully ping machine A from machine B. The machine A db is a default install (ORCL).
Is it possible the DB listener is not configured properly to connect to remote clients? On machine B, I have oracle tools such as SQLPLUS, Oracle Net Manager, and Net Configuration Assistant.
ORA-12518 Tns: Listener does not currently know of service
from application server using client 10g to connect our database.This problem happens only in application server and we tried from another server we can connect to database easily but problem only in application server.
this error since TNSNAMES and network are properly hosted since there no network disconnection betwwen database server and application server.
I just found out that the LISTENER I've creating with a password was with "-inherit" settings. Twice I succeeded in doing this, but it seems that it's not working when I tested it. Thus, I opted to get rid of it's listener.bak file and set the password again. Now I just can't stop it because of this error message: "TNS-01169: The listener has not recognized the password".
I've tried every passwords I made, and tried resetting it, but I'm not successful either, it's the same error message.My last option would be to restart the db Server (since the original listener.ora is already intact),
I have installed Oracle 10g in windows 2003 two times with two different homes. (D:oraclehome and E:oraclehome).Databases db01 and db02 created in these homes respectively. how to configure listener and tnsnames to aceess these databases.
I have set password on the listener and set the local_os_authentication parameter to "OFF", whenever i start/stop listener through "lsnrctl" ,it works fine and asks for password but i can stop/start listener through windows services without giving any password.
what is the use of setting password on listener if any body can start/stop it through services utility in windows xp sp3.
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).
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...
C:>sqlplus sys/oracle@duptest as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 18 17:58:22 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
How to set the QUEUESIZE in a RAC Database with SCAN feature. listener.ora inside the grid home contains the following information
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent
and the endpoints_listener.ora contains the following (edited the host and ip details for maintaining confidentiality)
LISTENER_HOSTDB02=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostdb02vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=<ip of hostdb02>)(PORT=1521)(IP=FIRST)))) # line added by Agent
As per my understanding, QUEUESIZE parameter can be set inside the endpoints_listener.ora
how to make changes in a oracle 11g rac environment.
I am have installed oracle 11.2.0 in redhat linux 5.4. I have respectively 2 oracle homes. so total 2 listener files in 2 oracle homes. For accessing one database.Which listener i need to use ? Also if i am going to enterprise manager which listener file. I have to configure.
TNS-12518: TNS:listener could not hand off client connection TNS-12571: TNS:packet writer failure TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error Linux Error: 104: Connection reset by peer
im getting error ORA-12514.our prod db runs under default listener.nw i have configured another listener.if i try to connect from the loacl im grtting above error,bt im able to tnsping from the local system.
