DBA Blogs

Partner Webcast - Maximizing the value of Oracle Cloud Infrastructure (OCI)

Oracle Cloud Infrastructure is a set of cloud services that enable you to build and run a wide range of applications in a highly-available environment. With Oracle Cloud Infrastructure we’ve...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Announcement: New Europe Seminar in Brussels, Belgium 27-28 September 2018

Richard Foote - Tue, 2018-07-03 01:49
Due to popular demand, I’ll be running another of my acclaimed seminars in Europe later in the year, this time in Brussels, Belgium on 27-28 September 2018. This is a must attend seminar of benefit to not only DBAs, but also to Developers, Solution Architects and anyone else interested in designing, developing or maintaining high […]
Categories: DBA Blogs

Email Domain Extraction using sql query

Tom Kyte - Tue, 2018-07-03 01:06
if the part of email before domain matches for eg in : xyz@gmail.com xyzef@gmail.com if xyz and xyzef does not match ,then do not consider this records and if the scenario is like , if non domain part are equal like xyz@gmail.com xyz@g...
Categories: DBA Blogs

Make Index Invisible for a session

Tom Kyte - Tue, 2018-07-03 01:06
Hi With the advent of In-Memory capabilities in 12C is there a way to make the optimizer ignore indexes for particular table for a session. The reason being if we want to use Oracle 12C as HTAP (Hybrid Transactional Analytical Processing) we wou...
Categories: DBA Blogs

ORA-31011: XML parsing failed issue

Tom Kyte - Tue, 2018-07-03 01:06
While extracting data from xml parsing issue is coming. Issue is coming while extracting data for field_name 401K_LOAN_1 and 401K_LOAN_2. Please advise. <code>PROCEDURE SP1( SXML IN CLOB, p_status OUT VARCHAR2, p_message OUT VARCHAR...
Categories: DBA Blogs

XMLForest for more than one tables

Tom Kyte - Tue, 2018-07-03 01:06
hi all i'm trying to make an enquiry from 2 tables with XML function, but i have some problems: this is sql i'm using for this sample select from the 2 different tables i'm using <code>select deptno,dname from dept; select empno,ename,de...
Categories: DBA Blogs

Transpose Rows Into Column

Tom Kyte - Mon, 2018-07-02 06:46
Hi, My question is regarding transpose of rows into columns: <code>BANNER_CODE/DIV_CODE/LEG_MATNR/SAP_MATNR/MAKTX/LEG_MATKL/SAP_MATKL/LEG_WHERL/SAP_WHERL/ CS/1/10137/58351/BAKE KING CHOCOLATE RICE 160G/384/10203004/34/SG/1 GH/1/36762/212615/M...
Categories: DBA Blogs

acfs not supported in oracle linux 7 though oracle documents says its supported.

Tom Kyte - Sun, 2018-07-01 12:26
Hi tom, In a rac environment with grid infrastructure i am trying to configure acfs. But i am getting following error. ACFS-9459: ADVM/ACFS is not supported on this OS version: 'unknown' ACFS-9201: Not Supported Blogs says i need to appl...
Categories: DBA Blogs

Creating linguistic indexes for CANADIAN FRENCH

Tom Kyte - Sun, 2018-07-01 12:26
When creating a linguistic index, I am not able to specify CANADIAN FRENCH. Oracle reports that the NLS parameter string is invalid. I suspect that it's because there is a space in it, but the answer eludes me. Here is a short example of a script ...
Categories: DBA Blogs

ora_rowscn - is it always incremental,

Tom Kyte - Sun, 2018-07-01 12:26
Hello, I want to sqoop data out of my Oracle 11.2 database on a daily basis. However, I want to do only incremental extracts. Apparently, scn_to_timestamp doesn't always work due to ORA-08181: specified number is not a valid system change number...
Categories: DBA Blogs

How to get the operating system user OSUSER from Oracle

Tom Kyte - Sat, 2018-06-30 18:06
I believe there is a way to get the LAN user ID of a user from within an Oracle query. I thought the variable was called OSUSER or OS_USER. I've tried select os_user from dual, but that doesn't work. Yet I think I'm close. Can you lead me in the ...
Categories: DBA Blogs

Some Interview Questions

Tom Kyte - Fri, 2018-06-29 05:26
Hi Tom, Recently I attened a inteview , I have given the questions which I'm not able to answer. 1.When using rman ,oracle will use its own processes than the OS one.the questions is what are the advantages oracle is getting by using it ow...
Categories: DBA Blogs

Performance Metric Service – Classic Configuration

DBASolved - Thu, 2018-06-28 16:37

Almost a year ago, Oracle released Oracle GoldenGate 12c (12.3.0.1.x). At that time, there were two architectures released; Microservices and Classic. Both architectures provided the same enterprise level replication. The only difference was that one enabled a RESTful API interface with HTML5 page and the other was still command line driven.

The biggest change though was with the addition of the Performance Metric Service/Server that come bundled with the core product. This is a huge addition to the core product and allows end-users to monitor their Oracle GoldenGate environment in near-realtime. On the Microservices architecture this service is enabled automatically and can be used on a per deployment basis. With the Classic architecture, it is there but requires a small configuration to get it to work.

In this post, I’ll show you how to get the Performance Metric Service (PMSRVR) in Classic Architecture configured and access the RESTful API endpoints. The context of this post actually builds upon a post I did almost 3 years ago (here), where I talked about how to pull XML information via a browser for Oracle GoldenGate.

After installing Oracle GoldenGate 12c (12.3.0.1.4) Classic Architecture, open GGSCI and evaluate the environment. You should notice that you have a Manager, JAgent, and Performance Metric Service (PMSRVR) all as defaults (Figure 1).

Figure 1:

Next start the Manager (MGR) process. This is done the same way as has been done in in the past – START MGR. Once the MGR process is started, your GGSCI should look like Figure 2.

Figure 2:

Now to get the PMSRVR to work. This requires the editing of the GLOBALS file. The GLOBALS files can be edited either from the command line (vi GLOBALS). Within the GLOBALS file, turn on the ENABLEMONITORING parameter. At this point, you need to understand that there has been a few changes to Oracle GoldenGate with the ENABLEMONTIORING parameter. Without getting into to much details of the changes, you now have to specify the option for UDP.

A simple GLOBALS file would look like this:

ENABLEMONITORING UDP

At this point, you can start the PMSRVR within GGSCI (start pmsrvr) (Figure 3). What this does is provide you with a default port of 9004 to access PMSRVR pages via HTTP. If you want to get more detail and have a bit more control over the port numbers, you can modify the GLOBALS file to specify the HTTP port you want to use.

An example would look like this:

ENABLEMONITORING UDP HTTPPORT 12000

Note: https://docs.oracle.com/goldengate/c1230/gg-winux/GWURF/Chunk1486599197.htm#GWURF474

Then restart the PMSRVR. After the restart, you will be able to access the PMSRVR via the HTTP port specified.

Figure 3:

Now to access the PMSRVR page, just navigate to http://hostname:port/groups (Figure 4). This is the starting point for checking the status.

Figure 4:

Notice that in Figure 4, you see a list of all services that are avaliable within the product. The services like AdminSrvr, Recvsrvr, Distsrvr, and Adminclnt are never executed. This is normal since this is not the Microservice Architecture. These services will not work.

At this point, you can use the web pages to drill into the PMSRVR, MGR and any capture/apply processes that are being monitored by the PMSRVR.

Enjoy!!

Categories: DBA Blogs

what's the exact difference bwtween force logging and supplemental logging?

Tom Kyte - Thu, 2018-06-28 11:06
I am confusing about the difference bwtween force logging and supplemental logging, could you explain that for me? and are both force logging and supplemental loggins necessary for goldengate? thanks!
Categories: DBA Blogs

Compare for matching recrds i n two table and return true or false against each row

Tom Kyte - Thu, 2018-06-28 11:06
Dear Tom I am sorry if this has been dealt before, I am a complete beginner to ORACLE SQL and will appreciate your help. I have two tables table A and Table B. Table A has about 60,000 rows of customer data with Customer Id as main identifie...
Categories: DBA Blogs

How to validate multiple errors in Oracle

Tom Kyte - Wed, 2018-06-27 16:46
Hi Tom, i have a table like an employee in the three fields 1) ename 2)empno 3)salary <code>create table details(ename varchar2(20),empno number(12),salary number(12));</code> I am receiving data from the file(clob) by the administrator for...
Categories: DBA Blogs

How can I check all the programs in my database?

Tom Kyte - Wed, 2018-06-27 16:46
Hello The Oracle Masters, First, congratulations for this site and your answers, you are so good that I try my chance today. Is it possible to find in ONE table or ONE view or with a PL/SQL package all the programs that can be executed in my ...
Categories: DBA Blogs

How to UNION ALL xxx_VIEWS and xxx_SOURCE ?

Tom Kyte - Wed, 2018-06-27 16:46
I often build a view to prototype/develop ETL transformation rules, then "wrap" the view in a PL/SQL package. Occasionally, I need to search the ETL code. However, xxx_VIEW.TEXT is LONG, while xxx_SOURCE is VARCHAR2(4000). I know I can run t...
Categories: DBA Blogs

strange index issue

Tom Kyte - Wed, 2018-06-27 16:46
Hi Tom, I will explain my case in example. I create simple table just with two columns: <code>create table OC_YKB.TAB_TEST1 ( GUID number, stat varchar2(1) );</code> Then insert 1 million of values where GUID is different values and STAT =...
Categories: DBA Blogs

Retrieving input from a COM port, source being weighing scales

Tom Kyte - Wed, 2018-06-27 16:46
We are currently migrating a client from a Forms environment towards an APEX application. The client is used to using scales, the result of which is inserted into a Forms application: The user enters the cursor into the target cell in the Forms envir...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs