oracle 10.2.0.5 patchset release!
patch id:8202632
oracle 10.2.0.5 patchset release!
May 3rd, 2010expdp over nfs
March 22nd, 2010[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 “/dmpdir/fjdds/cpdds_20100323_01.dmp”
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: unable to create dump file “/dmpdir/fjdds/cpdds_20100323_01.dmp”
ORA-27086: unable to lock file – already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10
数据库版本：
[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
Export: Release 10.2.0.4.0 – 64bit Production on Tuesday, 23 March, 2010 11:19:33
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
unix平台取消os论证
July 27th, 2009$ 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 – 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 – 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 – Production
SQL> show parameter remote_login
NAME TYPE VALUE
———————————— ———– ——————————
remote_login_passwordfile string EXCLUSIVE
$ sqlplus “/ as sysdba”
SQL*Plus: Release 9.2.0.8.0 – Production on Tue Jul 28 10:10:52 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
说明：
在sqlnet.ora文件加上sqlnet.authentication_services=(none)就限制了os论证。
注释这一行后，就可以使用os论证了。
特别指出，针对unix平台有效。