0

hi i am trying to create an hs for oracle rac for a course but i am unable to configure the hs

How to configure the listener with scan_listener? hs example:

odbc windows64 bits system dns:

odbcSQLSERVER

NOTE: db conexion using rac-scan configure in firewall "Untangle", disk share with "openfiler".

$GRID_HOME\network\admin\tnsnames.ora

SQLSERVERDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = SQLSERVERDB )
    )
  (HS=OK)
  )

$GRID_HOME\hs\admin\initSQLSERVERDB.ora

HS_FDS_CONNECT_INFO = odbcSQLSERVER
HS_FDS_TRACE_LEVEL = off

restart listener

lsnrctl stop
lsnrctl start

tnsping SQLSERVERDB

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = )) (CONNECT_DATA = (SERVER = ) (SERVICE_NAME = )))
OK (10 msec)

I don't understand how to configure this part since it is remote_scan.

is configured or not?

$GRID_HOME\network\admin\listener.ora

REMOTE_LISTENER_SCAN1= ...
REMOTE_LISTENER_SCAN2 = ...
REMOTE_LISTENER_SCAN3 = ...

SID_LIST_REMOTE_LISTENER_SCAN=
  (SID_LIST=
      (SID_DESC=
         (SID_NAME=SQLSERVERDB)
         (ORACLE_HOME=C:\oracle\app\grid)
         (PROGRAM=DG4ODBC)
      )
  )

create dblink: SQS

query:

select * from dbtest.table1@SQS;

ERROR:

ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from SQS

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.