database link - error ORA-02085 problem
Date: 2000/03/29
Message-ID: <38E26E7D.89A65A4C_at_vnp.com>#1/1
Hello,
I am attempting to create a database link between a production db and
another, in order to replicate the production db via snapshots.
I run across a problem which appears to be how Oracle resolves the
remote connection. I am not creating a "ORACLE.VNP.COM" connection, but
an "ORACLE" connection, and Oracle8i appears to expect those to be the
same.
Thank you so much if you have advice and help on this particular
subject.
regards,
The production db is 'oracle' on machine 'pr.vnp.com'.
The replicate db is 'backup' on machine 'life.vnp.com'.
The user and password is the same on both machines
(for access to table AdTable).
Database link created.
ERROR at line 1:
BACKUP.VNP.COM =
Peter Urka <pcu_at_vnp.com>
VNP Software
This is under Oracle8i, Windows 2000 platform.
ORA-02085: database link ORACLE.VNP.COM connects to ORACLE
# E:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration
File:E:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LIFE)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = backup)
)
)
PR.VNP.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PR)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
- here is the sqlnet.ora file
# E:\ORACLE\ORA81\NETWORK\ADMIN\SQLNET.ORA Configuration
File:E:\Oracle\Ora81\network\admin\sqlnet.ora
# Generated by Oracle Net8 Assistant
# commented out by me
# NAMES.DEFAULT_DOMAIN = VNP.COM
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Received on Wed Mar 29 2000 - 00:00:00 CEST