Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: HELP ORACLE,Please!!

Re: HELP ORACLE,Please!!

From: rafa <rafael.abril_at_wanadoo.es>
Date: Sun, 17 Sep 2000 18:58:37 GMT
Message-ID: <xv8x5.595$Pc.44104@m2newsread.uni2.es> 







  First of all thanks for your help...



  I get the same ERROR than before , the logs I get are...



  (In the connect dialog box, when asks for a DATABASE
   I have to put the DSN name, haven't I?)



 ( My DSN name is mibdora)



  sqlnet.log c:\ORAWIN95\BIN







Fatal OSN connect error 12154, connecting to:
 mibdora



  VERSION INFORMATION:



 TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
  Time: 17-SEP-99 20:03:45


  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: 17-SEP-99 20:05: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: 17-SEP-99 20:06: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: 17-SEP-99 20:07:53


  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: 17-SEP-99 20:09: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 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: 17-SEP-99 20:10:39


  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





And the sqlnet.log c:\ORAWIN95\NET80\LOG







Fatal NI connect error 12547, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))



  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: 17-SEP-99 20:03:56


  Tracing not turned on.


  Tns error struct:


    nr err code: 0


    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: 123


    nt OS err code: 0






Fatal NI connect error 12547, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))



  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: 17-SEP-99 20:05:18


  Tracing not turned on.


  Tns error struct:


    nr err code: 0


    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: 123


    nt OS err code: 0






Fatal NI connect error 12547, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))



  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: 17-SEP-99 20:06:41


  Tracing not turned on.


  Tns error struct:


    nr err code: 0


    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: 123


    nt OS err code: 0






Fatal NI connect error 12547, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))



  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: 17-SEP-99 20:08:04


  Tracing not turned on.


  Tns error struct:


    nr err code: 0


    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: 123


    nt OS err code: 0






Fatal NI connect error 12547, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))



  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: 17-SEP-99 20:09:27


  Tracing not turned on.


  Tns error struct:


    nr err code: 0


    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: 123


    nt OS err code: 0



"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> escribió en el mensaje
news:969199568.14012.0.pluto.d4ee154e_at_news.demon.nl...

> Developer 2000 uses sqlnet 2.
> The configuration files for sqlnet2 are by default in
> %ORACLE_HOME%\network\admin instead of
> %ORACLE_HOME%\net80\admin.
>
> Copy your sqlnet.ora and tnsnames.ora to afore-mentioned sqlnet2


 directory,

> or set up a string value TNS_ADMIN in the registry under
> hklm\software\oracle pointing to the net80\admin directory (use the full
> path name here).
>
> BTW this is an Oracle *newsgroup* only
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "rafa" <rafael.abril_at_wanadoo.es> wrote in message
> 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 - 13:58:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US