docker 中搭建dockers遇到的问题：sqlplus/nolog∗∗Error6initializingSQL∗Plus；修改字符集

指令登录连接数据库时：sqlplus/nolog∗∗Error6initializingSQL∗Plus

https://blog.youkuaiyun.com/weixin_41647508/article/details/90599038

$ su oracle

∗∗sqlplus/nolog∗∗Error6initializingSQL∗PlusSP2−0667:Messagefilesp1&lt;lang>.msbnotfoundSP2−0750:YoumayneedtosetORACLEHOMEtoyourOraclesoftwaredirectory[oracle@linux6 ]**sqlplus /nolog**Error 6 initializing SQL*PlusSP2-0667: Message file sp1&lt;lang&gt;.msb not foundSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory[oracle@linux6 ~]∗∗sqlplus/nolog∗∗Error6initializingSQL∗PlusSP2−0667:Messagefilesp1<lang>.msbnotfoundSP2−0750:YoumayneedtosetORACLE 
H
​    
 OMEtoyourOraclesoftwaredirectory[oracle@linux6 ]
$echo $ORACLE_HOME

- - 如果为空，则export ORACLE_HOME=$ORACLE_BASE/product

$source /home/oracle/.bash_profile
$sqlplus /nolog
————————————————
版权声明：本文为优快云博主「鲤鱼.wow」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.youkuaiyun.com/weixin_41647508/article/details/90599038

 

修改字符集

SQL> conn /as sysdba;

SQL>select userenv('language') from dual;

SQL>SHUTDOWN IMMEDIATE

SQL>STARTUP MOUNT

SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL>ALTER DATABASE OPEN;

SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;

SQL>SHUTDOWN IMMEDIATE;

SQL>STARTUP;

SQL>select userenv('language') from dual;