<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Dev&#039;s Weblog</title>
	<atom:link href="http://sysdbaonline.com/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://sysdbaonline.com</link>
	<description>Gateway to your Solution</description>
	<lastBuildDate>Wed, 01 Sep 2010 13:36:00 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9.2</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<item>
		<title>11GR2 Install Fails on Fedora 13</title>
		<link>http://sysdbaonline.com/?p=948</link>
		<comments>http://sysdbaonline.com/?p=948#comments</comments>
		<pubDate>Wed, 01 Sep 2010 13:36:00 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[11G]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=948</guid>
		<description><![CDATA[Reading time: 1 - 2 minutes
Problem:
======
During relinking operation OUI will fail and in $ORACLE_HOME/install/make.log Ayou will find following error.

/u01/app/dev/Middleware/agent11g/lib/libnnz11.so: could not read symbols: Invalid operation
collect2: ld returned 1 exit status
make[1]: *** [/u01/app/dev/Middleware/agent11g/sysman/lib/emdctl] Error 1
make[1]: Leaving directory `/u01/app/dev/Middleware/agent11g/sysman/lib'



Solution:
======

When you start to install with ./runInstaller, run in another terminal window (as root)
ls $ORACLE_HOME/sysman/lib/ins_emagent.mk
At first this will produce [...]]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=948</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Tune slow running query</title>
		<link>http://sysdbaonline.com/?p=905</link>
		<comments>http://sysdbaonline.com/?p=905#comments</comments>
		<pubDate>Fri, 30 Jul 2010 15:16:27 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[sql tuning]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=905</guid>
		<description><![CDATA[Reading time: 3 - 4 minutes
Today happed had a situation where i were called by my client and informed about slow generation of report.
&#160;
Client was using some SQL which was selecting some data from few tables to generate reports.
&#160;
I used the following query to find out how much it used to take in past.
&#160;
set lines [...]]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=905</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Create database silently in oracle</title>
		<link>http://sysdbaonline.com/?p=903</link>
		<comments>http://sysdbaonline.com/?p=903#comments</comments>
		<pubDate>Thu, 22 Jul 2010 09:55:30 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[11G]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[dbca silent]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=903</guid>
		<description><![CDATA[Reading time: < 1 minute
[oracle@db1 ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
[oracle@db1 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@db1 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName orcl.sysdbaonline.com -sysPassword oracle -systemPassword oracle -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS
]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=903</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Trigger SQL_trace automatically</title>
		<link>http://sysdbaonline.com/?p=876</link>
		<comments>http://sysdbaonline.com/?p=876#comments</comments>
		<pubDate>Mon, 12 Jul 2010 13:12:37 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[sql_trace trigger]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=876</guid>
		<description><![CDATA[Reading time: 1 - 2 minutes
Sometimes it is necessary to automatically trigger SQL trace. Automatically here means that code must be added somewhere. 
The simplest approach is to create a logon trigger at the database level. To avoid enabling SQL trace for all users, I usually suggest creating a role (named sqltrace in the following [...]]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=876</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Word press changes apostrophe characters</title>
		<link>http://sysdbaonline.com/?p=869</link>
		<comments>http://sysdbaonline.com/?p=869#comments</comments>
		<pubDate>Thu, 08 Jul 2010 13:47:39 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Wordpress]]></category>
		<category><![CDATA[apostrophes]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=869</guid>
		<description><![CDATA[Reading time: < 1 minute
&#160;
I noticed that wordpress changed all the occurrence of apostrophes in my all posts.
&#160;
I opened the source of page and i found all the apostrophes were changed to &#38;#8216 surprisingly.
&#160;
I had to modify wp-include/default-filters.php file to get my apostrophes working.
&#160;
I had commented out following line.
&#160;
#add_filter( 'the_content', 'wptexturize' ); 

&#160;
after that it [...]]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=869</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Find trace file using session id in oracle</title>
		<link>http://sysdbaonline.com/?p=866</link>
		<comments>http://sysdbaonline.com/?p=866#comments</comments>
		<pubDate>Thu, 08 Jul 2010 13:15:14 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=866</guid>
		<description><![CDATA[Reading time: 1 - 2 minutes
&#160;
Sometimes it becomes very tough to find the relevant oracle trace file using session id in oracle.You can alter your session before setting an event to identify trace file quite easily but following method doesn't require alteration of session.
&#160;
SELECT s.sid,      s.server,     [...]]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=866</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Howto find when table was last updated in Oracle.</title>
		<link>http://sysdbaonline.com/?p=832</link>
		<comments>http://sysdbaonline.com/?p=832#comments</comments>
		<pubDate>Thu, 24 Jun 2010 10:06:26 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=832</guid>
		<description><![CDATA[Reading time: < 1 minute
SQL&#62; select scn_to_timestamp(max(ora_rowscn)) from WRH$_FILESTATXS;

SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
24-JUN-10 11.00.10.000000000 AM

]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=832</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>Howto Change ias_admin password</title>
		<link>http://sysdbaonline.com/?p=826</link>
		<comments>http://sysdbaonline.com/?p=826#comments</comments>
		<pubDate>Wed, 16 Jun 2010 13:51:11 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Apps]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=826</guid>
		<description><![CDATA[Reading time: 2 - 2 minutes
a ias_admin is user required to use Enterprise Manager Web (Application Server Console - iASConsole) Site.
a ias_admin password is set during Installation of Oracle Application Server (902, 904, 10.1.2.X) or Oracle Identity Management (Infra Tier 10.1.4.X)aias_admin account is NOT stored in OID (Oracle Internet Directory), It is stored in XML [...]]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=826</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>DB Link Cloning Script</title>
		<link>http://sysdbaonline.com/?p=807</link>
		<comments>http://sysdbaonline.com/?p=807#comments</comments>
		<pubDate>Fri, 21 May 2010 15:58:16 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=807</guid>
		<description><![CDATA[Reading time: < 1 minute

SELECT
'create '&#124;&#124;DECODE(U.NAME,'PUBLIC','public ')&#124;&#124;'database link '&#124;&#124;CHR(10)
&#124;&#124;DECODE(U.NAME,'PUBLIC',Null, U.NAME&#124;&#124;'.')&#124;&#124; L.NAME&#124;&#124;chr(10)
&#124;&#124;'connect to ' &#124;&#124; L.USERID &#124;&#124; ' identified by '''
&#124;&#124;L.PASSWORD&#124;&#124;''' using ''' &#124;&#124; L.host &#124;&#124; ''''
&#124;&#124;chr(10)&#124;&#124;';' TEXT
FROM sys.link$ L,
sys.user$ U
WHERE L.OWNER# = U.USER# ;


]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=807</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Clone Database Structure</title>
		<link>http://sysdbaonline.com/?p=803</link>
		<comments>http://sysdbaonline.com/?p=803#comments</comments>
		<pubDate>Fri, 14 May 2010 14:59:58 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://sysdbaonline.com/?p=803</guid>
		<description><![CDATA[Reading time: < 1 minute
exp system/oracle file=structure.dmp full=y rows=n

Open the structure.dmp and you will have definitions for all the objects of the database.
]]></description>
		<wfw:commentRss>http://sysdbaonline.com/?feed=rss2&amp;p=803</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
