环境:
linux centos 5.3 64位。
oracle 10.2.0.1 64位。
[oracle@server115 zhs]$ cat /etc/sysconfig/i18n
#LANG="zh_CN.UTF-8"
LANG="zh_CN.GB18030"
SUPPORTED="zh_CN.GB18030:zh_CN:zh:en_US.UTF-8:en_US:en"
SYSFONT="latarcyrheb-sun16"
[oracle@server115 zhs]$ cat ~/.bash_profile
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/db/oracle10g
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
看em的时候,按钮会显示乱码,解决如下:
先要停掉em
[oracle@server115 ~]$ cd $ORACLE_HOME/jdk/jre/lib
[oracle@server115 lib]$ ls font*zh_CN*
font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1
font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun
我们只要用合适的中文字符集文件替换缺省文件即可,我选择使用font.properties.zh_CN.Redhat来替换缺省字体定义文件:
[oracle@server115 lib]$ cp font.properties.zh_CN.Redhat font.properties
[oracle@server115 lib]$ vi font.properties
最后一行改为:
filename.-misc-zysong18030-medium-r-normal--*-%d-*-*-c-*-iso10646-1=/usr/share/fonts/chinese/TrueType/uming.ttf
[oracle@server115 lib]$ cd $ORACLE_HOME/jre/1.4.2/lib/
[oracle@server115 lib]$ ls font*zh_CN*
font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1
font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun
[oracle@server115 lib]$ cp font.properties.zh_CN.Redhat font.properties
[oracle@server115 lib]$ vi font.properties
最后一行改为:
filename.-misc-zysong18030-medium-r-normal--*-%d-*-*-c-*-iso10646-1=/usr/share/fonts/chinese/TrueType/uming.ttf
替换之后需要清理一下Cache,重启EM即可.
Cache路径通常位于
[oracle@server115 lib]$
cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
[oracle@server115 zhs]$ ls
b-3d.gif b-68.gif b-70.gif b-b5.gif b-iagree.gif tb-0-0.gif
b-3d.imx b-68.imx b-70.imx b-b5.imx b-iagree.imx tb-0-0.imx
[oracle@server115 zhs]$ rm *.gif
[oracle@server115 zhs]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://server115:1158/em/console/aboutApplication
catalog备份数据库
linux centos 5.3 64位。
oracle 10.2.0.1 64位。
[oracle@server115 zhs]$ cat /etc/sysconfig/i18n
#LANG="zh_CN.UTF-8"
LANG="zh_CN.GB18030"
SUPPORTED="zh_CN.GB18030:zh_CN:zh:en_US.UTF-8:en_US:en"
SYSFONT="latarcyrheb-sun16"
[oracle@server115 zhs]$ cat ~/.bash_profile
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/db/oracle10g
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
看em的时候,按钮会显示乱码,解决如下:
先要停掉em
[oracle@server115 ~]$ cd $ORACLE_HOME/jdk/jre/lib
[oracle@server115 lib]$ ls font*zh_CN*
font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1
font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun
我们只要用合适的中文字符集文件替换缺省文件即可,我选择使用font.properties.zh_CN.Redhat来替换缺省字体定义文件:
[oracle@server115 lib]$ cp font.properties.zh_CN.Redhat font.properties
[oracle@server115 lib]$ vi font.properties
最后一行改为:
filename.-misc-zysong18030-medium-r-normal--*-%d-*-*-c-*-iso10646-1=/usr/share/fonts/chinese/TrueType/uming.ttf
[oracle@server115 lib]$ cd $ORACLE_HOME/jre/1.4.2/lib/
[oracle@server115 lib]$ ls font*zh_CN*
font.properties.zh_CN.Redhat font.properties.zh_CN.Redhat2.1
font.properties.zh_CN.Sun font.properties.zh_CN_UTF8.Sun
[oracle@server115 lib]$ cp font.properties.zh_CN.Redhat font.properties
[oracle@server115 lib]$ vi font.properties
最后一行改为:
filename.-misc-zysong18030-medium-r-normal--*-%d-*-*-c-*-iso10646-1=/usr/share/fonts/chinese/TrueType/uming.ttf
替换之后需要清理一下Cache,重启EM即可.
Cache路径通常位于
[oracle@server115 lib]$
cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
[oracle@server115 zhs]$ ls
b-3d.gif b-68.gif b-70.gif b-b5.gif b-iagree.gif tb-0-0.gif
b-3d.imx b-68.imx b-70.imx b-b5.imx b-iagree.imx tb-0-0.imx
[oracle@server115 zhs]$ rm *.gif
[oracle@server115 zhs]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://server115:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ......
更多参考:
the specified nodes are not clusterable
根据rowid删除表中重复的行
Agent process exited abnormally during initialization
一次字符乱码的解决过程
rman实验(一)
rman实验(二)
ORA-00600: internal error code, arguments: [keltnf
ORA-00600: ORA-12012 ORA-08102解决
linux下完全删除oracle
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory
centos4.8_64上安装oracle10201建库报ORA-12547
EM乱码解决
ORA-31613 Master process DM00 failed during startup
ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []
ORA-24324 ORA-01041 ORA-03113
centos5.3升级oracle
pdksh-5.2.14-36.el5.i386.rpm
使用rman进行数据库迁移
oracle10.2.0.1升级到10.2.0.4报错
Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)
改oracle的name和dbid
修改oracle实例名
Solaris8上迁移oracle8i---上
Solaris8上迁移oracle8i---下
未备份归档日志导致数据丢失的实验
使用NBU进行数据库迁移
catalog备份数据库
RMAN FORMAT字符串格式化
Error: can not register my instance state - -1
not all alterations performed
The ASM instance configured on the local node is a single-instance ASM
/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared
Initializing the Oracle ASMLib driver: [FAILED]
ORA-00245: control file backup operation failed
WARNING: failed to read mirror side 1 of virtual extent 229 logical extent
模拟恢复参数文件
Interface eth0 checked failed
import server uses ZHS16GBK character set (possible charset conversion)