oracle 12c é
ç½®TNSæ¥è®¿é®PDBçæ¹æ³å¦ä¸ï¼
1ãé ç½®çå¬
é¦å è¦æç¡®ï¼ææçPDBé½ä½¿ç¨1个çå¬ï¼é ç½®å¤ä¸ªå®é ä¸å¯å¨æ¶ä¹åªæ第1个ææä¹ã LISTENER = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c_A)(PORT = 1521)) )
)
æ¥ä¸æ¥ä½¿ç¨SID_LIST_LISTENERæ¥è¿è¡éæ注åæå¡ã
SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
(GLOBAL_DBNAME = ora12c) #该æå¡æ¯æé ç½®çcdbä¿¡æ¯ (SID_NAME = ora12c) )
)
2ãtnsnames.oraé ç½®
å¨tnsnamesä¸é ç½®pdbè·CDBï¼å³åæ¥11gçé ç½®å®å ¨ä¸æ ·ãè¿éSERVICE_NAME = pdborcl使ç¨å¾æ¯PDBçååï¼å¯ä»¥å¨v$pdbsä¸æ¥çã
ORA12C = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c_A)(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = ora12c) )
)
3ã为äºä¿é©ï¼æ£æ¥ä¸sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) è¿ä¸å¥æ¯ä¸ºäºä¿è¯ä¼å 使ç¨TNSNAMES解æã
é ç½®å®ï¼å¨PDBå¯å¨çæ åµä¸ï¼å°±å¯ä»¥ç´æ¥è¿æ¥å°PDBäºã
1ãé ç½®çå¬
é¦å è¦æç¡®ï¼ææçPDBé½ä½¿ç¨1个çå¬ï¼é ç½®å¤ä¸ªå®é ä¸å¯å¨æ¶ä¹åªæ第1个ææä¹ã LISTENER = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c_A)(PORT = 1521)) )
)
æ¥ä¸æ¥ä½¿ç¨SID_LIST_LISTENERæ¥è¿è¡éæ注åæå¡ã
SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
(GLOBAL_DBNAME = ora12c) #该æå¡æ¯æé ç½®çcdbä¿¡æ¯ (SID_NAME = ora12c) )
)
2ãtnsnames.oraé ç½®
å¨tnsnamesä¸é ç½®pdbè·CDBï¼å³åæ¥11gçé ç½®å®å ¨ä¸æ ·ãè¿éSERVICE_NAME = pdborcl使ç¨å¾æ¯PDBçååï¼å¯ä»¥å¨v$pdbsä¸æ¥çã
ORA12C = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c_A)(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = ora12c) )
)
3ã为äºä¿é©ï¼æ£æ¥ä¸sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) è¿ä¸å¥æ¯ä¸ºäºä¿è¯ä¼å 使ç¨TNSNAMES解æã
é ç½®å®ï¼å¨PDBå¯å¨çæ åµä¸ï¼å°±å¯ä»¥ç´æ¥è¿æ¥å°PDBäºã
温馨提示：内容为网友见解，仅供参考
第1个回答 2015-02-10
通过配置本地数据库的tns配置文件实现：
去oracle安装目录下oracle\product\10.2.0\db_2\NETWORK\ADMIN\ 找到tnsnames.ora，用记事本打开，里边有远程数据库的tns连接配置串如下
ORCL23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.23)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
添加好ip、端口和目标数据库的实例名(SID)，然后确保tns名称(ORCL23)在整个文档中唯一，保存后打开数据库连接工具，输入远程数据库上的用户名密码，选择数据库对象为你配置的连接名就可以了本回答被提问者和网友采纳
去oracle安装目录下oracle\product\10.2.0\db_2\NETWORK\ADMIN\ 找到tnsnames.ora，用记事本打开，里边有远程数据库的tns连接配置串如下
ORCL23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.23)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
添加好ip、端口和目标数据库的实例名(SID)，然后确保tns名称(ORCL23)在整个文档中唯一，保存后打开数据库连接工具，输入远程数据库上的用户名密码，选择数据库对象为你配置的连接名就可以了本回答被提问者和网友采纳
相似回答
