Wednesday 2 July 2014

Oracle Report Server Queue Monitoring

This article explains how to store the Oracle Reports Server queue information into a database. It discusses the installation of the tables and packages and its setup. The RW_SERVER_JOB_QUEUE table and PL/SQL API is an excellent feature to easy conserve and analyze historic meta information of a Reports Server’s job queue by simple database functionality. This functionality should enable in all application servers in which more than 3000 reports per day to save the historic data




Monday 16 June 2014

Oracle Forms 10g Vs Windows 7

Due to the late certification of Oracle Developer Suite 10g with Windows 7 32-bit environments, there is a known issue where opening some forms in 10g Forms Builder will crash the program making it unusable. The base installer for Oracle Developer Suite 10g is currently version 10.1.2.0.2. The Developer Suite will need to be patched to version 10.1.2.3 in order to be certified with Windows 7 32-bit. The following will need to be done to fix the problem:
  1. Reinstall Oracle Developer Suite using patch 10396165 (see detailed steps below)
  2. Install patch 5983622 on top of the newly-installed installation
  3. Apply Oracle patch 7047034 (OPatch) to the Oracle Home

Friday 16 May 2014

How to - Check the table size in Oracle 10g /11g

              To check actual tale size of oracle is really can be hectic for you if you dont know much about oracle blocks, extents, segment and specially PCT free and PCT used concepts, and there is no actual function in oracle to check the table size,
First, we must remember that Oracle table size is constantly changing as DML adds and re moves rows.  Also, we have many other factors that determine the "actual" size of a table:



Friday 2 May 2014

How to - Connect LUNs From EMC Storage HostAgent to Linux Server

EMC VNX Series is the huge storage to work with, High-performing unified storage with unsurpassed simplicity and efficiency, optimized for virtual applications. With the VNX Series, you’ll achieve new levels of performance, protection, compliance, and ease of management. In this writeup I am going to share an experience of working with EMC VNX 5700 and IBM Server for Database and I have created some luns for my database and now I want those luns in my DB server so that I can start my database and grid installation on that luns. There is a thing named "HOST AGENT" which is required to complete the process it is an rpm package for RHEL linux 64 bit, I have this package coz I was using the same database servers, so lets start the process.

Tuesday 15 April 2014

LinkedIn Disaster


Hello every one as you guys know linked is one of the best professional networks in the world now days, and helping everyone to extend their professional network although every professional person is using LinkedIn frequently for new opportunities for their professional, career and financial growth. The reason for being huge usage of LinkedIn is the giant companies also using it for sharing there technologies update and so many things and everyone like it.


Monday 7 April 2014

SQL Databases Vs NoSQL Databases


When people are comparing SQL and noSQL, and concluding the upsides and downsides of each one, what I never hear anyone talking about is the speed.
Isn't performing SQL queries generally faster than performing noSQL queries?
I mean, for me this would be a really obvious conclusion, because you should always be able to find something faster if you know the structure of your database than if you don't.
But people never seem to mention this, So I have decided to go with this writeup it would help everyone to select best database in the war between SQL vs NoSQL Databases.

How to Check Iphone, Android or Windows Devices Factory Unlock Status

There are so many reason of checking the factory unlock status of your phone whether your device is unlocked,  it might just be that because you are curious to know about your phone or your might want to sell that's why you need to know the status so you could accurately notify the prospective buyer, and also we know that unlocked devices are more valuable and if every one has the unlocked smart phone this world would be so better in the way.
lets come to the point of the blog which is how anyone can know about the status of your their smart devices.




Friday 4 April 2014

OneFS Vs Data OnTap





So Guys, all you guys know them, Netapp and EMC both of them are giant in the storage industry. Now EMC release its new OS name OneFS a One File system according to them this OS make them the only best in the industry of storage but once again there is one more sophisticated, user friendly and decent OS named Ontapp lies under the tree of NetApp. I have read both of them just get the main difference between them i.e. Architecture vise, volume vise and performance vise. The Main similarity between Ontap and OneFs is both of them can support tens of petabyte without any problem and hinderence in their performance.

Monday 31 March 2014

Configure SSH equivalence For Oracle RAC

SSH password less Equivalence  in RAC nodes are the most important things that count as pre reqs for installing Oracle RAC for more than one node for all RAC related users like oracle who is owner of database and grid who is owner of grid infrastructure. Oracle 11g includes automatic password less equivalence but as you guys know if it returns an error it is one of the most hillarious thing you can ever face before Installing Oracle RAC (click the link for step by step guide of installing Oracle RAC) and at that time you always go for manual way which was very very difficult for new comers so here the easy way to configure password less equivalence for users in Solaris and Linux based operating systems.

Saturday 29 March 2014

How to Configure and Access CIFS Server on NETAPP Filler



NetApp Support File and Block at the same time dislike EMC which depends upon the hardware and have to buy block and file separately or you can go for unified in EMC Storage. well in this writeup I am going to share Cifs setup configuration via CLI. you will be required to have a user which have administrative access in you Active Directory, Active directory's primary and secondary Ip addresses and Time Server Ip Addresses for Time Sync. and yeah you must have CIFS license, NetApps allow you to create CIFS and share them once the CIFS license is purchased. Nothing is free, except maybe samba :D

Friday 28 March 2014

How To Update NetApp Filler DOT Version from 8.0 to 8.1

Storage upgrade is always a big and tricky task for storage engineers. So in this writeup I am going to share the procedure to succesfull upgrade of DOT version from 8.0 to 8.1 and I believe this procedure will help you to upgrade any DOT version of Any netapp storage product for fas32xx and fas62xx.In my scenario the storage is fas6240 and has been provisioned to other unix based servers. you can follow the same step if you going to upgrade your brand new storage you will be needed below mention softwares:

Monday 17 March 2014

How to Update File OE of VNX 5700 - VNX Series Operating Environment

The system comes pre-installed with the latest version of VNX OE software available at the
time of shipment.
In addition to upgrading the VNX OE software, the USM wizards can be used for installing
other software, such as language packs, software enablers, and disk firmware. For these
tasks, EMC provides the ability to create instructions tailored to your environment. Go to
the Update VNX software link on https://mydocs.emc.com/VNX to create these customized
procedures.


Sunday 9 March 2014

Oracle Optimizer Modes (All_Rows, First_Rows, Choose & Rule RBO)


The optimizer_mode is the most powerful of these silver bullet parameters and a change can radically alter the characteristics of your SQL execution workload. 

To see how important the optimizer_mode is to SQL execution, consider the following three-way table join which returns 100,000 rows:

Let’s run this SQL query with several different optimizer_mode values and observe the changes to the execution plans and SQL response times:










Tuesday 18 February 2014

How to Install 12c Cloud Control For Database/RAC

Oracle Enterprise Manager is Oracle’s integrated enterprise IT management product line, which provides the industry’s only complete, integrated and business-driven enterprise cloud management solution. Oracle Enterprise Manager creates business value from IT by leveraging the built-in management capabilities of the Oracle stack for traditional and cloud environments, allowing customers to achieve unprecedented efficiency gains while dramatically increasing service levels.

Friday 14 February 2014

How to Upgrade VNX 5300 Block OE

Although your VNX system is customer installable, EMC recommends that the installation be
Performed by someone who has a general background in information technology. While prior
Training is not required; customers who successfully installed this product were trained as either:
EMC Proven Professionals
Microsoft Certified Technology Specialists
Cisco Certified Network Associates

CompTIA A+ certified technicians






Tuesday 11 February 2014

How to Install ASMLIB and Packages Required For Using Oracle ASM

There are many ways to ASMLIB, it can be from get from OTN account or you can use ULN (Un breakable Linux Network).
Also it comes in the the Unbreakable Linux media, but if you are not subscribed to ULN and you are not using Unbreakable Linux then most people go to the OTN, where you have to select your Linux flavor and then navigate to the correct file according to the linux kernel and then download the 3 files one by one.

Sunday 9 February 2014

How to Add ISCSI Storage Under Linux


Adding Iscsi Storage under Linux is always the problem for everyone, everyone try do this via different way and every time some thing goes wrong !! and in answer no storage showing in linux, it was always painful for everyone so my this writeup is for all those guys they want a simple steps for adding ISCSI storage under linux.So lets start with package 

Tuesday 4 February 2014

How To Check the Hardware Info Linux Vs Solaris

Mostly people think Linux and Solaris are same languages while similar in many respect there are still quite few differences between and Linux and Solaris Machine including commands, file system and heritage. This differences can be as simple as renamed configuration file to the more complicated alternate meaning of command line Ethernet.Mostly people face problem in getting hardware information in Solaris, in linux there is only a
prtdiag -v command 

Monday 3 February 2014

How To Tell If Your Gmail Account Was Hacked

Gmail, A huge part Google mostly every one using there primary email as gmail (including me) and as there are so many hackers all around in this global village. And there is service left which is safe from malicious hackers who are constantly comes with terrifying new ways to steal to 

Sunday 2 February 2014

Domain Name Giving Error without Using "www" as prefix

Some time it frustrate a lot when your your custom domain does not work properly and in result you a huge traffic lost on your blog.
With blogger blog one most common and frustrating issue is you see error when you try to open your domain without using "www" as prefix in your domain.
well now no more worries!! :)))
Here is the perfect solution of your problem.


Friday 31 January 2014

Test Case 3 - Oracle RAC and Dataguard

Test Case 3



 1-      Objectives:
Purpose of this test is to verify high availability and active-active configuration of the RAC Nodes.

 2-      Test Diagram:
 3-      Procedure:
 Shut down / disconnect one node manually

Test Case 2 - Oracle RAC and Dataguard

 Test Case 2


   1-      Objectives:
Purpose of this test is to check the  active-    passive configuration of database with role transition.

   2-      Test Diagram:
   3-      Procedure:
      Perform a switch over command from data broker CLI for role transition.

  4-      Expected Result:
The Status and Role of primary and standby database will be interchanged.

Test Cases - Oracle RAC and Dataguard



As a tech guy no one like to write document for client or any one they just love to do work. same thing happened with when I need test cases for Oracle 12c RAC with Dataguard and Broker. I searched alot but didn't find the thing I want so, I have write those test cases for you guys to help you. Test Case is the criteria to check the configuration and with coming result. 

Test Cases 1 for Oracle Data Guard High Availability(HA)


      1-      Objectives:
Purpose of Data Guard test is to verify high availability and active-active configuration of the both standby and primary databases.