Skip to content

Archive for

Oracle 11gR2 two node Real application cluster installation step by step guide on linux using VMware Server

Here…If you would like switch on to RAC DBA, first you must know about RAC installation. you think It may difficult for me while installation, Not at all but sometimes. you may refer some installation document so in this case If you’re searched in Google,  you can get a more installation document. then Why I was published, Answer is you can realized after reviewed my installation document. I hope This document style should be user friendly for you. In this document I demonstrated how do we install Oracle 11gr2 two node rac on linux using vmware server 2.0.

Download the below pdf document, I’m sure this installation guide should be easy for you.

Oracle 11gR2 two node real application cluster installation guide on linux using vmware server

Download right click on this url, choose save target as and save it.

Oracle 11g R1/R2 Real Application Clusters Essentials Book

Before I start my review  writing about  this book, First I convey my big thank and congratz for Mr.Syed Jaffer Hussian , He is the co-author of this book. I am really proud of him as his student and friend. My best wishes for him successful life forever.

Now a days, “RAC” this is the word pronouncing continuously by among the DBA guys and Technical Experts.

Everybody thinking what is RAC? Is this word is very difficult for us? I mean Is this environment is difficult for working?.Yes may be But not at all If you know the RAC High Availability  environment. I am sure You may love this environment If you have a knowledge about it .

As a Standalone  database administrator, they may  know about only about database concepts.but RAC environment DBA must want to knows about Database Administration, Network Structures, Storage, Virtual Environment etc. The RAC DBA must have a wide knowledge among this environmet.

Here this is the book explained about How do we deploy RAC installation and how do we choose our storage and how do we convert standalone to HA and more useful information available.

It has lot of screenshots helps for your understanding how do we deploy clusterware  installation and two node RAC installation and also how do you choose your storage redundancy while you’re installing.

many dba are thinking how do we manage ASM disks, i hope this book should be broken your thoughts. this book guide easily for you.

Additionally this book will guide you ,how can we take the RMAN backup for RAC environment.

and also you may think about Disaster Recovery i.e Dataguard delpoy enviornment ,here its there.

RAC installation techniques for EBS. This topic may be helps for apps dba guys.

and more steps available with helps of screens hots like clusterware upgrade, Convert standalone server to RAC server.

many many many questions if you have mind about RAC , I am sure this is the book will helpful for you and clear your doubts.

I mentioned this book ” Oracle 11g R1/R2 Real Application Clusters Essentials” written by Ben Prunsinki & Syed Jaffer Hussain.

Both Authors having good experience with Oracle RAC Database environment .more detail about them , you can reach them below blogs

Syed Jaffer Hussian — Blogs

Ben Prusinski — Blogs

Oracle Real Application Clusters, or Oracle RAC for short (formerly known as Oracle Parallel Server), is a clustering technology that provides the ability to scale performance and improve server availability for Oracle data center environments. Oracle RAC not only serves as a part of the Oracle Maximum Availability Architecture (MAA) for disaster recovery purposes, but it’s also used for other purposes such as scaling up and out for performance by adding additional nodes to an Oracle data center environment.

HA means High availability is a discipline within database technology that provides a solution to protect against data loss and against downtime, which is costly to mission-critical database systems.

This book has including contains 12 chapters

Sample Chapter

Table of Contents

What do you learn from this book.

  • Learn how to administer, implement, and manage Oracle 11g RAC environments for real world deployments
  • Discover the key architectural design and installation techniques required to successfully deploy Oracle 11g RAC
  • Effectively manage the complex 11g Clusterware, using key troubleshooting tips and techniques
  • Successfully implement database creation methods, manage the Oracle RAC database and handle workload in your RAC environment efficiently
  • Appropriately plan your backup and recovery strategy
  • Know when and how to upgrade your Oracle RAC environment effectively
  • Discover how to deploy Oracle 11g RAC with complex standard-off-the-shelf systems like Oracle EBS
  • Understand new key features for Oracle 11g R1/R2 RAC and ASM.
Don’t miss out to read “Appendix” of this book. Here most useful information available for your improve practical knowledge.
Audience of this book
If you are an Oracle DBA who wants to administer Real Application Clusters, then this book is for you. Basic understanding of Oracle DBA is required. No experience of Oracle RAC is required.
I’m highly recommend  this book for DBA guys, why you are waiting ,buy it from here and spread your knowledge..:-)

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

What do you think about Grid control ?

How do grid control useful for your organization business sector?. Answer.Yes I hope this is the right book for yours guidance.

Recently I have received this book comes from packt publications for book review.

You must know about Enterprise manager basic knowledge about installation before you read this book because this book not guide you step by step Enterprise manager installation. This book main focus is How do we manage a  organization business service management in Enterprise manager and How easy for.

And also you need IE or Mozilla browser and SLM License Enabled.

What is Oracle Enterprise manager grid control in Business Service management?
Oracle Enterprise Manager that’s used to model and manage the entire Oracle Grid and beyond. It has capabilities to manage a number of databases and application servers, and can manage multiple instances of Oracle deployment platforms.

Business Service Management (BSM) is a methodology for monitoring and measuring Information Technology (IT) services from a business perspective. The Business Service Management capabilities of Oracle Enterprise Manager are available only in the Grid Control flavor.

I mentioned this book is written by Ashwin Kumar Karkala & Govinda Raj Sambamurthy. Both are having a good experience with Grid control management relevant field.

If you want to read sample chapters about this book. you can from here.

This book has contains including  10 chapters.

Table of Contents

What you will learn from this book :

  • Discover Modeling as a panacea for managing complexity in today’s data centers
  • Gain an insight into various monitoring techniques like active and passive monitoring
  • Get to grips with salient management features of Oracle Enterprise Manager 11g that every system administrator must know
  • Manage the IT Infrastructure passively through Systems and Groups Targets-based modeling
  • Understand Active monitoring techniques and execute synthetic transactions using Beacons and Service Tests
  • Model business services using different types of Service Targets
  • Define the availability of your business services and infrastructure
  • Perform a measurement of your business services using KPIs
  • Deliver real-time monitoring using dashboards, reports, and widgets
  • Define, monitor, and manage Service-Level Agreements
  • Model complex business services using Aggregate Service Targets
  • Use out-of-the-box system-service models for Oracle products
  • Understand best practices for modeling and monitoring services in your data centers
Audience of this book,
If you are a System Administrator or Application Administrator who is responsible for Business Service Management (BSM) using Oracle Enterprise Manager Grid Control 11g R1, then this book is for you. You need basic knowledge of Middleware/Application Servers, Business Service Management, and Oracle Enterprise Manager Grid Control.

Packt Publications Celebrates its 50th Oracle Book

 

Packt Celebrates its 50th Oracle Book

Throughout July Packt Publishing will be celebrating the release of its 50th Oracle book – cementing its reputation as one of the leading publishers in Oracle books.

To mark this milestone Packt is offering the following discounts:

  • 20% off all Oracle print books
  • 30% off all Oracle eBooks

Packt first started publishing Oracle books in 2006, and has since published best-sellers such as Getting Started With Oracle SOA Suite 11g R1 – A Hands-On Tutorial, Oracle Coherence 3.5 and Oracle Fusion Middleware Patterns.  And with more than 20 exciting new Oracle titles scheduled for 2011 this current success is only set to increase.

Packt owes much of its success to its print-on-demand mantra which not only allows it to produce books on specialist areas, but enables a quick response to new developments in technology – which was recently demonstrated with Packt publishing the first ever book on GoldenGate, the Oracle GoldenGate 11g Implementer’s guide.

Packt’s entire range of Oracle books is also available via PacktLib, Packt’s Online Library, and as part of Packt’s celebrations it’s offering you the chance to win a year’s subscription to PacktLib worth $220 click here for details: http://www.packtpub.com/article/50th-oracle-book-offer

For further information on this, and other books published by Packt Publishing, please visit www.PacktPub.com

could not validate asmsnmp password due to following error ora-01031:insufficent privileges

During Create new database, It shows following errors

 

“could not validate asmsnmp password due to following error ora-01031:insufficent privileges”

 

 

Solution :
[oracle@mazar ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
[oracle@mazar ~]$ export PATH=/u01/app/oracle/product/11.2.0/grid/bin
[oracle@mazar ~]$ export ORACLE_SID=+ASM
[oracle@mazar ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 3 20:54:14 2011

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

Enter user-name: sys/Admin543 as sysasm

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL>  create user asmsnmp identified by Admin321;

User created.

SQL> grant sysdba to asmsnmp;

Grant succeeded.

can we recover dropped table from recyclebin if flashback mode off

yes ,We can recover dropped table from recyclebin even flashback database mode is disabled.

What is Recycle Bin?

recycle bin is actually a data dictionary table containing information about dropped objects. Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space. They continue to count against user space quotas, until specifically purged from the recycle bin or the unlikely situation where they must be purged by the database because of tablespace space constraints.

Each user can be thought of as having his own recycle bin, since unless a user has the SYSDBA privilege, the only objects that the user has access to in the recycle bin are those that the user owns. A user can view his objects in the recycle bin using the following statement:

SELECT * FROM RECYCLEBIN;

When you drop a tablespace including its contents, the objects in the tablespace are not placed in the recycle bin and the database purges any entries in the recycle bin for objects located in the tablespace. The database also purges any recycle bin entries for objects in a tablespace when you drop the tablespace, not including contents, and the tablespace is otherwise empty. Likewise:

  • When you drop a user, any objects belonging to the user are not placed in the recycle bin and any objects in the recycle bin are purged.
  • When you drop a cluster, its member tables are not placed in the recycle bin and any former member tables in the recycle bin are purged.
  • When you drop a type, any dependent objects such as subtypes are not placed in the recycle bin and any former dependent objects in the recycle bin are purged.
SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO
SQL> show parameter recyclebin;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
recyclebin                           string      OFF
SQL> alter system set recyclebin=ON scope=spfile;

System altered.

SQL> show parameter recyclebin;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
recyclebin                           string      OFF
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  535662592 bytes
Fixed Size                  1375792 bytes
Variable Size             335544784 bytes
Database Buffers          192937984 bytes
Redo Buffers                5804032 bytes
Database mounted.
Database opened.
SQL> show parameter recyclebin;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
recyclebin                           string      ON
SQL> conn testuser/testuser;
Connected.
SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
ABC                            TABLE
ABCD                           TABLE
XXX                            TABLE

SQL> create table test(empno number);

Table created.

SQL> insert into test values(001);

1 row created.

SQL> insert into test values(002);

1 row created.

SQL> insert into test values(003);

1 row created.

SQL> insert into test values(004);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test;

     EMPNO
----------
         1
         2
         3
         4

SQL> drop table test;

Table dropped.

SQL> select * from test;
select * from test
              *
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> set lines 500
SQL> SELECT object_name,original_name,droptime,dropscn from recyclebin;

OBJECT_NAME                    ORIGINAL_NAME                    DROPTIME               DROPSCN
------------------------------ -------------------------------- ---------
BIN$nkFizCIuTY23wgOmv1B1vA==$0 TEST                             2011-07-03:13:27:35    8811423

SQL> flashback table test to before drop;

Flashback complete.

SQL> select * from test;

     EMPNO
----------
         1
         2
         3
         4

SQL> SELECT object_name,original_name,droptime,dropscn from recyclebin;

no rows selected

SQL>

Ref : http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/tables011.htm#i1011362