Re: configuring oracle 9i with Oracle developer6i

From: sjrahman <sjrahman_at_supanet.com>
Date: Sun, 16 Mar 2003 12:30:20 +0000
Message-ID: <2649627.1047817820_at_dbforums.com>

Hi,
[Quoted] 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:
>
[Quoted] > > 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

Received on Sun Mar 16 2003 - 13:30:20 CET