Converting an Administrator-Managed Database to a Policy-Managed Database and vise versa.

Database Management and Performance
| May 15, 2013

Hi, 
Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database is dynamic with instances managed automatically based on server pools for effective resource utilization. Admin-Managed database results in instances tied to specific servers.

When we create 11g Release 2 RAC database, on database configuration assistant’s 3 of 13 (more...)

Which device is mapped Oracle ASM disk?

Database Management and Performance
| May 9, 2013

Hi,

Yesterday Yuva Kishore is commented on my Oracleasm - Instantiating disk : failed post and asked a question: We can list the asm disks (listdisks) but where can we find the mapping that ASMDISK1 is mapped to /dev/sda1 and so on? 

I want answer this question with this (more...)

Oracle Data Guard 11g – Redo Transport User

Database Management and Performance
| May 7, 2013


Hi,

As you know when we create Data Guard Configuration, we must copy password file. Because SYS user is default redo transport user on Data Guard configurations. 

SYS password is changed on primary

When we change SYS password on primary database, redo transport service is stopping and we are (more...)

Cluvfy error : Framework setup check failed on all the nodes

Database Management and Performance
| Feb 20, 2013
Hi

As you know Oracle recommends  before installation Oracle Real Application Clusters 11g Release 2 run Cluster Verification utility with  stage previous and post installation cluster ware or database.

Cluster verification utility help you for getting error before and  after installation Oracle Grid Infrastructure and Real Application Clusters Database.

I getting following error : 

[grid@oel62-rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n oel62-rac1,oel62-rac2 –verbose
…..
Checking user equivalence...
Check: User equivalence for user "grid"
  Node Name                             Status                 
  ------------------------------------  ------------------------
  oel62-rac2                            passed                 
  oel62-rac1                            passed              
   
Result: User equivalence check passed for user "grid"

Verifying node (more...)

Oracle VM 3.2 Now Available

Database Management and Performance
| Jan 24, 2013
Oracle Virtualization product Oracle VM 3.2.1 now available. 

You can read press release here and Oracle VM 3.2.1 documentation here. Download Oracle VM from  edelivery.oracle.com 



Installation 



MySQL Database Support: MySQL Database is used as the bundled database for the Oracle VM Manager management repository for simple installations. Support for an existing Oracle SE/EE Database is still included within the installer so that you can perform a custom installation to take advantage of your existing infrastructure. Simple installation using the bundled MySQL Database is fully supported within production environments.

Discontinued inclusion of Oracle (more...)

Differences of Oracle Database Editions

Database Management and Performance
| Dec 28, 2012
My  friend asked me what is the differences of  Oracle Database Editions? I answered his question and I sent him a  information for this topic from Oracle Documentation Library : Oracle® Database Licensing Information 11g Release 2 (11.2). 

I want share with you a following table from documentation, too. This tables shows  Feature Availability for Oracle Database Editions. 

SE1 - Oracle Database Standard Edition One
SE   - Oracle Database Standard Edition 
EE   - Oracle Database Enterprise Edition 


Feature/OptionSE1SEEENotes
High Availability
Oracle Fail Safe
Y
Y
Y
Windows only

Last meeting of the year 2012 – AZEROUG

Database Management and Performance
| Dec 3, 2012
At 01.12.2012 I attended AZEROUG (Azerbaijan Oracle User Group) - Last meeting of the year 2012 at Qafqaz University. 

This meeting is started with  speech of  Kamran Agayev, Oracle ACE Director (www.kamranagayev.com). Kamran spoke about AZEROUG meetings of this year and thanked all  users.

Kamran Agayev  


 Technical part of this meeting is started with  Ulfet Tanriverdiyev's (ulfet.blogspot.com) session. Ulfet's topic is Oracle Streems : general concepts and hand-on demo. He talked about streems very good , oracle replication technology and end of the session  he showed very  interesting video demo. 

(more...)

Oracleasm – Instantiating disk : failed

Database Management and Performance
| Dec 3, 2012
When I configure ASM disks with ASMLib on Oracle Linux 6.2
I got a error


This error is depend  with  SELinux. I  forget set disabled SELinux configuration.

You can disable SELinux on duration of installation Linux



or after installation with change /etc/selinux/config




It is very important for correct operations!

And following video demo showing solve problem when oracleasm createdisk fails.




You can found Oracle Support note : oracleasm createdisk fails with selinux enabled [ID 1430947.1]

Oracle recomended is disable SELinux before installation Oracle RAC!


Regards
Mahir M. Quluzade

Oracle RAC Traning

Database Management and Performance
| Oct 23, 2012

I completed, "Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2" course at "Metod Oracle Academy" in Istanbul / Turkey with Oracle Instructor, Oracle Certified Master - Cem Zorba. 

Me with Oracle Instructor,
OCM Cem Zorba
Cem Zorba is very experienced oracle expert and very nice speaker. I got enjoy to talk about Oracle with OCM Cem Zorba. He gave very  additional information from Oracle RAC duration of course.

Ugurata, Ergun, Cem Bakir attended to this course, too. I'm glad to met they. 
See you in Azerbaijan, friends! 

Me with Cme Zorba, Ugurata and Ergun 


Me (more...)

The biggest event of the year in Turkey : TROUG DAY2012

Database Management and Performance
| Oct 22, 2012
TROUG DAY2012 was started with  Keynote: High Availability 11g New Features  by  Syed Jaffar Hussain (OCM, Oracle ACE Director, DBA of the year 2011). His presentation is created very professional and he spoke new features Oracle Real Application Clusters and Syed shared with us his valuable experiences.

Syed Jaffar Hussain
Syed Jaffar Hussain
After keynote of Syed, TROUG DAY'12 was continued with two streams, DBA and Develeper Stream. I attended to  DBA Stream. 

DBA Streem was continued with Husnu Sensoy's (Oracle ACE Director, DBA of the year 2009) session, his presentation was very interesting for me, he talk (more...)

TROUG Day’12

Database Management and Performance
| Sep 12, 2012


Turkish Oracle Users Group's the largest event of this year TROUG Day'12 will be at 11th October 2012 in Bahcheshehir University / Besiktas Istambul.

The event is starting with OCM, Oracle ACE Director, DBA of the Year 2011 -  Syed Jaffar Hussain's "Keynote : Oracle High Availability 11g New Features" speech. 

Event will continue with two parallel sessions for  DBAs  and Developer. 

I will be attended to TROUG Day'12  and my session will be at 14:45 - 15:30 and I will speak about "Heterogenous Data Guard Configurations". 
     
I am very glad that (more...)

Oracle SQL Developer 3.2 released

Database Management and Performance
| Aug 21, 2012

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.

Oracle SQL  Developer 3.2 release on  August 20, 2012.

Regards
Mahir M. Quluzade

July 28 – AZEROUG II Meeting

Database Management and Performance
| Aug 12, 2012
Azerbaijan Oracle User Group Members

On July 28, AZEROUG's (Azerbaijan Oracle User Group) - second meeting took place.This was a technical meeting. We are planned three speech. I, Javid Hasanov and Ramin Orujov.

I spoke about Oracle Data Guard 11g concepts, new features of data guard and  mainly "Different operating systems in same Data Guard configuration". End of the my session I showed video demo on Linux and Windows operating system on  same data guard configuration.

After my speech, Javid Hasanov was speech about Oracle Resource Manager. He showed examples for testing management resources with Oracle Resource (more...)

Oracle Data Guard 11g – Using DBMS_DG

Database Management and Performance
| Jul 19, 2012

Oracle Database 11g  Release 1 onward new package - DBMS_DG. Package contains a procedure INITIATE_FS_FAILOVER, yet. This procedure for using to specify a condition string that, when encountered by an application, allows the application to request the primary database to immediately invoke a fast-start failover.
Syntax
DBMS_DG.INITIATE_FS_FAILOVER (condstr IN VARCHAR2)
RETURN BINARY_INTEGER;

condstr - parameter
Specifies the condition string for which a fast-start failover should be requested. If no condition string argument is supplied, the default string of "Application Failover Requested" will be logged in the broker log file and in the database alert log of the primary database.

Oracle Data Guard 11g – How to safely remove a Data Guard Broker configuration?

Database Management and Performance
| Jul 17, 2012

When you need safely remove broker-managed Data Guard Configuration then, oracle recommend following steps… 
You know dg_broker_start parameter is TRUE and data guard configuration information contains in broker configuration files dg_broker_config_file1, dg_broker_config_file2 with broker-managed Data Guard Configuration.
Following steps I use on my test machines witch is running on Oracle Virtual Box. I captures video on this   machines, too. Primary and Standby Database running on Oracle Linux Server 6.2 and  installed Oracle Database 11g Release 2 (11.2.0.3).
DG – is my data guard configuration. admdb is primary database, stldb – is standby database. 

DGMGRL> (more...)

Azerbaijan Oracle User Group – II Meeting

Database Management and Performance
| Jul 8, 2012
I’ll be speaking at Azerbaijan Oracle User Group II Meeting on July 28th at Qafqaz University. 
As expected, I’ll talk about  "Different operating systems  in same Data Guard configuration"
Here’s the speakers and subjects:
More info (In Azerbaijani) : http://www.azeroug.org/?p=40 

Waiting you to Azerbaijan Oracle User Group II  Meeting

Oracle Data Guard 11g – Overview Cascaded Redo Transport Destinations

Database Management and Performance
| Jul 6, 2012


Note: To use the Oracle Data Guard cascading redo transport destination feature described in this video, you should be using Oracle Database 11g Release 2 (11.2.0.2). Releases prior to 11.2.0.2 have several limitations for this feature that are not present in release 11.2.0.2.
***
We are know usually in data guard configurations standby databases receives primary database generated redo indirectly from  primary.

A cascaded redo transport destination receives primary database redo indirectly from a standby database rather than directly from a primary database.

A standby database that cascades primary database redo (more...)

Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration

Database Management and Performance
| Jun 25, 2012


I read My Oracle Support note “Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]” .
I made decision that let me check this.Then I have create two virtual machines with Oracle Virtual Box. Witch is a virtual machine OS Oracle Linux server 6.2 (x86_64) and a Virtual Machine with OS Microsoft Windows 2008 Server R2 (x64) . Installed Oracle Database 11g Release 2 (11.2.0.3) both server, and a database (ADMDB) is created on first server.

I used RMAN Duplicate command for creation of standby database and after creation (more...)

Oracle Data Guard 11g – Overview Logical Standby Database

Database Management and Performance
| Jun 6, 2012
Logical Standby  Database is one part of Oracle Database Guard.
The benefits are obvious: the standby database can not only be open for reads, but it can also support additional entities such as indexes and materialized views that can be too expensive to maintain at the primary database. In addition, you can add other tables or even entire schemas to a logical standby database and have complete read-write access to those tables as they are not maintained by SQL Apply.
Logical standby databases are support all role transition operations that are available in the context of a physical standby database.

Oracle Data Guard 11g – Overview Client Failover Configuration

Database Management and Performance
| May 29, 2012


Often we are needs,client continue works on new primary without change connection settings when current primary is failed. With this video, I showed overview client failover configuration. I have showed how to continue client works after failover to on new primary database, and I showed how to enable fast start failover on oracle data guard and how to working automatic client failover.

This video captured on three virtual machines, witch is created on Oracle VirtualBox, on two machines running operating system Oracle Linux Server 6.2, on a machine (client machine) running Microsoft Windows 2003 Server and I used Oracle (more...)