//
archives

Oracle Database

This category contains 0 posts

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options This issue happened when I was trying to backup the archive log file on an Oracle RAC database Solutions The cause of the issue is because the NFS volume hasn’t been mounted correctly. umount the /backup01 on both … Continue reading

Oracle 11g R2 RAC on Oracle Enterprise Linux 5.11 with Virtual Box – Section 2 Install OEL 5.11

Install Oracle Enterprise Linux 5 upgrade 11 Insert the Oracle Enterprise Linux 5u11 iso into the virtual machine and powerup the virtual machine. Select the language English(English) and click Next Ignore the warning message by select Yes, click Next Select Create custom layout. and click Next Select the partition /dev/sda, Add Partition. Create a swap … Continue reading

ORA-01102 – cannot mount database in EXCLUSIVE mode

Set up an Oracle Database on ODA today for testing, but got an error as below Well, login to sqlplus to start it manually. Ennnnnn, back to node1 testodadb01, the instance 1 startup successfully After I read the trace file, I realized that the database is not in cluster mode: Okey Dokey, let’s fix it.

Oracle Streams – Section2

Oracle Streams – Section2 The basic capture process If the data is modified in the ORACLE database, it will be record into the redolog, so that when an error occurs, to have a way of correction. The Capture process as a background process oracle redolog has the ability to read, so it also has the … Continue reading

Oracle streams – Section1

Oracle Stream – Section1 Oracle Streams Overview Oracle Streams provides a way of sharing information, different from other data sharing mode, Streams even allows data transfer between different types of databases. Oracle Streams to achieve this by its replication process – capturing, transmission and applying. These three steps to transfer the specified information to the … Continue reading

Oracle Database Appliance (X5-2) Study (Virtualized Platform deployment) section 6

**This article is only for the purpose of demonstrating of my study of the Oracle Database appliance, not for any other purposes.** Create a guest vm in Oracle ODA Download the Oracle Linux vm template from Oracle Website, transfer the vm template to the Dom0 Import a vm template (From ODA_BASE) Create a shared repository … Continue reading

Configure Oracle Streams BI-Directional (11gR2)

Configure Oracle Streams BI-Directional (11gR2) Configure the Oracle database listeners and tnsnames.ora for both main database(source database) and target database Some database instance parameters need to be checked on main database(source database) Some database instance parameters need to be checked on target database In main database server(source database server) – testdb01.newzonetech.com, modify the $ORACLE_HOME/network/admin/listener.ora In … Continue reading

Oracle Database Appliance (X5-2) Study (Virtualized Platform deployment) section 5

**This article is only for the purpose of demonstrating of my study of the Oracle Database appliance, not for any other purposes.** Oracle Database Appliance (X5-2) Deployment (Virtualized Platform) section 5 – Add additional VLAN In the Oracle Database Appliance virtualized deployment, we can add additional vlan. After read the doc oda-vp-vlan-2418821.pdf, DBAs and Network … Continue reading

Oracle Database Appliance (X5-2) Study (Virtualized Platform deployment) section 4

**This article is only for the purpose of demonstrating of my study of the Oracle Database appliance, not for any other purposes.** Oracle Database Appliance (X5-2) Deployment (Virtualized Platform) section 4 In Oracle Database Appliance, you can just create database by using the command oakcli create database, but Is there any other ways to create … Continue reading

Oracle SQL Plan Baseline

Oracle Database SQL Plan Baseline (11g) First, the basic concept Oracle 11g began to provide a new method of fixed operating plan that is SQL plan baseline; it can be summarized in the following two: Provide stable operation plan to the SQL Statement. Prevent the operating environment or object statistics and other factors change have … Continue reading