Re: configuring oracle 9i with Oracle developer6i

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Sun, 16 Mar 2003 12:45:52 -0800
Message-ID: <3E74E280.2C70BE30_at_exxesolutions.com>


sjrahman wrote:

> Hi,
> I have tried replaceing the TNSnames.ora and editing certain lines but
> cannot get to connect using developer. I have pasted the both
> TNSnames.ora hoping you could point me to the right directions
>
> thanks again
>
> [oracle9i TNSnames.ora]
>
> # TNSNAMES.ORA Network Configuration File:
> # C:\Oracle\Ora91\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = rahman)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORCL)
> )
> )
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = rahman)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = MODOSE)
> (PRESENTATION = http://HRService)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> ---------------------------------------------------
> [developer6i TNSnames.ora]
>
> Beq-local.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = BEQ)
> (PROGRAM = oracle80)
> (ARGV0 = oracle80ORCL)
> (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> TcpExample.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = Production1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> SpxExample.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = SPX)
> (Service = Server_lsnr)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
> NmpExample.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (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 = EXTPROC%ORACLE_HOME_ID%)
> )
> (CONNECT_DATA = (SID = extproc)
> )
> )
>
> Originally posted by Da Morgan
> > sjrahman wrote:
> >
> > > Hi all,
> > > I installed developer6i followed by a typical installation of
> > oracle9i
> > > which created a local database. I cannot log onto developer, as
> > i
> > > understand i have change things on the TNSnames.ora but dont
> > know what.
> > > Can anyone help me?
> > > Thanks
> > > Syed
> > > --
> > > Posted via
> > http://dbforums.com/http://dbforums.com
> >
> > Developer, in its separate ORACLE_HOME, has a tnsnames.ora at
> > \network\admin. Copy your 9i tnsnames.ora to this location and
> > replace any
> > tnsnames file that is there.
> >
> > Provided you have your default ORACLE_HOME set properly you
> > should be able
> > to connect.
> >
> Daniel Morgan
>
> --
> Posted via http://dbforums.com

The issue here is likely not tnsnames.ora but rather environment variables.

Daniel Morgan Received on Sun Mar 16 2003 - 21:45:52 CET

Original text of this message