I have been teaching security classes about Oracle Security for many years and they are very popular and I teach many classes per year around the world; mostly in the UK and EEC but I also venture to the Middle....[Read More]
Posted by Pete On 24/05/16 At 12:43 PM
Since Oracle Enterprise Manager 12C it is possible to allocate the costs of IT resources to the people of organizations who consume them. This is done through the use of the plugin ‘Consolidation Planning and Chargeback’ .
Pete Sharman wrote an excellent blog about configuring this plugin in Enterprise Manager 12c, and it’s not my intention to copy his work, so I’d like to focus on complementary stuff regarding Oracle Enterprise Manager 13c.
In this article (more...)
This is really messed up. I chose GoldenGate because I did not want to mess around with streams.
When using Integrated Capture or Delivery, then knowing streams is a prerequisites.
Apologies as the format is not pretty.
The QUEUE table was indeed missing and this is what I get for monkeying around.
To resolve the issue – exec DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
GGSCI (arrow.localdomain as ggs_admin@hawk) 3> unREGISTER EXTRACT e_hawk DATABASE
2016-05-23 19:16:32 ERROR OGG-08221 Cannot (more...)
This posting is to try to clarify what is supported when using Enterprise Manager Cloud Control 13c (EM13c) and Amazon Web Services (AWS). The question came from some of our sales consultants who were finding confusing information about what is actually supported when using EM13c and AWS, so I have asked our Support folks to write a support note to provide the definitive answer on this. While that is being written, I thought I would (more...)
BDB User Authentication
(courtesy of Brayden Zhang)
In Berkeley DB 6.2, user authentication extension is added into the SQL interface. The new user authentication layer is both secure and easy to use. In this article, we will introduce how to use the user authentication, and also... [Read More
In a couple of weeks, I will be presenting the following sessions at the HIUG Interact 2016 conference in San Antonio
- 16165 : PeopleSoft Fluid User Interface – Deep Dive: Grand Oaks D, Mon, Jun 13, 2016 (03:15 PM - 04:15 PM)
- 16164 : PeopleTools Tips & Techniques: Grand Oaks D, Tue, Jun 14, 2016 (02:30 PM - 03:30 PM)
- 16163 : Tech Clinic: Application Designer Grand Oaks D, Wed, Jun 15, 2016 (12:30 PM (more...)
Today’s post is courtesy of this question from a reader:
Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted?
The answer is ‘Yes!’
I’m going to use HR.EMPLOYEES to give me my data.
I start with…
SELECT Hire_date,... [Read More
Here’s a story of (my) failure prompted by a recent OTN posting.
The OP wants to use composite partitioning based on two different date columns – the table should be partitioned by range on the first date and subpartitioned by month on the second date. Here’s the (slightly modified) table creation script he supplied:
CREATE TABLE M_DTX
VC GENERATED ALWAYS AS (EXTRACT(MONTH FROM DATE2))
Those of you who know me will know that I’m working at Cedar and we’re moving from PeopleSoft to the Oracle Cloud. I won’t talk about the company’s journey, but more how I’ve found the transition personally.
In brief, there’s a lot to learn.
Data Model knowledge
In the PeopleSoft world, once you know the table structures you could work significantly faster. Whether you were writing an SQR, an App Engine, an XMLP report, a (more...)
I was asked by Delphix earlier this year to review their product with a particular focus on Oracle security of course. I wrote two papers; the first about Data Masking and Delphix and the second about securing data in non-production....[Read More]
Posted by Pete On 23/05/16 At 11:23 AM
Creating database tables in Oracle is one of the most common tasks an Oracle developer or Oracle DBA does. Learn how to create tables, what the syntax is, and see some examples in this article. What Is The Create Table Command Used For? The CREATE TABLE command is used to create a database table. It […]
A frequently reoccuring design problem with relational databases is the issue locating unprocessed rows in a large table, so we know which rows of data are still yet to be processed.
The problem with a STATUS column is that it generally has low cardinality; there are probably only a handful of distinct values [(C)omplete, (E)rror, (U)nprocessed or something like that]. Most records will be (C)omplete. This makes STATUS a poor candidate for standard B-Tree indexation. (more...)
If you didn’t come this page from my review about the OUGF Harmony16 Spring Conference, please don’t forget to read it. This post is generated almost automatically by scripts to share the twitter statistics of the conference. The statistics cover the period between May 17 and May 20. I included three hashtags (#OUGF, #OUGF16, #Harmony16), because at the beginning of the conference, people (including me) did not used the official hashtag (#Harmony16).
Last week I took part in the OUGF (Oracle User Group Finland) Harmony 16 Spring Conference. It was a two day event, and held in Helsinki, between May 18th and 19th. In the conference, I gave two speeches: “Essential Linux commands for DBAs” and “Enterprise Manager 13c for DBAs”. Most people expect to me to speak about Enterprise Manager but in my first session, I spoke about the tools which can be used for monitoring (more...)
Alternate script prvtlmpg.plb (included in the Oracle GoldenGate installation directory) to the mining database to work around this limitation.
$ ll prv*
-rw-r-----. 1 oracle oinstall 1272 Dec 28 2010 prvtclkm.plb
-rw-r-----. 1 oracle oinstall 9487 May 27 2015 prvtlmpg.plb
-rw-r-----. 1 oracle oinstall 3263 May 27 2015 prvtlmpg_uninstall.sql
The other option in this (more...)
I typically don’t like to see WARNING if I can help it.
Goldengate 12c has some security features to allow/prevent unauthorized access.
Be careful. Incorrect IPADDR or PROG is used will prevent Pump Extract delivery to target server.
$ tail -100 ggserr.log
2016-05-22 12:25:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-05-22 12:25:07 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule (more...)
So what’s different from this post versus other posts? I share my mistakes with you.
Did you know there was a DEFAULT domain? If you didn’t, neither did I and only found out by using
alter credentialstore add user ggs_admin alias ggs_admin domain admin
USERIDALIAS ggs_admin DOMAIN admin
alter credentialstore add user ggs_admin alias ggs_admin
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0. (more...)
I’ve been meaning to write about SQLcl for quite some time now – a lot is happening in the SQLcl world – but I hadn’t had the chance due to my very busy schedule.
Since some bigger things had happened recently, I feel it is a good opportunity to write about it. I promise to take some time to write (and maybe even video) some guides for SQLcl in the near future.
Okay, enough with (more...)