主页 / dba / 问题 / 95149
Accepted
artificer
Asked: 2015-03-13 21:55:13 +0800 CST

使用服务名连接到 Oracle Pluggable 数据库

  • 772

我使用所有默认设置在 Windows 上安装了 Oracle 12c，但选择使用可插入数据库并安装示例数据。容器数据库和 SID 名称为 ORCL，可插拔数据库为 PDBORCL。

我注意到使用 SQL Developer 我可以通过使用它的名称作为服务名称来连接到可插拔数据库。我也可以使用它的名称作为 SID 或服务名称连接到容器数据库。

查看我的 tnsnames.ora，我发现只有 ORCL 作为服务名称被提及。oracle 是否自动将可插拔数据库注册为服务名称，或者我缺少配置文件？

oracle

2 个回答

  1. Best Answer

    它会自动注册它们。

    非常容易测试...

    侦听器状态显示没有 PDB：

    $ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 13-MAR-2015 09:41:15

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                04-MAR-2015 15:03:10
Uptime                    8 days 18 hr. 38 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0.2/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "CDB1" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
Service "CDB1XDB" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
Service "UPGR" has 1 instance(s).
  Instance "UPGR", status READY, has 1 handler(s) for this service...
Service "UPGRXDB" has 1 instance(s).
  Instance "UPGR", status READY, has 1 handler(s) for this service...
The command completed successfully
[CDB1] oracle@localhost:/u01/app/oracle/product/11.2.0
$ echo $ORACLE_SID
CDB1
[CDB1] oracle@localhost:/u01/app/oracle/product/11.2.0

    创建一个新的 PDB：

    $ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Fri Mar 13 09:41:27 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

create pluggable database pdb_phil
admin user phil identified by phil
  3  file_name_convert = ('/pdbseed/', '/pdb_phil/');

Pluggable database created.

SQL> col name for a20
SQL> col open_mode for a10
SQL> select con_id, dbid, name, open_mode from v$pdbs;

    CON_ID       DBID NAME                 OPEN_MODE
---------- ---------- -------------------- ----------
         2 4096360259 PDB$SEED             READ ONLY
         3 3580684491 PDB_PHIL             MOUNTED

SQL> quit

    它现在已向侦听器注册：

    $ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 13-MAR-2015 09:44:06

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                04-MAR-2015 15:03:10
Uptime                    8 days 18 hr. 40 min. 57 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0.2/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "CDB1" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
Service "CDB1XDB" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
Service "UPGR" has 1 instance(s).
  Instance "UPGR", status READY, has 1 handler(s) for this service...
Service "UPGRXDB" has 1 instance(s).
  Instance "UPGR", status READY, has 1 handler(s) for this service...
Service "pdb_phil" has 1 instance(s).
  Instance "CDB1", status READY, has 1 handler(s) for this service...
The command completed successfully
[CDB1] oracle@localhost:/u01/app/oracle/product/11.2.0
$
    • 2

  2. 您必须将服务名称添加到 tnsnames.ora 文件中。这是我添加 pdborcl 的 tnsfile。

    # tnsnames.ora Network Configuration File: C:\app\pc\product\12.1.0\dbhome_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

pdbORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdborcl)
    )
  )
    • 0

相关问题