目前数据库用户:stage/ods/dim/dw/alldm/alldmcode
数据库tns配置:
D:/DevelopmentTools/oracle/product/10.2.0/db_1/NETWORK/ADMIN/tnsnames.ora内容如下:
# tnsnames.ora Network Configuration File: E:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
BCA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ery-67188536bc7)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bca)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ery-67188536bc7)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
BJODS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.77.113.88)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bjods)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
连接语法:conn user/pwd@hostIP/SID
sqlplus stage/1q2w3e@bjods
sqlplus stage/1q2w3e@132.77.113.88/bjods