ITPub博客

Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1][@more@]Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]

asmlib 包 下载的网址http://www.oracle.com/us/solutions/midsize/rhel5-084877.html[@more@]

11gr2 x64 rhel5.3 rac 关闭归档原因：需要批量加载sqlserver数据到oracle rac 库中操作：第一个节点：shutdown immediate第二个节点：shutdown immediate第一个节点：startup mount第一个节点：alter database noarchivelog第一个节点：alter database open第二个节点：startup 之后，分别登录2个节点的sqlplus ，archive log list 的结果反馈是no archive log[@more@]

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2Generic Linux Goal ASMLIB is a support library for the Automatic Storage Management (ASM) feature of the Oracle Database and is available for the Linux operating system. ASMLIB packages are available for Linux kernel 2.4 and 2.6 for the following Linux operating systems: Suse Linux Enterprise Server/United Linux versions 8 - 11Red Hat Advanced Server 2.1, Red Hat Enterprise Linux v

Requirements For Installing Oracle10gR2 On RHEL 5/OEL 5 (x86_64) [ID 421308.1] Requirements For Installing Oracle 10gR2 On RHEL/OEL 5 (x86) [ID 419646.1][@more@]Requirements For Installing Oracle10gR2 On RHEL 5/OEL 5 (x86_64) [ID 421308.1] Requirements For Installing Oracle 10gR2 On RHEL/OEL 5 (x86) [ID 419646.1]

ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only). [ID 1092213.1][@more@]

ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only). [ID 1092213.1][@more@]

http://hi.baidu.com/edeed/blog/item/2e99a14440bd8884b2b7dcb1.html例如zh_CN.GB2312、zh_CN.GB18030或者zh_CN.UTF-8。很多人都不明白这些古里古怪的表达方式。这个外星表达式规定了什么东西呢？这个问题稍后详述，现在只需要知道，这是locale的表达方式就可以了。 locale这个单词中文翻译成地区或者地域，其实这个单词包含的意义要宽泛很多。Locale是根据计算机用户所使用的语言，所在国家或者地区，以及当地的文化传统所定义的一个软件运行时的语言环境。 [oracle@game ~]$ locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UT

E297: Write error in swap file原来是文件系统满了，df -h即可看到文件系统满了。[@more@]E297: Write error in swap file

关闭selinux即可。[@more@]/sqlplus: error on libnnz11.so: cannot restore segment prot after reloc [ID 454196.1]

Defining a "default RPMs" installation of the RHEL OS [ID 376183.1][@more@]Defining a "default RPMs" installation of the RHEL OS [ID 376183.1]

Applies to: Linux OS - Version: Enterprise Linux 4.0 to Oracle Linux 5.0 - Release: RHEL4 to OL5Linux x86Linux x86-64 Linux Kernel - Version: 4.0 to 5.0 Goal How to fully disable SELinux (Security Enhanced Linux); or set it to "permissive" mode, in which case the SELinux software is loaded, but no enforcing is made of the rules, only logging is performed. Please note that disabling SELinux or setting to "permissive" mode may have some security considerations.

Applies to: Linux OS - Version: 4.0 to 5.3 - Release: RHEL4 to OEL5U3Linux x86Linux x86-64Linux Itanium ***Checked for relevance on 19-Jan-2011*** Linux Kernel - Version: 4.0 to 5.3 Goal From SELinux Frequently Asked Questions (FAQ):Security-enhanced Linux (SELinux) is a reference implementation of the Flask security architecture for flexible mandatory access control. It was created to demonstrate the value of flexible mandatory access controls and how such controls could be

Installing 32-bit RDBMS Client software on x86_64 Linux. [ID 1075717.1][@more@]

在rhel5.3 x86上安装oracle 11.2.0.1 db software的过程参考：Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on 32-bit x86 [ID 880936.1]I. Hardware: 主要是内存和硬盘的可用空间大小。这个不用说了。我的虚拟机环境是868m内存的，也可以安装上，只是有个提示说内存小于1g，ignore此提示就行 1. Minimum Hardware Requirements a.) At least 1.0 Gb (1024 MB) of physical RAM b.) Swap disk space proportional to the system's physical memory as follows: RAM

[root@localhost ~]# hostname127.0.0.1 localhost.localdomain ::1 localhost6.localdomain6 localhost6localhost.localdomain[root@localhost ~]# hostname leitest[root@localhost ~]# vi /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=leitest[root@localhost ~]# vi /etc/hosts127.0.0.1 localhost.localdomain ::1 localhost6.localdomain6 localhost6192.168.6.40 leitest[@more@]

在目的机器上oradim -new -sid lei建立bdump 和udump注册表添加键oracle_sid ,并修改其值为leicopy 源机器的full database 备份/archive备份/archive备份之后的归档日志到目的机器的相同目录下copy 源机器的控制文件自动备份到C:from14下restore spfile from 'C:from14O1_MF_S_764118213_793FY5QG_.BKP'restore controlfile from 'C:from14O1_MF_S_764118213_793FY5QG_.BKP'alter database mount;此时，请保证源机器的full database 备份/archive备份在相同的目录（相同的目录是指与源端的备份时的目录同名）下restore database;recover d

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

C:Documents and SettingsAdministrator>sqlplus system/aaaaaaSQL*Plus: Release 11.1.0.6.0 - Production on 星期六 10月 8 22:37:22 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select tablespace_name from dba_tablespaces;TABLESPACE_NAME------------------------------SYSTEMSYSAUXUNDOTBS1TEMPUSERSMYTBS已选择6行。SQL> alter

今天在一个win32下oracle 10.1.0.2的一个库上遇到了oe这个用户。貌似这个用户是安装了示例数据库后的自带的。 先记录一下，有机会找个oracle 10.1.0.2 或者oracle 92的环境确认一下。[@more@]