<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>dbazone</title>
	<link>http://www.dbazone.in</link>
	<description>knowledge sharing on Oracle Database Administration</description>
	<lastBuildDate>Sat, 04 Sep 2010 12:45:16 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.0.1" -->

	<item>
		<title>Useful UNIX command for oracle dba</title>
		<description><![CDATA[1).To find the top 10 larger files in the Directory $ls -lrt &#124; awk &#8216;{print $5,$9}&#8217; &#124; sort -nr head &#124; xargs ls -lrt 2) To find the access and Modification details of a file $istat *This command is available for AIX only 3).To remove file which are older then say 7 days $find . [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=892' rel='bookmark' title='Permanent Link: Kill Oracle process from UNIX server'>Kill Oracle process from UNIX server</a> <small>In some scenarios , my database may be hung and...</small></li>
<li><a href='http://www.dbazone.in/?p=853' rel='bookmark' title='Permanent Link: Configuring Kernel Parameters for Oracle database server'>Configuring Kernel Parameters for Oracle database server</a> <small>Impacts of  kernel parameter on oracle server ? On SGA(Shared...</small></li>
<li><a href='http://www.dbazone.in/?p=366' rel='bookmark' title='Permanent Link: Oracle Installation'>Oracle Installation</a> <small>One of the most important duties of an Oracle DBA...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1074</link>
			</item>
	<item>
		<title>SQL Tracing</title>
		<description><![CDATA[We can enable SQL Tracing at different levels of database operations. Following sections of this document describes the different procedures to enable the SQL Tracing. Enable at the database level SQL&#62;ALTER SYSTEM SET sql_trace = true SCOPE=MEMORY; &#8211; to enable SQL&#62;ALTER SYSTEM SET sql_trace = false SCOPE=MEMORY; &#8211; to disable Alternately  we can configure the  [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=896' rel='bookmark' title='Permanent Link: Killing Oracle Sessions'>Killing Oracle Sessions</a> <small>There are different ways to kill oracle sessions From  SQL*PLUS...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1071</link>
			</item>
	<item>
		<title>Configuring Kernel Parameters for Oracle database server</title>
		<description><![CDATA[Impacts of  kernel parameter on oracle server ? On SGA(Shared Global area) on oracle server Impacts on the total number of users and files in the database Impacts the number of users and the ability to use some optional features. To see all kernel parameters value on your system . execute the following command. su [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=403' rel='bookmark' title='Permanent Link: Oracle Initialization Parameters'>Oracle Initialization Parameters</a> <small>On startup of Oracle database instance,Oracle reads Initialization Parameters stored...</small></li>
<li><a href='http://www.dbazone.in/?p=207' rel='bookmark' title='Permanent Link: Initialization Parameters in Oracle'>Initialization Parameters in Oracle</a> <small>On startup of Oracle database instance,Oracle reads Initialization Parameters stored...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=853</link>
			</item>
	<item>
		<title>ORA-01078: failure in processing system parameters</title>
		<description><![CDATA[SQL&#62; startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file &#8216;D:\\ORACLE\\PRODUCT\\10.2.0\\DB_1\\DATABASE\\INITORCL.ORA&#8217; SQL&#62; create pfile from spfile=&#8217;D:\\oracle\\product\\10.2.0\\db_1\\dbs\\SPFILEORCL.ora&#8217; ; File created. SQL&#62; startup ORACLE instance started. Total System Global Area  612368384 bytes Fixed Size                  1250452 bytes Variable Size             197135212 bytes Database Buffers          411041792 bytes Redo Buffers                2940928 bytes Database mounted. Database opened. SQL&#62; [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=1049' rel='bookmark' title='Permanent Link: ORA-12638: Credential retrieval failed'>ORA-12638: Credential retrieval failed</a> <small>Today while I am going to startup my database ,...</small></li>
<li><a href='http://www.dbazone.in/?p=786' rel='bookmark' title='Permanent Link: Recover database when all control file and Redo log files are lost'>Recover database when all control file and Redo log files are lost</a> <small>As an Oracle DBA , Recover database and maintain high...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1051</link>
			</item>
	<item>
		<title>ORA-12638: Credential retrieval failed</title>
		<description><![CDATA[Today while I am going to startup my database , I found the following error SQL&#62; startup ORA-12638: Credential retrieval failed I have edited the sqlnet.ora file and modified the same as follows Before &#8211; SQLNET.AUTHENTICATION_SERVICES= (NTS) After &#8211; SQLNET.AUTHENTICATION_SERVICES= (NONE) After modification , I perform the following operation to bring the database open SQL&#62; [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=1051' rel='bookmark' title='Permanent Link: ORA-01078: failure in processing system parameters'>ORA-01078: failure in processing system parameters</a> <small>SQL&gt; startup ORA-01078: failure in processing system parameters LRM-00109: could...</small></li>
<li><a href='http://www.dbazone.in/?p=786' rel='bookmark' title='Permanent Link: Recover database when all control file and Redo log files are lost'>Recover database when all control file and Redo log files are lost</a> <small>As an Oracle DBA , Recover database and maintain high...</small></li>
<li><a href='http://www.dbazone.in/?p=116' rel='bookmark' title='Permanent Link: The Oracle Instance'>The Oracle Instance</a> <small>When Oracle database started, a memory structure, called the System...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1049</link>
			</item>
	<item>
		<title>Oracle database Logical and Physical Backups</title>
		<description><![CDATA[Oracle database backup is an important role for oracle DBA. Physical Backups Oracle database physical backup includes of backing up the  physical files as Datafiles Archived redo logs Control files Network files (tnsnames.ora,listener.ora,sqlnet.ora) Parameter file Physical backups are made on the disk or on the tape devices. Logical Backups Oracle database logical backup made using [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=430' rel='bookmark' title='Permanent Link: Oracle database backup'>Oracle database backup</a> <small>Database backup is a primary goal of an Oracle DBA...</small></li>
<li><a href='http://www.dbazone.in/?p=121' rel='bookmark' title='Permanent Link: Oracle database Logical structures'>Oracle database Logical structures</a> <small>Oracle logical structures includes oracle data blocks, extents, segments and...</small></li>
<li><a href='http://www.dbazone.in/?p=119' rel='bookmark' title='Permanent Link: Physical structure of oracle database'>Physical structure of oracle database</a> <small>The physical structure of Oracle database consists following files: One...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1045</link>
			</item>
	<item>
		<title>Monitoring background Jobs on UNIX systems</title>
		<description><![CDATA[To monitor background jobs on UNIX, you can use the following commands : jobs ps jobs command jobs command will list all the jobs running in the background as follows: [1]  &#8211; 12427 Running              test.pl [2]  + 12540 Stopped            myprog.pl The value within “[]” is the job number. By this number you can control our [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=1035' rel='bookmark' title='Permanent Link: Controling jobs on UNIX systems'>Controling jobs on UNIX systems</a> <small>UNIX  job monitoring and control facilities allows you to monitor...</small></li>
<li><a href='http://www.dbazone.in/?p=1031' rel='bookmark' title='Permanent Link: Background jobs on Unix impact on System Performance'>Background jobs on Unix impact on System Performance</a> <small>Is your background jobs on Unix impact on System Performance?...</small></li>
<li><a href='http://www.dbazone.in/?p=892' rel='bookmark' title='Permanent Link: Kill Oracle process from UNIX server'>Kill Oracle process from UNIX server</a> <small>In some scenarios , my database may be hung and...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1038</link>
			</item>
	<item>
		<title>Controling jobs on UNIX systems</title>
		<description><![CDATA[UNIX  job monitoring and control facilities allows you to monitor the jobs executed on background and bring the jobs on foreground . Here I like to  described different command used to control your jobs on background as well as foreground. Commands to control your jobs on UNIX systems jobs -  This command check the status [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=1038' rel='bookmark' title='Permanent Link: Monitoring background Jobs on UNIX systems'>Monitoring background Jobs on UNIX systems</a> <small>To monitor background jobs on UNIX, you can use the...</small></li>
<li><a href='http://www.dbazone.in/?p=1031' rel='bookmark' title='Permanent Link: Background jobs on Unix impact on System Performance'>Background jobs on Unix impact on System Performance</a> <small>Is your background jobs on Unix impact on System Performance?...</small></li>
<li><a href='http://www.dbazone.in/?p=896' rel='bookmark' title='Permanent Link: Killing Oracle Sessions'>Killing Oracle Sessions</a> <small>There are different ways to kill oracle sessions From  SQL*PLUS...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1035</link>
			</item>
	<item>
		<title>Background jobs on Unix impact on System Performance</title>
		<description><![CDATA[Is your background jobs on Unix impact on System Performance? Yes, but it depends upon the priority of the job and how much RAM they require to run. Large jobs like  you are downloading a huge file from the web, can consume immense amount of RAM which can be very painful for your system performance [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=1038' rel='bookmark' title='Permanent Link: Monitoring background Jobs on UNIX systems'>Monitoring background Jobs on UNIX systems</a> <small>To monitor background jobs on UNIX, you can use the...</small></li>
<li><a href='http://www.dbazone.in/?p=1035' rel='bookmark' title='Permanent Link: Controling jobs on UNIX systems'>Controling jobs on UNIX systems</a> <small>UNIX  job monitoring and control facilities allows you to monitor...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1031</link>
			</item>
	<item>
		<title>Clone production database</title>
		<description><![CDATA[Database cloning is a procedure to create an exact copy of a database. As an oracle DBA,you  have to update test or development environments from production database using database cloning procedure. Following is the steps to clone oracle database. 1. Take a copy of the production database&#8217;s initialization file . 2. Take a backup of [...]


Related posts:<ol><li><a href='http://www.dbazone.in/?p=412' rel='bookmark' title='Permanent Link: Create Oracle Database Manually'>Create Oracle Database Manually</a> <small>As being an Oracle DBA , we can create database...</small></li>
<li><a href='http://www.dbazone.in/?p=786' rel='bookmark' title='Permanent Link: Recover database when all control file and Redo log files are lost'>Recover database when all control file and Redo log files are lost</a> <small>As an Oracle DBA , Recover database and maintain high...</small></li>
<li><a href='http://www.dbazone.in/?p=366' rel='bookmark' title='Permanent Link: Oracle Installation'>Oracle Installation</a> <small>One of the most important duties of an Oracle DBA...</small></li>
</ol>

Related posts brought to you by <a href='http://mitcho.com/code/yarpp/'>Yet Another Related Posts Plugin</a>.]]></description>
		<link>http://www.dbazone.in/?p=1028</link>
			</item>
</channel>
</rss>
