测试pdb名称是否可以和cdb相同，结论是NO-白红宇

测试pdb名称是否可以和cdb相同，结论是NO

阅读量：2042 次

发布时间：2019-04-28

本文共 9411 字，大约阅读时间需要 31 分钟。

SQL>

SQL> show parameter name;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cdb_cluster_name string

cell_offloadgroup_name string

db_file_name_convert string +DATA, +DATA

db_name string orcl

db_unique_name string orcl

global_names boolean FALSE

instance_name string orcl1

lock_name_space string

log_file_name_convert string +DATA, +DATA

pdb_file_name_convert string

processor_group_name string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string orcl

SQL> show parameter pdbs;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

autotask_max_active_pdbs integer 2

enabled_PDBs_on_standby string *

max_pdbs integer 254

target_pdbs integer 9

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 JYC READ WRITE NO

SQL> alter session set container=pdb;

Session altered.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

3 PDB READ WRITE NO

SQL> alter pluggable database pdb close instances=all;

Pluggable database altered.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

3 PDB MOUNTED

SQL> startup open restrict

Pluggable Database opened.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

3 PDB READ WRITE YES

SQL> show parameter name;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cdb_cluster_name string

cell_offloadgroup_name string

db_file_name_convert string +DATA, +DATA

db_name string orcl

db_unique_name string orcl

global_names boolean FALSE

instance_name string orcl1

lock_name_space string

log_file_name_convert string +DATA, +DATA

pdb_file_name_convert string

processor_group_name string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string orcl

SQL> alter pluggable database pdb rename global_name to orcl;

alter pluggable database pdb rename global_name to orcl

ERROR at line 1:

ORA-65042: name is already used by an existing container

SQL> select * from global_name;

select * from global_name

ERROR at line 1:

ORA-01219: database or pluggable database not open: queries allowed on fixed

tables or views only

SQL> conn /as sysdba

Connected.

SQL> select * from global_name;

GLOBAL_NAME

--------------------------------------------------------------------------------

ORCL

SQL> alter database rename global_name to orclcdb;

Database altered.

SQL> show parameter name;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cdb_cluster_name string

cell_offloadgroup_name string

db_file_name_convert string +DATA, +DATA

db_name string orcl

db_unique_name string orcl

global_names boolean FALSE

instance_name string orcl1

lock_name_space string

log_file_name_convert string +DATA, +DATA

pdb_file_name_convert string

processor_group_name string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string orcl

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.8.0.0.0

[oracle@rac1 ~]$ srvctl stop database -d orcl

[oracle@rac1 ~]$ srvctl start database -d orcl

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 12 16:16:32 2020

Version 19.8.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.8.0.0.0

SQL> show parameter name;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cdb_cluster_name string

cell_offloadgroup_name string

db_file_name_convert string +DATA, +DATA

db_name string orcl

db_unique_name string orcl

global_names boolean FALSE

instance_name string orcl1

lock_name_space string

log_file_name_convert string +DATA, +DATA

pdb_file_name_convert string

processor_group_name string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string orcl

SQL> select * from global_name;

GLOBAL_NAME

--------------------------------------------------------------------------------

ORCLCDB

SQL> !lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-AUG-2020 16:17:17

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 12-AUG-2020 15:45:18

Uptime 0 days 0 hr. 31 min. 59 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/app/19c/grid/network/admin/listener.ora

Listener Log File /oracle/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.52.181)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.52.183)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "+ASM_DATA" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "orcl" has 1 instance(s).

Instance "orcl1", status UNKNOWN, has 1 handler(s) for this service...

Service "orcl_DGMGRL" has 1 instance(s).

Instance "orcl1", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 JYC READ WRITE NO

SQL> alter pluggable database pdb close instances=all;

Pluggable database altered.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB MOUNTED

4 JYC READ WRITE NO

SQL> alter session set container=pdb;

Session altered.

SQL> startup open restrict

Pluggable Database opened.

SQL> show parameter global;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

allow_global_dblinks boolean FALSE

global_names boolean FALSE

global_txn_processes integer 1

SQL> show parameter name;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cdb_cluster_name string

cell_offloadgroup_name string

db_file_name_convert string +DATA, +DATA

db_name string orcl

db_unique_name string orcl

global_names boolean FALSE

instance_name string orcl1

lock_name_space string

log_file_name_convert string +DATA, +DATA

pdb_file_name_convert string

processor_group_name string

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string orcl

SQL> alter pluggable database pdb rename global_name to orcl;

alter pluggable database pdb rename global_name to orcl

ERROR at line 1:

ORA-65149: PDB name conflicts with existing service name in the CDB or the PDB

SQL> select service_id,name,network_name,creation_date,pdb,con_id from cdb_services;

select service_id,name,network_name,creation_date,pdb,con_id from cdb_services

ERROR at line 1:

ORA-01219: database or pluggable database not open: queries allowed on fixed

tables or views only

SQL> conn /as sysdba

Connected.

SQL> set line 160

SQL> set wrap off

SQL> select service_id,name,network_name,creation_date,pdb,con_id from cdb_services

SERVICE_ID NAME NETWORK_NAME

---------- ---------------------------------------------------------------- ------------------------------------------------------------------------------------

1 SYS$BACKGROUND

2 SYS$USERS

3 orcl_CFG orcl_CFG

4 dgorcl dgorcl

5 orclXDB orclXDB

6 orcl orcl

10 JYC JYC

7 rows selected.

SQL> col name for a20

SQL> select service_id,name,network_name,creation_date,pdb,con_id from cdb_services

SERVICE_ID NAME NETWORK_NAME

---------- -------------------- --------------------------------------------------------------------------------------------------------------------------------

1 SYS$BACKGROUND

2 SYS$USERS

3 orcl_CFG orcl_CFG

4 dgorcl dgorcl

5 orclXDB orclXDB

6 orcl orcl

10 JYC JYC

7 rows selected.

SQL> col network_name for a20

SQL> col pdb for a20

SQL> select service_id,name,network_name,creation_date,pdb,con_id from cdb_services

SERVICE_ID NAME NETWORK_NAME CREATION_DATE PDB CON_ID