Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Unanswered: Personal Oracle 8i

    I have started up my database and have started my listeners but I cannot tnsping my instance. Why?

    This is what my tnsnames.ora looks like.....

    BRIAN.MRRMNH.ADELPHIA.NET. =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = brian-mills)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = brian.world)
    )
    )

    EXTPROC_CONNECTION_DATA.MRRMNH.ADELPHIA.NET. =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Does your sqlnet.ora file has SQLNET.DEFAULT_DOMAIN = MRRMNH.ADELPHIA.NET. line?

    If not add it there.

    Hope that helps,

    clio_usa
    OCP - DBA

    .
    .
    .

Posting Permissions

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