Emre Baransel - Oracle Blog

A Grid Infrastructure Installation Adventure

2012-01-09T12:34:00.000+02:00

I was very used to create ASM instance manually before 11gR2. With 11gR2 we must to install Grid Infrastructure even on sigle instance databases if we’re going to use ASM. In my last installation i had strange errors that i’ll share below. First error was complaining about the password and the log file is: INFO: Executing ASMCA INFO: Command /u01/app/oracle/product/11.2.0/grid/bin/asmca -

[INS-20802] Oracle Net Configuration Assistant failed

2012-01-09T10:25:00.000+02:00

I had the following error on 11gR2 Grid Infrastructure installation: [INS-20802] Oracle Net Configuration Assistant failed. The plug-in failed in its perform method tail -50 /u01/app/oraInventory/logs/installActions2012-01-06_09-45-58AM.log INFO: Oracle Net Listener Startup: INFO: The information provided for this listener is currently in use by other software on this computer.

Book Review: Oracle WebCenter 11g PS3 Administration Cookbook

2011-10-17T10:56:00.001+03:00

I knew a little about Webcenter and Packt's Oracle Webcenter 11g book was very helpful for me to learn about the new version and developing the administration skills. Yannick Ongena did a greate job on this book with a uniqe style of teaching. In this book topics are covered with 4 dimensions. "Getting ready" "How to do it..." "How it works..." and "There's more..." With this way of

Book Review: Oracle Enterprise Manager Grid Control 11gR1: Business Service Management

2011-08-10T16:46:00.001+03:00

Here is another greate book i read and recommend, published by Packt and written by Ashwin Kumar Karkala and Govinda Raj Sambamurthy. This is about Oracle Enterprise Grid Control. Book is named with "Business Service Management" to impress the capabilities of Grid Control. Grid Control is not just for your Database Monitoring needs, but also for a complete service management which includes

RMAN Channels, Parallelism, Multisection Backups & Multiplexing

2011-07-11T16:00:00.002+03:00

I wanted to summirize some complicated RMAN concepts, using the "11gR2 Backup and Recovery User's Guide" definitions. Channel & ParallelismThe number of channels available for use with a device when you run a command determines whether RMAN reads from or write to this device in parallel while performing the command. When the work is done in parallel, the backup of the files is done by more than

My OOW 2011 Presentation

2011-06-06T10:09:00.005+03:00

I submitted for Open World 2011 with a presentation titled "Effectively using Oracle Data Guard for multiple purposes". After the voting phase, Oracle reviewed and accepted my session. Here are some details of my presentation. Hope to see you there. Type: Conference Presenter: Emre Baransel Primary Track Database: High Availability

Book Review: Oracle GoldenGate 11g Implementer's Guide

2011-05-04T19:35:00.000+03:00

I've just finished reading the book "Oracle GoldenGate 11g Implementer's Guide" written by John P. Jeffries and published by PACKT. I strongly advise this book for solution/database architects who wants to learn what GoldenGate can do and how, database administrators who are new to GoldenGate and wants to learn the technical details of implementations and GoldenGate experienced administrators who

Presenting at TROUG Day 2011

2011-04-17T18:50:00.000+03:00

I'll be presenting at TROUG (Turkish Oracle User Group) Day 2011 on 21 April about "Using Oracle Dataguard Efficiently". Jonathan Lewis will be there with keynote and a presentation titled "Thinking About Joins". There will be very valuable presentations from valuable professionals. You can find event details here: (in Turkish) This event will be live streamed on the internet: http://

Dataguard Notes

2010-12-31T16:04:00.003+02:00

I wanted to share my notes on "Oracle Data GuardConcepts and Administration 11g Release 2" document. 11gR1 New Features · Compression of redo traffic over the network in a Data Guard configuration : This feature improves redo transport performance when resolving redo gaps by compressing redo before it is transmitted over the network. · You can now find the DB_UNIQUE_NAME of the primary

Dataguard on Different Operating Systems

2010-12-06T23:10:00.001+02:00

In 10g, dataguard started to support different binaries on primary and standby database servers with the same OS family. For example Microsoft Windows 64-bit Itanium on primary and Microsoft Windows 32-bit or Microsoft Windows 64-bit for AMD on standby database server. However with 11g, dataguard also supports different OS on primary and standby servers. I wanted to share the support matrix for

RMAN-03009 ORA-19554 ORA-27211 (2)

2010-09-01T11:14:00.003+03:00

This is the second post for the same error: RMAN-00571: ======================================= RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS ======= RMAN-00571: ======================================= RMAN-03009: failure of allocate command on t1 channel at 08/03/2010 19:57:21 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management

opatch error: OracleHomeInventory gets null oracleHomeInfo

2010-08-26T14:50:00.003+03:00

Opatch raised the following error: ApplySession failed: ApplySession failed to prepare the system. OracleHomeInventory gets null oracleHomeInfo System intact, OPatch will not attempt to restore the system OPatch failed with error code 73 In order to find root cause; export OPATCH_DEBUG=TRUEthen run "opatch apply" again. Following lines give more information. Home name= OUIHome1, Location= "/

Dataguard Cascade Standby Database

2010-08-12T22:12:00.003+03:00

Cascade standby database configuration lets your layer1 standby database transmit the archivelogs to a layer2 standby database. This feature can be configured with simple LOG_ARHIVE_DEST_x settings but (as always) there are some key points that you should know. • You must use standby redo logs on layer1 standby database. • RAC primary database and Data Guard Broker are not supported in Cascade

MRP Speed (Log Apply Rate of a Standby Database)

2010-06-04T15:01:00.002+03:00

You may want to calculate the apply rate of your standby database if you need performance tuning on your dataguard environment. Also if you are “Using a Physical Standby Database for Read/Write Testing and Reporting” in 10g or Snapshot Standby in 11g, you may need this value to calculate how much time does your standby database needs to re-syncronize in a point of time. There are some ways of

Oracle Database 11g RMAN Backup and Recovery book

2010-05-07T22:59:00.002+03:00

I’ve experienced my first book contribution work and prepared the “Configuring HP Data Protector for Oracle” chapter to “Oracle RMAN 11g Backup and Recovery” (Osborne Oracle Press Series), written by Robert Freeman and Matthew Hart. I saw Robert’s post on FreeLists Oracle-L about contribution and offered to add HP Data Protector - RMAN configuration chapter to the book. I’m glad my offer was

Transferring Oracle Files Between Databases in ASM

2010-04-02T22:37:00.010+03:00

Why do we need to transfer Oracle files between databases? There may be lots of cases depending on your imagination, and my case here is sending archivelogs in a dataguard configuration. Dataguard ships the archivelog files automatically, even if the standby database is read-write (Snapshot Standby Feature) in 11g. But in 10gR2, if you’re “Using a Physical Standby Database for Read/Write Testing

Authentication failed!null

2009-10-13T11:43:00.004+03:00

This strange error appeared after trying to login enterprise manager dbconsole. Error message clearly notes that there is an authentication problem but a user (me this time) who reads this error message normally thinks that he has entered wrong username or password. This is not the problem here, because when we enter wrong information on em login screen we see an error like: Error Your username

Higlights From IOUG Data Security 2009

2009-10-05T11:33:00.009+03:00

IOUG has recently published their valuable research on Data Security. Here are some suprising results from the report: 1- Over the past year, percentage of the company's, whose data been breached, compromised, or tampered was increased. I just wonder what will be the future of this increase every year. Will it be 50%, who says their data has been breached, compromised, or tampered 20 years

Hot Topics Of My Oracle Diary - 2

2009-09-14T11:08:00.004+03:00