?
Solved

ORA-12541 with 10g across a network

Posted on 2006-06-21
11
Medium Priority
?
1,027 Views
Last Modified: 2012-08-14
Hi Experts,

We have a Windows 2000 server running Oracle 10.2.0.2.0 Standard Edition. A lsnrctl status produces this:

=======================================================================================
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LSNR
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Produ
ction
Start Date                21-JUN-2006 08:27:05
Uptime                    0 days 15 hr. 10 min. 16 sec
Trace Level               admin
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   J:\ora10g\NETWORK\ADMIN\listener.ora
Listener Log File         j:\ora10g\network\log\lsnr.log
Listener Trace File       j:\ora10g\network\trace\lsnr.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fpe-server)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+asm", status BLOCKED, has 1 handler(s) for this service...
Service "+asm" has 1 instance(s).
  Instance "+asm", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "meercat" has 1 instance(s).
  Instance "meercat", status READY, has 1 handler(s) for this service...
Service "meercat_XPT" has 1 instance(s).
  Instance "meercat", status READY, has 1 handler(s) for this service...
The command completed successfully

=======================================================================================

on the server itself, I can do everything, no problems.

On a Windows XP Pro SP2 machine connected to the same network, running the 10g Instant Client, I can also connect with Toad, again, no issues.

But whenever I try to access the server via a home-grown application, I get an ORA-12541. TNS:no listener error. This same application works perfectly on the server itself, but not on the XP machine.

While I realise the application could have a fair bit to do with it, the fact that it works perfectly on the server means that it should also work remotely.

So, what I am wondering is, has anyone else seen a situation like this, where the ORA-12541 error is returned when there is a working listener in place, what might cause it and how would one go about tracking the cause down?



The
0
Comment
Question by:alexapostolou
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
11 Comments
 
LVL 8

Expert Comment

by:gvsbnarayana
ID: 16953239
Hi,
  Have you configured TNS Names on the client machine? If so, make a tnsping in the command prompt to see, if the tns is configured properly and is reachable. Also look at the details, it shows the host that it is looking for.
Syntax :
c:/> tnsping servicename

HTH.
Regards,
Badri.
0
 
LVL 8

Expert Comment

by:gvsbnarayana
ID: 16953273
Hi,
  Missed the point that you are able to connect from TOAD. Can you check the connection string that your application is using to connect to the server?
HTH.
Regards,
Badri.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16958515
Possibly a firewall has blocked the port of the Listener.
c:>tnsping name
will check this.
The machine also may has been not visible
Check this so:
C:>ping machine
As last resort try to find errors in tnsnames.ora
entry.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:alexapostolou
ID: 16965425
Have check the connection string and it is Oracle compliant, same string works within Toad.

As we are using no tnsname.ora or other local support (only the Instant Client) then the database name is not known to tnsping. The machine pinging works. And there is no firewall limitation.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16966525
If so, go to fixed registration of the instance in the Listener (may be this is done, if so, excuse me!) because dynamic registration often fails in 10g:

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Thats all.



0
 

Author Comment

by:alexapostolou
ID: 16966562
This is what it currently contains:

# listener.ora Network Configuration File: J:\ora10g\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

TRACE_LEVEL_LSNR = ADMIN

SID_LIST_LSNR =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = j:\ora10g)
      (PROGRAM = extproc)
    )
  )

LSNR =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = FPE-SERVER)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )



How are you suggesting that I change it?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16966879
# listener.ora Network Configuration File: J:\ora10g\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

TRACE_LEVEL_LSNR = ADMIN

SID_LIST_LSNR =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = j:\ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)  <---------------------- change this using the SID of your Instance
      (ORACLE_HOME = j:\ora10g)
    )
  )

LSNR =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = FPE-SERVER)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Try to connect.
0
 

Author Comment

by:alexapostolou
ID: 16968079
Tried this, but still the same. Can tnsping on server but on remote PC, still get no response. ANy other ideas?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16968667
Hidden firewall!
Had the same problem on my office laptop under XP.
There were an "Office Trend personal Firewall" in the processes
and only after stopping the service was able to make remote connection.

Also try to install the normal Oracle client.
Instant client was introduced in 10g Rel1, but after that
is not offered. Possibly it has bugs or mallfuctions.
Are you able to connect other instances using instant client?
0
 

Author Comment

by:alexapostolou
ID: 16992069
Tried the firewall option but that was not it. On the Instant Client side, we have the latest installed and are running it from within the application's directory and are passing through the full Oracle connect string, and there are no environment variables getting in the way, neither Oracle's nor pathing.

This is the entry from the sqlnet.log file...

***********************************************************************
Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fpe-server)(PORT=2108))(CONNECT_DATA=(SERVICE_NAME=meercat)(CID=(PROGRAM=C:\Documents and Settings\Alex.LAPTOP.000\Desktop\1.6 Test\TreeFrog.exe)(HOST=LAPTOP)(USER=Alex))))

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
      Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
  Time: 26-JUN-2006 20:11:50
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener
    nt secondary err code: 61
    nt OS err code: 0


0
 
LVL 48

Accepted Solution

by:
schwertner earned 2000 total points
ID: 16999995
2108
and
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fpe-server)(PORT=1521)))

You have error pointing the port!

Use:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fpe-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=meercat)(CID=(PROGRAM=C:\Documents and Settings\Alex.LAPTOP.000\Desktop\1.6 Test\TreeFrog.exe)(HOST=LAPTOP)(USER=Alex))))
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question