Jan 22
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 81,000 times in 2011. If it were an exhibit at the Louvre Museum, it would take about 3 days for that many people to see it.
Hi, I’m here announce that I changed my wordpress blog domain with following address.
However If you clicked on my wordpress blog, it will automatically redirected to this address.
Enjoy your reading….:-)
Oracle Recently released some new products
Look here
Oracle Big Data Appliance Latest
If you’re missed out on OOW11, SF, you can switch on to youtube and watch OOW11 live session on youtube.
Session Schedule
OOW 11 Live session at Youtube
Sep 27
Yes I am still working as a Core DBA, not act like as a Apps DBA. But I got a some opportunity to work for EBS Environment. So here First I installed the three tier EBS 12.1.1 on Linux machine. In this document I just demonstrate How do we install Oracle EBS 12.1.1 on Linux machine. I hope It may very useful for who willing to learn EBS installation. Just review my installation document. Hope you’re all like this document…
Download PDF Document here.
Oracle EBS 12.1.1. three tier step by step installation guide on Linux Download right click on this url, choose save target as and save it on your local machine.
Sep 20
When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the chopt tool.
The chopt tool is a command-line utility that is located in the directory ORACLE_HOME/bin. It uses the following syntax, where db_option is the option whose status you want to modify:
chopt [enable | disable] db_option
Refer :
Example : Disable Data mining options
[oracle@netbackuptest bin]$ pwd/u01/app/oracle/product/11.2.0/dbhome_1/bin[oracle@netbackuptest bin]$ chopt disable dmWriting to /u01/app/oracle/product/11.2.0/dbhome_1/install/disable_dm.log…
%s_unixOSDMakePath% -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk dm_off
%s_unixOSDMakePath% -f /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk ioracle[oracle@netbackuptest bin]$
Sep 6
I have five Linux machine, I want to create one folder on one Linux machine and share this folder on remaining Linux machine? how do we do?
Use NFS. I don’t want explain more about NFS. Here I am going to show how do we do?
If you want to share one folder of linux (1) machine,
[root@siebelfs ~]# mkdir /test
Create test file
[root@siebelfs test]# vi test.conf azar
and then Save it.
You need to check it out Whether portmap and nfs running or not
[root@siebelfs ~]# chkconfig --list portmap portmap 0:off 1:off 2:off 3:on 4:on 5:on 6:off [root@siebelfs ~]# chkconfig portmap on [root@siebelfs ~]# chkconfig --list portmap portmap 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@siebelfs ~]# ps ax | grep portmap 3228 ? Ss 0:00 portmap 4491 pts/1 R+ 0:00 grep portmap
For NFS
[root@siebelfs ~]# chkconfig --list nfs nfs 0:off 1:off 2:off 3:off 4:off 5:off 6:off [root@siebelfs ~]# chkconfig nfs on [root@siebelfs ~]# chkconfig --list nfs nfs 0:off 1:off 2:on 3:on 4:on 5:on 6:off And then, restart portmap and nfs service [root@siebelfs ~]# service portmap restart Stopping portmap: [ OK ] Starting portmap: [ OK ] [root@siebelfs ~]# service nfs restart Shutting down NFS mountd: [FAILED] Shutting down NFS daemon: [FAILED] Shutting down NFS quotas: [FAILED] Shutting down NFS services: [FAILED] Starting NFS services: [ OK ] Starting NFS quotas: [ OK ] Starting NFS daemon: [ OK ] Starting NFS mountd: [ OK ] [root@siebelfs ~]# ps ax | grep nfs 4664 ? S< 0:00 [nfsd4] 4666 ? S 0:00 [nfsd] 4667 ? S 0:00 [nfsd] 4668 ? S 0:00 [nfsd] 4669 ? S 0:00 [nfsd] 4670 ? S 0:00 [nfsd] 4671 ? S 0:00 [nfsd] 4672 ? S 0:00 [nfsd] 4673 ? S 0:00 [nfsd] 4691 pts/1 R+ 0:00 grep nfs [root@siebelfs ~]# chkconfig --list nfs nfs 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@siebelfs ~]# ps ax | grep mountd 4676 ? Ss 0:00 rpc.mountd 4694 pts/1 R+ 0:00 grep mountd [root@siebelfs ~]# chkconfig --list nfs nfs 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@siebelfs ~]# ps ax | grep portmap 4585 ? Ss 0:00 portmap 4699 pts/1 R+ 0:00 grep portmap
Now We need to add shared folder directory in /etc/exports file like below , Here I have used four linux machine, If I missed any ipaddress of client linux machine
you can not able to access this folder.
[root@siebelfs ~]# vi /etc/exports /test ipaddress(rw) /test ipaddress(rw) /test ipaddress(rw) /test ipaddress(rw) and then save it. Again restart nfs service only. [root@siebelfs ~]# service nfs restart Shutting down NFS mountd: [ OK ] Shutting down NFS daemon: [ OK ] Shutting down NFS quotas: [ OK ] Shutting down NFS services: [ OK ] Starting NFS services: [ OK ] Starting NFS quotas: [ OK ] Starting NFS daemon: [ OK ] Starting NFS mountd: [ OK ]
Now Go to another linux machine (client).
configure portmap and nfs like above. but don’t add any line in /etc/exports file.(in case if you want to
share this machine folder for other client machine , you can add line like above).
here 10.1.x.xx — ipaddress of shared folder machine.
[root@siebelas ~]# mkdir /test [root@siebelas ~]# mount -t nfs -o rw 10.1.X.XX:/test /test [root@siebelas ~]# cd /test [root@siebelas test]# ls test.conf
Sep 3
Microsoft SQL Server, SharePoint, and Silverlight for 10 Days Only
Throughout September Packt, a leading publisher of Microsoft books, will be celebrating…
10 days of SQL Server 1st – 10th September
10 days of SharePoint 11th – 20th September
10 days of Silverlight 21st – 30th September
Throughout these dates there will be up to 20% off SQL Server, SharePoint and Silverlight books and 30% off eBooks – for further information visit: http://www.packtpub.com/packt-10-days-of-sql-server-silverlight-sharepoint
Packt Publishing strives to not only produce top-quality content from expert authors, but to specialise in a range of topic areas such as SQL Server, SharePoint and Silverlight – ensuring the reader reaches their full potential as a Microsoft user, no matter what their level of expertise.
So don’t wait, take advantage of these special offers now!
Jul 16
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
What do you learn from this 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:
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
Database Administrator, Blogger, Contributor
DBA 