字符级是数据库的语言支持,这是有一些相关文章,http://www.ncn.cn/oracle/admin/nls_convert1.htm
http://expert.csdn.net/Expert/topic/1815/1815886.xml?temp=.628689
http://www2.ccw.com.cn/tips/9906/062804_04.asp如有什么问题,请发短信。
http://expert.csdn.net/Expert/topic/1815/1815886.xml?temp=.628689
http://www2.ccw.com.cn/tips/9906/062804_04.asp如有什么问题,请发短信。
shutdown immediate;
startup restrict;
ALTER DATABAE [dbname] CHARACTER SET [SIMPLIFIED CHINESE_CHINA.]ZHS16GBK ;
ALTER DATABAE [dbname] NATIONAL CHARACTER SET [SIMPLIFIED CHINESE_CHINA.]ZHS16GBK ;
配置:1.8GHZ+256M
问题:将数据库更改为归档模式,一切正常,修改init.ora,重启机器,发现oracle不可用
尝试在SVRMGR,PL/SQL DEVELOPER,SQL* PLUS操作,错误如下,share memory出错了,
但我已经把shared_pool_size调大了,还要怎么办?各位帮帮忙,我都折腾3天了,郁闷。 1.在SVRMGR下,
SVRMGR> connect internal/yxs@www
连接成功。
SVRMGR> select * from v$instance;
select * from v$instance
*
ORA-01034: ORACLE not available
SVRMGR> startup
ORA-27100: shared memory realm already exists
SVRMGR> shutdown
ORA-01012: not logged on
SVRMGR> shutdown abort
已关闭 ORACLE 实例。
SVRMGR> startup mount
ORA-27100: shared memory realm already exists
SVRMGR> 2.用pl/sql developer打开,提示:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exists
3.sql * plus
同2---------------------------------
init.ora的部分参数
...
db_block_buffers = 4395
#shared_pool_size = 52428800(安装默认值)
shared_pool_size = 824288000large_pool_size = 614400
java_pool_size = 20971520log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800processes = 150
parallel_max_servers = 5
log_buffer = 32768
...
log_archive_start = true
log_archive_dest_1 = "location=C:\oracle817\oradata\www\archive"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC