tag:blogger.com,1999:blog-73225346967496832322009-11-05T13:13:06.948-08:00All about Database. Mainly on Oracle all version (i.e. Oracle 8i/9i/10g/11g), PL/SQL, Trigger, Store Procedure. How to install Oracle on Linux platform and MS Windows platform. Ora Error and SolutionNiramit Soonthawongnoreply@blogger.comBlogger112125DatabaseTipTrickhttp://feedburner.google.comtag:blogger.com,1999:blog-7322534696749683232.post-38101984173275280002009-11-05T13:06:00.000-08:002009-11-05T13:10:33.061-08:00

Oracle Real Application ClusterThe video talk about Oracle RAC architecture there are 2 parts of it.Video IVideo II

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-9844532663327469502009-11-05T13:05:00.000-08:002009-11-05T13:06:11.507-08:00

Oracle RMAN Setup Tutorial

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-4367532688624349232009-11-05T13:02:00.000-08:002009-11-05T13:04:51.590-08:00

This videocast explains Vitrual IP (VIP) usage in Oracle Clusterware 10g and 11g - why they are needed and how they are used. A must know for any Oracle RAC DBA.

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-18407638452114212482009-07-15T15:15:00.000-07:002009-07-15T15:17:02.343-07:00

The Critical Patch Update for July 2009 was released on July 14, 2009. Oracle strongly recommends applying the patches as soon as possible.The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities for each product suite, and links to other important

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-12461980890822440292009-05-22T15:23:00.000-07:002009-05-22T15:23:01.138-07:00

You may notice a lot of online data businesses are nowoffering several different services to customers wholike to play it safe and prepare for the worst.Some of the services they offer include online andoffline secured data storage and data recoveryservices.The purpose is to protect what we spend several hourstyping up and it is like they are saying "We’ve gotyour back" so you don’t need to worry

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-82828173059098305082009-05-20T15:21:00.000-07:002009-05-20T15:21:00.487-07:00

When your computer becomes the most used piece ofequipment you have, you spend countless hours sittingdown typing important information down so you don’tlose anything.It may also be the way you earn your living so thelast thing you need is some serious time off becauseyour computer has failed.There are several ways that you can prevent the lossof data and it doesn’t cost a fortune.The most common

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-60200418017768343222009-05-20T15:16:00.000-07:002009-05-20T15:16:00.715-07:00

You may have lost some data recently and you need tobe able to recover it. This is easier than ever to doand the cost is minimal.You can always have your data stored professionally toavoid losing your data and without being invaded andinterrupted.These programs are available online and canperiodically save your data while you relax and keepworking.Data recovery techniques are complicated if you

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-71352623784287829372009-05-19T15:26:00.000-07:002009-05-19T15:27:35.336-07:00

Physical damage is not like picking up your computerand slamming it down on the floor or carrying it up aflight of stairs only to drop it at the top.Physical damage can occur in several ways.You use your computer’s hard drive everyday notrealizing that every time you use it you are puttingyour computer at risk of a malfunction that can loseyour data and be hard to recover it all

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-28813087939698383392009-05-19T15:20:00.000-07:002009-05-19T15:21:19.652-07:00

With technology today records and other importantdocuments are now kept on computers instead of thetraditional pen and paper style of bookkeeping.People put a lot of faith into computers and trustthat they will always provide the documentation thatthey store forever. Most of the time people do not seethe need for a back up system to recover any data thatmay get lost or they may think that it is

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-48038893491154620332009-05-19T15:17:00.000-07:002009-05-19T15:18:22.325-07:00

When you lose your data for what ever reason you wantto be able to recover it with minimal complication andtime.In order to do that you may need to purchase a datarecovery tool kit that is designed to help you recoveryour data on your own without any help on or off line.Data can be lost quickly and may have been importantto you for personal reasons or for work.Sometimes accidents happen and you

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-37464704119744777352009-05-19T15:16:00.001-07:002009-05-19T15:16:43.122-07:00

Losing your data is an unexpected time consumingproblem that may stop you from working depending onwhy your system crashed to begin with; mechanical orphysical.Either way you are stuck until you fix your system orpurchase a new one.If you purchase a new one you still need to accessyour data from your damaged computer system in orderto transfer files, documents and other importantinformation that

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-54089540169677063942009-05-15T15:18:00.000-07:002009-05-19T15:19:21.103-07:00

When you lose your data you may lose very importantinformation; birthdays, appointments, contactaddresses, homework assignments, work documents andother important information that you stored on yourcomputer not realizing that you could lose it.Maybe it was a page you had pulled up and working onwhen someone came in to talk. During the conversationa button may have been pushed and all of your

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-59925006594081497182009-05-10T15:19:00.000-07:002009-05-19T15:20:42.554-07:00

Losing your data usually occurs when you don’t havethe extra time to fix the problem. You may rely onyour computer for work or you may use your homecomputer to keep track of important personal files.Whatever your reason you are going to be lost withoutyour data so you need to find a quick easy solution torestore your data quickly and easily so you don’t haveto go long without those important

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-45775737128853097412009-05-04T03:52:00.000-07:002009-05-04T03:56:18.886-07:00

Get white paper on Oracle Compatibility Developer's Guide for DBAs & Application Developers by EnterpriseDB at http://research.bizreport.com/detail/RES/1240871902_713.html?li=201125&src=KA_RES_20090504&asrc=EM_KAR_6782029&uid=4401398Below is the abstract.In today's challenging economic climate, organizations running Oracle are struggling to meet rising information demands with constricted budgets

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-17976913756011555062009-05-02T15:25:00.000-07:002009-05-19T15:26:22.878-07:00

Data recovery is the process of saving the informationthat you can no longer get to by using the normalsource. Without being able to reach your data you maylose important documents and information that youcannot find anywhere else.Data recovery will help you to recover thatinformation even if your system has crashed. There areseveral ways you can recover the information and youcan do it yourself

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-50868010993173119672009-04-08T08:01:00.000-07:002009-04-08T08:03:16.954-07:00

Highly accurate and up-to-date customer data is one of the keys to maintaining strong customer relationships and ultimately growing revenue. Furthermore, lacking a single view of the customer through a customer data integration (CDI) initiative or a master data management (MDM) system enables organizations to lack a realistic way of applying vital data quality tools enterprise-wide. At the same

Niramit Soonthawongnoreply@blogger.com1tag:blogger.com,1999:blog-7322534696749683232.post-25715443134416643892009-04-02T07:20:00.001-07:002009-04-02T07:20:54.982-07:00

View this Webcast to find out from the experts how effective application archiving can help you effectively manage your production database, control data growth, and ultimately improve your bottom line. You'll learn to: * Improve performance of the production environment * Archive or purge inactive transactional data automatically to an online database or offline flat file * Maintain

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-81053022904425335752009-04-02T07:18:00.000-07:002009-04-02T07:19:52.810-07:00

Organizations are facing a massive challenge in protecting their data in a cost effective and timely manner. But with a growing number of branch offices, an increasing number of servers, and a high priority on reducing cost, backup is becoming increasingly difficult. In this paper, learn Riverbed's proven strategy for combining WAN-based backup with wide-area data services (WDS) solutions. Backup

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-74520249730510587592009-04-02T07:15:00.000-07:002009-04-02T07:17:00.997-07:00

Server virtualization is the most substantial shift in IT so far this decade. Adoption is high, and firms are virtualizing mission-critical and business-critical applications. But while server virtualization has become mainstream, firms still struggle with storage availability and performance. Storage configuration options abound, and successful deployment can be tricky.In an attempt to add

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-41376143782787798092009-04-01T00:55:00.000-07:002009-04-01T01:02:43.768-07:00

Postgres Plus claimedto be able to replace oracle database functionality, 100% compatible oracle database. We've tried it with out oracle database, and every triggers are working fine, all the same with procedure, view. The platform supported included windows, linux 32/64 bit MAC OS X... below are some of it's feature and download link.some feature I took it from the official site: http://

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-35147865102917283552009-04-01T00:34:00.000-07:002009-04-01T00:53:57.667-07:00

For a software developer, a «Swiss knife»-style tool can be incredibly useful, but only when that?s the «right» tool. The problem is, nobody can tell you exactly, how to determine whether a tool is «right». A right tool must be full-featured, but it must not be overloaded with features; a right tool must have laconic and functional interface, but it must be easy to learn and understand; it must

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-42776623803259155552009-04-01T00:29:00.000-07:002009-04-01T00:32:27.558-07:00

Oracle Maestro is a powerful solution for the Oracle server administration and development. Key features include: - support for all Oracle server versions on the market; - easy database object management ; - database designer; - PL/SQL debugger; - data management: viewing, editing, grouping, sorting and filtering abilities; - handy SQL editor with code folding, syntax highlighting,

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-79125593576412037302009-03-15T15:19:00.000-07:002009-03-15T15:24:17.827-07:00

If you are the owner of a table or view and you create a public synonym for the table or view, when you grant select on the synonym mane you are in effect granting select on the table or view. The synonym eliminates the need to clarify the table or view with the schema.table name.And here is how yo create public synonymCREATE public SYNONYM [table/view name] FOR [owner].[table/view name];and

Niramit Soonthawongnoreply@blogger.com0tag:blogger.com,1999:blog-7322534696749683232.post-18574036681301354662009-03-11T21:15:00.000-07:002009-03-11T21:16:56.395-07:00

One of the exciting new features of Oracle 11g is their inline data compression utility. While it is true that data storage prices have fallen dramatically over the last decade, and continue to fall rapidly, Oracle data compression has far more appealing benefits than simply saving on disk storage cost. Because indexes and the data itself can be highly compressed, information can be fetched off

Niramit Soonthawongnoreply@blogger.com1tag:blogger.com,1999:blog-7322534696749683232.post-29972726036308315532009-03-02T22:43:00.000-08:002009-03-02T22:44:11.617-08:00

The Critical Patch Update for January 2009 was released on January 13, 2009. Oracle strongly recommends applying the patches as soon as possible.The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities for each product suite, and links to other important

Niramit Soonthawongnoreply@blogger.com0