Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to configure access to TimesTen db from client system via TNS name?

m_yasiraliOct 11 2022 — edited Oct 11 2022

Good day,
We Installed Timesten server , and is working fine, created a db and connected from client system(windows OS) by Installing the client software via ODBC.
However, we want to connect to the Timesten from the client system(linux OR windows) to access the databases on the Timesten via TNS naming.
We want this to be able
to connect to the TimesTen DB via sqlplus using TNS naming.
And to configure ORDS to work with TimesTen DB using TNS entry.
So, How can we configure access to TimesTen db from client system via TNS naming entry?
Here is the detailed info of the TimeTen Server
We have installed Timesten timesten221120.xe.server on rockylinux-9 OS.
The server is running fine \
[ttuser@timesten timesten]$ ttstatus
TimesTen status report as of Tue Oct 11 12:21:45 2022

Daemon pid 526 port 6524 instance timesten
TimesTen server pid 533 started on port 6625
------------------------------------------------------------------------
------------------------------------------------------------------------
Data store /home/ttuser/databases/sampledb
Daemon pid 526 port 6524 instance timesten
TimesTen server pid 533 started on port 6625
There are no connections to the data store
Open for user connections
Replication policy : Manual
Cache Agent policy : Manual
PL/SQL enabled.
------------------------------------------------------------------------
Accessible by group ttadmin
End of report

This post has been answered by Doug Hood-Oracle on Oct 14 2022
Jump to Answer
Comments
Post Details