ORA-01667: cannot add any more tablespaces: limit of exceeded If your database version is 10.2g then your control file MAXDATAFILES parameter would expand...
How to use Oracle Logminer to analysis Logfile We know that any changes to database is recored in online redo logfiles. If your database archival mode on then...
Difference between V$parameter and v$spparameter V$PARAMETER It displays the information about initialization parameters that are currently in effect for the...
How to know database initialization parameter in oracle 1)SHOW PARAMETER option: If you use SQL*Plus then you can use SHOW PARAMETER parameter_name to display ...
How to monitor alert log file in Oracle We know in a UNIX system with tail -f we can monitor alert log file to see how alert log file is populated. For example...
How to Schedule or Automate Backup through Crontab Schedule or Automate Backup is a needed thing almost in all environment. We can do automate or scheduling...
Convert CLOB to BLOB I will write a procedure clob_blob_proc which convert description column of test table of type clob to blob. Here is the procedure. ... ...
How to configure(modify,see) Kernel Parameters in Linux Kernel Parameters, Recommended Values to install Oracle and Associated Files 1)semmsl semmns semopm...
How to change the hostname in Linux There are several ways by which we can change the hostname in linux. The process may vary based on distribution of linux. ...
How to load data using external table into oracle database Using SQL*Loader we can load data from flat data file to oracle database which is described in How...
How to Create and Use OMF OMF indicates Oracle Managed Files. With the use of Oracle-managed files the administration of an Oracle Database can be simplified. ...
How to Find out or Check Linux Version Information Before installing oracle clusterware it is necessary in which version of linux you are trying to install to....
Possible Limitations When Adding Datafiles to a Tablespace Before discussing limitations of adding datafiles to a tablespace let's think about DB_FILES...
Running Runinstaller fails with DISPLAY not set When I running the runinstaller command on my linux server after entering through ssh it fails with DISPLAY not...
ORA-12560: TNS:protocol adapter error on windows machine while starting oracle Error Description On my windows server machine whenever I try to logon to...
Recover database after missing online redo logs and all controlfiles. This example is based on, You have lost all your current and backup of controlfiles. You...
How to restore an Spfile from autobackup older than 7 days Whenever we issue in RMAN, RMAN> restore spfile from autobackup; then restoring from autobackup...
What will happen if oracle unable to write Alertlog, Core Dump Or Tracefiles In this I will show what can happen if Oracle is unable to write to the ...
How to avoid of recreating pfile or spfile if any error in spfile Let us some talk about pfile and spfile. Suppose I have done some wrong-edit inside spfile...
Why create between pfile and spfile works if shutdown database Sometimes it may arises question that while database is shutdown then you can still connect to...
How to find Top Sql through Queries If someone ask for top sql they from enterprise manager he can find some expensive queries. But the result may vary based...
How to find Top Sql through Queries If someone ask for top sql they from enterprise manager he can find some expensive queries. But the result may vary based...
Create Read only user for a Schema One thing you need to remember before read this post is there is no easy or shortcut way to make a read only user of another...
Drop Temporary Tablespace Hangs Problem Description The DROP temporary tablespace operations take long time and in fact it hangs. If you take a 10046 trace of...
Minimum privilege needed to take data pump export In your organization you may assign a user who is only responsible to take data pump export. Suppose everyday...
EM Daemon is not running On windows whenever I try to start my dbconsole in one time during process it shows me message EM Daemon is not running. Details in...
How to recover or recreate temporary tablespace in 10g In database you may discover that your temporary tablespace is deleted from OS or it might got...
How to clone database on the same host with different name In this post I will show how we can clone database on windows system without using RMAN duplicate....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
