Oracle PDB Client Connectivity | Oracle Multi-Tenant Architecture

preview_player
Показать описание
The #multitenant option introduced in #Oracle Database 12c allows a single container #database (CDB) to host multiple separate pluggable databases (PDB). This Video describes how to connect to container databases (#CDB) and pluggable databases (#PDB).

00:00 Connect to specific PDB
01:00 Create TNS entries
04:20 Switch between containers

Рекомендации по теме
Комментарии
Автор

Is there any other way to connect without opening it first time at service(OracleServiceORCL) startup in window 10.

RakeshKumar-lgvp
Автор

Hi, this is a very nice video. One question: could you please tell me why my listener.ora file is different? and when I add another tns entry for new pluggable db like you that doesn't work.

# listener.ora Network Configuration File:
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mydb.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = orclmydb.com)
(ORACLE_HOME =
(SID_NAME = dbtest)
)

mdhumayunkabir