This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@rhec2lab1:/home/oracle]$ sqlplus / as sysdba | |
| SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 20 15:04:33 2015 | |
| Copyright (c) 1982, 2014, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production | |
| With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options | |
| SYS@ATLAS> show pdbs | |
| CON_ID CON_NAME OPEN MODE RESTRICTED | |
| ---------- ------------------------------ ---------- ---------- | |
| 2 PDB$SEED READ ONLY NO | |
| 3 PDB MOUNTED | |
| [oracle@rhec2lab1:/u01/app/oracle/product/12.1.0.2/db1/OPatch]$ ./datapatch -verbose | |
| SQL Patching tool version 12.1.0.2.0 on Tue Oct 20 15:04:03 2015 | |
| Copyright (c) 2015, Oracle. All rights reserved. | |
| Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_10849_2015_10_20_15_04_03/sqlpatch_invocation.log | |
| Connecting to database...OK | |
| Note: Datapatch will only apply or rollback SQL fixes for PDBs | |
| that are in an open state, no patches will be applied to closed PDBs. | |
| Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation | |
| (Doc ID 1585822.1) | |
| Bootstrapping registry and package to current versions...done | |
| Determining current state...done | |
| Current state of SQL patches: | |
| Bundle series PSU: | |
| ID 4 in the binary registry and not installed in any PDB | |
| Adding patches to installation queue and performing prereq checks... | |
| Installation queue: | |
| For the following PDBs: CDB$ROOT PDB$SEED | |
| Nothing to roll back | |
| The following patches will be applied: | |
| 20831110 (Database Patch Set Update : 12.1.0.2.4 (20831110)) | |
| Installing patches... | |
| Patch installation complete. Total patches installed: 2 | |
| Validating logfiles... | |
| Patch 20831110 apply (pdb CDB$ROOT): SUCCESS | |
| logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_ATLAS_CDBROOT_2015Oct20_15_04_22.log (no errors) | |
| Patch 20831110 apply (pdb PDB$SEED): SUCCESS | |
| logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_ATLAS_PDBSEED_2015Oct20_15_04_25.log (no errors) | |
| SQL Patching tool complete on Tue Oct 20 15:04:27 2015 | |
| [oracle@rhec2lab1:/home/oracle]$ sqlplus / as sysdba | |
| SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 20 15:04:33 2015 | |
| Copyright (c) 1982, 2014, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production | |
| With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options | |
| SYS@ATLAS> alter pluggable database pdb open; | |
| Warning: PDB altered with errors. | |
| SYS@ATLAS> show pdbs | |
| CON_ID CON_NAME OPEN MODE RESTRICTED | |
| ---------- ------------------------------ ---------- ---------- | |
| 2 PDB$SEED READ ONLY NO | |
| 3 PDB READ WRITE | |
| [oracle@rhec2lab1:/u01/app/oracle/diag/rdbms/atlas/ATLAS/trace]$ tail -n 14 alert_ATLAS.log | |
| Tue Oct 20 15:04:49 2015 | |
| alter pluggable database open | |
| ORA-65000 signalled during: alter pluggable database open... | |
| alter pluggable database pdb open | |
| Tue Oct 20 15:05:06 2015 | |
| Database Characterset for PDB is WE8MSWIN1252 | |
| *************************************************************** | |
| WARNING: Pluggable Database PDB with pdb id - 3 is | |
| altered with errors or warnings. Please look into | |
| PDB_PLUG_IN_VIOLATIONS view for more details. | |
| *************************************************************** | |
| Opening pdb PDB (3) with no Resource Manager plan active | |
| Pluggable database PDB opened read write | |
| Completed: alter pluggable database pdb open | |
| [oracle@rhec2lab1:/home/oracle]$ sqlplus / as sysdba | |
| SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 20 15:04:33 2015 | |
| Copyright (c) 1982, 2014, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production | |
| With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options | |
| SYS@ATLAS> col cause for a10 | |
| SYS@ATLAS> col name for a10 | |
| SYS@ATLAS> col message for a35 word_wrapped | |
| SYS@ATLAS> select name, cause, type, message, status | |
| 2 from PDB_PLUG_IN_VIOLATIONS | |
| 3 where name = 'PDB' and type = 'ERROR'; | |
| NAME CAUSE TYPE MESSAGE STATUS | |
| ---------- ---------- --------- ----------------------------------- --------- | |
| PDB SQL Patch ERROR PSU bundle patch 4 (Database Patch PENDING | |
| Set Update : 12.1.0.2.4 | |
| (20831110)): Installed in the CDB | |
| but not in the PDB. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@rhec2lab1:/u01/app/oracle/product/12.1.0.2/db1/OPatch]$ ./datapatch -verbose | |
| SQL Patching tool version 12.1.0.2.0 on Tue Oct 20 16:00:27 2015 | |
| Copyright (c) 2015, Oracle. All rights reserved. | |
| Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_13061_2015_10_20_16_00_27/sqlpatch_invocation.log | |
| Connecting to database...OK | |
| Note: Datapatch will only apply or rollback SQL fixes for PDBs | |
| that are in an open state, no patches will be applied to closed PDBs. | |
| Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation | |
| (Doc ID 1585822.1) | |
| Bootstrapping registry and package to current versions...done | |
| Determining current state...done | |
| Current state of SQL patches: | |
| Bundle series PSU: | |
| ID 4 in the binary registry and ID 4 in PDB CDB$ROOT, ID 4 in PDB PDB$SEED | |
| Adding patches to installation queue and performing prereq checks... | |
| Installation queue: | |
| For the following PDBs: CDB$ROOT PDB$SEED | |
| Nothing to roll back | |
| Nothing to apply | |
| For the following PDBs: PDB | |
| Nothing to roll back | |
| The following patches will be applied: | |
| 20831110 (Database Patch Set Update : 12.1.0.2.4 (20831110)) | |
| Installing patches... | |
| Patch installation complete. Total patches installed: 1 | |
| Validating logfiles... | |
| Patch 20831110 apply (pdb PDB): SUCCESS | |
| logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_ATLAS_PDB_2015Oct20_16_00_45.log (no errors) | |
| SQL Patching tool complete on Tue Oct 20 16:00:46 2015 | |
| Pluggable database altered. | |
| [oracle@rhec2lab1:/home/oracle]$ sqlplus / as sysdba | |
| SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 20 16:01:54 2015 | |
| Copyright (c) 1982, 2014, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production | |
| With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options | |
| SYS@ATLAS> col cause for a10 | |
| SYS@ATLAS> col name for a10 | |
| SYS@ATLAS> col message for a35 word_wrapped | |
| SYS@ATLAS> select name, cause, type, message, status | |
| 2 from PDB_PLUG_IN_VIOLATIONS | |
| 3 where name = 'PDB' and type = 'ERROR'; | |
| NAME CAUSE TYPE MESSAGE STATUS | |
| ---------- ---------- --------- ----------------------------------- --------- | |
| PDB SQL Patch ERROR PSU bundle patch 4 (Database Patch PENDING | |
| Set Update : 12.1.0.2.4 | |
| (20831110)): Installed in the CDB | |
| but not in the PDB. | |
| SYS@ATLAS> alter pluggable database pdb close; | |
| Pluggable database altered. | |
| SYS@ATLAS> alter pluggable database pdb open; | |
| Pluggable database altered. | |
| SYS@ATLAS> col cause for a10 | |
| SYS@ATLAS> col name for a10 | |
| SYS@ATLAS> col message for a35 word_wrapped | |
| SYS@ATLAS> select name, cause, type, message, status | |
| 2 from PDB_PLUG_IN_VIOLATIONS | |
| 3 where name = 'PDB' and type = 'ERROR'; | |
| NAME CAUSE TYPE MESSAGE STATUS | |
| ---------- ---------- --------- ----------------------------------- --------- | |
| PDB SQL Patch ERROR PSU bundle patch 4 (Database Patch RESOLVED | |
| Set Update : 12.1.0.2.4 | |
| (20831110)): Installed in the CDB | |
| but not in the PDB. |
No comments:
Post a Comment