Re: HELP ORACLE

There are some bugs with Personal Oracle8 and Developer 2000, v.2.1. The first is that the order of installation needs to be Dev2K, then PO8.

John Alexander
www.SummitSoftwareDesign.com

rafa <rafael.abril_at_wanadoo.es> wrote in message news:%lsx5.361$Ju.7991_at_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 Tue Sep 19 2000 - 06:06:15 CDT