Posts

Showing posts from July, 2013

Step By Step to Restore RMAN to New Host

Old Topics But Always Good To share , Find Below the Links for Steps to Restore RMAN to New Host

Step by Step Restore RMAN to New Host Here

Thank you
Osama Mustafa

WebLogic Error BEA-141281

Image
This Solutions for this errors :
Change Directory to Domain directory

cd /u01/app/oracle/domains/IDMDomain/servers/AdminServer  if you have lock you will find folder called  tmp
rm -rf AdminServer.lok
 Thank you
Osama mustafa

New Slideshare Document ( EnterPrise manager 12c )

Upload New Documents to my SlideShare Account :

Add target manually em12c HereConfigure email notification and incidents rule  HereDeploy Agent in Em12c Here Thank you
Osama Mustafa

Clone Pluggable Database

If you want to Clone One Of Pluggable database , How can you do that :

SQL> select name from v$pdbs ;
NAME
------------------------------
PDB$SEED
TEST_1
TEST_2Let's Clone Test_1 , Create folder on os level to move test_1 data. 
[oracle@test12c u01]$ mkdir clone
[oracle@test12c u01]$ cd clone/
[oracle@test12c clone]$ pwd
/u01/cloneOpen Test_1 Read Only :  SQL> alter pluggable database test_1 close immediate;Pluggable database altered.SQL> alter pluggable database test_1 open read only ;Pluggable database altered.Set this parameter to our created directory above :  SQL> show parameter db_create_file_dest ;
NAME     TYPE VALUE
------------------------------------ -----------
db_create_file_dest     string
SQL> alter system set db_create_file_dest='/u01/clone';             System altered. SQL> show parameter db_create_file_dest ;
NAME     TYPE VALUE
------------------------------------ -----------
db_create_file_dest     string /u01/cloneSQL> create pluggable…

Point-In-Time Recovery for a Pluggable Database

Image
Check Pluggable database that you have :
SQL> select name from v$pdbs ;
NAME
------------------------------
PDB$SEED
TEST_1
TEST_2
TEST_3 Shutdown database , to configure database archivelog
SQL> shutdown immediate ; Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount ;  ORACLE instance started. Total System Global Area 1252663296 bytes
Fixed Size    2287864 bytes
Variable Size  838862600 bytes
Database Buffers  402653184 bytes
Redo Buffers    8859648 bytes
Database mounted.SQL> alter database archivelog ; Database altered.
SQL> alter database open  Database altered.
SQL> alter pluggable database all open; Pluggable database altered.
SQL> alter system set db_recovery_file_dest_size = 2G scope=both; System altered.
SQL> alter pluggable database all open; Pluggable database altered. Export ORACLE_SID for container database and enter rman to backup  like below

[oracle@test12c backup]$ export ORACLE_SID=db12c
[oracle@test12c backup]$ rman …

Adopting NON-CDB to CBD

This article describe steps to Adopt non-container database 12c to container 12c 
[oracle@test12c Desktop]$ ps -ef | grep pmon oracle    3230     1  0 04:04 ?        00:00:09 ora_pmon_db12c
oracle   12112     1  0 08:20 ?        00:00:07 ora_pmon_NonCDB
oracle   29621  3203  0 18:47 pts/1    00:00:00 grep pmon Where : db12c : Container database NonCDB : Non Container Database
Let Start
[oracle@test12c Desktop]$ export ORACLE_SID=NonCDB
SQL> select instance_name from v$instance ;
INSTANCE_NAME
----------------
NonCDB
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount exclusive
ORACLE instance started.
Total System Global Area  939495424 bytes
Fixed Size    2295080 bytes
Variable Size  348130008 bytes
Database Buffers  583008256 bytes
Redo Buffers    6062080 bytes
Database mounted.
SQL> alter database open read only; Database altered. Run the below procedure to generate the manifest file. 
SQL> exec dbms_pdb.describe(pdb_descr_fi…

Oracle Database 12c Architecture

Image
I want to share the below picture , describe Database 12c Architecture 



For the Better Resolution please follow This Link
Thank you
Osama mustafa

Pluggable Database Part (3)

Since Pluggable Database is New Topic to post about , I Cannot post Everything in One Post so i decide to do it as tutorial and this one part (3) , every Topics uploaded Here on my blog or on my Account on Shareslide here.

In This topic :

How to unplug database.Plugging Database to another Container Database.
Let's Start :
SQL> select name, con_id from v$active_services ;
NAME         CON_ID
--------------------------------- ----------
new2  4
new  3
db12cXDB  1
db12c  1
SYS$BACKGROUND  1
SYS$USERS  1 as you see i already create two pluggable database new,new2 and now :
SQL> alter pluggable database new close immediate ; Pluggable database altered.SQL> alter pluggable database new2 close immediate ;
Pluggable database altered. Unplug database included with xml file :
SQL> alter pluggable database new unplug into '/u01/app/oracle/oradata/new.xml';Pluggable database altered.
SQL> alter pluggable database new2 unplug into '/u01/app/oracle/oradata/new_2.xml';P…

Pluggable Database Tutorial (12c) Part 2

In my Part 1 Tutorial for how to deal with Pluggable database 12c I mentioned how to use pluggable database , How to create pluggable database , how to create tablespace , and how to open/close pluggable database .

Please check the Part ( 1 ) before continue reading this article here.

Welcome to Pluggable database Part 2 


Rename Pluggable Database Manage Pluggable databaseDrop Pluggable databaseSecurity In Pluggable database

SQL> select name, con_id from v$active_services order by 1;

NAME    CON_ID
----------------------------- ----------
TEST 3

as you see in the above query, I already created pluggable database called test. and it's in Read write Mode.
Rename Pluggable database 
SQL> alter pluggable database TEST close immediate ;Pluggable database altered. SQL> alter pluggable database TEST open restricted ;Pluggable database altered.SQL> select name, open_mode from v$pdbs;
NAME               OPEN_MODE
------------------------------ ----------
TEST       READ WRITESQL>…

Pluggable Database Tutorial Part 1 (12c)

Image
[oracle@test12c Desktop]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 3 19:05:10 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL> show con_name
CON_NAME
-------------------
CDB$ROOTWhere 
CON_NAME : Displays the name of the Container to which you are connected when connected to a Consolidated Database. For non-consolidated database, it will return "Non Consolidated".
SQL> show con_id
CON_ID
------------
1Where 
CON_ID : Displays the id of the Container to which you are connected when connected to a Consolidated Database. If issued when connected to a non-Consolidated Database, this command returns 0.

Now I want to check how Name for my my pluggable database , while installation i chosen five container with prefix db_

SQL> select na…

Upgrade 11.2.0.3 to 12c Part 1

In this article i am describing Step by step how to upgrade database using dbua , in part 2 i will use the manual upgrade process.

The Link For Document : Here 


Thank you
Osama mustafa

TEMP UNDO TABLESPACE : Another 12C Feature

Testing is not finished yet , Everyday working on database 12C  , Lot Of New Features , TEMP_UNDO_TABLESPACE one of these new features, In older Oracle Versions Temp Tables are stored in Undo Tablespace, But now with #DB12c you can enable Parameter TEMP_UNDO_TABLESPACE by Default this parameter set to FALSE But in Dataguard 12c  this parameter is set to TRUE by default.

The Benefit of Using Temp Undo Tablespace :


reduce the amount of using undo tablespacein this case performance improved because less data will be written on redolog.Temp Undo Tablespace support DML 
SQL> show parameter TEMP_UNDO_ENABLED; NAME     TYPE VALUE
------------------------------------ ----------- -------
temp_undo_enabled     boolean FALSE You Don't have to reset Database to Enable this Parameter because it's working on Session level 
SQL> alter session set temp_undo_enabled=TRUE   ;
Session altered.
also you set this parameter on database level :

SQL> alter system set temp_undo_enabled=true;
Syst…