手工编辑sys.odbc.ini尝试修改参数PermSize,重新连接报如下错误
Command>connect "dsn=sampledb;uid=hxl;pwd=oracle";
cx_Oracle.DatabaseError: ORA-01031: TT15019: Only the instance admin may alter the PermSize attribute
解决办法:
./ttisql "Driver=/opt/tt18.1.4.34.0/myinstance/instance1/install/lib/libtten.so;DataStore=/databases/sampledb;PermSize=1024;TempSize=128;LogBufMB=256;LogFileSize=256;LogDir=/logs;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;OracleNetServiceName=ttorcl"
这里的每一项根据sys.odbc.ini的值回填,PermSize值设置为新的值,其他的保持回填即可.
[sampledb] Driver=/opt/tt18.1.4.34.0/myinstance/instance1/install/lib/libtten.so DataStore=/databases/sampledb PermSize=1024 TempSize=128 LogBufMB=256 LogFileSize=256 LogDir=/logs DatabaseCharacterSet=ZHS16GBK ConnectionCharacterSet=ZHS16GBK OracleNetServiceName=ttorcl
重启动
[instanceadmin@localhost conf]$source /opt/tt18.1.4.34.0/myinstance/instance1/bin/ttenv.sh
[instanceadmin@localhost conf]$ttDaemonAdmin -stop
[instanceadmin@localhost conf]$ttDaemonAdmin -start