sit root : oracleasdpoi99
CID: cbstest
SCHEMA: notification
= sit (inbox)
notification/QazXSWe#dcVFR987@172.17.5.52
= uat (inbox)
notification/QazXSWe#dcVFR987@172.17.5.54
postgres sit :
port : 55432
user: dblinkusersit
pass: 123456
rooye database: sit_warehouse
schema: dwh
data:data_2021@172.17.5.21:55432/sit_warehouse
postgres uat :
port : 55432
user: dblinkusersit
pass: 123456
rooye database: sit_warehouse
schema: dwh
postgres production:
dblinkuser
PFXlKQyDZ31N
10.100.5.101:5432
++++++++++++++++++++++++++++++++++++
[PG]
Description = PG
Driver = /usr/lib64/psqlodbcw.so
ServerName = 172.17.5.21
Username = dblinkusersit
Password = 123456
Port = 55432
Database = sit_warehouse
[Default]
Driver = /usr/lib64/liboplodbcS.so
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Description = PSGDB
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
[PSGDB]
Description = PSGDB
ServerName = 172.17.5.21 psql -h 172.17.5.21 -p 55432 -U
dblinkusersit -d sit_warehouse
Username = dblinkusersit
Password = 123456
Port = 55432
Database = sit_warehouse
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
+++++++++++++++++++++++++++++
[PSGDB]
Driver = /usr/lib64/psqlodbcw.so
Description = PostgreSQL Data Source
Servername = 172.17.5.21
Port = 55432
UserName = dblinkusersit
Password = a123456
Database = sit_warehouse
ReadOnly = no
ServerType = Postgres
ConnSettings = UseServerSidePrepare=1
ByteaAsLongVarBinary=1
Optimizer=0
Ksqo=0
TraceFile = /var/log/odbc-PSGDB-trace.log
Debug = No
DebugFile = /var/log/odbc-PSGDB-debug.log
0219 8666 46007
++++++++++++++++++++++++++++++++++++++++++++
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = PSGDB
HS_FDS_TRACE_LEVEL = 0
HS_FDS_SHAREABLE_NAME = /usr/lib64/psqlodbcw.so
HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P9
#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini
#
# ODBC specific environment variables
#
#
# Environment variables required for the non-Oracle system
#
#set =
+++++++++++++++++++++++++++++
PSGDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.5.52)(PORT = 1521))
(CONNECT_DATA =
(SID = PSGDBG)
)
(HS = OK)
)
PSGDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.5.52)(PORT = 1521))
(CONNECT_DATA =
(SID = PSGDB)
)
(HS = OK)
)
+++++++++++++++++++++++++++++++++++++++++
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=PSGDB)
(ORACLE_HOME=/u01/app/oracle/product/19.3/dbhome_1)
(PROGRAM=dg4odbc)
)
)
+++++++++++++++++++++++++++
Link : "PSGDB"
Error : ORA-01017: invalid username/password; logon denied
FATAL: role "DBLINKUSERSIT" does not exist {28000,NativeErr = 210}
ORA-02063: preceding 2 lines from PSGDB
cd /u01/app/grid/product/19.3.0/grid/network/admin
#Backup file is
/u01/app/grid/product/19.3.0/grid_base/crsdata/coredb/output/listener.ora.bak.cored
b.grid line added by Agent
# listener.ora Network Configuration File:
/u01/app/grid/product/19.3.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = coredb)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent
