Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!xmission!news-out.spamkiller.net!propagator2-maxim!news-in.superfeed.net!news.mccons.net!news.maxbaud.net!newssvr31.news.prodigy.com!newsdbm02.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr16.news.prodigy.com.POSTED!10a1c2a2!not-for-mail Message-ID: <3EE100BA.1000503@nospam_netscape.net> From: Dave Hau User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server,microsoft.public.vb.database.ado Subject: Re: ADO connection to Oracle gets a listener error, but only on the first few attempts References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 119 NNTP-Posting-Host: 66.47.68.26 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr16.news.prodigy.com 1054933178 ST000 66.47.68.26 (Fri, 06 Jun 2003 16:59:38 EDT) NNTP-Posting-Date: Fri, 06 Jun 2003 16:59:38 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: TSU[@IONQJV_STHXOJND]_\@VR]^@B@MCPWZKB]MPXHJUZ]CDVW[AKK[J\]^HVKHG^EWZHBLO^[\NH_AZFWGN^\DHNVMX_DHHX[FSQKBOTS@@BP^]C@RHS_AGDDC[AJM_T[GZNRNZAY]GNCPBDYKOLK^_CZFWPGHZIXW@C[AFKBBQS@E@DAZ]VDFUNTQQ]FN Date: Fri, 06 Jun 2003 20:59:39 GMT Xref: core-easynews comp.databases.oracle.server:189052 microsoft.public.vb.database.ado:85471 X-Received-Date: Sun, 08 Jun 2003 12:40:32 MST (news.easynews.com) The errors you got are not very specific. Fortunately, from your sqlnet.ora, it looks like you've turned on client tracing. Go to your c:\ directory and look for files named like "sqlnet.trc". Then run: trcasst -od on each of them and see if you can get more info to help you debug. Cheers, Dave Mark Freeman wrote: > I have a VB 6.0 program that runs on a Win2k machine and connects to > an Oracle 8i database on an AIX system. It works fine. > > I split it up into two programs such that one invokes multiple > instances of the other. The one that has multiple instances running > accesses Oracle to do a query based on a command-line parameter passed > by the controller program. > > When I fire up the controller program, it immediately runs 8 instances > of the database access program. The first two or three get an Oracle > error and the rest work fine. > > The controller program ensures that 8 instances of the database access > program are always running -- when one instance completes and exists > it spawns a new one, until it goes through the thousands required. > > If I kill off the controller program, let all the access program > instances complete, and then run the controller program again, I do > not get the errors even though it is doing exactly the same thing as > it did before. > > The issue appears to be one of multiple programs attempting to make > Oracle connections at the same time, but only when no connection has > been made for some time. > > > The exact error I get is: > > Run-time error '-2147467259 (80004005)': > ORA-12541: TNS:no listener > > > I get the following in sqlnet.log: > > *********************************************************************** > Fatal NI connect error 12541, connecting to: > (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=uscoluxap04.cisgi.com)(PORT=1521))(CONNECT_DATA=(SID=aoninfrp)(CID=(PROGRAM=C:\to-home\NT > LAN-Server Group\Software\FetchWMI\FetchWMI-One.exe)(HOST=COL-MFREEMANLT)(USER=mfreeman)))) > > VERSION INFORMATION: > TNS for 32-bit Windows: Version 8.1.7.0.0 - Production > Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version > 8.1.7.0.0 - Production > Time: 06-JUN-2003 11:22:31 > Tracing not turned on. > Tns error struct: > nr err code: 0 > 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 > > > *********************************************************************** > Fatal NI connect error 12560, connecting to: > (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\to-home\NT > LAN-Server Group\Software\FetchWMI\FetchWMI-One.exe)(HOST=COL-MFREEMANLT)(USER=mfreeman)))) > > VERSION INFORMATION: > TNS for 32-bit Windows: Version 8.1.7.0.0 - Production > Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version > 8.1.7.0.0 - Production > Time: 06-JUN-2003 11:22:32 > Tracing not turned on. > Tns error struct: > nr err code: 0 > ns main err code: 12560 > TNS-12560: TNS:protocol adapter error > ns secondary err code: 0 > nt main err code: 530 > TNS-00530: Protocol adapter error > nt secondary err code: 126 > nt OS err code: 0 > > > My sqlnet.ora: > > # SQLNET.ORA Network Configuration File: > C:\orant\network\admin\sqlnet.ora > # Generated by Oracle configuration tools. > > SQLNET.AUTHENTICATION_SERVICES= (NTS) > > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) > > automatic_ipc=off > > trace_level_client=16 > trace_unique_client=true > trace_directory_client = c:\ > > > The code that makes the connection (in the interests of security, > actual strings have been replaced with pound signs): > > Dim cnnOracle As ADODB.Connection > Set cnnOracle = New ADODB.Connection > cnnOracle.Open "Provider=msdaora;Data Source=##;User > Id=##;Password=##;"