I am experiencing problems with Oracle 8 in a client machine. All was fine
until I had to reinstall Windows 95. After that, I reinstalled SQL*Plus
(Net8) and Oracle objects for OLE. But now the machine won´t connect to the
database. First of all, after defining the service using the Net8 Easy Config
tool I tried to test the service using the Net8 Easy Config itself and it
crashed. Then I manually changed the tnsnames.ora file, but when I tried to
use SQL*Plus to connect it also crashed. I tried other applications also and
none of them would connect to the database. I even tried to remove Oracle and
install it again but I got the same errors. I have enabled SUPPORT tracing in
Net8 Assistant and it produced the following trace file (with sensitive
information deleted):
- TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is
"c:\ORAWIN95\trace.trc" New trace level is 16 --- TRACE CONFIGURATION
INFORMATION ENDS --- nigini: entry nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1 nrigbi: entry nrigbni: entry nrigbni:
Unable to get data from navigation file tnsnav.ora nrigbni: exit nrigbi: exit
nigini: exit niqname: Using nnfsn2a() to build connect descriptor for
(possibly remote) database. nnftboot: entry nnftboot: exit nnfoboot: entry
nnfoboot: exit nnfhboot: entry nnfhboot: exit nncpmlf_make_local_addrfile:
construction of local names file failed nncpmsf_make_sys_addrfile: system
names file is C:\orawin95\net80\admin\tnsnames.ora nncpcin_maybe_init: first
request sent to name server will have ID 5661 nncpcin_maybe_init: initial
retry timeout for all name servers is 1500 csecs nncpcin_maybe_init: max
request retries per name server is 1 nngsini_init_streams: initializing
stream subsystem, cache size is 10 nngtini_init_msg: initializing PDU
subsystem, initial pool size is 2 nncpcin_maybe_init: default name server
domain is world nnfun2a: entry nnftqnm: entry nnfcagmd: entry nnfcagmd:
Attempting to find metadata for type a.smd nnfcagmd: Attribute name a.smd is
a predefined meta type, syntax is 4. nnfcagmd: exit nnfotran: Checking local
tnsnames.ora file nnfotran: Checking local tnsnames.ora file
nncpldf_load_addrfile: initial load of names file
C:\orawin95\net80\admin\tnsnames.ora nncpldf_load_addrfile: success nnftqnm:
Using tnsnames.ora address (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
<my_db_ip_address>)(PORT = 1521)) (CONNECT_DATA = (SID = <some_SID>))) for
name <my_db_alias>.world nnfcraa: entry nnfun2a: Obtaining answer records for
<my_db_alias>.world nnftans: entry nnfcran: entry nnfcran: 64 rrs requested,
1 remaining, 1 total nnfcran: exit nnfotrv1: entry nnfotrv1: translated
"<my_db_alias>.world" to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
<my_db_ip_address>)(PORT = 1521)) (CONNECT_DATA = (SID = <some_SID>)))
nngsdei_deinit_streams: deinit nngscls_close_stream: UID 0 not established,
ignored nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream:
UID 0 not established, ignored nngscls_close_stream: UID 0 not established,
ignored nngscls_close_stream: UID 0 not established, ignored
nngscls_close_stream: UID 0 not established, ignored nngscls_close_stream:
UID 0 not established, ignored nngscls_close_stream: UID 0 not established,
ignored nngscls_close_stream: UID 0 not established, ignored nsbfrfl: entry
nsbfrfl: normal exit niotns: entry niotns: niotns: setting up interrupt
handler... niotns: Not trying to enable dead connection detection. niotns:
Calling address:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<my_db_ip_address>)(PORT=1521))(CON
NEC
T_DATA=(SID=<some_SID>)(CID=(PROGRAM=C:\ORAWIN95\BIN\PLUS80W.EXE)(HOST=<my_ho
st> )(USER=<my_username>)))) 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: Simple address...
nrigla: No community component so just use straight address nrigla: exit
nridst: entry nridst: Resolving address to use to call destination or next
hop nridst: Found destination address nridst: Local address nridst: Local
destination community found 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=<some_SID>)(CID=(PROGRAM=C:\ORAWIN95\BIN\PLUS
80W
.EXE)(HOST=<my_host>)(USER=<my_username>)))(ADDRESS=(PROTOCOL=TCP)(HOST=<my_d
b_i p_address>)(PORT=1521))). nricdt: entry nricdt: Calling with outgoing
connect data:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<my_db_ip_address>)(PORT=1521))(CON
NEC
T_DATA=(SID=<some_SID>)(CID=(PROGRAM=C:\ORAWIN95\BIN\PLUS80W.EXE)(HOST=<my_ho
st> )(USER=<my_username>)))). nscall: entry nscall: connecting... nsc2addr:
entry nttbnd2addr: entry nttbnd2addr: port resolved to 1521 nttbnd2addr:
using host IP address: <my_db_ip_address> nttbnd2addr: exit nsc2addr: normal
exit nsopen: entry nsmal: entry nsmal: 400 bytes at 0xb5a7a0 nsmal: normal
exit nsnainconn: entry nsmal: entry nsmal: 1664 bytes at 0xab4fd4 nsmal:
normal exit nsnainconn: normal exit nsopen: opening transport... nttcon:
entry nttcon: toc = 1 nttcnp: entry ntvlin: entry ntvllt: entry ntvllt: No
PROTOCOL.ORA file is found ntvllt: exit ntvlin: exit nttcnp: Validnode Table
IN use; err 0x0 nttcnp: creating a socket.
And that´s all. Everything seems ok, except for the fact that it stops here,
just before actually making the connection.
Can anybody out there help me with this ? Please send the answers to my e-mail
address also: wesleyerNOSPAM_at_NOSPAMhotmail.com (remove NOSPAM string).
Thanks for any help and sorry for the long post,
Wesley
PS: I´m using SQL*Plus 8.0.4.
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 02 1999 - 07:25:08 CST
