Newbie questions

From: Paul <nothanks_at_btopenworld.com>
Date: Tue, 8 Apr 2008 10:08:52 +0100
Message-ID: <UeqdnRyescmvq2banZ2dnUVZ8uOdnZ2d_at_bt.com>

[Quoted] I am completely new to Oracle after 10 years of using MS SQl, and I am struggling with the basics.

I need to collect data from an Oracle database, and I have had access to the oracle database set up
I have the following information, with obvious bits changed.

XXXXXXM =
  (DESCRIPTION =     (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx.xx.xx.147)(PORT = 1521))

    )

    (CONNECT_DATA =
(SERVICE_NAME = xxxxR1)

(SRVR = DEDICATED)
    )

  )

I also have the user id and pw

I have installed oracle client 9i, but the SQL+ asks for a host string??

I have also tried to configure a connection using the "Network Configuration Assistant" by adding a Oracle Names Servers. But having added this it doesn't seem to work, and I cant edit or delete it.

Any help would be appreciated. Received on Tue Apr 08 2008 - 11:08:52 CEST