HELP ORACLE

From: rafa <rafael.abril_at_wanadoo.es>
Date: Mon, 18 Sep 2000 17:33:47 GMT
Message-ID: <%lsx5.361$Ju.7991@m2newsread.uni2.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\NETWORK\ADMIN

and the directory is in the PATH

Please I need your help...

Thanks

Rafael Abril
rafael.abril_at_wanadoo.es
Spain Received on Mon Sep 18 2000 - 12:33:47 CDT