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
We have a change in IT Dept in our organisation and we have been asked us about the impact of the following changes
1. Change in listener Port
2. Change in value of send and Recieve buffer in listener.ora
3. Change in Archive Size from 40M to 20M
I was asked if it was possible to restrict which users / or client IP's connect to my Oracle 11.2 database. I guess I could just shutdown the listener and have me and one other DBA connect to it via SSH / LOCALHOST but I was wondering if there was a more DBA specific way to restrict client connections to just two specific IP's over the Oracle listening port?
View 5 Replies View RelatedI have 2 databases( A and .. which shares common ORACLE_HOME....
i configured 2 listeners through netca in different ports....
and both listener names are different...
But when I stop LISTENER.. both the listeners are getting stop and when i start both the listeners are up and running.. and I could see database B's services.. and vice versa...and when i tnsping , i am able to see port 1521 default port for database A.
when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..if so, which SID should I add A or B?
I have 2 databases( A and B).. which shares common ORACLE_HOME.i configured 2 listeners through netca in different ports and both listener names are different...
But when I stop LISTENER.. both the listeners are getting stop and when i start both the listeners are up and running.. and I could see database B's services.. and vice versa.and when i tnsping , i am able to see port 1521 default port for database A.
when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..if so, which SID should I add A or B? from where listener picks the default information???
>> when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..
Yes, among MANY other things.
CODE#*************************************************************
# Create an alias for every $ORACLE_SID on the UNIX server
#*************************************************************
for DB in `cat /var/opt/oracle/oratab|\
grep -v \#|grep -v \*|cut -d":" -f1`
[code]....
"ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
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.
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.
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.
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?
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.
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.
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).
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.
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 RelatedI 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?
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
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 Related11g 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.
I want to know the best practices about managing listener. Second how can i read log file of listener?
View 2 Replies View RelatedI 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
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
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?
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 RelatedI'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.
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 RelatedThough 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]....
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?
When i run EM ,in my explorer show these
SID = ORCL
instance is open agent is up but ...listener is down .my listener is active and run.... however i can connect to DataBase and execute DDL or DML transactions.How i could resolve it ?
I have the following problem on a 10.2.0.4 Oracle on AIX 1.6..I have 2 RAC nodes as the node # 2 goes down, the VIP migrated correctly to the node # 1, but the listener # 1 do not see the change, and just resolve to the local ip.
The same does not apply in the reverse case, when it drops the node N 1, the listener attends to the fallen VIP node and migrated.The configuration is correct and identical in both nodes, according to the documentation, but I can not find a reasonable answer.
IP node # 1.
scm1or01 192.68.60.11
scm1or01-VIP 192.68.60.13
IP node # 2
scm1or02 192.168.60.12
scm1or01-VIP 192.168.60.14
when scm1or02 is down: scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 11-APR-2012 19:56:46
Copyright � 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCM1OR01
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 11-APR-2012 16:50:19
[code]...
I do not understand the reason, I've rebuilt the configuration of the listener, and netmgr netca tools, but the problem persists
Recently, I've just restored my QAS database and filesystem from my backup tape. I have checked all the configuration files and oracle setting files and do not notice any problem.
However, when I tried to start my listener, it shows some error messages as below. As a result, I'm unable to start my SAP application.
Error:
-------
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
For you information, I'm able to start my Oracle instance. Please refer to below.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5620367360 bytes
Fixed Size 2064184 bytes
Variable Size 2818572488 bytes
Database Buffers 2785017856 bytes
Redo Buffers 14712832 bytes
Database mounted.
oraqas 3> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 12:57:25
Copyright � 1991, 2007, Oracle. All rights reserved.
Starting /oracle/QAS/102_64/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
System parameter file is /oracle/QAS/102_64/network/admin/listener.ora
Log messages written to /oracle/QAS/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD))
STATUS of the LISTENER
-------------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
Start Date 30-AUG-2010 12:57:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/QAS/102_64/network/admin/listener.ora
Listener Log File /oracle/QAS/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Services Summary...
Service "QAS" has 1 instance(s).
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
