java思维

正在学习中:(

oracle 强行修改服务端字符集

说明:
建议在刚安装完的时候进行修改,对已经投产的系统,风险太大!

步骤如下:
1. Make sure the parallel_server parameter in INIT.ORA is set to false
or it is not set at all.

2. Execute the following commands in Server Manager (svrmgrl):

SVRMGR> SHUTDOWN IMMEDIATE; -- or NORMAL

SVRMGR> STARTUP MOUNT;
SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SVRMGR> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SVRMGR> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SVRMGR> ALTER DATABASE OPEN;
SVRMGR> ALTER DATABASE [NATIONAL] CHARACTER SET INTERNAL_USE ;
SVRMGR> SHUTDOWN IMMEDIATE; -- OR NORMAL
SVRMGR> STARTUP RESTRICT;

3. Restore the parallel_server parameter in INIT.ORA, if necessary.

4. Execute the following commands in Server Manager:

SVRMGR> SHUTDOWN IMMEDIATE; -- OR NORMAL
SVRMGR> STARTUP;

如果没有登陆,首先执行
SVRMGR> connect internal;

Google

posted on 2005-10-06 22:43 john 阅读(600) 评论(0)  编辑  收藏 所属分类: Oracle Technology


只有注册用户登录后才能发表评论。


网站导航: