 |
| 等 级：居民 |
| 经 验 值：21 |
| 魅 力 值：12 |
| 龙 币：49 |
| 积 分：29.1 |
| 注册日期：2003-09-09 |
| |
|
|
|
我来问个关于TimesTen的技术问题:在load cache group时提示5056错误!!
在load cache group时提示5056错误，求解！
以下是我的实验过程!
操作系统 : window server 2003 sp2
Oracle 版本: ORACLE 11gR2
TimesTen : 11.2.1
Oracle TimesTen 安装在同一台电脑上.
在oracle database 中已创建用户 u_tt_cadm ,并执行以下语句:
C:> SQLPLUS /NOLOG
SQL> conn u_tt_cadm
SQL> CREATE TABLE test_TimesTen (ID NUMBER(5) PRIMARY KEY, NAME VARCHAR2(30));
SQL> INSERT INTO test_TimesTen VALUES (1, 'ABC');
SQL> INSERT INTO test_TimesTen VALUES (2, 'DEF');
SQL> COMMIT;
c:> ttisql
Command> CONNECT "dsn=dsn_tt_mgr;uid=u_tt_cadm;pwd=u_tt_cadm;oraclepwd=u_tt_cadm";
Command> CALL ttCacheUidPwdSet('u_tt_cadm','u_tt_cadm');
Command> CALL ttCacheUidGet;
Command> CALL ttGridCreate('tt_cgrid');
Command> CALL ttGridNameSet('tt_cgrid');
Command> CREATE READONLY CACHE GROUP tt_cgrid
AUTOREFRESH INTERVAL 5 SECONDS
FROM test_TimesTen (ID NUMBER(5) PRIMARY KEY, NAME VARCHAR2(30));
Command> LOAD CACHE GROUP tt_cgrid COMMIT EVERY 30 ROWS;
5056: The cache operation fails: error_type=<Oracle Error>, error_code=<12154>,
error_message: ORA-12154: TNS:could not resolve the connect identifier specified
The command failed.
Command> cacheGroups
Cache Group U_TT_CADM.TT_CGRID:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: Paused
Autorefresh Interval: 5 Seconds
Autorefresh Status: ok
Aging: No aging defined
Root Table: U_TT_CADM.TEST_TIMESTEN
Table Type: Read Only
1 cache group found.
Command>
|
| |
|
|
2011-02-05 22:45:02
