在建立cache group的时候,有时候会发现如下错误:
[tt70s@com ~]\( ttisql "DSN=ttcache;UID=oratt;PWD=timesten;OraclePWD=oracle" <br /> Copyright (c) 1996-2008, Oracle. All rights reserved. <br /> Type ? or "help" for help, type "exit" to quit ttIsql. <br /> All commands must end with a semicolon character. <br /> <br /> connect "DSN=ttcache;UID=oratt;PWD=timesten;OraclePWD=oracle"; <br /> Connection successful: DSN=ttcache;UID=oratt;DataStore=/home/tt70s/TimesTen/ttcache/ckpt/ckpt;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=/home/tt70s/TimesTen/tt70s/lib/libtten.so;OracleId=orcl;Authenticate=0;LogDir=/home/tt70s/TimesTen/ttcache/log;PermSize=32;TempSize=16;TypeMode=0; <br /> (Default setting AutoCommit=1) <br /> <font color="#ff0000">Command> call ttCacheUidPwdSet('cacheadm', 'oracle');<br /> 5102: Cannot load backend library 'libttor.so' for Cache Connect. OS error message 'libttor.so: cannot open shared object file: No such file or directory'.<br /> The command failed.<br /> Command> </font> <br /> 常见的几种原因: <br /> 1,sys.odbc.ini文件配置不对 <br /> 2,timesten用户的profile文件中缺少oracle 或者timesten的lib设置 <br /> 3,oracle监听没有启动 <br /> 4,没有正确安装cache connect to oracle的选件 <br /> 5,不过,Cache Connect TimesTen v7.0.5 to Oracle DB 11.1g 出现类似问题,需要一个workround,这个会在后续的blog中在说 <br /> 当然,实际情况可能因人而异(比如安装,操作的失误等等),这里列举的仅仅是常见的问题: <br /> 我的sys.odbc.ini配置如下: <br /> ==========sys.odbc.ini:=================== <br /> [ttcache] <br /> DataStore=/home/tt70s/TimesTen/ttcache/ckpt/ckpt <br /> LogDir=/home/tt70s/TimesTen/ttcache/log <br /> DatabaseCharacterSet=AL32UTF8 <br /> PermSize=32 <br /> TempSize=16 <br /> Authenticate=0 <br /> UID=oratt <br /> PWD=oracle <br /> racleId=orcl <br /> raclePwd=oracle <br /> 尝试建立cache group: <br /> [tt70s@com ~]\) ttisql “DSN=ttcache;UID=oratt;PWD=timesten;OraclePWD=oracle”
Copyright © 1996-2008, Oracle. All rights reserved.
Type ? or “help” for help, type “exit” to quit ttIsql.
All commands must end with a semicolon character.
connect “DSN=ttcache;UID=oratt;PWD=timesten;OraclePWD=oracle”;
Connection successful: DSN=ttcache;UID=oratt;DataStore=/home/tt70s/TimesTen/ttcache/ckpt/ckpt;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=/home/tt70s/TimesTen/tt70s/lib/libtten.so;OracleId=orcl;Authenticate=0;LogDir=/home/tt70s/TimesTen/ttcache/log;PermSize=32;TempSize=16;TypeMode=0;
(Default setting AutoCommit=1)
Command> call ttCacheUidPwdSet(‘cacheadm’, ‘oracle’);
5102: Cannot load backend library ‘libttor.so’ for Cache Connect. OS error message ‘libttor.so: cannot open shared object file: No such file or directory’.
The command failed.
Command>
使用 tnsping orcl发现ping不通:
[oracle@com admin]\( tnsping orcl <br /> TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30-OCT-2008 16:10:05 <br /> Copyright (c) 1997, 2005, Oracle. All rights reserved. <br /> Used parameter files: <br /> /home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora <br /> <br /> Used TNSNAMES adapter to resolve the alias <br /> Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = com.oracle.linux)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle.com))) <br /> <br /> 。。。 <br /> <br /> <br /> <font color="#0000ff">检查监听,发现没有启动,于是启动监听:<br /></font>[oracle@com admin]\) lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-OCT-2008 16:11:20
Copyright © 1991, 2005, Oracle. All rights reserved.
。。。
发现不能启动
ping主机不通:
[tt70s@com ~]\( ping com.oracle.linux <br /> PING com.oracle.linux (192.168.80.128) 56(84) bytes of data. <br /> --- com.oracle.linux ping statistics --- <br /> 4 packets transmitted, 0 received, 100% packet loss, time 3006ms <br /> <br /> <font color="#0000ff">检查/etc/hosts:<br /></font>[tt70s@com ~]\) cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.80.128 com.oracle.linux
127.0.0.1 com.oracle.linux com localhost.localdomain localhost
[tt70s@com ~]\( <br /> <br /> <font color="#0000ff">发现地址不对,修改为:</font> <br /> # Do not remove the following line, or various programs <br /> # that require network functionality will fail. <br /> 192.168.10.128 com.oracle.linux <br /> 127.0.0.1 com.oracle.linux com localhost.localdomain localhost <br /> <font color="#0000ff">现在,可以ping主机:<br /></font>[root@com tt70s]# ping com.oracle.linux <br /> PING com.oracle.linux (127.0.0.1) 56(84) bytes of data. <br /> 64 bytes from com.oracle.linux (127.0.0.1): icmp_seq=0 ttl=64 time=1.90 ms <br /> 64 bytes from com.oracle.linux (127.0.0.1): icmp_seq=1 ttl=64 time=0.638 ms <br /> 64 bytes from com.oracle.linux (127.0.0.1): icmp_seq=2 ttl=64 time=0.116 ms <br /> --- com.oracle.linux ping statistics --- <br /> 3 packets transmitted, 3 received, 0% packet loss, time 2002ms <br /> rtt min/avg/max/mdev = 0.116/0.885/1.902/0.750 ms, pipe 2 <br /> [root@com tt70s]# <br /> <br /> <font color="#0000ff">然后启动监听:</font> <br /> [oracle@com admin]\) lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-OCT-2008 16:13:42
Copyright © 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=com.oracle.linux)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 30-OCT-2008 16:13:43
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=com.oracle.linux)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@com admin]\( <br /> <font color="#0000ff">tnsping 可以了:</font> <br /> [tt70s@com ~]\) tnsping orcl
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 30-OCT-2008 16:17:25
Copyright © 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = com.oracle.linux)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle.com)))
OK (10 msec)
[tt70s@com ~]\( <br /> <font color="#0000ff">再次执行,还是报错:</font> <br /> Command> call ttCacheUidPwdSet('cacheadm', 'oracle'); <br /> 5102: Cannot load backend library 'libttor.so' for Cache Connect. OS error message 'libttor.so: cannot open shared object file: No such file or directory'. <br /> The command failed. <br /> Command> <br /> <br /> <font color="#0000ff">于是检查动态库</font> <br /> [tt70s@com ~]\) ls -al \(TT_HOME/lib/libtto* <br /> ls: /home/tt70s/TimesTen/tt70s/bin/lib/libtto*: No such file or directory <br /> [tt70s@com ~]\)
[tt70s@com ~]\( <br /> [tt70s@com ~]\) ls -la \(ORACLE_HOME/lib/libclntsh.so <br /> lrwxrwxrwx 1 oracle oinstall 61 Jul 18 2007 /home/oracle/oracle/product/10.2.0/db_1/lib/libclntsh.so -> /home/oracle/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 <br /> [tt70s@com ~]\)
原来没有安装cache connect component
于是添加该组件,方法如下:
[tt70s@com ~]\( ttversion <br /> TimesTen Release 7.0.5.0.0 (32 bit Linux/x86) (tt70s:17000) 2008-04-04T00:09:04Z <br /> Instance admin: tt70s <br /> Instance home directory: /home/tt70s/TimesTen/tt70s <br /> Daemon home directory: /home/tt70s/TimesTen/tt70s/info <br /> Access control enabled. <br /> [tt70s@com ~]\)
[tt70s@com linux86]\( setup.sh <br /> There are 3 TimesTen instances installed locally : <br /> 1) ttclient (TimesTen7.0.4.0.0) <br /> 2) tt70m (TimesTen7.0.5.0.0) <br /> 3) tt70s (TimesTen7.0.5.0.0) <br /> Of the following options : <br /> [1] Install a new instance <br /> [2] Upgrade an existing instance <br /> [3] Display information about an existing instance <br /> [q] Quit the installation <br /> <font color="#ff0000">Which would you like to perform? [ 1 ] 2</font> <br /> Would you like to add Cache Connect to an existing installation? [ no ] yes <br /> NOTE: There is only one instance which can be upgraded. <br /> Instance Name : tt70s <br /> Product Installed : TimesTen7.0.5.0.0 <br /> Installation Directory : /home/tt70s/TimesTen/tt70s <br /> BitLevel : 32 <br /> Component Installed : Client/Server and DataManager <br /> Daemon Port : 17000 <br /> <font color="#0000ff">Would you like to upgrade this instance? [ yes ]</font> <br /> Extracting Cache Connect to Oracle ... <br /> The following variables have been set in the file : <br /> /home/tt70s/TimesTen/tt70s/bin/ttThunk <br /> ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1 <br /> LD_LIBRARY_PATH=/home/tt70s/TimesTen/tt70s/lib:/home/oracle/oracle/product/10.2.0/db_1/lib32:/home/oracle/oracle/product/10.2.0/db_1/network/lib32:/home/oracle/oracle/product/10.2.0/db_1/lib:/home/oracle/oracle/product/10.2.0/db_1/network/lib <br /> <font color="#0000ff">Would you like to enable the Cache Connect to Oracle Administrator? [ yes ] 这里也可以选择no<br /></font>What TCP/IP port number would you like Cache Connect to Oracle Administrator to listen on? [ 17004 ] <br /> NOTE: To access the TimesTen Cache Connect to Oracle Administrator <br /> go to the url: <font color="#0000ff">http://localhost:17004/cache</font> <br /> Restarting the daemon ... <br /> TimesTen Daemon stopped. <br /> TimesTen Daemon startup OK. <br /> End of TimesTen installation. <br /> [tt70s@com linux86]\)
再次连接就成功了,呵呵:
[tt70s@com ~]$ ttisql “DSN=ttcache;UID=oratt;PWD=timesten;OraclePWD=oracle”
Copyright © 1996-2008, Oracle. All rights reserved.
Type ? or “help” for help, type “exit” to quit ttIsql.
All commands must end with a semicolon character.
connect “DSN=ttcache;UID=oratt;PWD=timesten;OraclePWD=oracle”;
Connection successful: DSN=ttcache;UID=oratt;DataStore=/home/tt70s/TimesTen/ttcache/ckpt/ckpt;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;OracleId=orcl;Authenticate=0;LogDir=/home/tt70s/TimesTen/ttcache/log;PermSize=32;TempSize=16;TypeMode=0;
(Default setting AutoCommit=1)
Command> call ttCacheUidPwdSet(‘cacheadm’, ‘oracle’);
Command>
这里实际上也介绍给大家一个碰到类似问题时,troubleshooting的思路,希望可以帮助大家
ttCacheUidPwdSet 报 5102错误的原因和解决方法
ttCacheUidPwdSet 报 5102错误的原因和解决方法在建立 cache group 的时候 有时候会发现如下错误 tt70s com ttisql DSN ttcache UID oratt PWD timesten OraclePWD oracle br Copyright c 1996 2008
大家好,我是讯享网,很高兴认识大家。
UCB——上界置信算法
上一篇
2025-02-10 11:39
《近世代数》笔记
下一篇
2025-01-27 23:21

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容,请联系我们,一经查实,本站将立刻删除。
如需转载请保留出处:https://51itzy.com/kjqy/76487.html