灌溉梦想,记录脚步

Oracle 11g Software Installation on Linux—CentOS-5

  Introduction
  This paper takes a look at installing oracle 11g (11.1) on Linux (CentOS-5).You can read about CentOS at www.centos.org and be assured of its’ Enterprise-class quality. This paper will use oracle’s Quick Installation Guide for Linux x86 as its’ guide—noting where additional information may be obtained but getting oracle installed on Linux as fast as possible. We at thecheapdba.com have years of experience installing oracle—starting back with oracle 7. We will point out best practices so that you end up with a reliable database that provides exceptional performance. We will occasionally re-visit, edit, and post additions to this paper as we find further configuration best practices.
  This paper will not cover the installation of CentOS-5 as that can be acquired through the CentOS website and additional Linux guides. We will however point out those alterations to the Linux environment that pertains to getting oracle installed.
  Our goal is to provide you with the steps to properly install the oracle 11g software without having to read oracle’s installation guide from front to back cover. We will provide you the commands to execute (just cut-n-paste) and the desired outcome of those commands. If you get something other than what is expected it would be time for you to re-visit earlier steps in this process. So hold on, here we go.
  It is assumed that the installer of oracle software has access and is running on an X Window System workstation. Please consult X Server documentation if you need help. We at thecheapdba.com typically will use cygwin ( www.cygwin.com ) for all interfacing with our Linux distribution. It has an X Window System that works quite well—and as we always like is free.
   继续阅读 »

ubuntu 9.10 安装ibus

首先清理所有scim相关包和安装中文字体:

sudo aptitude purge ~nscim
sudo aptitude install language-support-fonts-zh

然后检查源的配置:

sudo gedit /etc/apt/sources.list

检查一下有没有这行:

deb http://archive.ubuntu.com.cn/ubuntu-cn/ intrepid main restricted universe multiverse

如果没有就添加进去,然后保存退出。并更新软件源列表[sudo aptitude update]

继续阅读 »

ORA-27101 Shared memory realm does not exist 之解決

在试图登录pl/sql时,输入用户名(system/pwd)后,Oracle报告下列错误:
ERROR:
orA-27101 Shared memory realm does not exist
orA-01034 orACLE not available

或者在em登录的时候报告下列错误:
错误: NMO 未 setuid-root (只适用于 Unix)

查阅了相关
orA-27101 Shared memory realm does not exist
orA-01034 orACLE not available
的说明,解释为ORACLE_HOME或者ORACLE_SID设置不正确。
但检查bash_profile以后没有发现错误;
錯誤點,沒有開啟oracle服務;
解決辦法,直接開啟oracle相關數據庫的服務;
或按照下面的步驟操作:
继续阅读 »

vnc安装oracle 11g报错

[oracle@test database]$ ./runInstaller
正在启动 oracle Universal Installer…
检查临时空间: 必须大于 120 MB。 实际为 117329 MB 通过
检查交换空间: 必须大于 150 MB。 实际为 1983 MB 通过
检查监视器: 监视器配置至少必须显示 256 种颜色
>>> 无法使用命令 /usr/bin/xdpyinfo 自动检查显示器颜色。请检查是否设置了 DISPLAY 变量。 未通过 <<<< 未通过某些要求检查。必须先满足这些要求, 然后才能继续安装,那时将重新检查这些要求。 是否继续? (y/n) [n] y 原因: 当时是通过vnc登录的root,然后通过root切换到oracle用户的,注销通过oracle登录就可以!

Xlib: connection to “:0.0” refused by server的解决方法

Xlib: connection to ":0.0" refused by server的解决方法
在我的linux下安装的Oracle,我用平常用的账户登录系统后,再su oracle切换到oracle账户。

运行很多X程序都提示Xlib: connection to ":0.0" refused by server。

解决办法:

用平时用的账户登录,然后在终端输入以下命令,就可以搞定了!

xhost local:oracle non-network local connections being added to access control list

再试试su oracle

进去后随便运行个X程序,比如:nautilus

oracle 10g 乱码解决

操作系统:Red Hat Enterprise Linux AS release 4
语言安装的为英文,安装完数据库后,通过企业管理器登陆,点击的按钮显示乱码。

1,重新安装中文支持
[root@tonykorn97 ~]# rpm -ivh ttfonts-zh_CN-2.14-6.noarch.rpm
warning: ttfonts-zh_CN-2.14-6.noarch.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing… ########################################### [100%]
1:ttfonts-zh_CN ########################################### [100%]
[root@tonykorn97 ~]#
2,安装如下步骤操作:
企业管理器已经关闭了
[root@tonykorn97 ~]# su – oracle
[oracle@tonykorn97 ~]$ cd $ORACLE_HOME/jdk/jre/lib
[oracle@tonykorn97 lib]$ ls -al font*zh_CN*
-rwxr-xr-x 1 oracle oinstall 6854 Apr 20 2005 font.properties.zh_CN.Redhat
-rwxr-xr-x 1 oracle oinstall 7410 Apr 20 2005 font.properties.zh_CN.Redhat2.1
-rwxr-xr-x 1 oracle oinstall 6845 Apr 20 2005 font.properties.zh_CN.Sun
继续阅读 »

linux/centos cacti备份及恢复shell

备份及恢复Cacti
(1)cacti的文件目录的备份(rra目录除外)
(2)mysql备份
mysqldump -p cacti >/tmp/cacti.sql
(3)备份rra
dumprrd.sh

#!/bin/sh
rrddump=”/usr/local/bin/rrdtool dump”
xmldir=”/tmp/mysqlbackup/rraxml”
xmlbackup=”/tmp/mysqlbackup/rrabak”
mysqlbackupDIR=”/tmp/mysqlbackup”
rrdpath=”/usr/local/share/cacti/rra/”
DATE=`date +”%y-%m-%d”`
if [ ! -e {xmldir}
继续阅读 »