Seed Database (pdb$seed) - Read Write OR Read Only Mode in Oracle Database 12c
1. Check the instance and check the pluggable databases.
[oracle@Server ~]$ ps -ef | grep pmon
oracle 3268 1 0 07:40 ? 00:00:00 ora_pmon_cdb1
oracle 4235 4205 0 08:00 pts/1 00:00:00 grep pmon
[oracle@Server ~]$ . oraenv
ORACLE_SID = [oracle] ? cdb1
The Oracle base has been set to /u01/app/oracle
[oracle@Server ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Feb 10 08:00:34 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ -----------------
2 PDB$SEED READ ONLY
3 PDB_AUDIT MOUNTED
2. Perform close instance operation in seed database (pdb$seed)
SQL> alter pluggable database pdb$seed close;
alter pluggable database pdb$seed close
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
3. Set the parameter "_oracle_script" and close the seed database (pdb$seed)
SQL> alter session set "_oracle_script"=TRUE;
Session altered.
SQL> alter pluggable database pdb$seed close immediate instances=all;
Pluggable database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED MOUNTED
3 PDB_AUDIT MOUNTED
4. Open the seed database in Read-Write Mode
SQL> alter pluggable database pdb$seed open read write;
Pluggable database altered.
SQL> select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ WRITE
3 PDB_AUDIT MOUNTED
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB$SEED
SQL> show con_id
CON_ID
------------------------------
2
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
SQL> create tablespace example;
Tablespace created.
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
EXAMPLE
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ----------------- ------------------
2 PDB$SEED READ WRITE NO
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> create pluggable database cdb1_pdb1 admin user user1 identified by oracle;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ----------------- -------------------
2 PDB$SEED READ WRITE NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
SQL> create pluggable database cdb1_pdb2 admin user user1 identified by oracle;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ------------------- ------------------
2 PDB$SEED READ WRITE NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
SQL> alter pluggable database pdb$seed close immediate instances=all;
alter pluggable database pdb$seed close immediate instances=all
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> alter pluggable database pdb$seed close immediate instances=all;
alter pluggable database pdb$seed close immediate instances=all
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set "_oracle_script"=TRUE;
Session altered.
SQL> alter pluggable database pdb$seed close immediate instances=all;
Pluggable database altered.
SQL> show con_name
CON_NAME
------------------------------
PDB$SEED
SQL> show con_id
CON_ID
------------------------------
2
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> sho con_id
CON_ID
------------------------------
1
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ----------------- -------------------
2 PDB$SEED MOUNTED
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
SQL> create pluggable database cdb1_pdb3 admin user user1 identified by oracle;
create pluggable database cdb1_pdb3 admin user user1 identified by oracle
*
ERROR at line 1:
ORA-65036: pluggable database PDB$SEED not open in required mode
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB$SEED
SQL> show con_id
CON_ID
------------------------------
2
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set "_oracle_script"=TRUE;
Session altered.
SQL> alter pluggable database pdb$seed open read only;
Pluggable database altered.
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ------------------ ----------
2 PDB$SEED READ ONLY NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
SQL> create pluggable database cdb1_pdb3 admin user user1 identified by oracle;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ------------------ ----------
2 PDB$SEED READ ONLY NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
6 CDB1_PDB3 MOUNTED
[oracle@Server ~]$ ps -ef | grep pmon
oracle 3268 1 0 07:40 ? 00:00:00 ora_pmon_cdb1
oracle 4235 4205 0 08:00 pts/1 00:00:00 grep pmon
[oracle@Server ~]$ . oraenv
ORACLE_SID = [oracle] ? cdb1
The Oracle base has been set to /u01/app/oracle
[oracle@Server ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Feb 10 08:00:34 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ -----------------
2 PDB$SEED READ ONLY
3 PDB_AUDIT MOUNTED
2. Perform close instance operation in seed database (pdb$seed)
SQL> alter pluggable database pdb$seed close;
alter pluggable database pdb$seed close
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
3. Set the parameter "_oracle_script" and close the seed database (pdb$seed)
SQL> alter session set "_oracle_script"=TRUE;
Session altered.
SQL> alter pluggable database pdb$seed close immediate instances=all;
Pluggable database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED MOUNTED
3 PDB_AUDIT MOUNTED
4. Open the seed database in Read-Write Mode
SQL> alter pluggable database pdb$seed open read write;
Pluggable database altered.
SQL> select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ------------------------------ ----------
2 PDB$SEED READ WRITE
3 PDB_AUDIT MOUNTED
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB$SEED
SQL> show con_id
CON_ID
------------------------------
2
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
SQL> create tablespace example;
Tablespace created.
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
EXAMPLE
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ----------------- ------------------
2 PDB$SEED READ WRITE NO
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> create pluggable database cdb1_pdb1 admin user user1 identified by oracle;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ----------------- -------------------
2 PDB$SEED READ WRITE NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
SQL> create pluggable database cdb1_pdb2 admin user user1 identified by oracle;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ------------------- ------------------
2 PDB$SEED READ WRITE NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
SQL> alter pluggable database pdb$seed close immediate instances=all;
alter pluggable database pdb$seed close immediate instances=all
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> alter pluggable database pdb$seed close immediate instances=all;
alter pluggable database pdb$seed close immediate instances=all
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set "_oracle_script"=TRUE;
Session altered.
SQL> alter pluggable database pdb$seed close immediate instances=all;
Pluggable database altered.
SQL> show con_name
CON_NAME
------------------------------
PDB$SEED
SQL> show con_id
CON_ID
------------------------------
2
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> sho con_id
CON_ID
------------------------------
1
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ----------------- -------------------
2 PDB$SEED MOUNTED
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
SQL> create pluggable database cdb1_pdb3 admin user user1 identified by oracle;
create pluggable database cdb1_pdb3 admin user user1 identified by oracle
*
ERROR at line 1:
ORA-65036: pluggable database PDB$SEED not open in required mode
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDB$SEED
SQL> show con_id
CON_ID
------------------------------
2
SQL> alter pluggable database pdb$seed open read only;
alter pluggable database pdb$seed open read only
*
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered
SQL> alter session set "_oracle_script"=TRUE;
Session altered.
SQL> alter pluggable database pdb$seed open read only;
Pluggable database altered.
SQL> connect sys/oracle@cdb1 as sysdba
Connected.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ------------------ ----------
2 PDB$SEED READ ONLY NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
SQL> create pluggable database cdb1_pdb3 admin user user1 identified by oracle;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ------------------ ----------
2 PDB$SEED READ ONLY NO
3 PDB_AUDIT MOUNTED
4 CDB1_PDB1 MOUNTED
5 CDB1_PDB2 MOUNTED
6 CDB1_PDB3 MOUNTED
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/18903360/viewspace-2132333/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 3.2.3 Opening a Database in Read-Only ModeDatabase
- 【PDB】Oracle 建立pdb說明(create pluggable database)OracleDatabase
- 1.3.2.1.1. 通過種子Seed建立PDB
- Z001-001 從 PDB$SEED 種子容器建立 PDB
- Oracle 12C Database File Mapping for Oracle ASM FilesOracleDatabaseAPPASM
- [20181018]Oracle Database 12c: Data Redaction.txtOracleDatabase
- CSS :read-write 選擇器CSS
- SRAM的Write Assist與Read Assist
- Oracle 11g 新特性:只讀表(Read-only)Oracle
- CSS :read-only 選擇器CSS
- [20200309]expdp 與read only.txt
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Oracle:ORA-01219:database not open:queries allowed on fixed tables/views onlyOracleDatabaseView
- 4.3.2.3 關於PDB$SEED資料檔案的屬性
- MongoDB:Read and write access to data and configuration is unrestricted.MongoDBREST
- Bypass McAfee Application Control--Write&Read ProtectionAPP
- 2.3.1.4 Application SeedAPP
- ORACLE database vaultOracleDatabase
- Oracle clone databaseOracleDatabase
- DG -- READ ONLY模式開啟物理Standby模式
- ORACLE-1Z0-060題庫(Upgrade to Oracle Database 12c)OracleDatabase
- ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- Oracle Database Scheduler整理OracleDatabase
- Oracle Physical Database LimitsOracleDatabaseMIT
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- Oracle:db file scattered readOracle
- oracle ORA-01102: cannot mount database in EXCLUSIVE mode(無法起到獨佔模式)OracleDatabase模式
- 嚐鮮Oracle Database 12c的十二大新特性VKOracleDatabase
- 4.3.2.2 關於CDB Root和PDB$SEED檔案的名稱和位置
- Oracle Database 12c RAC損壞ocr和votedisk恢復實驗OracleDatabase
- Oracle 12c DG備庫啟動報錯standby database requires recoveryOracleDatabaseUI
- [20181009]12C FULL DATABASE CACHING.txtDatabase
- oracle ocp 19c考題,科目082考試題(21)-read-only tableOracle
- idea怎麼修改檔案的file is read-onlyIdea
- 【SEED Labs】DNS Rebinding Attack LabDNS
- PHP artisan db:seed 報錯PHP
- Oracle OCP(35):Database 安裝OracleDatabase
- oracle 10g flashback databaseOracle 10gDatabase
- Oracle DG Standby Database型別OracleDatabase型別