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