ttCacheUidPwdSet 报 5102错误的原因和解决方法

ttCacheUidPwdSet 报 5102错误的原因和解决方法在建立 cache group 的时候 有时候会发现如下错误 tt70s com ttisql DSN ttcache UID oratt PWD timesten OraclePWD oracle br Copyright c 1996 2008

大家好,我是讯享网,很高兴认识大家。

在建立cache group的时候,有时候会发现如下错误:
[tt70s@com ~]\( ttisql &#34;DSN&#61;ttcache;UID&#61;oratt;PWD&#61;timesten;OraclePWD&#61;oracle&#34; <br /> Copyright (c) 1996-2008, Oracle.  All rights reserved. <br /> Type ? or &#34;help&#34; for help, type &#34;exit&#34; to quit ttIsql. <br /> All commands must end with a semicolon character. <br /> <br /> connect &#34;DSN&#61;ttcache;UID&#61;oratt;PWD&#61;timesten;OraclePWD&#61;oracle&#34;; <br /> Connection successful: DSN&#61;ttcache;UID&#61;oratt;DataStore&#61;/home/tt70s/TimesTen/ttcache/ckpt/ckpt;DatabaseCharacterSet&#61;AL32UTF8;ConnectionCharacterSet&#61;US7ASCII;DRIVER&#61;/home/tt70s/TimesTen/tt70s/lib/libtten.so;OracleId&#61;orcl;Authenticate&#61;0;LogDir&#61;/home/tt70s/TimesTen/ttcache/log;PermSize&#61;32;TempSize&#61;16;TypeMode&#61;0; <br /> (Default setting AutoCommit&#61;1) <br /> <font color="#ff0000">Command&gt; call ttCacheUidPwdSet(&#39;cacheadm&#39;, &#39;oracle&#39;);<br /> 5102: Cannot load backend library &#39;libttor.so&#39; for Cache Connect.  OS error message &#39;libttor.so: cannot open shared object file: No such file or directory&#39;.<br /> The command failed.<br /> Command&gt; </font> <br /> 常见的几种原因&#xff1a; <br /> 1&#xff0c;sys.odbc.ini文件配置不对 <br /> 2&#xff0c;timesten用户的profile文件中缺少oracle 或者timesten的lib设置 <br /> 3&#xff0c;oracle监听没有启动 <br /> 4&#xff0c;没有正确安装cache connect to oracle的选件 <br /> 5&#xff0c;不过&#xff0c;Cache Connect TimesTen v7.0.5 to Oracle DB 11.1g 出现类似问题&#xff0c;需要一个workround&#xff0c;这个会在后续的blog中在说 <br /> 当然&#xff0c;实际情况可能因人而异&#xff08;比如安装&#xff0c;操作的失误等等&#xff09;&#xff0c;这里列举的仅仅是常见的问题&#xff1a; <br /> 我的sys.odbc.ini配置如下&#xff1a; <br /> &#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;sys.odbc.ini:&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61; <br /> [ttcache] <br /> DataStore&#61;/home/tt70s/TimesTen/ttcache/ckpt/ckpt <br /> LogDir&#61;/home/tt70s/TimesTen/ttcache/log <br /> DatabaseCharacterSet&#61;AL32UTF8 <br /> PermSize&#61;32 <br /> TempSize&#61;16 <br /> Authenticate&#61;0 <br /> UID&#61;oratt <br /> PWD&#61;oracle <br /> racleId&#61;orcl <br /> raclePwd&#61;oracle <br /> 尝试建立cache group&#xff1a; <br /> [tt70s&#64;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&gt; 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&gt;


使用 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 &#61; (ADDRESS &#61; (PROTOCOL &#61; TCP)(HOST &#61; com.oracle.linux)(PORT &#61; 1521)) (CONNECT_DATA &#61; (SERVER &#61; DEDICATED) (SERVICE_NAME &#61; orcl.oracle.com))) <br /> <br /> 。。。 <br /> <br /> <br /> <font color="#0000ff">检查监听&#xff0c;发现没有启动&#xff0c;于是启动监听&#xff1a;<br /></font>[oracle&#64;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&#xff1a;<br /></font>[tt70s&#64;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">发现地址不对&#xff0c;修改为&#xff1a;</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">现在&#xff0c;可以ping主机&#xff1a;<br /></font>[root&#64;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&#61;0 ttl&#61;64 time&#61;1.90 ms <br /> 64 bytes from com.oracle.linux (127.0.0.1): icmp_seq&#61;1 ttl&#61;64 time&#61;0.638 ms <br /> 64 bytes from com.oracle.linux (127.0.0.1): icmp_seq&#61;2 ttl&#61;64 time&#61;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 &#61; 0.116/0.885/1.902/0.750 ms, pipe 2 <br /> [root&#64;com tt70s]# <br /> <br /> <font color="#0000ff">然后启动监听&#xff1a;</font> <br /> [oracle&#64;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 可以了&#xff1a;</font> <br /> [tt70s&#64;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">再次执行&#xff0c;还是报错&#xff1a;</font> <br /> Command&gt; call ttCacheUidPwdSet(&#39;cacheadm&#39;, &#39;oracle&#39;); <br /> 5102: Cannot load backend library &#39;libttor.so&#39; for Cache Connect.  OS error message &#39;libttor.so: cannot open shared object file: No such file or directory&#39;. <br /> The command failed. <br /> Command&gt; <br /> <br /> <font color="#0000ff">于是检查动态库</font> <br /> [tt70s&#64;com ~]\) ls -al \(TT_HOME/lib/libtto* <br /> ls: /home/tt70s/TimesTen/tt70s/bin/lib/libtto*: No such file or directory <br /> [tt70s&#64;com ~]\)
[tt70s@com ~]\( <br /> [tt70s&#64;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 -&gt; /home/oracle/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 <br /> [tt70s&#64;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&#64;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&#61;/home/oracle/oracle/product/10.2.0/db_1 <br /> LD_LIBRARY_PATH&#61;/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&#64;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&gt; call ttCacheUidPwdSet(‘cacheadm’, ‘oracle’);
Command&gt;
这里实际上也介绍给大家一个碰到类似问题时,troubleshooting的思路,希望可以帮助大家


讯享网

小讯
上一篇 2025-02-10 11:39
下一篇 2025-01-27 23:21

相关推荐

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