[root@localhost ~]# su - oracle [oracle@localhost ~]$ export ORACLE_SID=orcl [oracle@localhost ~]$ sqlplus username:system password:password
Search This Blog
Thursday, December 9, 2010
How to set AUTOTRACE in Oracle 10g.
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.
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.
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.
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.
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.
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.
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"
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.
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).
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.
http://www.itsamples.com/network-activity-indicator.html
Read more >>
Here's the link to the authors website.
http://www.itsamples.com/network-activity-indicator.html
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.
http://www.soluto.com/
Read more >>
http://www.soluto.com/
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
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
1) First we will add groups by runing the following commands.
groupadd oper
groupadd dba
groupadd oinstall
Subscribe to:
Posts (Atom)