Thursday, October 01, 2015

No timesten tab in sql developer ?




Following https://docs.oracle.com/cd/E55747_01/doc.41/e39882/connect.htm to config sql developer.
But no timesten tab found.



googled and realize needing to install timesclient first.

following https://docs.oracle.com/cd/E11882_01/timesten.112/e21632/install.htm#TTINS171

for timesten client installation


Program Folder: TimesTen 11.2.2 (32-bit)
Register TimesTen enviroment variables: Enabled
World-Writeable: Enabled
PL/SQL: Enabled
Java Version: JDK 6
Java Classpath: C:\TimesTen\tt1122_32\lib\ttjdbc6.jar

Destination Location: C:\TimesTen\tt1122_32\
Demo Data_Store Location: C:\Users\liqy\AppData\Roaming\TimesTen\DemoDataStore

Features Selected:
            TimesTen Data Manager
            TimesTen Documentation
            TimesTen Client
            TimesTen Quickstart


Finally , see the timesten tab in sql developer.




Next, I am a bit confused by the username and password needed. Here are information found from various source.

UID


Specify a user name that is defined on the TimesTen server. When caching data from an Oracle database, the UID must match the UID on the Oracle database that is being cached in TimesTen.

In the Username field, enter the TimesTen user. If you use the TimesTen database to cache data from an Oracle database, enter the TimesTen cache manager user name. If you use the TimesTen database to load data from an Oracle database, enter the TimesTen user name that has SELECT privileges on the Oracle database tables that you want to load.


PWD

In the Password field, enter the password for the TimesTen user.


Specify the password that corresponds with the specified UID. When caching data from an Oracle database, PWD specifies the TimesTen password. You can specify the Oracle PWD in the connection string, if necessary.






As shown above, I can connect to timesten use either cacheadm or hr to connect to database, subject to purpose/function interested.

No comments:

Post a Comment