Oracle 12cè¿æ¥PDBæ¶ï¼listeneråtnsnames.oraé ç½®
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)
)
(SID_DESC =
(GLOBAL_DBNAME = pdborcl)#该æå¡æ¯æé ç½®çpdbä¿¡æ¯
(SID_NAME = ora12c)
)
)
ADR_BASE_LISTENER= /opt/oracle
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)
)
)
pdborcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =ora12c_A)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdborcl)
)
)
3ã为äºä¿é©ï¼æ£æ¥ä¸sqlnet.ora
NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)
è¿ä¸å¥æ¯ä¸ºäºä¿è¯ä¼å 使ç¨TNSNAMES解æã
é ç½®å®ï¼å¨PDBå¯å¨çæ åµä¸ï¼æä¹å¯å¨è¿éä¸å¤è®²äºï¼ï¼å°±å¯ä»¥ç´æ¥è¿æ¥å°PDBäºãï¼Oracle12cæ¯æ²¡æscottç¨æ·çï¼æèªå·±å¨PDBä¸é¢æ°å»ºçï¼ã