Re: Connecting to Oracle

The instance name ( ORC0 ) is not what you put as service name - the service name is the alias of the connection to ORC0 - in other words, the name you gave to the connection when you created the tnsnames.ora file - see the following example:

JVGORA8.WORLD =
  (DESCRIPTION =
    (SOURCE_ROUTE = OFF)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hrownt314)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = jvgora8i)
    )
  )

With this, the service name I use in a tool would be JVGORA8.WORLD not jvgora8i

hth,
John Greco

Valentina Muraglia <valentina.muraglia_at_wuerth.it> wrote:

>Ok, using Net8 Easy I created a new tns file but when I try to open an
>oracle tool (for example entrerprise manager) I don't know what i have to
>put in the service field. (I try writing ORC0 but I get un error)
>
>PS. If you want you can answer privately in italian.
>
>Gennaro Napolitano wrote:
>
>> I think that you need to configure the tnsnames.ora file, try using the
>> Net8 Easy Config.
>>
>> Hope this helps
>>
>> Ciao Gennaro
>>
>> Valentina Muraglia wrote:
>>
>> > I installed oracle enterprise 8.0.5 and create a new database (orc0).
>> > Now, if I want to do some operations on the database (for example
>> > creating a table) I have to specify the following information to get a
>> > connection:
>> >
>> > user
>> >
>> > password
>> >
>> > service
>> >
>> > I read the user should be SYSTEM and the password MANAGER. The service
>> > name should be ORC0. I insert the informations but I can't get a
>> > connection, the error is the following:
>> >
>> > the service name could not be find
>> >
>> > or something like that.
>> >
>> > Who can help me?
>> >
>> > vale

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Nov 09 1999 - 13:40:40 CST