<?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>Różności ... &#187; oracle</title>
	<atom:link href="http://www.jaceksen.pl/wordpress/?feed=rss2&#038;tag=oracle" rel="self" type="application/rss+xml" />
	<link>http://www.jaceksen.pl/wordpress</link>
	<description>czyli moje notki</description>
	<lastBuildDate>Sun, 14 Nov 2021 16:21:49 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.3</generator>
		<item>
		<title>oracle em agent unreachable</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4440</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4440#comments</comments>
		<pubDate>Fri, 11 Dec 2015 17:20:56 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4440</guid>
		<description><![CDATA[&#8211; To implement the solution, please execute the following steps:: 1. Stop the agent 2. Remove all the files from AGENT_HOME/sysman/log/ directory. 3. Backup and edit AGENT_HOME/sysman/config/emd.properties. 4. Add this line: NMUPM_TIMEOUT=120 5. Uncomment: ThreadPoolModel = LARGE 6. start the agent 7. Monitor the performance of the server https://community.oracle.com/message/2558818#2558818]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4440</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>report schema</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4438</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4438#comments</comments>
		<pubDate>Thu, 10 Dec 2015 20:25:11 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4438</guid>
		<description><![CDATA[http://www.dba-oracle.com/t_rman_46_schema_report.htm]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4438</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>srvctl</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4436</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4436#comments</comments>
		<pubDate>Wed, 09 Dec 2015 20:59:40 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4436</guid>
		<description><![CDATA[https://oracleexamples.wordpress.com/2010/01/22/most-used-srvctl-commands/ What is srvctl? it is the Server Control Utility, we use SRVCTL to start and stop the database and instances, manage configuration information, and to add, move or remove instances and services. These are some of the srvctl commands I frequently use, this is not a complete reference guide. I organized the commands as [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4436</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>global cache blocks lost</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4406</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4406#comments</comments>
		<pubDate>Sat, 17 Oct 2015 07:06:51 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[database]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4406</guid>
		<description><![CDATA[global cache blocks lost&#8211;This statistic reveals any block losses during transfers and high values may indicate network problems. When using an unreliable IPC protocol such as UDP, the value for &#8216;global cache blocks lost&#8217; may be non-zero. If this is the case, then the ratio of &#8216;global cache blocks lost&#8217; divided by &#8216;global cache current [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4406</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>grant select on all tables</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4341</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4341#comments</comments>
		<pubDate>Thu, 11 Dec 2014 15:58:52 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4341</guid>
		<description><![CDATA[You could, of course, leverage dynamic SQL, i.e. FOR x IN (SELECT * FROM user_tables) LOOP   EXECUTE IMMEDIATE 'GRANT SELECT ON ' &#124;&#124; x.table_name &#124;&#124; ' TO &#60;&#60;someone&#62;&#62;'; END LOOP; Of course, if you&#8217;re doing this sort of thing, you&#8217;d normally grant the privileges to a role and grant that role to one or [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4341</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Error Opening RPD Online: [nQSError: 46036] Internal Assertion</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4319</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4319#comments</comments>
		<pubDate>Sat, 22 Nov 2014 12:12:52 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4319</guid>
		<description><![CDATA[http://bidirect.blogspot.com/2013/07/error-opening-rpd-online-nqserror-46036.html]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4319</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ora-00604 timezone region not found sql developer</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4281</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4281#comments</comments>
		<pubDate>Fri, 10 Oct 2014 06:06:17 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4281</guid>
		<description><![CDATA[check timezone in your database add following entry do sqldeveloper.conf with appropriate timezone name AddVMOption -Duser.timezone=America/Santiago restart sqldeveloper VOILA!]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4281</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>APEX upgrade</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4253</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4253#comments</comments>
		<pubDate>Mon, 11 Aug 2014 12:20:03 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[ApEx]]></category>
		<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4253</guid>
		<description><![CDATA[http://infotechinspiration.blogspot.com/2010/07/upgrade-oracle-apex-40-in-11g-database.html]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4253</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>datapump expdp impdp</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4247</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4247#comments</comments>
		<pubDate>Mon, 21 Jul 2014 08:33:52 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4247</guid>
		<description><![CDATA[CONN / AS SYSDBA ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK; CREATE OR REPLACE DIRECTORY test_dir AS &#8216;/u01/app/oracle/oradata/&#8217;; GRANT READ, WRITE ON DIRECTORY test_dir TO scott; expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log impdp hr/HR directory=DATADUMP dumpfile=FMC_LOGICAL_VESSELS.DMP remap_schema=VTRACK:HR exclude=index,constraint,grant,trigger expdp user/pass schemas= directory=dumpdir \ dumpfile=.dmp \ logfile=expdp_.log impdp user/pass schemas=schema1 directory=dumpdir \ remap_schema=schema1:schema2 \ dumpfile=schema1.dmp [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4247</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>table to csv</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4244</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4244#comments</comments>
		<pubDate>Thu, 17 Jul 2014 17:19:19 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Linux]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4244</guid>
		<description><![CDATA[#!/usr/bin/bash FILE=&#8221;emp.csv&#8221; sqlplus -s scott/tiger@XE Setting the column separator to &#8220;,&#8221;. With this setting, the list displayed by the SELECT clause will be comma separated. This is the most important setting of this script. SET LINESIZE 200 => The number of characters per line. The default is 80 which means after 80 characters, the rest [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4244</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ovm cdrom boot problem</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4237</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4237#comments</comments>
		<pubDate>Thu, 17 Jul 2014 11:27:42 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>
		<category><![CDATA[OVM]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4237</guid>
		<description><![CDATA[Its funny how things work in Oracle VM .. I made some changes in configuration file and its working for me.. But I think this needs to be corrected. xvdb is replaced with hdc.. Before disk = ['file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/VirtualDisks/0004fb000012000095516dd08c3b253f.img,hda,w', 'file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/ISOs/slampp.iso,xvdb:cdrom,r'] After disk = ['file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/VirtualDisks/0004fb000012000095516dd08c3b253f.img,hda,w', 'file:/OVS/Repositories/0004fb0000030000aa8563ec6175dcfb/ISOs/slampp.iso,hdc:cdrom,r'] I didn&#8217;t upload the iso using OVM managers import option ..Instead [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4237</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle on Solaris 10 : Fixing the &#8216;ORA-27102: out of memory&#8217; Error</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4202</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4202#comments</comments>
		<pubDate>Mon, 02 Jun 2014 20:12:40 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Solaris]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4202</guid>
		<description><![CDATA[https://blogs.oracle.com/mandalika/entry/oracle_on_solaris_10_fixing]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4202</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>vbox snapshot</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4199</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4199#comments</comments>
		<pubDate>Mon, 02 Jun 2014 20:10:02 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4199</guid>
		<description><![CDATA[https://www.virtualbox.org/ticket/7461]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4199</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ASM</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4193</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4193#comments</comments>
		<pubDate>Mon, 02 Jun 2014 16:48:42 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4193</guid>
		<description><![CDATA[http://blog.sina.com.cn/s/blog_4ea0bbed0100zd6d.html http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94156]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4193</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Oracle read consistency.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4103</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4103#comments</comments>
		<pubDate>Tue, 04 Mar 2014 05:44:24 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Programowanie]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4103</guid>
		<description><![CDATA[Read consistency is an automatic implementation. It keeps a partial copy of the database in the undo segments. The read-consistent image is constructed from the committed data in the table and the old data that is being changed and is not yet committed from the undo segment. When an insert, update, or delete operation is [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4103</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>NVL NULL, to_date, to_char</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4027</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4027#comments</comments>
		<pubDate>Wed, 12 Feb 2014 05:47:22 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4027</guid>
		<description><![CDATA[to_char]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4027</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>OVM and VMWare comparison.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4013</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4013#comments</comments>
		<pubDate>Wed, 22 Jan 2014 21:59:52 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4013</guid>
		<description><![CDATA[http://www.oracle.com/us/technologies/virtualization/oraclevm/comparisons/index.html]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4013</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Migrate from vSphere into Oracle VM 3.0</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4010</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4010#comments</comments>
		<pubDate>Wed, 22 Jan 2014 20:49:50 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4010</guid>
		<description><![CDATA[By Steen Schmidt on Dec 06, 2011 I have had so many question &#8220;Can we do an import of vmware VM into Oracle VM 3.0&#8243;, and the answer is yes. But as you properly have found out I like to see how it works. So I just took a vmware image of a Linux converte [...]]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4010</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ORACLE &#8211; archive log mode.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4008</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4008#comments</comments>
		<pubDate>Wed, 22 Jan 2014 19:49:22 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4008</guid>
		<description><![CDATA[SQL&#62; startup mount ORACLE instance started. Total System Global Area 184549376 bytes Fixed Size 1300928 bytes Variable Size 157820480 bytes Database Buffers 25165824 bytes Redo Buffers 262144 bytes Database mounted. SQL&#62; alter database archivelog; Database altered.]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4008</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ORACLE &#8211; Renaming and moving files.</title>
		<link>http://www.jaceksen.pl/wordpress/?p=4006</link>
		<comments>http://www.jaceksen.pl/wordpress/?p=4006#comments</comments>
		<pubDate>Wed, 22 Jan 2014 08:15:55 +0000</pubDate>
		<dc:creator>Jacek</dc:creator>
				<category><![CDATA[Bazy danych]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://www.jaceksen.pl/wordpress/?p=4006</guid>
		<description><![CDATA[http://www.oracle-base.com/articles/misc/renaming-or-moving-oracle-files.php]]></description>
		<wfw:commentRss>http://www.jaceksen.pl/wordpress/?feed=rss2&amp;p=4006</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
