:::互联网信息技术研究中心:::

十一月 16th, 2012

ORACLE 数据库11gR2版本号11.2.0.3 patch下载地址

第一，二个包表示database , 如果升级数据库，只需要这2个文件即可。
第三个包表示grid, 用来升级RAC 的CRS。如果升级RAC 要先用这个文件。
第四个表示客户端，
第五个表示gateways,
第六个表示 examples, 这个是我们的示例文件安装包。
第七个表示deinstall

以此类推
Oracle 11.2.0.3 patch for Linux x64 :
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_1of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_2of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_3of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_3of7.zip

Oracle 11.2.0.3 patch for windows 64:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_1of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_2of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_3of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_3of7.zip

Oracle 11.2.0.3 patch for AIX:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_1of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_2of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_3of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_3of7.zip

Oracle 11.2.0.3 patch for HP IA64:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_1of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_2of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_3of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_3of7.zip

Oracle 11.2.0.3 patch for HP PA-RISC 64:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_1of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_1of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_2of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_2of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_3of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_3of6.zip

Oracle 11.2.0.3 patch for Solaris x64：
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_1of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_1of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_2of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_2of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_3of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_3of6.zip

Oracle 11.2.0.3 patch for Solaris x86：
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solarisx86_1of2.zip?aru=14152437&patch_file=p10404530_112030_Solarisx86_1of2.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solarisx86_2of2.zip?aru=14152437&patch_file=p10404530_112030_Solarisx86_2of2.zip

Oracle 11.2.0.3 patch for Solaris SPARC X64：
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_1of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_2of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_3of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_3of7.zip

Oracle 11.2.0.3 patch for Solaris SPARC x86：
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS_1of2.zip?aru=14152484&patch_file=p10404530_112030_SOLARIS_1of2.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS_2of2.zip?aru=14152484&patch_file=p10404530_112030_SOLARIS_2of2.zip

十一月 16th, 2012

ORACLE 数据库10gR2版本号10.2.0.5 patch下载地址

已关闭评论, 数据库试用下载推荐, by 小哥.

Oralce 10205最终版

oracle 10.2.0.5 patch下载地址:

p8202632_10205_WINNT.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch22/PLATFORM/CORE/WINNT/R80102050/p8202632_10205_WINNT.zip?params=MkFFYkUrSzd3cFZUOUIyK2Z3YVplZzphcnU9MTI3Njk5NjgmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMxMzg2NTgxJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfV0lOTlQuemlwJnVzZXJpZD1vLWNud3g2OEBtb3Rvcm9sYS5jb20mc2l6ZT0xMDg1MjQwOTA0JmNvbnRleHQ9QUAxMCtIQGFhcnUyMDMub3JhY2xlLmNvbStQQA%40%40&e=1292124692&h=6c06b185195c01c44f1a21435c565f81

p8202632_10205_LINUX.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch22/PLATFORM/CORE/LINUX/R80102050/p8202632_10205_LINUX.zip?params=ZHlzVXpCcWNSaXl0Si82S0piYUJDZzphcnU9MTI3OTQyMzImZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwMzExODQ5JnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfTElOVVguemlwJnVzZXJpZD1vLWNud3g2OEBtb3Rvcm9sYS5jb20mc2l6ZT0xMTAzOTkyOTAwJmNvbnRleHQ9QUAxMCtIQGFhcnUyMDUub3JhY2xlLmNvbStQQA%40%40&e=1292124723&h=6fdd0a32d3a2bd00d29a805fabc1745c

p8202632_10205_AIX64-5L_1of2.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/AIX5L/R80102050/p8202632_10205_AIX64-5L_1of2.zip?params=S0lUdG85UXhMTWlHUFZWWWlqYXJuUTphcnU9MTI2NTM3OTEmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwNjIwMTUxJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfQUlYNjQtNUxfMW9mMi56aXAmdXNlcmlkPW8tY253eDY4QG1vdG9yb2xhLmNvbSZzaXplPTExOTkyNzgxMDcmY29udGV4dD1BQDEwK0hAYWFydTIwMi5vcmFjbGUuY29tK1BA&e=1292124826&h=97d76b457d555092e15d99e5da82e24c

p8202632_10205_AIX64-5L_2of2.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/AIX5L/R80102050/p8202632_10205_AIX64-5L_2of2.zip?params=Zk5hUDV5ZkJGV1FRZ3ZWSWdhNGliUTphcnU9MTI2NTM3OTEmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwNjIwMTYwJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfQUlYNjQtNUxfMm9mMi56aXAmdXNlcmlkPW8tY253eDY4QG1vdG9yb2xhLmNvbSZzaXplPTgwNDQ0NTg5MyZjb250ZXh0PUFAMTArSEBhYXJ1MjA1Lm9yYWNsZS5jb20rUEA%40&e=1292124839&h=acdcd345199e1dade5a374bd1d272a00

p8202632_10205_Linux-x86-64.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/Linux-x86-64/R80102050/p8202632_10205_Linux-x86-64.zip?params=UlZPbFZSMlBFVVVyRWt1dldva3hjUTphcnU9MTI1NDA4MjQmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwMzAxODQzJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTI0OTg1Nzg2NiZjb250ZXh0PUFAMTArSEBhYXJ1MjAzLm9yYWNsZS5jb20rUEA%40&e=1292124852&h=3e16aa21f55a3b257d06fc462b94eeeb

p8202632_10205_Solaris86-64.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/Solaris86-64/R80102050/p8202632_10205_Solaris86-64.zip?params=UzdHNGs4NWJCTDg5WVVsOVd2TGlyUTphcnU9MTI2MDU0NjgmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwNDg0NjcxJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfU29sYXJpczg2LTY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTI1NTIyODc2OCZjb250ZXh0PUFAMTArSEBhYXJ1MjA0Lm9yYWNsZS5jb20rUEA%40&e=1292124867&h=12de42504f5150d5fb11da165d2a3ab4

p8202632_10205_SOLARIS64.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch22/PLATFORM/CORE/SOLARIS64/R80102050/p8202632_10205_SOLARIS64.zip?params=eHg3UFFlZmJjYUwzQmRYZHRrNjd5dzphcnU9MTI2MDU1ODImZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwNDg1NzQ5JnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfU09MQVJJUzY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTMyMDcyODQ3MSZjb250ZXh0PUFAMTArSEBhYXJ1MjA1Lm9yYWNsZS5jb20rUEA%40&e=1292124894&h=8a4c41c04fd60d516856780b41acad27

p8202632_10205_HPUX-IA64.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/HPUX-IA64/R80102050/p8202632_10205_HPUX-IA64.zip?params=OG9qL0o5KzNJck9rU243bGxlbzVBQTphcnU9MTI2NTI4OTUmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMwNjE1MjI4JnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfSFBVWC1JQTY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTgzMTE0NjU3MiZjb250ZXh0PUFAMTArSEBhYXJ1MjAyLm9yYWNsZS5jb20rUEA%40&e=1292124908&h=8cb57fbbea93554e025c41d6bdd37f2b

p8202632_10205_MSWIN-x86-64.zip
http://aru-llnw-dl.oracle.com/aaruna03/vol/patch26/PLATFORM/CORE/MSWIN-x86-64/R80102050/p8202632_10205_MSWIN-x86-64.zip?params=MHY2QU5aSXZ0UXBPMitkYWtveklEUTphcnU9MTI3OTExNjgmZW1haWw9Y253eDY4QG1vdG9yb2xhLmNvbSZmaWxlX2lkPTMxNTc4MzczJnBhdGNoX2ZpbGU9cDgyMDI2MzJfMTAyMDVfTVNXSU4teDg2LTY0LnppcCZ1c2VyaWQ9by1jbnd4NjhAbW90b3JvbGEuY29tJnNpemU9MTE2MjQ4MTkzOCZjb250ZXh0PUFAMTArSEBhYXJ1MjAyLm9yYWNsZS5jb20rUEA%40&e=1292124919&h=321034feb75f02a8cbaf66ba8dc5a83b

十一月 13th, 2012

ORACLE 数据库9iR2版本号9.2.0.8 patch下载地址

已关闭评论, 数据库试用下载推荐, by 小哥.

Oracle 9208最终版

九月 26th, 2012

Visual Studio 2012 旗舰版试用 ISO 镜像下载（附测试用序列号）

已关闭评论, 应用程序试用下载推荐, by 小哥.

概述

Visual Studio Ultimate 2012 是一个最先进的开发解决方案，它使各种规模的团队能够设计和创

建出使用户欣喜的引人注目的应用程序。您可以使用灵活敏捷的规划工具（如容量规划、任务板和

积压工作管理）来按照您自己的进度实现增量开发技术和敏捷方法。使用高级建模、发现和体系结

构工具可描述您的系统并帮助确保实现您的体系结构构想。通过使用生产中的 IntelliTrace、

Operations Manager Connector 和 Preemptive Analytics，使开发团队和运营团队能够很好地协

作。通过从部署的软件生成可对其采取措施的 Bug 来改进质量和减少解决时间，让运营人员高效

协作以提供使开发人员能够深入了解生产问题的数据。

简而言之，您可以创建创新的高质量解决方案并降低开发成本。
返回页首返回页首
系统要求

支持的操作系统： Windows 7 Service Pack 1, Windows 8, Windows Server 2008 R2 SP1,
Windows Server 2012
Windows 7 SP1（x86 和 x64）
Windows 8（x86 和 x64）
Windows Server 2008 R2 SP1 (x64)
Windows Server 2012 (x64)

下载地址：http://download.microsoft.com/download/B/0/F/B0F589ED-F1B7-478C-849A-02C8395D0995/VS2012_ULT_chs.iso

– Microsoft Visual Studio Ultimate 2012 旗舰版有效注册密钥：
YKCW6-BPFPF-BT8C9-7DCTH-QXGWC

– Microsoft Visual Studio Premium 2012 高级版有效注册密钥：
MH2FR-BC9R2-84433-47M63-KQVWC

– Microsoft Visual Studio Professional 2012 专业版有效注册密钥：
4D974-9QX42-9Y43G-YJ7JG-JDYBP

–提供的旗舰版是试用版，可以用这个KEY：
RBCXF-CVBGR-382MK-DFHJ4-C69G8

八月 17th, 2012

作为一个DBA交接ORACLE数据库时需要了解的内容

已关闭评论, 数据库问题解决方案, by 小哥.

1、先要了解当前的Oracle 数据库的版本和平台和相关信息
这个很重要，忙乎了半天还知道你的数据库是哪个版本，跑在什么系统上，那岂不是很悲哀，所以我个人认为这是第一步需要了解的。下面的这些脚本可以帮助你获取你需要的相关信息。
select * from v$version;
select * from dba_registry_database;
select dbid, name, open_mode, database_role, platform_name from v$instance;
select dbms_utility.port_string from dual;

set serveroutput on
declare
ver VARCHAR2(100);
compat VARCHAR2(100);
begin
dbms_utility.db_version(ver, compat);
dbms_output.put_line(‘Version: ‘ || ver ||’ Compatible: ‘ || compat);
end;
/
2、其次要了解你的数据库中装了哪些组件
select * from dba_registry;
　
3、搞清楚这个环境是单机还是集群？
这个判断方法很多，我这里给出一个借助dbms_utility来判断的方法。
set serveroutput on

declare
inst_tab dbms_utility.instance_table;
inst_cnt NUMBER;
begin
if dbms_utility.is_cluster_database then
dbms_utility.active_instances(inst_tab, inst_cnt);
dbms_output.put_line(‘-‘ || inst_tab.FIRST);
dbms_output.put_line(TO_CHAR(inst_cnt));
else
dbms_output.put_line(‘Not A Clustered Database’);
end if;
end;
/
4、是否配置了DataGuard?
select protection_mode, protection_level, remote_archive, database_role, dataguard_broker,guard_status
from v$database;
5、是否起用了归档模式？
conn /as sysdba
archive log list;
select log_mode from v$database;
　
6、是否起用了flashback database特性？
select flashback_on from v$database;
如果是，再进一步查看FRA的配置情况
7、是否起用了force logging和补充日志？
select force_logging,supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui,
supplemental_log_data_fk, supplemental_log_data_all
from v$database;
8、了解控制文件的组成
select * from v$controlfile;
9、了解日志文件的组成
select l.group#, lf.type, lf.member, l.bytes, l.status LOG_STATUS, lf.status LOGFILE_STATUS
from v$log l, v$logfile lf
where l.group# = lf.group#
order by 1,3;
10、了解参数文件的组成和位置
show parameter spfile
create spfile from pfile…
create pfile from spfile;
create spfile from memory;
create pfile from memory;
11、了解instance的相关信息
select instance_name, host_name, status, archiver, database_status, instance_role, active_state
from v$instance;
12、用户和密码相关
是否使用了缺省密码？
是否使用了profile?
是否起用了密码验证函数？
用户身份验证的方法？
密码是否区分大小写等。
select name, value from gv$parameter where name = ‘resource_limit’;
select profile, resource_name, limit from dba_profiles order by 1,2;

select username, profile from dba_users where account_status = ‘OPEN’ order by 1;
　
select d.username, u.account_status
from dba_users_with_defpwd d, dba_users u
where d.username = u.username and account_status = ‘OPEN’
order by 2,1;
　
13、是否打开了BLOCK CHANGE TRACKING
select filename, status, bytes from v$block_change_tracking;
14、起用了那些特性(Feature)?
DBMS_FEATURE_USAGE_REPORT
　
15、表空间和数据文件的规划
这个大家都很熟悉，就不写了
　
16、字符集相关
select * from database_properties;
　
17、系统中是否存在invalid对象
select owner, object_type, COUNT(*)
from dba_objects
where status = ‘INVALID’
group by owner, object_type;
18、更进一步的
是否使用了ASM？
当前系统的备份方法和策略是什么？
网络文件的配置是如何的？
　
19、查看一下最近的alert日志，获取一些有用的信息
20、跑几个性能分析报告，看看最近系统的运行状态如何
21、跑一个RDA报告，收集完整的系统状态报告

:::互联网信息技术研究中心:::

十一月 16th, 2012

ORACLE 数据库11gR2版本号11.2.0.3 patch下载地址

十一月 16th, 2012

ORACLE 数据库10gR2版本号10.2.0.5 patch下载地址

十一月 13th, 2012

ORACLE 数据库9iR2版本号9.2.0.8 patch下载地址

九月 26th, 2012

Visual Studio 2012 旗舰版试用 ISO 镜像下载（附测试用序列号）

八月 17th, 2012

作为一个DBA交接ORACLE数据库时需要了解的内容

日历

分类目录

最新文章

友情链接

分类目录

最新文章

2024年十月
一	二	三	四	五	六	日
« 10月
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31