ORA-01031: TT15019

 

手工编辑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