Search This Blog

Thursday, December 9, 2010

How to set AUTOTRACE in Oracle 10g.

[root@localhost ~]# su - oracle
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ sqlplus


Saturday, November 13, 2010

Using logminer to undo incorrectly committed changes in Oracle 10g.

In order to work with logminer, the Oracle database should be in archive log mode.
Skip the steps mentioned below if your database is already in archive log mode.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Thursday, October 21, 2010

How to write protect your USB flash drive.

Here is a really cool trick to write protect your usb flash drive.

For this trick to work you must know exactly how much space is available in your usb flash drive in bytes.

Tuesday, October 19, 2010

Hiren's BootCD 11.1

Hiren's BootCD is a completely free bootable cd containing lots of tools which are capable of data recovery, partitioning, system analysis, benchmarking etc.
You can use these tools even if your primary OS has got corrupted, because all the tools boot directly from the cd.

Tuesday, September 14, 2010

Oracle Database 10g Flashback Technology.

Flashback Database allows the DBA to “roll back” a table, set of tables or the entire database to a previous point-in-time.

First of all change the undo_retention parameter of your database.
SQL>show parameter undo_retention;

# The default value is 900 seconds.

Tuesday, August 31, 2010

Oracle 10g Rman Configuration & Backup.

In Oracle database we can do two types of backup’s manual or through
Rman(Recovery Manager).

Then there are two backup modes hot and cold.
Hot backup means, that the backup operations are done when the database
is running.Cold backup is done when the database is shut down or
is in mount stage.

Thursday, August 19, 2010

Configuring yum in RHEL5.

1) Make a directory where all our RHEL5 dvd files will be stored.

mkdir -p /var/ftp/pub/repo

Monday, August 9, 2010

How to hide files and folders in windows xp even when show hidden files and folders option is selected.

Here is a neat trick to hide your folders.

The best thing about this trick is that you can hide your personal data without the help of any third party software.

Sunday, August 8, 2010

Enabling Archive log mode in Oracle 10g and 9i.

First of all make sure that your database is started using spfile.
If you have created your database using DBCA then your database
will automatically start from spfile located in the dbs folder.

path of my spfile is "/u01/app/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora"

Tuesday, August 3, 2010

Creating external tables in oracle 10g.

External Tables lets you query data in a flat file as though the file were an Oracle table. In 10g, you can write out data to an external table, although you cannot write to an existing external table.

While external tables can be queried, they're not usable in many ways regular Oracle tables are. You cannot perform any DML operations on external tables other than table creation. One consequence is that you can't create an index on an external table. External tables are largely used as a convenient way of moving data into and out of the database.


Tuesday, July 27, 2010

Create oracle 10g database manually

It is assumed in this article that you have already installed oracle software.

The purpose of this article is to learn how we can manually create a oracle 10g database without the help of 'DBCA'(Database configuration assistant).

Monday, July 26, 2010

Network Activity Indicator for Windows 7

Miss those two blinking network lights taht were in windows xp, here is a small app that can get that function to windows 7.

Here's the link to the authors website.

Sunday, July 25, 2010

Oracle 10g Datapump.

In order to work with oracle data pump we will have to first unlock the scott user and create a directory object. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file system.

Friday, July 23, 2010

Wonderful application for slow booting computers.

Is your system too overloaded with apps? Does it take way too much time to boot up? Would you like a simple, uncomplicated software that can help you optimize the programs that load on Windows startup and decrease the time it takes your system to boot up? If so, you should check out Soluto.

Thursday, July 22, 2010

Online Tutorial of Oracle APEX.

Here is the brief description description that i found at the oracle’s website.
“Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.”
…….and this is the link where you can learn how to use this tool.

Tuesday, July 20, 2010

Oracle 10g Installation on Linux

This post assumes that you have already installed Red Hat Enterprise Linux 4. (Cent OS 4 can also be used for this purpose.)
1) First we will add groups by runing the following commands.
groupadd oper
groupadd dba
groupadd oinstall