On 8 Apr, 10:08, "Paul" <notha...@[EMAIL PROTECTED]
> wrote:
> 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
t=
he
> oracle database set up
> I have the following information, with obvious bits changed.
>
> XXXXXXM =3D
> =A0 (DESCRIPTION =3D
>
> =A0 =A0 (ADDRESS_LIST =3D
>
> =A0 =A0 =A0 (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D
xxxx.xx.xx.147)(****T =
=3D 1521))
>
> =A0 =A0 )
>
> =A0 =A0 (CONNECT_DATA =3D
>
> =A0 =A0 =A0 (SERVICE_NAME =3D xxxxR1)
>
> =A0 =A0 =A0 (SRVR =3D DEDICATED)
>
> =A0 =A0 )
>
> =A0 )
>
> 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
Configurati=
on
> 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.
What operating system?
|
