| cannot connect via sql*net v2 to oracle 9.2 [message #66747] |
Fri, 06 December 2002 07:02  |
Coen Bruinenberg
Messages: 2
Registered: December 2002
|
Junior Member |
|
|
On a win2K (and w95) client i need a sql*net v2 connection to an oracle 9i database.
On the client both net8 and sqlnet are installed.
Tnsping and tnsping80 are installed in the directory. both work.
I'm trying to connect to a remote database. And the net8 connection works just fine!
when trying a sqlplus session the following error occurs (sqlnet log)
====================
Fatal OSN connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PLUS33.EXE)(HOST=STRAYHORN)(USER=CBB))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 2.3.4.0.0 - Production
Time: 06-DEC-02 12:05:02
Tracing not turned on.
Tns error struct:
nr err code: 12206
TNS-12206: TNS:received a TNS error during navigation
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
TNS-00517: Lost contact
nt secondary err code: 0
nt OS err code: 0
===================
sqlnet trace file :
osnqrn: Hst is already an NVstring.
osnqrn: Inserting CID.
onstns: osntns: setting up interrupt handler...
onstns: Not trying to enable dead connection detection.
onstns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PLUS33W.EXE)(HOST=STRAYHORN)(USER=CBB))))
nricall: entry
nric2a: entry
nric2a: Getting local community information
nriglp: entry
nriglp: Looking for local addresses setup by nrigla
nriglp: No addresses in the preferred address list
nriglp: exit
nric2a: TNSNAV.ORA is not present. No local communities entry.
nrigla: entry
nrigla: Getting local address information
nrigla: Address list being processed...
nrigla: No community information so all addresses are "local"
nrigla: exit
nridst: entry
nridst: Resolving address to use to call destination or next hop
nridst: Processing address list...
nridst: No community entries so iterate over address list
nridst: exit
nric2a: This is a local community access
nric2a: exit
nricall: Got routable address information
nricall: Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PLUS33W.EXE)(HOST=STRAYHORN)(USER=CBB)))(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))
nricdt: entry
nricdt: Calling with outgoing connect data (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PLUS33W.EXE)(HOST=STRAYHORN)(USER=CBB))))
nscall: entry
nscall: connecting...
nsc2addr: entry
nsc2addr: (DESCRIPTION=(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=PLUS33W.EXE)(HOST=STRAYHORN)(USER=CBB)))(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))
nlpcaini: entry
nlpcaini: prg = oracle80
nlpcaini: arg[[0]] = oracle80ORCL
nlpcaini: arg[[1]] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
nlpcaini: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 456 bytes at 0xb406c0
nsmal: normal exit
nsopen: opening transport...
ntpcon: entry
ntpcon: toc = 1
sntpcall: entry
snlpcss: entry
-<ERROR>- snlpcss: Unable to spawn Oracle oracle80 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) ORCL, error 2.
ntpcon: exit
nserror: entry
-<ERROR>- nserror: nsres: id=0, op=65, ns=12547, ns2=12560; nt[[0]]=517, nt[[1]]=0, nt[[2]]=0
-<ERROR>- nsopen: unable to open transport
nsmfr: entry
nsmfr: 456 bytes at 0xb406c0
nsmfr: normal exit
nsopen: error exit
nscall: error exit
nricdt: Call failed...
nricdt: exit
nricall: Failed to copy originating community name value binding
nricall: Exiting NRICALL with following termination result -1
nricall: exit
-<ERROR>- osnqper: error from nricall
-<ERROR>- osnqper: nr err code: 12206
-<ERROR>- osnqper: ns main err code: 12547
-<ERROR>- osnqper: ns (2) err code: 12560
-<ERROR>- osnqper: nt main err code: 517
-<ERROR>- osnqper: nt (2) err code: 0
-<ERROR>- osnqper: nt OS err code: 0
osnqme: entry
osnqme: reporting ns (2) error: (12547) as rdbms err (12547)
osnqme: exit
-<ERROR>- onstns: Couldn't connect, returning 12547
onstns: exit
osnqtg: Count in the OSN global area is now 0
nrigbd: entry
nrigbd: exit
osnqtg: Count in the NL global area is now 0
|
|
|
|
|
|
| Re: cannot connect via sql*net v2 to oracle 9.2 [message #66752 is a reply to message #66747] |
Tue, 10 December 2002 03:02  |
Coen Bruinenberg
Messages: 2
Registered: December 2002
|
Junior Member |
|
|
thanks for the suggestion
- tried recreation of services, did not work.
- installed the patchset 1 for windows2000 and
recreated the services
result: none
but . . .
- cleaned up some of the oracle services in
the nt registry
(four listeners were available as a service
and started!)
- created a new database (same content using
an import)
- via sqlnet 2.3 (32 bit) database connection
is possible
- via slqnet 2.3 (16bit) / odbc connection is
also possible.
not sure what went wrong but it works now
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
