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

username:system
password:password
Read more >>

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.
Read more >>

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.
Read more >>

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.
Read more >>

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.
Read more >>

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.
Read more >>

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
Read more >>

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.
Read more >>

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"
Read more >>

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.

Read more >>

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).
Read more >>

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.

http://www.itsamples.com/network-activity-indicator.html
Read more >>

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.
Read more >>

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.

http://www.soluto.com/
Read more >>

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.
http://www.mandsconsulting.com/oracle-apex-video-training-tutorials-complete-list
Read more >>

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

Read more >>