#oracle 12c

How to set Oracle Pluggable Database Automatic startup and Discard the pdbs saved state

As you know the pluggable database concept introduce in oracle 12c and when we startup the CDB database the PDBs (Pluggable Database) will be mount stage. So that time we need to open PDBs manually using alter command. Here we are going to learn how to Oracle Pluggable Database Automatic startup step by step. To make the PDBs open automatically we need to use the saved state option and that…

Log.xml files in diagnostic destination fill up the space of alert log

Log.xml files in diagnostic destination fill up the space of alert log

In Oracle 12c, the log files is automatically created for 10 MB size as file size reached to 10 MB then it create new file for log. It is used by ADRCI utility. The size is increasing of alert and log.xml file in Oracle 12c is usally. It provide patching information and parameters information. If you donot want to log the extra…

ORA-28040: No matching authentication protocol error

ORA-28040: No matching authentication protocol error

SQLNET parameters ALLOWED_LOGON_VERSION_CLIENT & ALLOWED_LOGON_VERSION_SERVER issue in Oracle 12c. Set the value to the minimum authentication protocol allowed while making connection to Oracle Database instances.

Note: Version refer to the authentication protocol its not mean that oracle release version.

Error: Caused by:…

Update Multiple PDBs in a Single DML Statement

Update Multiple PDBs in a Single DML Statement of Application container

With DML Query you can also update the multiple PDBs if having same tables and columns or same database.

Example: Set the country_name column to the value USA in the sh.sales table. This table exists in two separate PDBs, with container IDs of 7 and 8. Both PDBs are in the application container named sales_ac. You can connect…

Execute SQL script in all PDBs database Oracle

Execute SQL script in all PDBs database Oracle 12c

In a CDB Environment, the catcon.pl utility is used to run SQL scripts and SQL statements in all PDBS database provide by Oracle.

catcon.pl script can run from the root container and in specified PDBs and it also have option for log files that you can view to confirm that the SQL script or SQL statement did run successfully.

Syntax for Catcon…

Renaming and Relocating Online Data Files in Oracle 12c

Renaming and Relocating Online Data Files in Oracle 12c

In Oracle 12c, New feature is given from moving the datafiles from one location to another without downtime of the environment. It increase the great flexibility of the Oracle Database moving datafiles to one location to other without downtime like move datafiles which is less needed to low cost storage or Move datafile to ASM Storage online…

Esta semana estuve en conversación con unos viejos amigos de Oracle, donde estuvimos hablando acerca de licenciamiento y soporte de diferentes versiones.

Aun nos encontramos con varios clientes no se han decidido migrar a las nuevas versiones desde 11gR2 e inclusive 10gR2 con el simple comentario o visión de que todo esta funcionando.

Otros tantos me expresaron la idea que no tienen quien los…