Solved

ORA-12541 with 10g across a network

Posted on 2006-06-21
11
1,020 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
  • 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 47

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
 

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 47

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 47

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 47

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 47

Accepted Solution

by:
schwertner earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now