SQL>alter pluggable database pdb01 open; Pluggable database altered. SQL>show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED--- --- --- ---2PDB$SEED READ ONLY NO3PDB01 READ WRITE NO SQL> 2.在Oracle用户下的tnsnames.ora文件添加了监听: [oracle@mesdb01 ~]$ cd $ORACLE_HOME/network/admin...
oracle 19C 归档学习 1.查看数据库是否归档 archive log list; select log_mode from v$database;2.关闭归档 shutdown immediate startupmountalterdatabasenoarchivelog; 开启alterdatabasearchivelog;alterdatabaseopen;3.查看归档文件位置、大小 Oracle笔记3 ...
SQL>alter pluggable database pdb01 open; Pluggable database altered. SQL>show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED--- --- --- ---2PDB$SEED READ ONLY NO3PDB01 READ WRITE NO SQL> 2.在Oracle用户下的tnsnames.ora文件添加了监听: [oracle@mesdb01 ~]$ cd $ORACLE_HOME/network/admin...