Newbie Help!

From: Mike Baranski <mbaranski_at_celito.net>
Date: Fri, 17 Nov 2000 16:57:39 -0500
Message-Id: <10683.122422@fatcity.com>

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. Received on Fri Nov 17 2000 - 15:57:39 CST