So how do we setup the True Cache and Application services. You’re going to create a database application service on the primary database. You might already have one created that you want to use for True Cache. But however, we’re going to operate under the concept that you don’t have one. You want to verify that your database application services are created. You’re going to make sure that those services are started.
And then on the primary database, you’re going to use the DBMS_SERVICE. This is usually specific to a pluggable, so you’re going to connect to that PDB or make sure you set the correct PDB container in the session before you start the DBMS_SERVICE.
For RAC, you’re going to use service control to configure it. So here we can see an example of the service control command utility to add that service.
On the primary database, if you’re using one True Cache service, two services, one single database as the instance primary database, what are you going to do? So here, in this first example, we’re creating a database application service for the True Cache called SALES TC, using that as the name.
Next, we have a create database application service SALES for the primary database using SALES as the name. And we are associating it to the SALES TC service using the TRUE_CACHE_SERVICE attribute.
And then third, if you already have a service created, optionally, just modify an already existing primary database service called SALES. And here, we’re associating it to the SALES TC service, again using the TRUE_CACHE_SERVICE attribute. So create them, associate it. Or it’s already created, just associate it.
We’re going to verify the service.
This is an example query with the possible output. So here we’re selecting, OK, what are the services I have? So here we can see that we have the SALES True Cache. We have the SALES service. And then we also– then on the TRUE_CACHE_SERVICE, we have the SALES True Cache.
We can start the service on the True Cache instance. We’re going to launch SQL*Plus.
Here we connect to it. Check our role.
Yep, this is the one. This is where we have the True Cache. That is the role of this database.
Then we’re going to start it. Start the service.
Then we’re going to verify the service.
Yep, we can see, there’s our SALES_TC service.
So we’re going to do something similar on the primary database. We’re going to launch SQL*Plus, check the database role. Because you might say, well, that’s pretty simple. Well, we want to make sure that you’re on the right place at the right instance to do the right command. That’s why sometimes we check those things. We’re going to make sure the service is started. In this case, SALES services started.
We’re going to check the service. We’re going to select from that active service name. There we see our SALES service.
Recent Comments