Re: HELP ORACLE,Please!!

From: rafa <rafael.abril_at_wanadoo.es>
Date: Sun, 17 Sep 2000 13:36:44 GMT
Message-ID: <MN3x5.279478$Z05.2608818@telenews.teleline.es>

And this another one in the bin directory...

sqlnet.ora

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 12:44:50
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 12:46:13
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 12:47:36
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 12:48:59
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12154, connecting to:  mibdora

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 2.3.4.0.0 - Production   Time: 16-SEP-99 13:01:23
  Tracing not turned on.

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:02:46
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:04:08
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:05:31
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:06:54
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:08:16
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12154, connecting to:  ORCL   VERSION INFORMATION:
 TNS for 32-bit Windows: Version 2.3.4.0.0 - Production   Time: 16-SEP-99 13:28:40
  Tracing not turned on.

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:30:03
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:31:26
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:32:48
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:34:11
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:35:33
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\ORAWIN95\BIN\OSTOP80.EXE)(HOST=DEFAULT) (USER=OraUser))))

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.3.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.3.0.1 - Production
  Time: 16-SEP-99 13:48:54
  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

---

Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\ORAWIN95\BIN\OSTOP80.EXE)(HOST=DEFAULT) (USER=OraUser))))

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.3.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.3.0.1 - Production
  Time: 16-SEP-99 13:48:57
  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

---

Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\ORAWIN95\BIN\OSTOP80.EXE)(HOST=DEFAULT) (USER=OraUser))))

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.3.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.3.0.1 - Production
  Time: 16-SEP-99 13:49: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

---

Fatal OSN connect error 12154, connecting to:  mibdora

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 2.3.4.0.0 - Production   Time: 16-SEP-99 13:51:03
  Tracing not turned on.

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:52:26
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:53:48
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:55:11
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:56:34
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal OSN connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=R30DES32.EXE)(HOST=DEFAULT)(USER=OraUser)) ))

  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: 16-SEP-99 13:57:56
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal NI connect error 12547, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\ORAWIN95\BIN\OSTOP80.EXE)(HOST=DEFAULT) (USER=OraUser))))

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.3.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.3.0.1 - Production
  Time: 16-SEP-99 14:28:01
  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

"rafa" <rafael.abril_at_wanadoo.es> escribió en el mensaje news:fA3x5.279231$Z05.2605680_at_telenews.teleline.es...
>
>
> Hi everybody
>
> I have installed Oracle8 DB in Windows95 and it is working
> good because I can access it with sql plus.
>
> I have created a service with 'Net easy config' using 'Beq' protocol
> and the test is correct.
>
> Later, using de ODBC Admin of MS I created a SYSTEM DSN associated
> with the service created before. and the test with the ' ORACLE ODBC
> TEST' is Ok.
>
> Later on, I installed the Developer 2000 in the same machine.
> The problem is that when I execute some developer aplication
> such as the query builder and I try to connect to the local DB
> I get this ERROR
>
>
> REP-0501: Unable to connect to the specified database
> ORA-12154: TNS could not resolve service name.
>
> and I can't connect
>
> What is the problem????
>
> The TNSNAMES.ora file I have IS
>
>
>
> # TNSNAMES.ORA Configuration file: C:\ORAWIN95\NET80\ADMIN\tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> TcpExample.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = Production1)
> (Port = 1521)
> )
> (CONNECT_DATA = (SID = SID1)
> )
> )
> SpxExample.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = SPX)
> (Service = Server_lsnr)
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> NmpExample.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = NMP)
> (Server = FinanceServer1)
> (Pipe = ORAPIPE)
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> CMExample.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = tcp)
> (PORT = 1610)
> (HOST = CM_SERVER)
> )
> (ADDRESS =
> (PROTOCOL = tcp)
> (PORT = 1521)
> (HOST = LSNR_SERVER)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> (SOURCE_ROUTE = yes)
> )
> extproc_connection_data.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = IPC)
> (KEY = ORCL)
> )
> (CONNECT_DATA = (SID = extproc)
> )
> )
> Beq-local.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = BEQ)
> (PROGRAM = oracle80)
> (ARGV0 = oracle80ORCL)
> (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>
> -----
> And the sqlnet.ora
>
> TRACE_LEVEL_CLIENT = OFF
> sqlnet.authentication_services = (NTS)
> names.directory_path = (TNSNAMES, HOSTNAME)
> names.default_domain = world
> name.default_zone = world
> automatic_ipc = off
>
>
> Both in the same directory WINORA95\net80\ADMIN
>
> and the directory is in the PATH
>
> Please I need your help...
>
> Thanks
>
> Rafael Abril
> rafael.abril_at_wanadoo.es
> Spain
>
>
Received on Sun Sep 17 2000 - 08:36:44 CDT