TNS Error - Dataguard
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: TNS Error - Dataguard

  1. #1
    Join Date
    Sep 2003
    Posts
    1

    TNS Error - Dataguard

    Hi,

    Solaris 9, Oracle 9.2.0.3

    I'm trying to set up a standby database for use with dataguard. I've already set up the standby, but my archive logs aren't being transferred. If I look in the sqlnet.log, I can see the following error on the PRIMARY DB:

    Fatal NI connect error 12514, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=telos.mydomain.mycom.com)(PORT=1521))(CON
    NECT_DATA=(SERVICE_NAME=VSID_telos)(SERVER=DEDICATED)(CID=(PROGRAM=)(HOST=meno.mydomain.mycom.com)(U SER=oracle))))

    VERSION INFORMATION:
    TNS for Solaris: Version 9.2.0.3.0 - Production
    Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.3.0 - Production
    TCP/IP NT Protocol Adapter for Solaris: Version 9.2.0.3.0 - Production
    Time: 16-SEP-2003 13:17:25
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12564
    TNS-12564: TNS:connection refused
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

    Ok, so I looked on google and the TNS-12564 is pretty vauge. I've restarted the listener on my standby, to no avail. I try to tnsping the database, but I get the following :

    $ tnsping vsid

    Used parameter files:
    /services/oracle/product/9.2/network/admin/sqlnet.ora
    TNS-03505: Failed to resolve name
    $ tnsping VSID_telos
    Used parameter files:
    /services/oracle/product/9.2/network/admin/sqlnet.ora
    TNS-03505: Failed to resolve name

    vsid is my sid, and VSID_telos is the service name..., below is my sqlnet.ora on the standby:
    NAMES.DIRECTORY_PATH= (ONAMES, HOSTNAME, TNSNAMES)
    and on the PRIMARY:
    NAMES.DIRECTORY_PATH= (HOSTNAME, TNSNAMES)

    I believe the problem is with my tnsnames.ora file on the standby DB, but I'm not sure what needs changed. Below is a copy, any info would really, really be great.

    # TNSNAMES.ORA Network Configuration File: /services/oracle/product/9.2/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    EXTPROC_CONNECTION_DATA.CITES.UIUC.EDU =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    VSID_TELOS.CITES.UIUC.EDU =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = telos.mydomain.mycom.com)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = VSID)
    (SERVER = DEDICATED)
    )
    )

    INST1_HTTP.CITES.UIUC.EDU =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = telos.mydomain.mycom.com)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    VSID.MYDOMAIN.MYCOM.COM=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = meno.mydomain.mycom.com)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = VSID)
    )
    )


    My PRIMARY db contain's its local connection strings, plus the following for the standby DB:
    VSID_TELOS.mydomain.mycom.com =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = telos.mydomain.mycom.com)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SID = VSID)
    )
    )

    Again, any help would be really super, thanks in advance

    - Chris Newman

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    A couple of thins you can try here.

    1. Set NAMES.DIRECTORY_PATH= (TNSNAMES) in sqlnet.ora
    2. Try to tnsping VSID.MYDOMAIN.MYCOM.COM
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its 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
  •  



Click Here to Expand Forum to Full Width