灌溉梦想,记录脚步
标签类目:oracle

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.
   继续阅读 »

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相關數據庫的服務;
或按照下面的步驟操作:
继续阅读 »

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
继续阅读 »

修改oracle默认编码

查看oracle数据库字符集:
select userenv(‘language’) from dual;

修改过程:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 135337420 bytes
Fixed Size 452044 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> Alter SYSTEM ENABLE RESTRICTED SESSION;
System altered.
SQL> Alter SYSTEM SET JOB_QUEUE_PROCESSES=0;
System altered.
SQL> Alter SYSTEM SET AQ_TM_PROCESSES=0;
System altered.
SQL> Alter DATABASE OPEN;
Database altered.
SQL>alter database character set INTERNAL_USE UTF8
或者修改成zhs16gbk编码格式
SQL> alter database character set zhs16gbk

SQL> shutdown immediate //先关闭数据库,再开启使之字符集生效
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>startup