**************
public信息
**************
SQL> select * from dba_db_links;
OWNER DB_LINK USERNAME HOST CREATED
------------------------------ ---------------------------------------- ------------------------------ -------------------------------------------------- ------------
PUBLIC TOMOT CRM (DESCRIPTION = 08-AUG-17
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.245.3
2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PUBLIC GWTOCRMHIS pifuser toCrmHis 01-AUG-17
PUBLIC LINK2TOUGU syn TOTOUGU 11-OCT-18
OWNER DB_LINK USERNAME HOST CREATED
------------------------------ ---------------------------------------- ------------------------------ -------------------------------------------------- ------------
PUBLIC GWTOOTC pifuser toOtc 30-JUN-17
PUBLIC GWTOKCBL pifuser toKCBL 30-JUN-17
PUBLIC GZ20 GZREADER (DESCRIPTION = 30-JUN-17
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.29.67
)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = guzhibk)
)
)
OWNER DB_LINK USERNAME HOST CREATED
------------------------------ ---------------------------------------- ------------------------------ -------------------------------------------------- ------------
PUBLIC GWTOCOS pifuser toCos 30-JUN-17
PUBLIC GWTOCCRM pifuser toCcrm 30-JUN-17
PUBLIC GWTOCRMOF pifuser toCrmof 30-JUN-17
PUBLIC GWTOCRM pifuser toCrm 30-JUN-17
PUBLIC GWTOSJZD pifuser dg4msql 30-JUN-17
/oracle/app/oracle/product/11.2.0.4/tg_1/network/admin
/oracle/app/oracle/product/11.2.0.4/tg_1/dg4msql/admin
create public database link KBSSACCT connect to "sa" IDENTIFIED by "bushisa" using 'dg4msql';
/oracle/app/oracle/product/11.2.0.4/tg_1/network/admin
/oracle/app/oracle/product/11.2.0.4/tg_1/dg4msql/admin
TOTOUGU =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.232.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = totougu)
)
(HS=OK)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)
(PROGRAM=dg4msql)
)
(SID_DESC=
(SID_NAME=toCrm)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)
(PROGRAM=dg4msql)
)
(SID_DESC=
(SID_NAME=toCrmof)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)
(PROGRAM=dg4msql)
)
(SID_DESC=
(SID_NAME=toCos)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)
(PROGRAM=dg4msql)
)
(SID_DESC=
(SID_NAME=toCcrm)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)
(PROGRAM=dg4msql)
)
(SID_DESC=
(SID_NAME=toKCBL)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)
(PROGRAM=dg4msql)
)
(SID_DESC=
(SID_NAME=toOtc)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)
(PROGRAM=dg4msql)
)
(SID_DESC=
(SID_NAME=totougu)
(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/dbhome_1)
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH=/usr/lib64:/oracle/app/oracle/product/11.2.0.4/dbhome_1/lib)
)
)
alter public database link LINK2TOUGU connect to syn identified by "syn";
create public database link LINK2TOUGU2 connect to "syn" IDENTIFIED by "syn" using 'TOTOUGU';
[dbjf-crm-pifda:oracle]:/oracle/app/oracle/product/11.2.0.4/dbhome_1/hs/admin>cat inittotougu.ora
HS_FDS_CONNECT_INFO=totougu # /etc/odbc.ini中的配置
HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_FDS_REMOTE_DB_CHARSET=utf8
HS_KEEP_REMOTE_COLUMN_SIZE=ALL
HS_NLS_LENGTH_SEMANTICS=CHAR
HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8
# Oracle数据库字符集，根据情况进行设置
#HS_FDS_MAP_NCHAR = TRUE
#HS_SQL_HANDLE_STMT_REUSE = TRUE
HS_NLS_NCHAR = UCS2
#UCS2
# ODBC env variables
set ODBCINI=/etc/odbc.ini
[dbjf-crm-pifda:oracle]:/oracle/app/oracle/product/11.2.0.4/dbhome_1/hs/admin>cat /etc/odbc.ini
[totougu]
# 如上为ODBC的连接标识
Driver = /usr/lib64/libmyodbc5.so
# 指定驱动文件路径
Description = Connect to MySQL DB of TouGu system
# 描述
SERVER = 10.16.244.218
# MySQL服务器IP
PORT = 3306
# MySQL服务器端口
USER = syn
# MySQL数据库用户
PASSWORD = syn
# MySQL数据库密码
DATABASE = robot_portfolio_core
# MySQL数据库的库，注意大小写
OPTION = 0
TRACE = OFF
CHARSET = utf8
STMT = SET NAMES 'utf8'
# 如上两行需要设置为与MySQL数据库字符集相同
export ODBCINI=/etc/odbc.ini
export LD_LIBRARY_PATH=/usr/lib64:/oracle/app/oracle/product/11.2.0.4/dbhome_1/lib
isql totougu -v
[totougu]
Driver = /usr/lib64/libmyodbc5.so
Description = Connect to MySQL DB of TouGu system
SERVER = 10.16.244.218
PORT = 3306
USER = syn
PASSWORD = syn
DATABASE = robot_portfolio_core
OPTION = 0
TRACE = OFF
CHARSET = utf8
STMT = SET NAMES 'utf8'
[root@dbjf-crm-pifda ~]# odbcinst -j
unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
[root@dbjf-crm-pifda ~]#
root@dbjf-crm-pifda ~]# isql totougu -v
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
[root@dbjf-crm-pifda ~]#
[root@dbjf-crm-pifda ~]# isql totougu -v
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> show tables;
+-----------------------------------------------------------------+
| Tables_in_robot_portfolio_core |
+-----------------------------------------------------------------+
| cart_item |
| content |
| customer |
| customer_cart |
| customer_fof |
| fund_dividend |
| fund_dividend_tmp |
| fund_monthly_return |
| fund_performance |
| fund_return |
| fund_split |
| fund_split_tmp |
| fund_value |
| fund_value20190228 |
| fund_value_tmp |
| fund_weekly_return |
| holiday_period |
| index_type |
| portal_role |
| portal_user_role |
| portfolio |
| portfolio_adjustment_history |
| portfolio_detail |
| portfolio_max_drawdown |
| portfolio_monthly_return |
| portfolio_performance |
| portfolio_return |
| portfolio_risk_sequence |
| portfolio_setting |
| portfolio_value |
| portfolio_value20190228 |
| portfolio_weekly_return |
| site |
| site_jwt_key |
| sub_fund |
| sub_fund_attachment |
| sub_fund_class |
| sub_fund_detail |
| sub_fund_detail_tmp |
| sub_fund_estimated_fee_rate |
| sub_fund_open_date |
| sub_fund_site |
| sub_fund_tmp |
| update_log |
| version |
+-----------------------------------------------------------------+
SQLRowCount returns 45
45 rows fetched
SQL>
