odbc configure in oracle database

ODBC configure & run time data sink in oracle database
--------------------------|||||------------------------


# install fingerTech 
  #finally create new database.. video mistec
# connect to punch machine ip
# Create system dns face


C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\hs\admin

HS_FDS_CONNECT_INFO = face
HS_FDS_TRACE_LEVEL = off

C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\network\admin
listener.ora

(SID_DESC =
(SID_NAME = face)
(ORACLE_HOME = C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1)
(PROGRAM = dg4odbc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)

tnsnames.ora

FACEDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SID = face))
      (HS=OK)
  )


conn sys as sysdba

create user root identified by root;

grant connect,resource,dba to root;   

conn root/root@orcl

DROP PUBLIC DATABASE LINK FACELINK;

CREATE PUBLIC DATABASE LINK "FACELINK"
 CONNECT TO "root"
 IDENTIFIED BY "root"
 USING 'FACEDB';

restart pc and check --

select * from auditdata@facelink;

select "serialno",to_char("checktime",'DD-MON-RR HH24:MI:SS') from auditdata@facelink;