Creating Database in TimesTen of Exalytics

Standard

Hi Users,

As all of we know that Exalytics use TimesTen database.

Today we learn how to create new database in TimesTen

In Exalytics, edit your sys.odbc.ini file.

Declare & define dsn with parameters required. Let’s we’ve defined dsn as TT_Test

Connect to Exalytics through putty

Enter into sql command prompt by issuing ./ttisql command

Issue this command after connecting to sql command prompt.

Connect “dsn=TT_Test”;

Let’s understand this command, while issuing connect command to TimesTen, what it’ll do is: It checks any database existed with name TT_Test. If not exists, it create new database in TimesTen, if existed it loads the data into Memory.

You’ll see message: It’s successfully connected/created.

If you want to use this database to crate aggregates from summary advisor, we need to create a schema in this.

So, issue this command:

>create user test_user identified by test_user;

>grant admin to test_user;

Now, schema is created with test_user name and can be used in rpd to make it available for summary advisor as target db.

Hope we’re clear on how to create database in TimesTen of Exalytics.

Thanks,

Kishore Guggilla

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s