Monday, 31 October 2011

Can Oracle be a NoSQL player?

Oracle on Monday advertised the instantaneous accessibility of its new Oracle NoSQL database, but skilled population quizzed if Oracle will be a very large competitor in the complete NoSQL market.
The NoSQLmovement -- delineated substantially by its crosswise ascending and service of thoroughly trafficked websites -- is still quite nascent but has ensnared some mindshare in the database world, mostly with financial gatherings for instance Digg and Facebook employing it. Earlier this month, along with its statement about its Big Data Appliance due out in the first quarter next year, Oracle said that it would have a NoSQL database to depart along with a Hadoop record system. But as of now the Oracle NoSQL database is only obtainable on freestanding podiums for instance disseminated x86 servers.
Carl Olofson, examine vice head of request for paid job development and deployment at IDC in Framingham, Mass., said it’s hard to declare if Oracle will become a very large NoSQL player.

What is NoSQL (Not Only SQL)?

NoSQL database, in addition called Not Only SQL, is an advance to written knowledge organisation and database create that's practical for very large collections of disseminated data.

NoSQL, which includes in a large assortment of technologies and architectures, looks for to resolve the scalability and big data recital subjects that relationaldatabases weren’t created to address. NoSQL is principally practical when an enterprise wants to entry to and examine gigantic allotments of unstructured written knowledge or written knowledge that's preserved remotely on multiple virtual servers in the cloud. . 
produced by its label, NoSQL does not prohibit composed query terminology (SQL). While it's accurate that some NoSQL procedures are wholly non-relational, other people basically avert picked relational

Relational Database

A relational database is a accumulation of data details directed as a set of formally-described tables from which written knowledge can be accessed or reassembled in more divergent means without having to reorganize the database tables. The relational database was devised by E. F. Codd at IBM in 1970.
The yardstick customer and request for paid job program interface to a relational database is the structured query language (SQL). SQL assertions are employed both for interactive queries for knowledge from a relational database and for collecting written knowledge for reports.
In augmentation to being quite not hard to bring ahead and access, a relational database has the valued superiority of being not hard to extend. After the primary database creation, a new written knowledge group can be adjoined without demanding that all surviving requests for paid job be modified.

E. F. Codd (Edgar F. "Ted" Codd)

E. F. Codd (Edgar F. "Ted" Codd) formed the fundamental thoughts for directing and accessing data that are embodied in the relational database, the predominant advance to written knowledge governing body in today's enterprise world. Critical of IBM's then prevailing written knowledge organisation procedures, Codd, as a youthful IBM programmer toiling in IBM's San Jose Research Lab in California in 1970, recommended that written knowledge be directed as showed by beliefs supported on acknowledged family between assorted varieties of data. The written knowledge itself would be directed in two-dimensional (row and column) desks and precise details in a table

What is Oracle

Oracle (in aged Greece, a person in contact with the deities; from Latin, oraculum or divine announcement) declares it is the world's primary supplier of programs for knowledge organisation but it is best famous for its highly developed relational database yield (notably Oracle9i), which are employed in Fortune 1000 businesses and by more of the greatest Web sites. Oracle's relational database was the world's first to support the Structured Query Language (SQL), now an development standard.
When CEO Lawrence J. Ellison and a small number affiliates formed Oracle in 1977, they were out to confirm erroneous the existing model that relational databases could not be commercially viable. As validation of their triumph, they parlayed an first $2,000 financial endeavour in the financial gathering into an per annum profits surpassing $9.7 billion

Friday, 28 October 2011

Linux Installation

Installing Linux>Boot from RHEL4 disc1
>press enter for graphical install
** Need at least 512MB RAM / 2.5GB Space **
>Manually partition your hard drive with Disk Druid
/tmp = 512MB ext3 fixed size
/boot = 128MB ext3 fixed size
Swap = 1024MB fixed size
/ = fill to maximum allowable size

Click here To Go Next

Oracle Installation in Linux

After Linux Installation, I have installed Oracle10g 2 in Linux machine. I followed steps given at below link.
Check "Part II: Configuring Linux for Oracle"

Now Steps to Create auto startup of the database with linux startup.

Automating Oracle DB startup in Linux

I am writing steps that will auto start Oracle Database along with linux OS startup.

1. connect with Oracle user and edit the "/etc/oratab" file setting flag to 'Y'. soni:/home/oracle/oracle/product/10.2.0/db_1:Y
2. connect wih root user- created empty file (/etc/init.d/dbora) and write:

3. chmod 750 /etc/init.d/dbora
4. chkconfig --add dbora
5 check whether dbora is working or not.. as root issue /etc/init.d/dbora start
# /etc/init.d/dbora start
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
Processing Database instance "soni": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log

We got any error in listner settings... This is due to a hard coded path in the dbstart script. To correct this, connect with Oracle user, edit the "$ORACLE_HOME/bin/dbstart" script and replace the following line (approximately line 78): ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle withORACLE_HOME_LISTNER=$ORACLE_HOME and then check
# /etc/init.d/dbora start
Processing Database instance "soni": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log
Congratz you are DONE 

Nokia launched first Smartphone with Microsoft OS

Nokia has launched two new smartphones Lumia 800 and the Lumia 710 supported on
Microsoft Windows Operation System which was deduced in an 8 month collaboration with the programs experts.

Google+ is now available with Google Apps

Google Apps buff, today we’re geared up to add you to our circles. Google+ makes dividing on the world large web more like dividing in the actual world, and now Google+ is obtainable to population who use Google Apps at educational school, at work or at home.

Starting now you can manually turn on Google+ for your organization. Once Google+ is turned on, your users will just want to indication up at to get started. For paying clients who use Google Apps for Business or the free variety of Google Apps and who have picked to self-acting empower new services, Google+ will self-acting become obtainable to all of your users over the next numerous days.*

Google Apps users will have entry to to the same set of features that are obtainable to every Google+ customer, and more. In augmentation to dividing publicly or with your disks, you’ll in addition have the pick to share with all population in your governing body, even if you haven’t adjoined all of those population to a circle.

Google+ for Google Apps

As agreed, Google+ is now available for Google Apps users. Administrators can empower the new service from the manipulate board, as described here. Google+ demands that Picasa Web Albums and Google Talk are empowered and that the governing body benefits the new statements infrastructure. If the two services are empowered and the pick to

Dropbox Tips for Wizards, Intermediates & Beginners

If you’re like us, you’re employing Dropbox for all varieties of extraordinary tasks. But we desired to depart farther, so we requested the skilled population at Dropbox to advise us their most extraordinary, unforeseen and silly means to use this versatile programs tool.

Dropbox Bug Made Accounts Accessible Without Passwords

Online storage provider Dropbox tolerated an authentication bug that made it probable to log into some users’ statements without a password for a short while, the financial gathering declares on its blog.
The bug was first publicized by Chris Soghoian some population of days ago. According to Dropbox, it changed a “very tiny number of users (much less than 1%)” and was fastened at 5:46 p.m. PT, five minutes after Dropbox admins divulged it.

Dropbox allegations it finished all logged-in


Visit Dropbox
Dropbox is a Web-based record hosting service ran by Dropbox, Inc. that benefits cloud storage to empower users to warehouse and share records and folders with other people through the Internet employing record synchronization. It was grounded in 2007 by MIT graduates Drew Houston and Arash Ferdowsi as a Y Combinator startup.
There are both free and paid services, each with deviating options. In equivalence to comparable services, Dropbox bids a quite large number of customer customers through a type of desktop and portable running systems. There are a number of versions through more running procedures, embracing versions for Microsoft Windows, Mac OS X, and Linux (official and unofficial), as well as versions for portable inventions, for instance Android, Windows Phone 7, iPhone, iPad and BlackBerry, and a web-based customer for when no restricted customer is installed. Dropbox benefits the freemium fiscal type and its free service gives 2 GB of free online storage. Users who cite Dropbox to other people can gain up to 8 GB.

Wednesday, 26 October 2011

Oracle Database 11g Release 2 Installation Steps on Windows

In this post I will delineate the putting in steps of Oracle database 11g Release 2 (32-bit) on Windows Server 2003 (32-bit).
- Download Oracle Database 11g distribute 2.
- Run the setup.exe

Oracle, Salesforce spar over cloud, multi-tenancy

At the center of the conflict in the cloud between and Oracle is a technological discussion -- multi-tenancy versus virtualization. and the bulk of Software as a Service vendors plunge on the boundary of multi-tenancy -- an architecture where a solitary case of a programs request for paid job helps multiple customers.
“Multi-tenancy is truly the future of our industry,” CEO Marc Benioff said in his off-campus keynote after his planned facade at OpenWorld 2011 was canceled. “We observe it in technologies that we all use every day -- Twitter, Facebook, Google, [Oracle CEO Larry Ellison’s] financial gathering NetSuite, our financial gathering Salesforce, Workday. All the new financial gatherings you’ve observed draw close along are all multi-tenant, divided architectures. It is the most recent, most prevailing of all architectures.”

Oracle experts weigh in on Oracle cloud computing

Ian Abramson, chief director of constituents and making acquaintance and first head for the Independent Oracle Users Group (IOUG); chief director of enterprise written knowledge gathering for Thoughtcorp.

Image <span style='color: red;'> moves </span> herehree Oracle skilled population weigh in on customer onvolvement in cloud computing, implementations for instance Oracle CRM on demand, Oracle on the Amazon cloud, and the high cost of submission for Exalogic, Oracle's confidential cloud machine.
On an IOUG component study last year: "The study presented that a large fraction of users are commencing to manufacture confidential clouds, that they have a want to twist up environments promptly and bring ahead competency as they want them. It’s all through virtualization. So is that the cloud? Well, it’s in a company’s ‘little cloud,’ right? I observe that kind of virtualization, and it’s now

Oracle Interview Questions

1- You have written in your CV that As a DBA u can Test a Backup, How?
2- You have written in your CV, that you can monitor physical and logical backup, how?
3- You have written in your CV, that you can Rebuild Index to rectify segment fragmentation. (Coalesce)
4- You has written in your CV, that you can Automatic Schedule a logical backup. how?
5- HVM, when it will be decreased? How can I do it? (Truncate table)
6- Alert log file? What it contains?
7- Control file? What information it contains? When it is read?
8- I have lost my Control File & don’t have any Backup; Can I start DB & operate? How? (You create a control file in no mount mode.)
9- Mount- No Mount?

Google's Plus Operator, No Longer Available

The plus operator from Google Search was practical to climax one or more keywords that had to be embraced in the explore effects accurately as you prepared them. If you explore for [ai], Google equates time spans like "artificial intelligence", "Amnesty International", "Art Institutes", "Appraisal Institute", "Adobe Illustrator" and that's not so useful. To impede the effects to pieces of paper that embrace "ai", you had to return your query with [+ai]. Unfortunately, the added to operator is no longer obtainable and you now have to use quotation labels even for solitary remarks and explore for ["ai"].

Integration Blogger to Google

When you edit your Blogger profile, Blogger presentations a communication at the apex of the piece of paper that says: "Connect Blogger to Google+: Use your Google profile and get entry to to approaching Google+ aspects on Blogger". Unfortunately, the bonds look like to be broken, but both URLs source profile switching.

Tuesday, 25 October 2011

Chrome Web Store's Redesign

Aspromised, Google's Chrome Web Store has a new interface that benefits promotional diagrams and greater screenshots, unfastens widening pieces of paper in overlays and makes it less difficult to fit expansions, subjects and apps. Another change is that the new variety is many speedier as it benefits AJAX to consignment widening pages. Infinite scrolling returns pagination, so you no longer have to snap "next".

Getting your app discovered in the Chrome Web Store with new promotional assets.

In August  they made a tiny change in Chrome Web Store’s app upload flow: when you upload new apps and expansions to the Chrome Web Store, or edit one of your surviving details, you'll be encouraged to give them with new promotional photograph assets. We are requesting you for these assets so that we can climax your apps and expansions in a brand label new warehouse layout that there assembly is toiling on.

A New Look For Gmail

A video from Google's YouTube channel (update: the video is now confidential, but there's a looking glass here) ushers in a new Gmail interface. It's supported on the Preview subject that's now obtainable in Gmail, but there are more other changes: an achievement bar that benefits icons alternatively of text tags, a fully completed new interface for talks, profile photos adjacent acquaintances, a flexible layout that adapts to any window amount, show clearly density picks like in Google Docs, resizable chat/labels segments, new high-definition subjects and an renewed explore packing box that embraces superior options.

Oracle Public Cloud to offer two Fusion apps

The Oracle Public Cloud will have the subsequent yield available: Fusion Customer Relationship Management (CRM), Fusion Human Capital Management (HCM), Social Network, Java and Oracle Database. However, only the Fusion yield will be obtainable at the start, with the other people to draw close online in the “near future,”as showed by the Oracle cloud site.

OAUG President Mark Clark talks Fusion, R12, cloud computing

On Fusion Applications: I believe folks are going to delay to glimpse how things agitate out. People are still in the method of managing upgrades to R12. Undergoing another large-scale task right now might be too much.
Most persons are looking at a issue answer, certain thing they could augment into their living applications. We’re still at the very, very beginning.

Getting started with Oracle Fusion Applications

This is part two of a two-part narrative on Oracle Fusion Applications. The first part studied the availability of Fusion Applications and its very complex charge list.
Before an Oracle shop even considers about taking on Oracle Fusion Applications, it ought first appraise what Oracle request for paid job yield and versions it now has, as showed by experts.

Oracle Fusion Applications move toward widespread release

After a half-dozen years in development, Oracle Fusion Applications have calmly arrived. The business has worked with enterprises this year through its Early Adopter Program, but the first foremost sign that Fusion Applications was usually accessible came last month when Oracle released its “Oracle Fusion Applications Global Price List” with little fanfare.
Also in June, Richard Bingham's book Managing Oracle Fusion Applications was released by Oracle Press.

Saturday, 22 October 2011

OracleHyperion Enterprise Planning release date and features

Oracle Hyperion Enterprise Planning is planned for distribute between April and June, as showed by representatives at Oracle OpenWorld this month. The new distribute will be optimized for Oracle Exalytics, the company’s enterprise smartness appliance, though the programs will be obtainable singly on other podiums as well. The query is how much of an redevelopment the new variety will be.

Oracle Hyperion migration features

A nice amazement in the release is a novel value summoned hssmigrate. In beforehand liberations, a value summoned CSSImportExport did the Shared Services protection migration. Using this tool, you had to export protection from Shared Services, write an XML or CSV file

Oracle Hyperion features and gotchas

After a yearlong hold back, Oracle has liberated Oracle Hyperion Enterprise Performance Management (EPM) This is a much friendlier distribute than 11.1.2, with a small number new utilities and a large number of much wanted bug fastens that users should find to be a refreshing change from variety 11.1.2.
The new distribute is more complex than earlier distributes,

Inside Oracle10g dynamic sampling

Oracle9i ushered in the new dynamic tasting manner for collecting run-time schema statistics, and it is now empowered by default in Oracle10g. But you may like to turn it off to get clear of unwarranted overhead in some circumstances. This excerpt, taken from Oracle Silver Bullets by Donald K. Burleson, clarifies what those circumstances are. Click here to scenery the every part of chapter.

Friday, 21 October 2011

Oracle database performance tuning guide

 Performance Tuning Basics

No subject what variety of Oracle you are employing, the basics of recital adjusting continue the same. Problems can originate from a type of reasons for, and as the DBA, your job is to diagram out what they are. For instance, poorlydesigned requests for paid job and database schemas can source subjects like extreme CPU use due to too more lucid I/Os, extreme circular plate reads due to missing indicators or extreme contention for divided resources.

Performance tuning, step 3: Working the plan

In step 1 we recognised the components of a basics of a presentation tweaking plan. Then, in step 2, we recognised the present state for later phases and very resolute the relation main concerns which require to be contacted in periods of client obligations and administration requirements

Performance tuning, step 2: Determining the current state

The Curent state
Determining the present state engages both users and the mechanical architecture of the database. This encompasses employed with knowing users, often called power users, to find out what they glimpse as problems. Ask your power users if they have discerned any exact tendencies, jot down what time difficulties happen and what they were doing.

Performance tuning, step 1: Planning a tuning engagement

Introduction to this series

Tuning a database or database requests for paid job is a time-intensive, repetitive task. Over time, the database modifications in more means and ought be reevaluated. In augmentation, modifications made to enhance recital will want to be evaluated

How can I calculate Oracle database efficiency?

There are no trick recipes you can use to spit out the competence of a database. There are more metrics that can be employed to aid you ascertain if one environs of the database is playing well or not. I'd start with Statspack (Oracle 8i and 9i) or ADDM (Oracle 10g). You can get descriptions on more assorted characteristics of the database performance. For instance, you can observe if advancing your buffer cache will aid database performance.

The Common posiblity of Oracle Effieciency

I have been tasked with recognising modes we can melody our Oracle database for better performance. First, I desire to understand what are the most widespread determinants of oracle db presentation problems? What should I be looking for and when?

Ensuring high availability in Oracle Database 11g R2

Oracle Database 11g Release 2 High Availability, an Oracle Press publication that came out in March, examines the high accessibility characteristics in Oracle Database 11g R2 and its affiliated tools. Scott Jesse, the co-author pictured to the left, converses in this Q&A about what high accessibility entails and the  new characteristics that advance high accessibility in Oracle DB. Jesse is the clientele support older supervisor for the Oracle RAC Assurance Team. The other authors are Bill Burton and Bryan Vongray, who are both Oracle RAC Assurance Team members.

Five goals for implementing Oracle Business Intelligence Applications

Oracle Business Intelligence Applications (OBIA) can give an governing body a deep analytical scenery into how a enterprise is playing, as showed by Sameer Agrawal, BI rehearse chief at San Jose, Calif.-based IT services firm Jade Global.

Infrastructure's effect on Oracle Database performance

Oracle databases are often the basis of large enterprise requests for paid job, and as most DBAs have divulged, poor database recital has a ripple issue through IT procedures, opposing impinging on productivity. Regaining and enhancing productivity has become a greatest worry for most administration that are still attempting to perform more with less – bringing ahead both a contest and an possibility for the harried DBA.

Can the Oracle DBA manage the Exadata machine?

AN FRANCISCO -- Oracle person in accuse Larry Ellison advertised this week that the financial gathering marketed 1,000 Exadata devices in the past year.
While it's set a lofty objective of marketing another 3,000 in the drawing close year, use instances and best practices are still arduous to draw close by in spite of the sheer amount of Oracle's buyer base.

A query for any governing body deeming the big-ticket database device is, who oversees it -- and what talents does an person employed need? Bundling concurrently storage, database, hardware and networking would look like to call for a large assortment of IT skills

Thursday, 20 October 2011

Step By Step Instructions on Installing Oracle 10g R2 32-bit

Pre-Installation Task
  NOTE: Installing Oracle 10g on RedHat EL4 works matching way as that of on Cent OS 4.
             Installing Oracle 10g on RedHat EL3 works matching way as that of on Cent OS 3.

Wednesday, 19 October 2011

Transaction Management with LogMiner and Flashback Data Archive

LogMiner is an often dismissed yet very strong implement in the Oracle Database. It is employed to extract DML assertions from the redo log files—the primary SQL that produced the transaction and even the SQL that can change back the transactions. (For an introduction to LogMiner and how it works, cite to my Oracle Magazine portion "Mining for Clues.") Until now, this strong implement was ordinarily under-appreciated due to the deficiency of a more simple interface. In Oracle Database 11g, even so, Oracle Enterprise Manager has a graphical interface to extract transaction from the redo logs employing LogMiner,

How To- Ping Sitemap of Website Blogs

XML sitemaps announce search engines about the sheets accessible to crawl on your website. Search motors find new sheets by navigating connections on websites. Sitemaps enhance seek motor crawling by supplying explicit data about the exact urls on your website. Sitemaps don’t double-check that your webpages will be indexed, but they normally boost both the possibility and pace of indexing.

How To- Submit Your Blogs Website to Google

Blogging is the newest passion for youth presently. 
Many juvenile persons were rotating their vocations as bloggers. 
Its likely because of the Globalization. Many new and juvenile bloggers 
were developing every year. According to latest Technorati investigation over 
1.8 million blogs were been listing every year. These statistics notify us the power of Blogging.

Tuesday, 18 October 2011

Installation Of Grid Structure For Linux

Install the Grid Infrastructure

Make sure both virtual machines are started, then login to "ol6-112-rac1" as the oracle user and start the Oracle installer.
$ cd /host/software/oracle/11gR2/
$ ./runInstaller
Select the "Skip software updates" option, then click the "Next" button.

Easy Step By Step installation Of RAC On Linux

Oracle Linux 6 installation as you would for a basic server. A general pictorial guide to the installation can be found here. More specifically, it should be a server installation with a minimum of 4G+ swap, firewall and SELinux disabled and the following package groups installed:
  • Base System > Base
  • Base System > Client management tools
  • Base System > Compatibility libraries
  • Base System > Hardware monitoring utilities
  • Base System > Large Systems Performance
  • Base System > Network file system client
  • Base System > Performance Tools

Oracle Database 11g Release 2 ( RAC On Oracle Linux 6.1 Using VirtualBox


One of the large-scale obstacles stopping persons from setting up check RAC environments is the obligation for distributed storage. In a output natural environment, distributed storage is often supplied by a SAN or high-end NAS apparatus, but both of these choices are very costly when all you desire to manage is get some know-how establishing and utilising RAC. A lower alternate is to use a FireWire computer disk enclosure to permit two appliances to get access to the identical disk(s), but that still charges cash and needs two servers. A third choice is to use virtualization to phony the distributed storage.
Using VirtualBox you can run multiple Virtual Machines (VMs) on a lone server, permitting you to run both RAC nodes on a lone machine. In additon, it permits you to set up distributed virtual computer disks, overwhelming the obstacle of costly distributed storage.
Before you launch into this setting up, here are a couple of things to consider.

Facebook Launches TimeLine !! Do you Want it ??

FaceBook Timelines Steps:
open the link FaceBook TimeLine Or you can find facebook developers from search bar in your profile.
After the highlighted link open you have to clicp APP on the top centre and give the permission as facebook ask for some application. then it will lead you the below page.

Monday, 17 October 2011

Auditing In Oracle Of Sys and Other Users


NAME                 TYPE        VALUE
audit_file_dest      string      C:\ORACLE\PRODUCT\10.2.0\
audit_sys_operations boolean     FALSE
audit_trail          string      NONE
Audit is disable by default, but can be enabled by audit_trail 
static parameter which can have following possible values.

Friday, 14 October 2011

Oracle Installation Guide Step by Step

Installation Process
It is same for Oracle 10g and 11g , but you must have your system eligible for 11g .
A Welcome window will appear: when you start the Oracle Universal Installer :
§         It is assumed that this is a fresh install so no other Oracle products should be installed at this time.

Wednesday, 12 October 2011

IBM Calls Out Oracle On Server And Systems Claims

Oracle's evaluations of its T4 Servers and SuperCluster wares to IBM Power 7 yield are off foundation, and its allegations about hardware and programs toiling concurrently are confusing because programs isn't truly embraced in so-called engineered systems. That's the gist of a apex IBM executive's response to Oracle smashes over the last two week.
IBM seldom observations on competent allegations, but Bernard Spang, chief director of approach and selling for database programs and procedures, advised InformationWeek Oracle's evaluations with IBM Power 7 procedures "don't line up" with reality.

Friday, 7 October 2011

Data Guard/Broker Configuration Oracle 10g

PRIMARY SITE: (Information)
  •                      Machine IP:
  •                      Database name (db_name): ORCL
  •                      Database Unique Name (db_unique_name): primary
  •                      TNS Service Name: to_standby (Through this service, the primary machine will be connected to   STANDBY machine)
STANDBY SITE: (Information)
  •                      Machine IP:
  •                      Database name (db_name): ORCL
  •                      Database Unique Name (db_unique_name): standby
  •                      TNS Service Name: to_primary (Through this service, the standby machine will be connected to PRIMARY machine)