Re: Newbie Help!

In the SID_LIST in the listener file you have to ented SID of the instance it is listening to. What you have now is just the part for the external programs. It should look like:

  (SID_DESC=
   (SID_NAME=prod)
   (ORACLE_HOME=/u01/app/oracle/product/8.0.4))

In the tnsnames ora file you should have something like:

XXXX =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = YYYY)(PORT = 1521))     (CONNECT_DATA = (SID = prod))
  )

Of course replace XXXX and YYYY appropriately.

HTH Djordje

• Original Message ----- From: Mike Baranski <mbaranski_at_celito.net> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, November 17, 2000 3:56 PM Subject: Newbie Help!

>
>
> Here's an overview of my problem:
>
> I'm trying to get a 1 table database set up on a Windows NT Workstation
> 4.0 machine using Oracle 8 EE. I need to share this via tcp/ip over the
> network. I'm connecting to it with a perl script using DBI::Oracle to
> transfer the database to a flat file.
>
> I am very new to Oracle and need to know some steps to set up the
> database and share it, the documentation is very convoluted as far as
> explaining how to set this stuff up.
>
> 1. The database is created, I can connect to it and run some sql
> scripts that I have written.
> 2. There is a listener configured, and the listener.ora file looks like
> this:
>
> # LISTENER.ORA Network Configuration File:
> E:\ORANT2\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> MIKE =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = hailey)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
> )
> )
> )
>
> SID_LIST_MIKE =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = E:\ORANT2)
> (PROGRAM = extproc)
> )
> )
>
>
> 3. My local tnsnames.ora looks like:
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> TEST.SMC =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = hailey)(PORT =
> 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = test.smc)
> )
> )
>
> I still can't connect. Does anyone see anything obviously wrong.
> Please help! I've already spent more time on the dba stuff than I will
> on development and testing of the script. Perls DBI and Oracle are
> built already, they just can't connect.
>
> Thanks
> Mike B.
> --
>
>
> Studies show that research causes cancer in lab rats!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mike Baranski
> INET: mbaranski_at_celito.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Nov 17 2000 - 17:37:27 CST