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, or via the Oracle Public Yum
repository.

When it is installed, the Oracle RDBMS Pre-install RPM does the following:

* Automatically installs any additional packages needed for installing Oracle Grid
Infrastructure and Oracle Database 11gR2 (11.2.0.3).

* Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for
that user. For security purposes, this user has no password by default and cannot login
remotely. To enable remote login, please set a password using the “passwd” tool.

* Sets and verifies sysctl.conf settings, system startup parameters, user limits, and driver
parameters to the minimum acceptable values based on recommendations from the Oracle Database
Installation Guide and the Oracle Validated Configurations program.

Important Note

Removal of the Oracle RDBMS Server 11gR2 Pre-install RPM will restore the following files to
the version prior to inital installation:

* /etc/security/limits.conf
* /boot/grub/grub.conf
* /etc/sysctl.conf

If you make further changes to these files after installing the Oracle RDBMS Server 11gR2
Pre-install RPM, please make a backup of your changed files and manually restore them after the
package removal is complete.

x86_64:
oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64.rpm

SRPMS:

http://oss.oracle.com/ol6/SRPMS-updates/oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.src.rpm

Description of changes:

[1.0-3.el6]
- Added smartmontools as dependency, bz13653

[1.0-2.el6]
- kernel.shmall=1073741824 as per bz7256
- kernel.shmmax=4398046511104 as per bz7256
- stack hard = 32768 as per doc max limit

[1.0-1.el6]
- Renamed rpm to oracle-rdbms-server-11gR2-preinstall
- Included xorg-x11-utils xorg-x11-xauth as dependency bz13653
- Included kernel-uek as dependency.
- fs.aio-max-nr=1048576 to match document,bz13653
- kernel.shmall=2097152 to match document,bz13653
- kernel.shmmax=536870912 to match document,bz13653
- nofile soft = 1024 to match document,bz13653
- nofile hard = 65536 to match document,bz13653
- nproc soft = 2047 to match document,bz13653
- nproc hard = 16384 to match document,bz13653
- stack soft = 10240 to match document,bz13653
- stack hard = 10240 to match document,bz13653

[1.0.0-3.el6]
- removed util-linux and added util-linux-ng (fork of util-linux)
- removed openssh and added openssh-clients bz13173
- removed 32 bit dependency for x86_64 as per st docs.
- removed kernel-uek-headers/kernel-headers
- disable login for oracle user for bug12623491
- Merge fix
- Removed msgmni, msgmnb, msgmax for bz11029
- Increase stack limit for oracle user bz11683
- bugfix for bug11656858
- added compat-libcap1 dependency bz12221
- move link creation to install part bz11030
- removed comment related to bugdb6820451
- removed flowcontrol settings bz11508
- Removed 10G related info from oracle-rdbms-server-11gR2-preinstall.param
- Changed kernel.semmni to 128 as per 11203crs-cvu_prereq.xml
- removed vm.min_free_kbytes
- removed readme

[1.0.0-1.el6]
- Changed requirement for x86_64 arch
/lib/libaio.so.1
libodbc.so.2()(64bit)
/usr/lib/libodbc.so.2
/usr/lib/gcc/x86_64-redhat-linux/4.4.4/libstdc++.a

Software Accessibility

All packages are available via ULN (http://linux.oracle.com) or the Oracle Public
Yum Repository (http://public-yum.oracle.com)

For more information, please visit http://linux.oracle.com

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]

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.

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 name and password can be used to access the database.

all for all authentication methods.

nts for Microsoft Windows native operating system authentication.