DBA Blogs

Partner Webcast – Understanding GDPR and the Oracle value proposition for Partners

The EU General Data Protection Regulation (GDPR), replaces the over fifteen year old existing EU Data Protection Directive, and it’s equally important for Oracle customers and partners. While...

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

Oracle Indexing Myths (Telling Lies)

Richard Foote - Mon, 2017-09-25 16:41
I’m currently hard at work fully revising and updating my “Indexing Internals and Best Practices” seminar in time for a series of events I’ll be running in Australia in October/November. This has been a highly popular and acclaimed 2 day seminar that is a must for any DBA, Developer, Solutions Architect or anyone else interested […]
Categories: DBA Blogs

#GoldenGate Microservices (4 of 5) … Receiver Service

DBASolved - Mon, 2017-09-25 12:23

This is post 4 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The Receiver Serivice is the least complicated of the microservices with Oracle GoldenGate 12.3 Microservices. This service is taking the place of the collectors in classic architectures. When you fist login to the Reciever Service, you land on the Overview page (Figure 1). On this page, you can clearly see that the host were it is running on what trail file it is writing to.

Figure 1:

If you click on the “Action” button, you willl be presented with a “Details” option. This option takes you to the Path Information page. On this page, you can see the Network Statistics and File IO Statistics (Figure 2). All this information provides you a view into how your transactions are being written to the trail file and at what rate.

Figure 2:

Lastly, if you go back to the overview page. On the context menu, just like other pages, you have a Diagnosis & Reports page (Figure 3). This page, provides you a quick and easy look at the log file associated with the services. It is color coded (greed, yellow, red) to help you quickly identify what needs to be looked at.

Figure 3:

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

#GoldenGate Microservices (3 of 5) … Distribution Service

DBASolved - Mon, 2017-09-25 09:44

This is post 3 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The third part of setting up the replication enviornment with Microservices is to understand what the Distributuion Server is. The component is the replacement for the Data Pump Extract in classic architecture. Distribution Server does all the same things as the Data Pump Extract except with from transformations. If you use transformations in the Data Pump, you really should relook where this is being done.

Note: Transformations should be done at the source, target, or with Oracle Data Integrator.

Distribution Server is your path way for shipping trail files from source to target in the Microservices architecture. Let’s take a closer look at this service.

Upon accessing the Distribution Server page, you see a blank page (Figure 1). This is the overview page and where you will configure you distribution paths needed for replication.

Figure 1:

To begin adding a distribution path, click the plus ( + ) sign on the right hand side of the page. This will take you to the Add Path page (Figure 2). On the Add Path page, you will provide the details for the path. These details include extract/trail file to read from, protocol to use for transmissions, log positioning and many other options. A lot of the items you could do in the data pump extract, can be configured on this page as well.

Figure 2:

After adding a distribution path, you will be able to see clearly where the transactions are coming from and being shipped to (Figure 3). You will also see what database, extract, and trail if being used for the transactions.

Figure 3:

If you click on the “Action” button, you are taken to a menu where you can perform operations on the Distribution Path. There is an option for “Details”. By looking at the details, you can quickly see, in more detail, what is happening with the Distrubtuion Path. You can see the source and target, database, extract, trail name, source trail file, as well as many other item (Figure 4). Additonally, on the details page, you can see the statistics for what is running through the Distribution path.

Figure 4:

Lastly, if you return to the context menu on the left hand side, you will see an option for “Diagnosis & Reports”. Here is where you will be able to take a look at the report file for the Distribution Server (Figure 5). This page provides you with a date sorted view of the log file for easy reading. You will also be able to quickly find items that are wrong or warnings by the color indicator used with the log file.

Figure 5:

Enjoy!!!


Filed under: Golden Gate
Categories: DBA Blogs

TNS could not resolve the service name

Tom Kyte - Mon, 2017-09-25 09:26
I have been trying to connect SQL Plus, Report Builder but getting error "TNS could not resolve the service name " In SQL developer i tried with two connections name it worked ,below is the detail : Connection name : MyConn user : system passs:...
Categories: DBA Blogs

Is there a risk in continuing to develop using plsql web toolkit?

Tom Kyte - Mon, 2017-09-25 09:26
Hi Tom, I hope you can help or point me in the right direction. I have been asked to evaluate an in-house developed system that is written entirely in plsql/web toolkit using mod_plsql. This is a heavily used service, sometimes with very high conc...
Categories: DBA Blogs

String buffer into Oracle (utl, xml)

Tom Kyte - Mon, 2017-09-25 09:26
<code>I have procedure to create xml file and save it on disc directory: create or replace procedure test_write_xml_data_to_file (p_directory varchar2, p_file_name varchar2) as v_file UTL_FILE.FILE_TYPE; v_amount INTEGER := 32767; v_xml_dat...
Categories: DBA Blogs

Error while inserting data through SQL Loader

Tom Kyte - Mon, 2017-09-25 09:26
Hi All, We are using SQL loader in our .Net application to insert data into oracle Data base. We are inserting through bulk insert process. We have another Stored procedure in Oracle which deletes data from the same table where insertion happe...
Categories: DBA Blogs

Using Interval Datatype

Tom Kyte - Mon, 2017-09-25 09:26
I have the following query where TS_END and TS_START are DATE columns. I used to run this query to give me the average response time in seconds: SELECT COUNT(*) system_process_count, TRUNC(AVG(lgrt.ts_end - lgrt.ts_start)*24*60*60, 1) FRO...
Categories: DBA Blogs

Oracle Cloud Announcement: More Automation. Lower Prices.

This week Larry Ellison, Executive Chairman and CTO of Oracle, announced two new programs designed to increase flexibility and automation in the way customers can purchase and consume their Oracle...

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

how the SQL query is processed

Tom Kyte - Sun, 2017-09-24 15:06
How the SQL query is processed in detail
Categories: DBA Blogs

Range constraint

Tom Kyte - Sun, 2017-09-24 15:06
Hi! First i want to thank you for the many Responses that where usefull for me. I need a constraint or trigger that controls if the row inserted or updated contains a range of numbers that is already contained in another row of the same table. ...
Categories: DBA Blogs

oracle plsql data migration

Tom Kyte - Sun, 2017-09-24 15:06
Hi Tom, i need to write a plsql program, Suppose there are 10 sup tables with different columns in each table and 1 target table which have columns same as combined all source columns. i need to write a procedure which will extracts the data from...
Categories: DBA Blogs

temp undo sizing

Tom Kyte - Sun, 2017-09-24 15:06
Hi team, I have One question - 1. Suppose i have 1TB DB Size so What our recommendation in term of -sizing of database memory. -Temporary tablespace -Undo tablespace Thanks
Categories: DBA Blogs

Convert sys_guid to number

Tom Kyte - Sun, 2017-09-24 15:06
Hi Tom I read some articles about to_number(sys_guid()), but You suggest not to use it. Why Apex QuickSQL suggests to_number(sys_guid()) for unique object-ID ? Example create or replace trigger country_biu before insert or update ...
Categories: DBA Blogs

Query taking more time to split,compare against lookup table and to insert

Tom Kyte - Sat, 2017-09-23 02:26
We have a dimension table in which one column has mutlipul values like an Array. I have to get all this individual values and should compare against a lookup table, if the value does not exist in the look up table then i have to insert this value ...
Categories: DBA Blogs

TNS No Listener issue

Tom Kyte - Sat, 2017-09-23 02:26
When i am trying to connect to one of our databases on Toad/SQL developer/SQLPLUS, getting the issue that the ORA-12541 TNS No Listener. steps to take: verify that the port specified in the connect descriptor is correct in tnsnames.ora verify t...
Categories: DBA Blogs

ORA 1017 error while connecting to the database as SYS using SQL developer

Tom Kyte - Sat, 2017-09-23 02:26
I changed the SYS user password in database I recreated the password file using Oracle Doc ID 1029539.6 Now when I try to login to the database using SQL developer it gives the ORA 1017 error Am I missing any step here ? please advise ... ...
Categories: DBA Blogs

How to see SGA usage for all active and inactive sessions i.e SGA used by each process / session

Tom Kyte - Sat, 2017-09-23 02:26
Recently , I ran into a System Global Area (SGA) related alert as below : SGA USAGE INST_ID TOTAL_MB USED_MB FREE_MB FREE_PCNT 1 168836.35 105033.66 43802.71 29 And these alert kept on showing frequently for pas...
Categories: DBA Blogs

Protect access to certain data from the DBA

Tom Kyte - Sat, 2017-09-23 02:26
This question has probably been asked many times, but I cannot find a solid solution. We are required to restrict access (select/insert/update/delete) to certain database tables even from the DBA. As far as I know, only Database Vault can do this rel...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs