Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1030
  • Last Modified:

ORA-12541 with 10g across a network

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
alexapostolou
Asked:
alexapostolou
  • 5
  • 4
  • 2
1 Solution
 
gvsbnarayanaCommented:
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
 
gvsbnarayanaCommented:
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
 
schwertnerCommented:
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.

 
alexapostolouAuthor Commented:
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
 
schwertnerCommented:
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
 
alexapostolouAuthor Commented:
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
 
schwertnerCommented:
# 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
 
alexapostolouAuthor Commented:
Tried this, but still the same. Can tnsping on server but on remote PC, still get no response. ANy other ideas?
0
 
schwertnerCommented:
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
 
alexapostolouAuthor Commented:
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
 
schwertnerCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now