Connect to remote oracle database on a different domain via ODBC

Hi everyone,

Would appreciate some help on this one:

• have master site on host1.here.com
• have mirror site on host2.there.com

Would like to connect

On host1 did following:

1. ping host2.there.com - OK
2. tnsping mirror.there.com - OK
3. sqlplus me/pwd_at_mirror.there.com - OK
4. test via Net Configuration Assistant - OK
5. Try to set up ODBC connection to mirror using Oracle in OraHome92. when test connection get:

ORA 12545

• SQLNET.ora **

NAMES.DEFAULT_DOMAIN = here.com

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES)

• tnsnames.ora **

mirror.there.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MirrorHost)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mirror.there.com)

    )
  )

master.here.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MasterHost)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = master.here.com)

    )
  )

tried remming out names.default_domain - no difference.

what is happening and what can I do?

Regards

Edwinah63 Received on Tue Feb 21 2006 - 21:50:55 CST