Nov 18, 2015
573

Oracle Database Free Trial in Oracle Cloud

Oracle is offering Database services in Cloud.  Oracle Cloud provides several Oracle Database offerings. We can choose between a single schema based service, or a virtual machine with a fully configured running Oracle Database Instance, or Exadata Service with all the database features, options, and workloads. You can even try a...
Jul 15, 2013
Online Oracle Database 12c Training
518

Online Oracle Database 12c Training

Please find the course content: Introduction Course Objectives Course Schedule Overview of Oracle Database 12c Overview of Oracle Cloud Exploring the Oracle Database Architecture Oracle Database Architecture: Overview Oracle Database Instance Configurations Connecting to the Oracle Database Instance Oracle Database Memory Structures Process Architecture Process Structures Process Startup Sequence Database...
Jul 04, 2013
1.3K

Oracle RAC 12c Installation on Oracle Virtual Box

Step-by-step Installation of Oracle RAC 12c on Oracle Virtual Box Download Virtual Box Download Oracle Enterprise Linux 5.7 64-bit Download Oracle 12cR1 64-bit Database Software Installation of Oracle Enterprise Linux 5.7 by clicking on the link Linux Post Installation Steps: 1) To be consistent with the rest of the article, the following information should be set during the installation process. #vi /etc/hosts 127.0.0.1 localhost.localdomain localhost # Public 192.168.1.101 rac1.oracle.com rac1 192.168.1.109...
Jul 04, 2013
Upgrade database from 11g to 12c
2.7K

Upgrade database from 11g to 12c

Step by Step Procedure to update Oracle Database 11gR2 to 12cR1 There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below: 1)Database Upgrade Assistant (DBUA) 2)Manual Upgrade 3)Transportable Tablespaces 4)Datapump export/import 5)Oracle Streams 6)Oracle GoldenGate Now,...
Jun 30, 2013
Oracle Database 12c installation on linux
1.1K

Oracle Database 12c installation on linux

Oracle 12c Database installation step by step procedure on Linux: 1) Install OEL 5.7 Linux using the following link Oracle Enterprise Linux 5.7 Installation Here my hostname [root@12cdb ~]# hostname 12cdb.oracle.com 2) create user and group [root@12cdb /]# groupadd dba [root@12cdb /]# useradd -g dba oracle 3) Create required directory structure [root@12cdb /]# mkdir -p /u01/app/oracle/product/12.1.0 4) Copy...
Jun 28, 2013
Oracle Database 12c New Features
599

Oracle Database 12c New Features

Hi Guys, Oracle 12C Database has Released.  You can download it from edelivery.oracle.com. It comes with plug and play concept. Pluggable database: – Oracle provided metadata and data is kept in the container database (CDB). – User metadata and data is kept in the plugable database (PDB) . – One container...
Apr 12, 2013
Create Oracle database in silent mode
566

Create Oracle database in silent mode

How to create Oracle database in silent mode? COMMAND ========= dbca -silent -gdname dbname -sid dbname -responsefile NO_VALUE -createDatabase -templateName General_purpose.dbc -characterset AL32UTF8 -memorypercentage 30 -emconfiguration LOCAL OUTPUT ======= Enter SYSTEM user password: password Enter SYS user password: password Copying database files 1% complete 3% complete
Jan 08, 2013
Oracle Database 12c Architecture
852

Oracle Database 12c Architecture

Oracle Database 12c Multi-Tenant Data Architecture: Shared Database, Separate Schema In this architecture, each tenant has their own set of tables stored in a separate schema. Each database server will only serve up one database. The login credentials used to connect to the database by each user will determine which tenant’s...
Jan 08, 2013
Oracle database 12c be released
550

Oracle database 12c be released

oracle database 12c be released: The next version of Oracle’s database will feature support for multitenancy as a critical feature, providing superior security, control, and efficiency for software services delivered from the cloud, CEO Larry Ellison said Sunday during the OpenWorld conference in San Francisco.  Ellison’s comments Sunday provided the...
Jul 13, 2012
How to change the password of a DB Link in Oracle
2.5K

How to change the password of a DB Link in Oracle

How to change the password of a DB Link in Oracle? Alter Database Link to Change Password Sometimes, when we use alter database link command, it will show below error: SQL> ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY hr; ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY...