Forms :: ORA-12224 - TNS - No Listener

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


ADVERTISEMENT

Application Express Listener :: Using PL/SQL Procedure / Function In Resource Template (listener 1.1.3)

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

Networking And Gateways :: Any Option To Change Default Listener As Listener 1

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

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.

View 4 Replies View Related

Forms :: FRM-10142 - HTTP Listener Is Not Running

Mar 12, 2007

Currently I am using Oracle 9i Database and 10g Developer when I connect via login/password successful login but not execute and shows the error

FRM: 10142 The HTTP listener is not running on <computer Name> at port 8889. start the listener and check your runtime preference.

View 11 Replies View Related

Forms :: FRM-10142 / HTTP Listener Is Not Running At Port 8888

Jul 6, 2005

I am still facing the following error even though i have started the OC4j instance,

"FRM-10142: The HTTP Listener is not running on <computernam> at port 8888.start the listener or check your runtime preferences."

View 24 Replies View Related

Application Express Listener :: APEX Listener With APEX 3.0 On 11gR2?

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

Reg The Configuration Of Listener On OEM?

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

TNS - Listener Does Not Currently Know Of Service?

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

Oracle RAC Listener Configuration

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

Windows :: Listener Not Starting?

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

SQL & PL/SQL :: How To Get Listener Port Through A Query

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

TNS Listener Throwing ORA-12514?

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

Listener Port Number?

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

Clusterware :: Listener Restart In 11g RAC

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

Listener Listening At 2 Ports?

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

Managing Listener And Log Files

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

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 View Related

Listener In Production Environment

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

MTS Listener Current Connection

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

Upgrade :: Get Listener Status?

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

Windows :: Cannot Configure Listener

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

Listener Log File Size

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

11g RAC Listener Show Only One Instance?

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

Use IP Address In Listener.ora Not Working

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

Enterprise Manager :: Listener Is Getting Down?

Apr 25, 2010

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 ?

View 6 Replies View Related

RAC - Listener - VIP Doesn't Migrate From One Node To Another

Apr 17, 2012

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

View 3 Replies View Related

Unable To Start Oracle Listener

Aug 30, 2010

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

View 6 Replies View Related

Multiple Listener Creation In Windows 7

May 5, 2011

I have window7 OS, I installed 4 ORACLE HOME's in WINDOWS7 machine,

two ORACLE_HOME is for 10.2.0.3

two ORACLE_HOME is for 11.2.0.2

My intension is to configure DATAGAURD on 10g,11g But while configuring Listeners it creating problems like as of my knowledge we have set exicutable path in envronmental veriables.

creation of Listener for 10.2.0.3 ( first ORACLE_HOME)

but while creating listerner for 10.2.0.3( seconde ORACLE_HOME)

LISTENER created but it's showing ORACLE_HOME of FIRST ORACLE_HOME

as i know we need to set parameters

SET ORACLE_HOME=
SET ORACLE_SID=

is there any setting Required before configuring LISTENER for SECOND ORACLE_HOME? and for 11g

View 3 Replies View Related

Create Another Listener Service In RAC 11gR2 Env?

Aug 30, 2011

I need to create another listener service in RAC 11gR2 env for a new application connecting to the database in 11gR2 env. I have an existing listener service listening on 2 RAC instances now.The new one needs to be created will have a new service_name, preferably using different port (other than 1521), listening on same same set of instances.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved