oracle 11g rac 修改字符集
来源:互联网 发布:php程序员面试宝典 编辑:程序博客网 时间:2024/05/24 06:34
系统版本:
Oracle Linux Server release 5.7
数据库版本:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
查看字符集:
SQL>select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
关闭RAC其中一个节点:
[root@rac1 ~]#cd /u01/app/11.2.0/grid/bin/crsctl
[root@rac1 ~]#./crsctl stop cluster
在另一个节点查看oracle启动参数:
SQL>show parameter spfile;
NAME
---------------------------------------------------------------------------------------------------
spfile
若VALUE为空,表示用pfile参数启动,即修改为spfile参数启动:
SQL>CREATE SPFILE FROM PFILE;
SQL>shutdown immediate;
SQL>startup;
执行:
SQL>alter system set cluster_database=falsescope=spfile;
关闭数据库:
SQL>shutdown immediate;
SQL>startup mount;
SQL> ALTER SYSTEM ENABLE RESTRICTEDSESSION;
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_USEZHS16GBK;
Database altered.
恢复数据库为RAC:
SQL> alter system set cluster_database=truescope=spfile;
SQL> shutdown immediate;
SQL>startup;
启动另一节点cluster服务并验证:
[root@rac1 ~]#./crsctl
查看字符集:
SQL>select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
- oracle 11g rac 修改字符集
- 11G RAC 简单命令
- RAC 修改字符集 AL32UTF8-->UTF8
- Oracle 11g Password Features
- oracle 11g 修改默认监听端口1521
- jdbc 连接 oracle rac
- oracle 11g 分区表
- ORACLE 11G R2 修改"用户名"
- oracle 11g 新参数 MEMORY_TARGET
- oracle 11g jdbc 驱动链接
- linux oracle 11g 安装
- CentOS6 下Oracle 11 g数据库
- ORACLE 11G 配置DG&nbsp…
- oracle 11g 添加控制文件
- Oracle RAC Cache Fusion 机制详解
- oracle 更改字符集
- 64位 Ubuntu 安装 Oracle 11G
- Oracle 11g Windows 迁移至 Linux
- Win 2008 R2安装SQL Server …
- ORACLE-RAC-11G-R2_INSTALL
- 存储-配置多路径
- ORACLE 11G R2 修改"用户名"
- oracle11g dataguard 安装手册
- oracle 11g rac 修改字符集
- ORACLE-体系结构
- oracle11g-11.2.0.3.0 - 64bit
- android Java heap space
- ORACLE 11G 配置DG&nbsp…
- oracle-linux下挂载"移动硬盘"&nbs…
- oracle-11g-配置dataguard
- ORA-00054
- ORA-00845