Re: HELP ORACLE

I'll try to install the developer 2k first... Thanks

RAFA "John Alexander" <jalexander_at_summitsoftwaredesign.com> escribió en el mensaje news:HMHx5.2538$Ya2.519806_at_typhoon.tampabay.rr.com...
> 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 - 13:08:32 CDT