Oracle Multitenant 3 エラーメッセージ集

随時追加しています。

PDB起動中に切断しようとした
(対策) PDBを停止してから切断する

SQL> alter pluggable database orclpdb2 unplug into '/opt/oracle/oradata/ORCLCDB/orclpdb3/orclpdb3.xml';

alter pluggable database orclpdb2 unplug into '/opt/oracle/oradata/ORCLCDB/orclpdb3/orclpdb3.xml'
 *
ERROR at line 1:
ORA-65025: Pluggable database ORCLPDB2 is not closed on all instances.

SQL> alter pluggable database orclpdb2 close;

Pluggable database altered.


SQL> alter pluggable database orclpdb2 unplug into '/opt/oracle/oradata/ORCLCDB/orclpdb3/orclpdb3.xml';

Pluggable database altered.

切断したPDBにsqlcl接続した
(対策) PDBをプラグして起動する

# sql sys/password@ORCLPDB2 as sysdba

SQLcl: Release 19.1 Production on Mon Dec 07 16:11:35 2020

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

ERROR:
IO Error: Unknown host specified
Username? (RETRYING) ('sys/*********@ORCLPDB2 as sysdba'?)

Dec 07, 2020 4:11:41 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run
SEVERE: oracle.dbtools.raptor.scriptrunner.commands.NLSLANGListener.setLanguage(NLSLANGListener.java:86)
java.lang.NullPointerException
        at oracle.dbtools.raptor.scriptrunner.commands.NLSLANGListener.setLanguage(NLSLANGListener.java:86)
        at oracle.dbtools.raptor.scriptrunner.commands.NLSLANGListener.runOnConnect(NLSLANGListener.java:52)
        at oracle.dbtools.raptor.scriptrunner.commands.NLSLANGListener.endEvent(NLSLANGListener.java:102)
        at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireEndListeners(CommandRegistry.java:471)
        at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:294)
        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:344)
        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:227)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.handleLoginSql(SqlCli.java:911)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:483)

切断中のPDBを起動をかけた
(対策) 再接続してから起動する

SQL> alter pluggable database orclpdb2 open;

alter pluggable database orclpdb2 open
 *
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database

インスタンスを間違えて起動した
(対策) 正しいインスタンス名を指定する

SQL>

SQL> alter pluggable database orclpdb22 open;

alter pluggable database orclpdb22 open
 *
ERROR at line 1:
ORA-65011: Pluggable database ORCLPDB22 does not exist

アプリケーションPDBをCDBか再接続しようした
(対策) アプリケーションシードから実行する

SQL> create pluggable database orclpdb2 using '/opt/oracle/oradata/ORCLCDB/orclpdb3/orclpdb3.xml' nocopy;

create pluggable database orclpdb2 using '/opt/oracle/oradata/ORCLCDB/orclpdb3/orclpdb3.xml' nocopy
 *
ERROR at line 1:
ORA-65240: not connected to an application root

切断済みのPDBに切断コマンドを投げた

SQL> alter pluggable database orclpdb1 unplug into '/opt/oracle/oradata/ORCLCDB/orclpdb1/orclpdb1.xml';
alter pluggable database orclpdb1 unplug into '/opt/oracle/oradata/ORCLCDB/orclpdb1/orclpdb1.xml'
*
ERROR at line 1:
ORA-65265: PDB cannot be dropped or unplugged.

PDB切断時に指定したxmlファイルの拡張子が.xmlなど有効なものではなかった
(対策)拡張子を.xmlなどにする

SQL> alter pluggable database orclpdb1 unplug into '/opt/oracle/oradata/ORCLCDB/orclpdb1/orclpdb1.xml.20200116';
alter pluggable database orclpdb1 unplug into '/opt/oracle/oradata/ORCLCDB/orclpdb1/orclpdb1.xml.20200116'
                                              *
ERROR at line 1:
ORA-65125: valid XML or PDB archive file name is required