- 30
- 22 317
Onur Senturk
เข้าร่วมเมื่อ 14 ก.พ. 2018
Providing demos for frequently implemented use cases in cloud environments
Quick Demo - OCI GoldenGate Real Time Replication From Oracle Database to SQL Server 2019
Hello,
In this video i wanted to do a live demo on how to configure real time replication from OCI Base Database Service to a SQL Server 2019 environment.
Here is the cheat sheet you can use:
You can also find it on GitHub.
Create deployment
Create tables in target db
Integrated extract - source dep
Initial load - source dep
Replicat - target
User - target
Distribution service for initial load - source
Distribution service for integrated extract - source
Could not paste the code snippets here but you can find them in the GitHub link here:
github.com/onsenturk/OCICheatSheet/blob/main/GoldenGate%20Replication.txt
00:00 Intro
02:11 SQL Server Database and table configuration
04:20 Oracle Database GoldenGate configuration and user setup
06:30 OCI GG Connection creation
07:50 OCI GG Deployment setup
12:10 Assign connection to each deployment
16:15 OCI GG Oracle integrated extract setup
19:20 OCI GG Oracle initial load setup
24:08 OCI GG Sql Server user setup for receiver service
25:20 OCI GG Oracle, credential setup for distribution service
25:57 OCI GG Oracle, Distribution service setup - integrated extract
27:44 OCI GG Oracle, Distribution service setup - initial load
29:10 OCI GG Sql Server, Replicat Setup - Initial Load
30:30 Troubleshooting
38:30 Found the solution (make sure you remove the foreign keys in the target table definitions)
39:20 Verify data
40:10 OCI GG Sql Server, Replicat Setup - Integrated Extract
In this video i wanted to do a live demo on how to configure real time replication from OCI Base Database Service to a SQL Server 2019 environment.
Here is the cheat sheet you can use:
You can also find it on GitHub.
Create deployment
Create tables in target db
Integrated extract - source dep
Initial load - source dep
Replicat - target
User - target
Distribution service for initial load - source
Distribution service for integrated extract - source
Could not paste the code snippets here but you can find them in the GitHub link here:
github.com/onsenturk/OCICheatSheet/blob/main/GoldenGate%20Replication.txt
00:00 Intro
02:11 SQL Server Database and table configuration
04:20 Oracle Database GoldenGate configuration and user setup
06:30 OCI GG Connection creation
07:50 OCI GG Deployment setup
12:10 Assign connection to each deployment
16:15 OCI GG Oracle integrated extract setup
19:20 OCI GG Oracle initial load setup
24:08 OCI GG Sql Server user setup for receiver service
25:20 OCI GG Oracle, credential setup for distribution service
25:57 OCI GG Oracle, Distribution service setup - integrated extract
27:44 OCI GG Oracle, Distribution service setup - initial load
29:10 OCI GG Sql Server, Replicat Setup - Initial Load
30:30 Troubleshooting
38:30 Found the solution (make sure you remove the foreign keys in the target table definitions)
39:20 Verify data
40:10 OCI GG Sql Server, Replicat Setup - Integrated Extract
มุมมอง: 531
วีดีโอ
Quick Demo - Oracle Database Data Guard Observer 3rd site installation
มุมมอง 734ปีที่แล้ว
In this video I would like to show you how to install the observer on a 3rd site and enable fast start failover between a primary and standby database instance. Please find the commands i used here in the github link github.com/onsenturk/OCICheatSheet/blob/main/DataGuardObserver.txt The official documentation for the data guard configuration can be found here: docs.oracle.com/en/database/oracle...
Quick Demo - Enabling SuiteAnalytics Connect and connecting Oracle Analytics Cloud with NetSuite
มุมมอง 1.7Kปีที่แล้ว
Hello, In this video I wanted to show you how you can enable SuiteAnalytics Connect on Netsuite and connect OAC with Netsuite for custom reporting. Some helpful links are: Enabling SuiteAnalytics Connect: docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3996274388.html Information about roles and permissions: docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3998867068....
Quick Demo - Create Persistent Volume Claim with File Storage Service on Oracle Cloud Kubernetes OKE
มุมมอง 849ปีที่แล้ว
Hi, In this video I will show you how you can create a persistent volume claim with the OCI native File Storage Service on OKE. I will create the File Storage Service from scratch as well The steps and the yaml files can be found here: tinyurl.com/okepvcfssgithub Link to official documentation: docs.oracle.com/en-us/iaas/Content/ContEng/Tasks/contengcreatingpersistentvolumeclaim_Provisioning_PV...
Quick Demo - OCI Container Instances - Deploy phpMyAdmin
มุมมอง 466ปีที่แล้ว
Hi, In this session I will show you what OCI Container Instances can do to help you easily deploy your containerized images. Details on the Container Instances: www.oracle.com/cloud/cloud-native/container-instances/ Pricing: www.oracle.com/cloud/cloud-native/container-instances/pricing/ #oraclecloud #oci #cloud #cloudnative #iaas #container #docker
Quick Demo - Send OCI Audit Logs to Azure Sentinel SIEM with OCI Streaming and Azure Functions
มุมมอง 1.6K2 ปีที่แล้ว
One of the most frequent questions that I get is how to I integrate OCI with other SIEM solutions. Here is the fastest and easiest way that I found to make it work using: OCI Streaming Service OCI Service Connector Azure Functions and of course Azure Sentinel. There are of course other ways to do it too like described here: blogs.oracle.com/cloud-infrastructure/post/using-microsoft-azure-sentin...
Quick Demo - OCI Database Service Storage Utilization Email Alarms
มุมมอง 2682 ปีที่แล้ว
tinyurl.com/dbcsstoragealarmgithub Go to OCI Console Navigate to "Observability & Management" Click on "Alarm Definitions" "Create Alarm" Define the alarm name, alarm body etc Select the: "Metric Namespace" to be "oci_database_cluster" "Metric Name" to be "ASMDiskgroupUtilization" For DATA storage area; Dimension Name: "diskgroupName", Dimension value: "org.data.dg" For RECO storage area; Dimen...
Quick Demo - Configure CMAN (Connection Manager) with TLS (Protocol Switching) for OCI DBCS
มุมมอง 1K2 ปีที่แล้ว
Hi, In this video I will show you how you can expose a database in a private subnet to public internet via Connection Manager (CMAN) CMAN will accept traffic via TLS and relay the traffic to the database in the private subnet via TCP. This is called Protocol Switching and can easily be set up both on premise and on Oracle Cloud (also other clouds) the configuration can be found in the github li...
Quick Demo - Exposing OCI Database Service to public internet via Load Balancer and TLSv1.2
มุมมอง 4562 ปีที่แล้ว
Hi, Today I will show you how we can expose a database (Base Database service) that runs on Oracle Cloud - OCI to the public internet via an OCI Native Application Load Balancer Also I will show how we can set up TLS termination on the load balancer so that the traffic coming through the Oracle Cloud can be encrypted and the traffic within the Oracle Cloud will continue unencrypted. First we ne...
Quick Demo - ORDS 22.1 Installation and configuration on Oracle Linux VM in OCI
มุมมอง 2.3K2 ปีที่แล้ว
Today I will show you how to install ords to an Oracle Linux instance. I already have an Oracle database set up. but I do not have ords installed or activated yet. First I will create a VM on OCI then I will install ords and java ORDS 22.1 does not support java 8 anymore that's why we will proceed with java 17.. Please make sure you visit the official documentation on: docs.oracle.com/en/databa...
Quick Demo - IPSec VPN (Static Routing) Between OCI and AWS (No Fastconnect, No BGP)
มุมมอง 3.1K2 ปีที่แล้ว
Hi, Today I will show you how to set up a vpn connection between aws and oci using static routing Not with express route, fastconnect etc.. conventional vpn.. The documentation I followed was: www.ateam-oracle.com/post/oci-to-aws-ipsec-tunnel-using-the-built-in-vpn-service If you want BGP here is the official documentation on what you need to follow docs.oracle.com/en-us/iaas/Content/Network/Ta...
Quick Demo - Assign/Unassign Public IP to/from an existing VM on OCI
มุมมอง 2782 ปีที่แล้ว
Hi, In this short video, I will show you how you can assign and unassign a public IP to/from an existing VM. It a quite simple process that can be done in seconds. Signup for an Oracle Cloud account for free at the link below signup.cloud.oracle.com/ #oraclecloud #oci #cloud #cloudnative #iaas #paas #bulut #networking #publicip
Quick Demo - IPSec VPN (Static Routing) Between OCI and Azure (No Fastconnect, No BGP)
มุมมอง 3.3K2 ปีที่แล้ว
Hi, Today I will show you how to set up a vpn connection between azure and oci using static routing Not with express route, fastconnect etc.. conventional vpn.. I already have my network and virtual network gateway set up in azure because it takes quite a long time to provision on azure... The rest is within the video.. The documentation can be found here: docs.oracle.com/en-us/iaas/Content/Net...
Quick Demo - Setting up PDB Refreshable Clone using DBLink
มุมมอง 3852 ปีที่แล้ว
Hi, In this video I will create a dblink between 2 database cloud service instances and have a pdb cloned from one cdb database to the other. The video is around 25 minutes old but it is uneditted just to show you how long it takes to move around 26GB of data from one pdb to the other. Both the databases are in the same network and the same subnet. The shapes are VM.Standard2.2 which have a net...
Quick Demo - Oracle Cloud Database Management
มุมมอง 3672 ปีที่แล้ว
Before you start, MAKE SURE YOU HAVE THE POLICY CREATED FOR DATABASE MANAGEMENT SERVICE to have read access to the vault Allow service dpd to read secret-family in compartment ABC where target.vault.id = 'Vault OCID' Hi, I will show you how to enable Database Management Service for a database running on Oracle Cloud NOTE: Basic management will give you the metrics in the Database details page F...
Quick Demo - Oracle Data Integrator Web Edition
มุมมอง 1.8K2 ปีที่แล้ว
Quick Demo - Oracle Data Integrator Web Edition
[TÜRKÇE] Oracle Cloud Infrastructure - Resource Manager (Terraform as a Service)
มุมมอง 584 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Resource Manager (Terraform as a Service)
[TÜRKÇE] Oracle Cloud Infrastructure - NodeJS Kurulum ve Konfigürasyonu
มุมมอง 1484 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - NodeJS Kurulum ve Konfigürasyonu
[TÜRKÇE] Oracle Cloud Infrastructure - NoSQL Veritabanı
มุมมอง 1714 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - NoSQL Veritabanı
[TÜRKÇE] Oracle Cloud Infrastructure - Weblogic Kurulumu
มุมมอง 8484 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Weblogic Kurulumu
[TÜRKÇE] Autonomous Database - APEX ve ORDS ile Uygulama Geliştirme
มุมมอง 8975 ปีที่แล้ว
[TÜRKÇE] Autonomous Database - APEX ve ORDS ile Uygulama Geliştirme
[TÜRKÇE] Oracle Cloud Infrastructure - Primavera P6 on OCI
มุมมอง 1985 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Primavera P6 on OCI
[TÜRKÇE] Oracle Cloud Infrastructure - VMDK Windows Imajının Buluta Taşınması
มุมมอง 455 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - VMDK Windows Imajının Buluta Taşınması
[TÜRKÇE] Oracle Cloud Infrastructure - Autonomous Database
มุมมอง 755 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Autonomous Database
[TÜRKÇE] Oracle Cloud Infrastructure - Block Storage
มุมมอง 445 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Block Storage
[TÜRKÇE] Oracle Cloud Infrastructure - Object Storage
มุมมอง 615 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Object Storage
[TÜRKÇE] Oracle Cloud Infrastructure - Database Cloud Service oluşturulması
มุมมอง 805 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Database Cloud Service oluşturulması
[TÜRKÇE] Oracle Cloud Infrastructure - Enterprise Edition Data Guard kurulumu
มุมมอง 1345 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Enterprise Edition Data Guard kurulumu
[TÜRKÇE] Oracle Cloud Infrastructure - Sanal Makine (Compute) oluşturulması
มุมมอง 2305 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Sanal Makine (Compute) oluşturulması
[TÜRKÇE] Oracle Cloud Infrastructure - Virtual Cloud Network oluşturulması
มุมมอง 3005 ปีที่แล้ว
[TÜRKÇE] Oracle Cloud Infrastructure - Virtual Cloud Network oluşturulması
Very good! Thanks!
How about Oracle Fusion Application audit logs, will those be covered via the same method?
Route Tables for Azure and Oracle?
You need to update routes for AWS vpc as well then connection will establish
dünya alem orakıl diyor... türkiyede orekil diyorlar...
Awsome workok thanks much for the support
how long does it takes for logs to in? I followed the instructions step by step and nothing is being forwarded to Sentinel.
Hello did you find the solution?
@@lizziegesbie2370 no, the customer reached out to Microsoft/OCI on this.
Thanks Onur for sharing
Bijan is that you
lmao
Elinize saglik hocam.
So you created the streaming service and setup the REST API to grab the logs, but do you have a video as to configuring the logs on OCI itself? What data is in these logs, etc, or is it a template?
You mean as to send the logs to oci logging analytics?
Your demo is very helpful I'll try to find it for months thanks u
Hi! Thanks for the video, there is any way to see the custom reports in the database? Or any way to know with wich tables/columns are some report created? Thanks!
Hi, I'm afraid not. But I'm not an expert in Netsuite. There are some tables and views defined for those. Let me see if I can find it somewhere
Good Work 👏
Do you have video - IPSec VPN (Static Routing) Between OCI and Azure with BGP 😀
onur hocam port açma da yardımcı olur musunuz
tabi ki.. onursenturk.youtube gmail.com a mail atabilirsiniz
I can Ping from OCI to Azure VM but Unable to Ping from azure vm to OCI VM
Surely late to help. For future viewers who might face the same issue. Ping is not enabled be default you woups have to add a ingress rule to allow ping i.e icmp type 8 traffic. You can also check what are the egress rule over azure and if there is any setting on firewall device.
If all doest work check the hops between the two ends and see where the issue is.
Should of sped up the the typing footage or just talked, it's so slow...
Merhaba Onur bey. Hazirladiginiz video icin tesekkur ederim. Cok guzel olmus. Ben sunu ogrenmek istiyorum: Oracle APEX ile uygulama gelistirmek ve bunu baska bir hostinge tasiyarak calistirmak istiyorum. Ama oncelikle Oracle APEX ile ilgili detayli egitime ihtiyacim var. Udemy den baktim ama Turkce egitim yok goremedim. Bu konuda ne onerirsiniz?
Merhaba Fuat Bey, Su linkleri incelediniz mi? apex.oracle.com/en/learn/training/ apex.oracle.com/en/learn/tutorials/ Ozellikle egitim istediginiz bir konu var mi?
@@CloudArch evet bu egitimi bitirdim. Oracle cok yuzeysel anlatmis. Cok az uygulama yapmis. Ama hicbirsey omamasindan iyidir.
Hocam size nasıl ulaşabilirim
onursenturk hotmail
Is it possible to built a IPSEC tunnel between two different OCI.
yes it is
Indeed without audio this is not very useful, also first show a quick architectural diagram on explain the use case(s) : why/where this solution may be applied
fixing that with the new videos.
Why do you create a separate VM for ORDS, why not install it on the existing database VM?
Wow nice.. Thanks
Welcome 😊
No audio
yes because i did not say anything :) i will record the future videos with audio if you find it useful.
Thanks for the tutorial, How to Enable the Database ORDS Schemas?
Ön bilgilendirme için süper bir yayın olmuş. Teşekkürler.
ORDS'in yeni versiyonu cikti, onun kurulumuyla ilgili de bir video yaptim. izlemek isterseniz
Can you show me that you created policy ?
Do I need to create dbsnmp useraccount on IAM ?
thanks dear ,we are waiting the update decription in aws side
Sizden bu konuda birkaç saat özel ders alabilir miyim
Merhaba, tabi ki.. iletisim icin mail adresinizi yazarsaniz konusabiliriz
I want to share this app for oracle cloud available in iOs and Android th-cam.com/video/tGvEBl69AvQ/w-d-xo.html
I just came across your application today by coincidence. I wish it was an official Oracle app. Good work buddy.
Great video!
Thanks!