Posts By: Eric

Easy way to install Oracle Database on Oracle Linux

Posted by & filed under install.

Overview Oracle is pleased to announce the general availability of the Oracle RDBMS Server 11gR2 Pre-Install RPM for Oracle Linux 6 x86_64 (64 Bit) architecture. This package replaces the previous Oracle Validated RPM. You can complete most preinstallation configuration tasks by using the Oracle RDBMS Server 11gR2 Pre-install RPM, available from the Unbreakable Linux Network,… Read more »

HP-UX 彻底被Oracle抛弃

Posted by & filed under general.

Oracle database 11.2将是HP-UX 平台的最终版本，包括Itanium和PA-RISC架构。将来就只剩下AIX、Linux、Solaris了。 参考官方文档： Oracle Database Support on the Itanium Processor Architecture [ID 1307745.1] Support Status for Oracle Database on HP-UX PA-RISC systems [ID 1313798.1] Release Schedule of Current Database Releases [ID 742060.1]

安装Oracle Database时，先检查软件介质的完整性

Posted by & filed under install.

Oracle Database 11.2的安装介质越来越大，动辄6GB，安装介质的下载非常费时，而且Oracle目前不支持用下载工具下载，只能在网页里直接保存。建议使用IE浏览器下载，尝试过Chrome，Firefox下载的软件都有不完整的情况出现。 近期遇到的几个安装时的错误案例，都是跟下载的软件不完整有关的。因此建议在安装前务必先确认安装软件是正确、完整的。 可以在下载界面查看“view digist”，里面有每个文件的MD5，SHA-1校验值，可以用检查工具对下载的软件进行检查。 检查工具可以下载微软的FCIV，地址：Availability and description of the File Checksum Integrity Verifier utility Happy Installation.

案例分享：Windows XP下，SYS登录报ORA-1031

Posted by & filed under reference.

Windows XP环境下安装的数据库，使用sys登录时报ora-1031错误。 sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 – Production on M Mar 8 17:22:36 2010 Copyright (c) 1982, 2003, Oracle. All Rights Reserved. ERROR: ORA-1031: Insufficient privileges. 检查sqlnet.ora文件的配置： SQLNET.AUTHENTICATION_SERVICES=(NTS) 重新修改配置如下： SQLNET.AUTHENTICATION_SERVICES=(nts) 关于AUTHENTICATION_SERVICES参数有如下的常规设置： none for no authentication methods, including Microsoft Windows native operating system authentication. When SQLNET.AUTHENTICATION_SERVICES is set to none, a valid user… Read more »