ORACLE µÄ²¹¶¡ÏÂÔØµØÖ· (ת)
oracle²¹¶¡ÏÂÔØ
¹Ø¼ü×Ö: oracle
9.2.0.4 = 3095277
9.2.0.5 = 3501955
9.2.0.6 = 3948480
9.2.0.7 = 4163445
9.2.0.8 = 4547809£¨9i×îÖÕ£©
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189
ÏÂÔØ²¹¶¡Ê±£¬¿É½øÈëcmd£¬Ê¹ÓÃftpÃüÁîÖ±½ÓµÇÂ¼ÍøÕ¾ÏÂÔØ¡£Ïàͬ°æ±¾£¬Õë¶Ô²»Í¬µÄ²Ù×÷ϵͳ£¬»áÓв»
ͬµÄ²¹¶¡¡£Ã¿¸ö²¹¶¡´óСԼÔÚ500MB~1.3GBÖ®¼ä¡£ÏÂÃæÒÔoracle 10.2.0.2 ²¹¶¡ÎªÀý£º
ftp updates.oracle.com
user metalib_user ÊäÈëÃÜÂë
cd 4547817
dir
p4547817_10202_AIX64-5L.zip
p4547817_10202_HP64.zip
p4547817_10202_HPUX-IA64.zip
p4547817_10202_LINUX.zip
p4547817_10202_Linux-IA64.zip
p4547817_10202_Linux-x86-64.zip
p4547817_10202_MVS.zip
p4547817_10202_SOLARIS.zip
p4547817_10202_SOLARIS64.zip
p4547817_10202_WINNT.zip
p4547817_10202_WINNT64.zip
ʹÓÃmgetÃüÁîÏÂÔØ¼´¿É¡£
½áºÏѸÀ×,¿ÉÒÔÈ¡µÃʰ빦±¶µÄЧ¹û,Á´½ÓÈçÏ£º
oracle 9206 patchset:
ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HPUX-IA64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip
ftp://updates.oracle.com/3948480/p3948480_9206_Linux-x86-64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_MVS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_TRU64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT64.zip
oracle 9207patch set:
ftp://updates.oracle.com/4163445/p4163445_92070_AIX64-5L.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HP64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HPUX-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip
ftp://updates.oracle.com/4163445/p4163445_92070_Linux-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_
Ïà¹ØÎĵµ£º
1¡¢ÐÞ¸ÄOracle×î´óÁ¬½ÓÊýµÄ·½·¨
a¡¢ÒÔsysdbaÉí·ÝµÇ½PL/SQL »òÕß Worksheet
b¡¢²éѯĿǰÁ¬½ÓÊý
show parameter processes;
c¡¢¸ü¸ÄϵͳÁ¬½ÓÊý
alter system set processes=1000 scope=spfile;
......
н¨Îļþϵͳ
crfs -v jfs -g rootvg -m /arch -a \ size=32768 -a frag=512 -a nbpi=8192 Ò²¿ÉÒÔ smit¡£
¿ªÆô¹éµµÄ£Ê½
$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 10 13:38 ......
//ʹÓÃ×Ô¶¨Ò庯Êý¶¨ÒåÈÕÆÚ¸ñʽ
to_date('1982-11-11','yyyy-mm-dd')
to_date('1982/11/11','yyyy/mm/dd')
//Ï£ÍûÔ±¹¤scottµÄ¸Ú룬¹¤×Ê£¬²¹ÖúÓësmithÔ±¹¤Ò»Ñù
update emp set (job,sal,comm)=(select job,sal,comm from emp where ename='SMITH') where ename='SCOTT';
||------- javaʹÓÃoracle &nbs ......
ÍÆ¼öcrs°æ±¾¸ßÓÚdb°æ±¾
If you also plan to apply this patch to Oracle Clusterware,
ensure that you apply the patch to Oracle Clusterware before
applying it to Oracle Database. This is because Oracle Clusterware
hould always be at the same or later version as the database.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......
1.oracle»·¾³
create table test
(
id number(4),
name varchar2(20)
)
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯû±»×èÈû
2.sqlserver»·¾³
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯ±»×èÈû(Ê ......