从oracle v$version视图中查询os的信息
C:>sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on Fri Oct 14 08:48:07 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProdPL/SQL Release 10.2.0.4.0
SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]
SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1][@more@]SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]
Changing between 32-bit and 64-bit Word Sizes [ID 62290.1]
Changing between 32-bit and 64-bit Word Sizes [ID 62290.1][@more@]
linux 上32bit的 database向 64bit的database迁移
How to convert a 32-bit database to 64-bit database on Linux? [ID 341880.1][@more@]
GoldenGate 不支持从oracle 11g的 active dataguard 目的端进行extract
GoldenGate 不支持从oracle 11g的 active dataguard 目的端进行extractDoes GoldenGate Support Extract Reading Redo from Active Data Guard? [ID 1299805.1]SolutionNo. This is not supported in current version (v11). Extract must read the redo/archived logs from the primary database.[@more@]
Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]
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]
Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]
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 包 下载的网址
asmlib 包 下载的网址http://www.oracle.com/us/solutions/midsize/rhel5-084877.html[@more@]
11gr2 x64 rhel5.3 rac 关闭归档
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@]
How to map device name to ASMLIB disk [ID 1098682.1]
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 x86 /x64
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
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
ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only). [ID 1092213.1][@more@]
【转帖】locale的设定及其LANG、LC_ALL、LANGUAGE环境变量的区别
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
su - grid 提示E297: Write error in swap file
E297: Write error in swap file原来是文件系统满了,df -h即可看到文件系统满了。[@more@]E297: Write error in swap file
/sqlplus: error on libnnz11.so: cannot restore segment prot after reloc [ID 454196.1]
关闭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]
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]
How to Disable or set SELinux to Permissive mode [ID 457458.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.
How to Check whether SELinux is Enabled or Disabled [ID 432988.1]
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
在x86_64linux上安装32-bit RDBMS Client software
Installing 32-bit RDBMS Client software on x86_64 Linux. [ID 1075717.1][@more@]