Re: Oracle 8i running Stand alone

From: Jim Bonnie <jbonnie_at_home.com>
Date: Tue, 05 Oct 1999 23:11:23 GMT
Message-ID: <vAvK3.6098$S32.14110@news.rdc1.ct.home.com>

Thanks for the tip on tnsping, it has helped a little,but I still am having a problem connecting Developer to
a local 8i database so I am posting the tnsnames.ora files for any suggesttions.
It looks like the 8i Net 8 config uses Service names, where the Developer SQL NET used SID's.

Can anyone suggest how to configure this or on how I can get the SID from the 8i Database?

Thanks and Regards, Jim

Oracle 8i NET 8 Created TNSNAMES.ORA File contents

---

GLOBAL =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = JBATHOME))     )
(CONNECT_DATA =

      (SERVICE_NAME = Global.Reuters)
    )
  )

And here is the Oracle Developer SQL NET created TNSNAMES.ORA File -

 Note that I entered the SNAME entry manually to test the 'service name' attribute. It did not work!

---

SID.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = JBATHOME)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = JBATHOME)
          (Port = 1526)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )
SNAME.world =
  (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = JBATHOME)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = JBATHOME)
          (Port = 1526)
        )

    )
(SERVICE_NAME = Global.Reuters)

  )

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:938923051.27406.0.pluto.d4ee154e_at_news.demon.nl... > To test the connection, use the tnsping utility. In a dos box, type tnsping

> <service name>.
> If you are using net easy config, and setup a tcp/ip connection, the only
> thing you need to do is add a service, choose the tcp/ip protocol, specify
> the host name, specify a port (usually 1521) and specify the SID of the
> database.
> Or post your net 8 and sqlnet config files and the group will resolve it.
>
> Hth,
> --
> Sybrand Bakker, Oracle DBA
>
> Jim Bonnie <jbonnie_at_home.com> wrote in message
> news:3avJ3.4188$S32.8642_at_news.rdc1.ct.home.com...
> > I tried copying the files from the 8i home over, but was not successful,

I

> > still get the not able resolve servive name error for Developer and
> > Designer.
> >
> > I think that the SQLNET config is the way to go, but there is not much
> > information on it in the docs.
> >
> > It seems odd that the sqlnet does not allow you to test the connection

the

> > way the Net 8 Configuration assistant does.
> >
> > I will keep plugging away...
> >
> > Thanks, Jim
> >
> >
> >
>
>

Received on Tue Oct 05 1999 - 18:11:23 CDT