eMarcel.com

Oracle Database, Fusion Middleware, Linux

Oracle Database

Installing Oracle Database 12c R1 on Linux 6 with ASM

In previous article we covered operating system installation: Installing Oracle Linux 6 and preparing for Oracle Software installations. It is a prerequisite for this tutorial. In this tutorial we will use this OS as a seed for our Oracle Database 12c installation. Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage database […]

, , , , , , , , ,

Data Masking with Oracle Enterprise Manager 12c Cloud Control

Data Masking in Oracle Enterprise Manager 12c Cloud Control This tutorial shows you how to identify sensitive data, create Application Data Model, select appropriate mask formats for the sensitive fields, and apply the mask. First of all I would like to mention that I don’t want to reinvent the wheel. We will use Oracle 11g/10g […]

, , , , , , , ,

Installing Oracle Database 11g R2 on Linux with ASM

In this guide we are going to cover Oracle Database 11g R2 installation on Linux with ASM. Automatic Storage Management (ASM) is a feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles, logfiles and backups. ASM will be used as the file system and volume manager for Oracle […]

, , , , , , , , , , , , , , ,

Installing Oracle Database 11g R2 on Linux

In article Installing Oracle Linux in VMware virtual machine we covered installation of Oracle Linux 5U8 including oracle-validated package. Now, our system is ready for Oracle database installation, and no additional configuration tasks is required at this moment. Note: Most of the time we work with OS from remote locations and target servers are located […]

, , , , , , , ,

DBMS_STATS in an Oracle Database

DBMS_STATS in an Oracle Database Using DBMS_STATS package to gather Oracle dictionary statistics. 1. To gather table statistics with DBMS_STATS SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(ownname =>’HR’, tabname =>’EMP’) 2. To gather table statistics with DBMS_STATS with estimate percent SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(ownname => ‘HR’, tabname => ‘EMP’, estimate_percent =>50); SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(‘HR’, estimate_percent =>50); 3. To gather a […]

, ,

Creating an online Phone Book with Oracle Database and SQLDeveloper

This tutorial shows how to create an Online Phone Book with search feature using Oracle Database and SQLDeveloper. What’s needed? Oracle Database Oracle SQLDeveloper A data set – names and phone numbers. Let’s roll… 1.    First let’s prepare our data set in excel sheet. Create a dump of your phone book into an excel sheet; […]

, ,

Orcle APEX Manage HTTP remote access

Manage HTTP Access in Application Express 3.0 After default installation of Oracle APEX 3.0, remote users are not allowed to access Database home page (APEX console) http://127.0.0.1:8080/apex http://localhost:8080/apex http://hostname.com:8080/apex (not allowed by default from a remote location) This is because the listener local access setting is being set to local only by default. To set […]

, ,

Problem when creating the SQL Profile

Scenario: UserX tries to run SQL Tuning Advisor on a long running SELECT query in the database. The SQL Tuning Advisor has came up with the tuning recomendation and UserX attempts to apply it. An ERROR message has been thrown in OEM Grid Control 10g There was a problem creating the SQL Profile ORA-13605: The […]

How to uninstall Oracle Database 11g

Oracle Installer 11g doesn’t provide “uninstall database” option… In order to uninstall Oracle Database 11g go to “deinstall” directory in $ORACLE_HOME: echo $ORCALE_HOME /u01/app/oracle/product/11.2.0 cd $ORACLE_HOME/deinstall #run deinstall script (none a graphical): sh deinstall   Follow the script answering to few questions and uninstall product. NOTE: This also applies to other oracle 11g products like […]

,

Passwords in Oracle Database

Fact sheet about Oracle database passwords Oracle Password Algorithm (7-10g Rel.2) (Designed by Bob Baldwin) Up to 30 characters long. All characters will be converted to uppercase before the hashing starts 8-byte hash, encrypted with a DES encryption algorithm without real salt (just the username). The algorithm can be found in the book “Special Ops […]

Next posts

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close