Instant Client

[techstar]

1. I installed instant client and verified that it works.

2. I can log on using the database string:
(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = TSIDB4)(PORT = 1522))) (CONNECT_DATA =(SERVICE_NAME = TSIDB4)))

3. That exact same string (without cr) exists in the tnsnames.ora file as:
TSIDB4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TSIDB4)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = TSIDB4)
)
)
4. Using the database = tsidb4 I get an error.

Note that this database uses Post 1522 not 1521.

5. I can log onto the following database using the tnsnames.ora file:

TSIDB3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TSIDB3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TSIDB3)
)
)

What is the problem?

 

[Marco Kalter]

What error do you get?

 

[techstar]

ORA-12541 TNS:No Listener

 

[techstar]

Marco - are you assuming Port 1521 when using instant client?

 

[CTzen]

Perry,

I just use following format and it works for me

//:/

 

[Marco Kalter]

Marco - are you assuming Port 1521 when using instant client?

PL/SQL Developer does not operate at this level. It does not directly use (or assume) ports. This is all handled at the Oracle Net level, in this case the Instant Client.

ORA-12541 TNS:No Listener

Maybe you can use Oracle Net Tracing with trace_level_client = USER. This will at least show what exactly the Instant Client is doing, and will help you determine why exaclty the client thinks that there is no listener.

 

[techstar]

As far as I know, Instant Client does not have tracing. Here is the entry in sqlnet.log. Note that it is changing the port to 1521 from 1522:

Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=tsidb4.tsisports.com)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=TSI-LAPTOP-01)(USER=Administrator)))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521)))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 09-DEC-2005 06:18:05
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: Message 12541 not found; No message file for product=NETWORK, facility=TNS
ns secondary err code: 12560
nt main err code: 511
TNS-00511: Message 511 not found; No message file for product=NETWORK, facility=TNS
nt secondary err code: 61
nt OS err code: 0

 

[techstar]

CTzen - Thanks, but the problem is also happening in DOA, so I think it needs some resolution.

 

[techstar]

Marco- Here is the sqlnet.log from a delphi program using doa. Same problem:

***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=tsidb4.tsisports.com)(CID=(PROGRAM=C:\Documents and Settings\Administrator.TSI-LAPTOP-01\Desktop\TSISports.exe)(HOST=TSI-LAPTOP-01)(USER=Administrator)))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.11)(PORT=1521)))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 09-DEC-2005 06:50:24
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: Message 12541 not found; No message file for product=NETWORK, facility=TNS
ns secondary err code: 12560
nt main err code: 511
TNS-00511: Message 511 not found; No message file for product=NETWORK, facility=TNS
nt secondary err code: 61
nt OS err code: 0

 

[Marco Kalter]

Oracle MetaLink suggests that this might be a Client-side Firewall issue.

nioqper: ns main err code: 12541
nioqper: ns (2) err code: 12560
nioqper: nt main err code: 511
nioqper: nt (2) err code: 61
nioqper: nt OS err code: 0

Under the "nserror" call you will see the parameter "nt[1]=61". The same information is also found in the "nioqper" error stack in parameter "nt (2)" with error code 61.

If you add 10000 to this number and look up 10061 in the "Windows Sockets Error Codes" reference provided by Microsoft

http://msdn.microsoft.com/library/d...ock/winsock/windows_sockets_error_codes_2.asp

you will see that the Operating System is throwing the error:

WSAECONNREFUSED 10061 - Connection refused.

"No connection could be made because the target computer actively refused it. This usually results from trying to connect to a service that is inactive on the foreign host -- that is, one with no server application running."

 

[techstar]

Marco- I could buy this, except notice the 1521 in the port, where I am specifying 1522.

 

[Marco Kalter]

I can't explain that. Like I said, this all happens at the Oracle Net level.

Do you have a client-side firewall?

 

[techstar]

No firewall.