Completed My First RAC project.



My birthday on this year is an unforgettable day!!!.

Yes. I've achieved one of my dreams today.

For the first time on my career, I've configured an Oracle 11gR2 RAC on an E-BIZ environment.

****************************************************
[oraprod@ec-pdb01 bin]$ ./rconfig /u01/rdbms/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs/ConvertToRAC_AdminManaged.xml

Converting Database "RAC1" to Cluster Database. Target Oracle Home: /u01/rdbms/product/11.2.0/dbhome_1. Database Role: PRIMARY.
Setting Data Files and Control Files
Adding Database Instances
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Adding Trace files
Setting Flash Recovery Area
Updating Oratab
Creating Password file(s)
Configuring Listeners
Configuring related CRS resources
Starting Cluster Database

Operation Succeeded

/u01/rdbms/product/11.2.0/dbhome_1

***************************************************************

I would like to say "Thank You" to  Kishoreji (akr14feb) for making me an Apps DBA ,
SriHari (Guruji) for Guiding me on difficult times,
Chandru  for  providing me a turning-point on life and all my friends.
A special Thanks to my wife Vasanthakala for her support.
Without them I would be a dust.
at 1 comment:

Reset VM Manager Portal "admin" user password

Guys,




This is how I reset the 'admin' user password of my Oracle VM Manager Installation.



1. There's a "register" link under the password field in Login page. Click that link and register a new user with simple password like 123456.

2. Login as sys or OVS user using sqlplus and connect to the DB.

3. select account_name, password from ovs.ovs_user where account_name='';

4. Copy the password field output.

5. update ovs.ovs_user set password='' where account_name='';

6. Commit and voila, you can now login with admin username and password will be 123456;



Isn't it Simple?

at No comments:

Difference Between Oracle Standard Edtion and Standard Edtion One (SE and SE1)

Recently, I came across difference between Oracle Editions in a particular version.

The differences are enormous.

Also, there's a new edition apart from standard and Enterprises Editions. It is Standard Edition One (SE1).

Following table lists the Differences: (Referred with Oracle docs)

Feature/OptionSE1SEEENotes
High Availability
    
Oracle Fail Safe
Y
Y
Y
Windows only
Oracle Data Guard—Redo Apply
N
N
Y
 
Oracle Data Guard—SQL Apply
N
N
Y
 
Rolling Upgrades—Patch Set, Database, and Operating System
N
N
Y
 
Online index rebuild
N
N
Y
 
Online index-organized table organization
N
N
Y
ALTER TABLE ... MOVE ONLINE operations
Online table redefinition
N
N
Y
Using the DBMS_REDEFINITION package
Duplexed backup sets
N
N
Y
 
Block change tracking for fast incremental backup
N
N
Y
 
Unused block compression in backups
N
N
Y
 
Block-level media recovery
N
N
Y
 
Parallel backup and recovery
N
N
Y
 
Tablespace point-in-time recovery
N
N
Y
 
Trial recovery
N
N
Y
 
Fast-start fault recovery
N
N
Y
 
Flashback Table
N
N
Y
 
Flashback Database
N
N
Y
 
Flashback Transaction Query
N
N
Y
 
Scalability
    
Oracle Real Application Clusters
N
Y
Y
Extra cost with EE, included with SE
Automatic Workload Management
N
Y
Y
Requires RAC
Performance
    
In-Memory Database Cache
N
N
Y
Extra cost option
Security
    
Advanced Security Option
N
N
Y
Extra cost option
Oracle Label Security
N
N
Y
Extra cost option
Virtual Private Database
N
N
Y
 
Fine-grained auditing
N
N
Y
 
Development Platform
    
SQLJ
Y
Y
Y
Requires Oracle Programmer
Oracle Developer Tools for Visual Studio .NET
Y
Y
Y
Windows only
Microsoft Distributed Transaction Coordinator support
Y
Y
Y
Windows only
Active Directory integration
Y
Y
Y
Windows only
Native .NET Data Provider—ODP.NET
Y
Y
Y
Windows only
.NET Stored Procedures
Y
Y
Y
Windows only
Manageability
    
Oracle Change Management Pack
N
N
Y
Extra cost option
Oracle Configuration Management Pack
N
N
Y
Extra cost option
Oracle Diagnostic Pack
N
N
Y
Extra cost option
Oracle Tuning Pack
N
N
Y
Extra cost option, also requires the Diagnostic Pack
Oracle Provisioning and Patch Automation Pack
N
N
Y
Extra cost option
Database Resource Manager
N
N
Y
 
VLDB, Data Warehousing, Business Intelligence
    
Oracle Partitioning
N
N
Y
Extra cost option
Oracle OLAP
N
N
Y
Extra cost option
Oracle Data Mining
N
N
Y
Extra cost option
Data Compression
N
N
Y
 
Bitmapped index, bitmapped join index, and bitmap plan conversions
N
N
Y
 
Parallel query/DML
N
N
Y
 
Parallel statistics gathering
N
N
Y
 
Parallel index build/scans
N
N
Y
 
Parallel Data Pump Export/Import
N
N
Y
 
Transportable tablespaces, including cross-platform
N
N
Y
Import of transportable tablespaces supported into SE, SE1, and EE
Summary management—Materialized View Query Rewrite
N
N
Y
 
Asynchronous Change Data Capture
N
N
Y
 
Integration
    
Basic Replication
Y
Y
Y
SE1/SE: read-only, updateable materialized view
Advanced Replication
N
N
Y
Multi-master replication
Oracle Streams
N
N
Y
SE1/SE: apply only
Messaging Gateway
N
N
Y
 
Transparent Gateways
Y
Y
Y
Extra cost option
Networking
    
Oracle Connection Manager
N
N
Y
 
Infiniband Support
N
N
Y
 
Content Management
    
Oracle Spatial
N
N
Y
Extra cost option

The Only (of-course two) differences between SE and SE1 are support for RAC and AWR feature.

Your updates are welcome.
Sundar K
at 2 comments:
Labels: ,

ksh not found while pre/post cloning


  I usually receive the below mentioned error while Pre/Post Installation Check.

System Utilities Check

These utilities need to be accessible on your system in order to do administrative tasks.
command : /usr/Stage11i/startCD/Disk1/rapidwiz/bin/adchkutl.sh
Checking for make... found - /usr/bin/make
Checking for ld... found - /usr/bin/ld
Checking for cc... found - /usr/bin/cc
Checking for ar... found - /usr/bin/ar
Checking for ksh...
Unable to find PD KSH version.
Unable to locate all utilities with system path.
PATH = /usr/bin:/usr/Stage11i/startCD/Disk1/rapidwiz/unzip/Linux:/usr/bin:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin


The Solution for this issue is:
export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'



Even though you have performed all your pre-reqs.

Anyone knows what this '@(#)PD KSH v5.2.14 99/07/13.2' mean to?
at No comments:
Subscribe to: Posts (Atom)

  Find below few useful scripts for  Performance  Management:: # Important MOS notes for TRACING: There are several ways to trace a particul...

  • adapcctl.sh: exiting with status 204
    On a new VIS R12.1 installation, the OHS (oracle http server) failed to start and give status 204. Upon querying the status of opmn manage...
  • Ever Hit with ORA-46981 in Oracle EBS Environment ?
    Recently when I was tasked to do a cloning of my production Oracle Apps instance to a target single-node server,  I hit a dead-end with the ...
  • (no title)
    A nice story about RMAN.           The story begins,  when one of my associate DBAs did an RMAN restoration & recovery 2 days back...