<?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>think</title>
	<atom:link href="http://nolog.cn/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://nolog.cn</link>
	<description>Just another WordPress weblog</description>
	<lastBuildDate>Mon, 03 May 2010 12:57:06 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.1</generator>
		<item>
		<title>oracle 10.2.0.5 patchset release!</title>
		<link>http://nolog.cn/?p=49</link>
		<comments>http://nolog.cn/?p=49#comments</comments>
		<pubDate>Mon, 03 May 2010 12:57:06 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://nolog.cn/?p=49</guid>
		<description><![CDATA[oracle 10.2.0.5 patchset release! patch id:8202632]]></description>
			<content:encoded><![CDATA[<p>oracle 10.2.0.5 patchset release!<br />
patch id:8202632<br />
<a href="http://nolog.cn/wp-content/uploads/2010/05/8202632.jpg"><img class="aligncenter size-full wp-image-50" title="8202632" src="http://nolog.cn/wp-content/uploads/2010/05/8202632.jpg" alt="" width="284" height="311" /></a></p>
]]></content:encoded>
			<wfw:commentRss>http://nolog.cn/?feed=rss2&amp;p=49</wfw:commentRss>
		<slash:comments>2</slash:comments>
		</item>
		<item>
		<title>expdp over nfs</title>
		<link>http://nolog.cn/?p=45</link>
		<comments>http://nolog.cn/?p=45#comments</comments>
		<pubDate>Tue, 23 Mar 2010 03:33:00 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[oracle]]></category>
		<category><![CDATA[expdp nfs]]></category>

		<guid isPermaLink="false">http://nolog.cn/?p=45</guid>
		<description><![CDATA[[root@fjdds ~]# mount -t nfs -o hard,bg,proto=tcp,vers=3,suid,rsize=32768,wsize=32768,intr,noac,timeo=600,nolock 10.214.0.79:/nas/nasvg2/nasvg2 /dmpdir 请注意mount option，不然报错， 报错1： ORA-39000: bad dump file specification ORA-31641: unable to create dump file &#8220;/dmpdir/fjdds/cpdds_20100323_01.dmp&#8221; ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 3 报错2: ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: [...]]]></description>
			<content:encoded><![CDATA[<p>[root@fjdds ~]# mount -t nfs -o hard,bg,proto=tcp,vers=3,suid,rsize=32768,wsize=32768,intr,noac,timeo=600,nolock 10.214.0.79:/nas/nasvg2/nasvg2 /dmpdir</p>
<p>请注意mount option，不然报错，</p>
<p>报错1：<br />
ORA-39000: bad dump file specification<br />
ORA-31641: unable to create dump file &#8220;/dmpdir/fjdds/cpdds_20100323_01.dmp&#8221;<br />
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options<br />
Additional information: 3</p>
<p>报错2:<br />
ORA-39001: invalid argument value<br />
ORA-39000: bad dump file specification<br />
ORA-31641: unable to create dump file &#8220;/dmpdir/fjdds/cpdds_20100323_01.dmp&#8221;<br />
ORA-27086: unable to lock file &#8211; already in use<br />
Linux-x86_64 Error: 37: No locks available<br />
Additional information: 10</p>
<p>数据库版本：</p>
<p>[oracle@fjdds fjdds]$ expdp system directory=dmpdir dumpfile=cpdds_201003230_%U filesize=4G schemas=(cpdds,cpdds_etl,cpdds_pdata) logfile=cpdds_201003230.log parallel=4</p>
<p>Export: Release 10.2.0.4.0 &#8211; 64bit Production on Tuesday, 23 March, 2010 11:19:33</p>
<p>Copyright (c) 2003, 2007, Oracle.  All rights reserved.<br />
Password:</p>
<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 &#8211; 64bit Production<br />
With the Partitioning, OLAP, Data Mining and Real Application Testing options</p>
]]></content:encoded>
			<wfw:commentRss>http://nolog.cn/?feed=rss2&amp;p=45</wfw:commentRss>
		<slash:comments>4</slash:comments>
		</item>
		<item>
		<title>unix平台取消os论证</title>
		<link>http://nolog.cn/?p=7</link>
		<comments>http://nolog.cn/?p=7#comments</comments>
		<pubDate>Tue, 28 Jul 2009 02:13:36 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[oracle]]></category>

		<guid isPermaLink="false">http://nolog.cn/?p=7</guid>
		<description><![CDATA[$ cat sqlnet.ora TCP.nodelay=yes TCP.validnode_checking=yes TCP.invited_nodes=(192.168.100.11,192.168.100.12) sqlnet.authentication_services=(none) $ sqlplus SQL*Plus: Release 9.2.0.8.0 &#8211; Production on Tue Jul 28 10:09:32 2009 Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 &#8211; 64bit Production With the Partitioning, OLAP and Oracle Data Mining options [...]]]></description>
			<content:encoded><![CDATA[<p>$ cat sqlnet.ora<br />
TCP.nodelay=yes<br />
TCP.validnode_checking=yes<br />
TCP.invited_nodes=(192.168.100.11,192.168.100.12)<br />
sqlnet.authentication_services=(none)<br />
$ sqlplus</p>
<p>SQL*Plus: Release 9.2.0.8.0 &#8211; Production on Tue Jul 28 10:09:32 2009</p>
<p>Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.</p>
<p>Enter user-name: sys as sysdba<br />
Enter password:</p>
<p>Connected to:<br />
Oracle9i Enterprise Edition Release 9.2.0.8.0 &#8211; 64bit Production<br />
With the Partitioning, OLAP and Oracle Data Mining options<br />
JServer Release 9.2.0.8.0 &#8211; Production</p>
<p>SQL&gt;  show parameter remote_login    </p>
<p>NAME                                 TYPE        VALUE<br />
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br />
remote_login_passwordfile            string      EXCLUSIVE</p>
<p>$ sqlplus &#8220;/ as sysdba&#8221;</p>
<p>SQL*Plus: Release 9.2.0.8.0 &#8211; Production on Tue Jul 28 10:10:52 2009</p>
<p>Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.</p>
<p>ERROR:<br />
ORA-01031: insufficient privileges<br />
Enter user-name:</p>
<p>说明：<br />
在sqlnet.ora文件加上sqlnet.authentication_services=(none)就限制了os论证。<br />
注释这一行后，就可以使用os论证了。<br />
特别指出，针对unix平台有效。</p>
]]></content:encoded>
			<wfw:commentRss>http://nolog.cn/?feed=rss2&amp;p=7</wfw:commentRss>
		<slash:comments>2</slash:comments>
		</item>
	</channel>
</rss>
