DBA Blogs

Need some suggestion on Special characters.

Tom Kyte - Thu, 2018-03-08 22:26

Hi Tom, I'm using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production. Need some suggestion regarding how to handle special characters. <b>My doubt with converting any special characters to normal character except belo...

Categories: DBA Blogs

It doesnt Work. VARCHAR2(4000 CHAR)

Tom Kyte - Thu, 2018-03-08 22:26

Hi, I have five columns as below in my DB col1 VARCHAR2(4000 CHAR) col2 VARCHAR2(4000 CHAR) col3 VARCHAR2(4000 CHAR) col4 VARCHAR2(4000 CHAR) col5 VARCHAR2(4000 CHAR) When i try to save the data with max length, i get the following error. <...

Categories: DBA Blogs

Making APEX_WEB_SERVICE.make_rest_request work with HTTPS

Tom Kyte - Thu, 2018-03-08 22:26

I have created a standard template database via DBCA in Oracle 12c R2 and then installed the APEX code via the apex installation directory that was installed with the Oracle 12c R2 binaries. I have also upgraded APEX to 5.0.4 I have created a s...

Categories: DBA Blogs

ODP.NET - System.Exception: 'UnmarshalColumnData: Unimplemented type' when calling nested cursor

Tom Kyte - Thu, 2018-03-08 22:26

Hello! I've faced with strange behaviour while calling procedure over ODP.NET with nested cursors inside. 1. I've created simple Oracle function under example schema: <code>CREATE OR REPLACE FUNCTION TEST_CUR RETURN SYS_REFCURSOR IS O...

Categories: DBA Blogs

Does an automated cloud data warehouse need partitioning and indexes?

Bobby Durrett's DBA Blog - Thu, 2018-03-08 16:33

This is a late post inspired by my time at RMOUG Training Days 2018. I attended two RMOUG Training Days presentations about automated cloud data warehouse database systems. The first was about Snowflake. The second was about Oracle’s coming Autonomous Data Warehouse Cloud offering. Both products seem to have the goal of automating as much as possible in a data warehouse database and neither seem to allow users to create indexes or to partition their data in the way they choose.

This raises the obvious question – do you need the ability to create indexes and define your own partitioning scheme in a data warehouse database? I have seen many situations on data warehouse databases where both are helpful. When we went to Exadata there was a push to drop all of our indexes but we did not. Also, we used partitioning to improve query performance. If we had to get rid of both features what would we have done on Exadata?

I don’t know the answer, but people say that we need more automation and less control. So, you could spin up a cloud based data warehouse database quickly and start using it. But how many knobs are left to turn when performance is slow? Do users need indexes and partitioning methods to get acceptable performance? Really, what is wrong with giving users the ability to create indexes and to partition tables in the way they want?

Time will tell whether index and partition free cloud based data warehouse database systems make it. But, for now I’m left to wonder what we are losing without these features.

Bobby

Categories: DBA Blogs

Changing Security Role Password in Oracle GoldenGate 12.3 Microservices

DBASolved - Thu, 2018-03-08 12:02

One of the nice things about Oracle GoldenGate 12.3 Microserivces, is the flexibility we now have to interact with Oracle GoldenGate. Additionally, what comes with Oracle GoldenGate 12.3 Microservices is a new role based security frame work.

When you first setup Oracle GoldenGate 12.3 Microservices, you setup your ServiceManager and initial deployment. Upon setting this up, you will assign a new administrator to the frame work. This is a different user than the Oracle GoldenGate user within the database. This user is the user assigned to the security role (highest role). This user is the equivalent of the SYS user in the Oracle Database and has access to everything within the security framework of Oracle GoldenGate 12.3 Microservices. It should be a no-brainer to keep the password for this user secure and to as few people as possible.

Now, when you look at the user from inside of the Administration Server (AdminServer); notice there is not an update button under the Action category (Figure 1).

Figure 1:

So how do we update this password for a user in the security role, much less any other role? Remember, when I said Oracle GoldenGate 12.3 Microservices was “flexible”? We have to use the RESTful API to update the password.

The exact end-point that you have to use is: /services/v2/authorizations/{role}/{user}. More info can be found here.

The way that I update the password is by using a JSON document and a simple cURL command. Below is a simple JSON document example:

{
“credential”:”welcome1″
}

Then the cURL command I use is:

curl -u oggadmin:********* -H “Content-Type:application/json” -H “Accept:application/json” -X PATCH http://localhost:16001/services/v2/authorizations/security/oggadmin -d @update_security_password.json| python -mjson.tool

After running the cURL command, the password for the oggadmin user is updated. You should see some similiar output to this output.

{
“$schema”: “api:standardResponse”,
“links”: [
{
“href”: “http://localhost:16001/services/v2/authorizations/security/oggadmin”,
“mediaType”: “application/json”,
“rel”: “canonical”
},
{
“href”: “http://localhost:16001/services/v2/authorizations/security/oggadmin”,
“mediaType”: “application/json”,
“rel”: “self”
}
],
“messages”: [],
“response”: {
“links”: [
{
“href”: “http://localhost:16001/services/v2/authorizations/security/oggadmin”,
“mediaType”: “application/json”,
“rel”: “self”
}
]
}
}

Hope this helps you understand how to change a user password from REST within the Oracle GoldenGate 12.3 Microservices Architecture.

Enjoy!!!

Categories: DBA Blogs