Tagged: Oracle database

Oracle VM

ORACLE: OVMM 3.4.2

Oracle VM Manager 3.4.2 supports current and previous Oracle VM Server releases. You can use Oracle VM Manager 3.4.2 to manage Oracle VM Server Release 3.4.x, 3.3.x, 3.2.10, or 3.2.11. If Oracle VM environment consists of Oracle VM Manager Release 3.4.2 and one or more instances of Oracle VM Server at a different release, you should review the list of supported and unsupported operations and features, as follows: Supported Operations Oracle VM supports most common operations when using Oracle VM Manager to manage an instance of Oracle VM Server that is at an earlier release, for example, creating virtual machines...

Oracle Database

ORACLE: UTL_MAIL

The UTL_MAIL database package is used to manage email. It allows you to send an email message directly from the database server, with cc and bcc, and also catering for RAW attachments. This package is not installed by default due to obvious security reasons, but needs to be installed manually via two scripts: utlmain.sql and prvtmail.plb, both of which are in the rdbms/admin directory under the Oracle Home. sqlplus / as sysdba SQL> @?/rdbms/admin/utlmail.sql SQL> @?/rdbms/admin/prvtmail.plb However, in the case of an Oracle 12c Database, it is not enough to run these scripts in the root container. You need to...

Oracle Database

Oracle 12C – Password File in ASM

Prior to Oracle Database 12c, the password file was always located under $ORACLE_HOME/dbs file structure, even for RAC instances and for RAC ASM cluster. For RAC the DBA had to managed to keep the password file in sync on each node. Now , in Oracle 12c, it is possible to store the password file on ASM. This means a shared password file for Oracle RAC databases , it is shared for all instances in the cluster. The command utility to create the password file is still the same: “orapwd” Oracle 11g file – name of password file (required), password –...

Oracle Database / Oracle Database 12 c

Oracle12C : Database Firewall

The Oracle Database Firewall enables organizations to protect their databases from internal and external attacks. Oracle Database Firewall allows unauthorised SQL traffic on the network to be monitored and blocked before reaching the database. Database Firewall for Security and Compliance Oracle Database Firewall monitors and enforces normal application behavior in order to avoid the increasingly sophisticated Data Centre attacks that can lead to unauthorised external access. The security control of Oracle Database Firewall helps to prevent malicious activity such as SQL injection and application bypass from reaching the database. Next-Generation Network-based Database Security The grammar of the SQL statements being...

Oracle Database / Oracle Database 12 c

ORACLE 12C: Data Migration Assistant

The Database Migration Assistant for Unicode (DMU) provides a good solution for migrating databases from legacy character sets to the Unicode character set. It is shipping with Oracle Database 12c Rel.1 and becomes the officially supported method for migration to the Unicode character set. Database Character Set Scanner (CSSCAN) and CSALTER utilities are removed from the database installation and have been desupported. DMU also supports migrating selected prior database releases of 10.2, 11.1 and 11.2. Oracle DMU 2.1, released in May 2015, supports a near-zero downtime migration model in conjunction with the Oracle GoldenGate replication technology. Using DMU2.1 and GoldenGate...

Oracle Database

Oracle: DBMS_COMPARISON package

An interesting feature for Oracle 11g is DBMS_COMPARISON package which planned to use compare data within two schemas or between database`s schema. To use DBMS_COMPARISON you have to grant. If you connected as SYSDBA you already have had grant to execute. Other users need execute grants on DBMS_COMPARISON and that user will need to be granted execute catalog role too. Note: The database character sets must be the same for the databases that contain the database objects being compared. For all scan modes to be supported by the DBMS_COMPARISON package, the database objects must have one of the following types...

Oracle Database

ORACLE: UTL_MAIL

The UTL_MAIL database package is used to manage email. It allows you to send an email message directly from the database server, with cc and bcc, and also catering for RAW attachments. This package is not installed by default due to obvious security reasons, but needs to be installed manually via two scripts: utlmain.sql and prvtmail.plb, both of which are in the rdbms/admin directory under the Oracle Home. sqlplus / as sysdba SQL> @?/rdbms/admin/utlmail.sql SQL> @?/rdbms/admin/prvtmail.plb However, in the case of an Oracle 12c Database, it is not enough to run these scripts in the root container. You need to...

Oracle Database

Global Temporary Table

Global Temporary Table (GTT): Data base version: Oracle Database 11g Environment: DWH This kind of table defines a temporary table for the current connection, these tables do not reside in the system catalogues and are not persistent. Temporary tables exist only during the connection that declared them and cannot be referenced outside of that connection. When the connection closes, the table rows are deleted, and the table is dropped. Temporary tables are useful when: The table structure is not known before using an application Data in the temporary table is needed while using the application The table can be declared...

Oracle Database / Oracle Database 12 c

ORACLE 12C : Extended Data Type

With the previous Oracle database release, long characters strings of more then 4000 bytes had to be handled using CLOB or LONG data types. Starting from Oracle 12c was introduced a new system parameter: MAX_STRING_SIZE. This parameter allows string data types to be much larger when the parameter is changed from its default value STANDARD to EXTENDED. New higher limits (in bytes) are available for following types: – VARCHAR2 – 32767 bytes – NVARCHAR – 32767 bytes – RAW – 32767 bytes To use extended version you need to set new initialization parameter MAX_STRING_SIZE and run sql script utl32k.sql. Set...

Oracle Database

11gR2 RAC installation and the ORA-15014 error

In 11gr2, we now have to place the Voting Disk and Cluster Registry files on ASM disks and we do not have the option of placing them on OCFS or raw devices as in the case of previous versions. When you run the root.sh script as part of the 11gR2 RAC installation, it will create an ASM disk group CDATA and will place the OCR and Voting disk files on this ASM disk. We provide an ASM disk discovery string where the raw devices exist on which the ASM disk groups will be built. Initially we had provided the ASM...