Archive for the ‘Oracle RAC’ Tag

Why can’t I connect to my pluggable database?   Leave a comment

This afternoon one of my colleagues was having trouble connecting his database. He got the following error when he

tried to connect the application to the database:

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

He logged to the database server host and found that the database instance was up and he was able to connect to the database instance :

SQL> connect system/password
Connected.

But when he tried to connect to the application user  in a PDB:

[oracle@inmem2 ~]$ sqlplus  user1/user1pwd@app1_pdb

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 15 16:48:13 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Here is the troubleshooting part that I did:

check if the PDB is up:

sqlplus  / as sysdba

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> select NAME, OPEN_MODE FROM V$PDBS;

NAME                           OPEN_MODE
—————————— ———-
PDB$SEED                       READ ONLY
APP1_PDB                      MOUNTED

So the APP1_PDB is only mounted not open although the instance is up and the container CDB is open.

So we need to open the PDB:

SQL> alter PLUGGABLE  DATABASE APP1_PDB open;

Pluggable database altered.

check the PDB open status:

SQL> select NAME, OPEN_MODE FROM V$PDBS;

NAME                           OPEN_MODE
—————————— ———-
PDB$SEED                       READ ONLY
APP1_PDB                      READ WRITE

Then he was able to login to the PDB:

SQL> connect user1/user1pwd@app1_pdb
Connected.

For more details about how to manage pluggable database, especially in Oracle RAC environment, check my presentation at Collaborate 14:

Oracle RAC 12c Flex Architecture and RAC support for Multitenant Architecture, May 27, 2014

https://kyuoracleblog.files.wordpress.com/2014/05/achieving-availability-and-scalability-with-oracle-12c-flex-clusters-and-flex-asm.pdf

and even more details on Apress Book “Expert Oracle RAC 12c ” Chapter 4 :New Features in RAC 12c which I co-authored.

Advertisements

My Collaborate 11 Conference preseations are loaded.   Leave a comment

I just uploaded three of my Collaborate 11 conference presentations. You can see these presentation pdf by clicking the following links:

1. Oracle E-Business Suite: Migration to Oracle VM & template based deployment, OAUG Collaborate 11 conference presentation.

2. Automated Provisioning Oracle 11g R2 RAC using Oracle Enterprise Manager 11g  Provisioning Pack, IOUG Collaborate 11 conference presentation

3. Ensure the RAC High Availability: Storage and Network Side Story, IOUG Collaborate 11 conference presentation.

My presentation schedule on Oracle Fusion Architecture – Soup to Nuts Online;   Leave a comment

I will be presenting the  following topic on  OAUG Fusion Council:  Oracle Fusion Architecture “Soup to Nuts” Online webseminar:

Date:                                        Monday, July 12

Time:                                        9am PST / 12pm EST to 10:00am PST / 1:00pm EST

Host Users Group:                    Independent Oracle Users Group (IOUG)

Presenter:                                 Kai Yu, Dell

Title: Provisioning Oracle RAC in a Virtualized Environment using Oracle Enterprise Manager

Abstract:

Oracle Enterprise Manager provides an end-to-end solution for automated provisioning, patching, and lifecycle management of virtual infrastructures and Oracle Real Application Clusters (Oracle RAC). Oracle Enterprise Manager provides a central management solution for Oracle RAC in virtualized environments. Learn how Oracle Enterprise Manager allows rapid provisioning of Oracle RAC systems in virtualized environment by using prebuilt Oracle VM templates and Oracle RAC provisioning features.  Authored by a Dell engineer and the Oracle enterprise manager product manager, this session shows the best practices to  establish an Oracle VM environment on commodity servers  and to configure the guest VMs for deploying Oracle RAC using Enterprise manager VM management  pack. It will focus on how to provision and scale up an Oracle RAC system in no more than few clicks using the enterprise management provisioning pack. The presentations will share the road map for upcoming provisioning, virtualization, and cloud computing features of Oracle Enterprise Manager.

 Objectives:

  • Configuration Oracle VM server: OVM server installation, network/storage configuration best practices
  • Management OVM from Grid control: adding VM management pack, management OVM from Grid control
  • Provisioning Oracle RAC on VMs: the best practices to configure VMs for RAC, provisioning RAC/Extending RAC on VMs

To join the training session
——————————————————-
1. Go to https://meetingexpectations.webex.com/meetingexpectations/k2/j.php?ED=134744802&UID=930362122&rid=1&RT=MiMxMQ%3D%3D.
2. Enter your name and email address (or registration ID).
3. Enter the session password: Soup2nuts
4. Click “Join Now”.
5. Follow the instructions that appear on your screen.