Results 1 to 2 of 2

Thread: instancename

  1. #1
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Arrow Unanswered: instancename

    I have 2 oracleservers. When I create an instance with dbca on server1 for example test. I can find in my tnsnames.ora the following:
    SOZ.ISH.NL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ora01)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = soz)
    )
    )

    When I do the same thing on server 2 I get the following in tnsnames.ora:
    SOZ2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ora02)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = soz2)
    )
    )

    Now my local network name is not there anymore. How can I change this. I can just edit the file. This works ok, but I rather don't want this. Has anyone an idea?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    tnsnames.ora is editable file; I change (I'd better say: add entries into) it using the text editor.
    Net Configuration Assistant can help you do that (choose "Local Net Service Name configuration" radio button).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •