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