Loading...

Follow K21 Academy - Oracle Trainings Blog on Feedspot


Valid
or
Continue with Google
Continue with Facebook

This post covers upgrading classic capture mode to integrated capture in Oracle GoldenGate.

From 11gR2 onwards, Oracle Goldengate introduced a new feature called as Integrated Extract. The main difference between the classic capture and integrated capture modes is that in the classic capture the extract reads the Oracle database online redo log files/archive log files to capture changes while in the integrated capture mode the database log mining server reads the redo log files and captures changes in the form of LCR’s (Logical Change Records) which are then accessed by the Golden Gate extract process.

Classic Capture:

Integrated Capture

Note: Integrated mode is only applicable for Oracle Databases and from 11gR2 onwards.

Since organizations are deploying this new feature, there is an option of upgrading the classic capture to an integrated one. Let us see how to perform this upgrade.

In this case, we have a (classic capture) extract group called ext1. Let us create the extract process in Classic mode first.

GGSCI (ashish159) 1> ADD EXTRACT ext1, TRANLOG BEGIN NOW

EXTRACT added.

GGSCI (ashish159) 2> ADD RMTTRAIL ./dirdat/lt EXTRACT ext1

RMTTRAIL added.

GGSCI (ashish159) 3> EDIT PARAMS ext1

EXTRACT ext1

USERID ggate, PASSWORD ggate

RMTHOST 192.168.1.188, MGRPORT 7809

RMTTRAIL ./dirdat/lt

TABLE ggtraining1.dept1;

GGSCI (ashish159) 4> START EXTRACT ext1

Sending START request to MANAGER …

EXTRACT EXT1 starting

How to know If the Extract Process is Classic or Integrated

Once the extract process has started, it is reading the online redo log files of the database – so it is classic extract.

GGSCI (ashish159) 5> INFO EXTRACT ext1

EXTRACT    EXT1    Last Started 2017-12-18 12:15   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:10 ago)

Log Read Checkpoint  Oracle Redo Logs

2017-12-18 13:28:09  Seqno 182, RBA 2508668

SCN 0.0 (0)

To upgrade Classic to Integrated Capture
  1. Stop the Extract Process ext1 and register it with the database.
  2. Check if Extract can be upgraded.
  3. For an upgrade classic extract, use the UPGRADE INTEGRATED TRANLOG command.

Step1:

GGSCI (K21) 8> STOP EXTRACT ext1

Sending STOP request to EXTRACT EXT1 …

Request processed.

GGSCI (K21) 9> REGISTER EXTRACT ext1 DATABASE

2017-12-18 14:22:12  INFO    OGG-02003  Extract EXT1 successfully registered with the database at SCN 1213445.

You can also open the alert log file of the database and see whats happening in the background. You will see the logminer build happening in the background. Also in case of any issues, the alert log of DB will come handy.

Step2: Register and Check if the extract can be upgraded.

You may notice an error message as shown below stating that the extract cannot be upgraded at this stage.

GGSCI (K21) 11> STOP EXTRACT ext1

Sending STOP request to EXTRACT EXT1 …

Request processed.

GGSCI (K21) 12> REGISTER EXTRACT ext1 DATABASE

2017-12-18 14:27:34  INFO    OGG-02003  Extract EXT1 successfully registered with the database at SCN 1213492.

GGSCI (K21) 13> INFO ext1 UPGRADE

Extract EXT1 is ready to be upgraded to integrated capture.

Step 3: For an upgrade the classic capture extract, use the UPGRADE INTEGRATED TRANLOG command as shown below.

GGSCI (K21) 14> ALTER EXTRACT ext1 , UPGRADE INTEGRATED TRANLOG

Extract EXT1 successfully upgraded to integrated capture.

GGSCI (K21) 15>  START EXTRACT ext1

Sending START request to MANAGER …

EXTRACT EXT1 starting

GGSCI (K21) 16> INFO EXTRACT ext1

EXTRACT    EXT1    Initialized   2017-12-18 15:24   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:01:57 ago)

Log Read Checkpoint  Oracle Integrated Redo Logs

2017-12-18 15:24:42

SCN 0.1213550 (1213550)

We can see that the extract is no longer reading the redo log files.

You can query DBA_CAPTURE view for getting the information as well at DB level.

SQL> select CAPTURE_NAME, QUEUE_NAME, STATUS from DBA_CAPTURE;

CAPTURE_NAME                   QUEUE_NAME                     STATUS

—————————— —————————— ——–

OGG$CAP_EXT1                 OGG$Q_EXT1                   ENABLED

This post is from our Oracle GoldenGate 12c Administration Training, in which we cover  Architecture, Installation, Configuring & Preparing the Environment, DML Replication, Online Change Synchronization, Initial Load, Oracle GoldenGate Security, Performance of Oracle GoldenGate and Troubleshooting and much more.

If you wish to learn GoldenGate systematically then look at Activity Guides (tasks) you must perform from our Step by Step Guide to Learn Oracle GoldenGate

Have a question related to your Oracle GoldenGate?   Post under comments below

The post GoldenGate: Upgrade Classic Capture to Integrated Capture appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In this post, we are going to look at what changed in May 2018 update on Oracle Database Cloud Service (DBCS). The major change happen is DBaaS Monitor is no more available and replaced by SQL Developer Web.

So let’s have a look on below video on May 2018 DBCS Updates.

DBCS: Changes May 2018 - YouTube

Here are the latest updates that happened in DBCS:

    1. SQL Developer Web replaced DBaaS Monitor:
      So if you are working on Oracle database on cloud then you may be knowing that DBaaS Monitor is a management tool to manage Oracle Database on Cloud. DBaaS Monitor is being decommissioned in favor of Oracle SQL Developer Web for DBCS Single or Single Instance with data Guard (Standby). It is not yet available for RAC on Cloud.  When you create a new database deployment, SQL Developer Web is automatically installed. If you have an older database deployment, you can replace DBaaS Monitor with SQL Developer Web by updating your cloud tooling. This is how SQL developer web looks like:
    2. April 2018 PSU patches available to apply on DBCS: April 2018 PSU patches should now be available in your database cloud service account.
    3. Oracle Application Express (Apex) 5.1.4 is now part of DBCS: APEX is rapid or database development tool that helps you to design, develop and deploy database-driven web applications accessible through web browser. Apex is also available for Single instance DBCS (not for RAC on DBCS). If you are creating a new database account or registering a new database account then you will get Apex 5.1.4 as part of DBCS. However, if you already had an account on database cloud and you want latest apex version then you can upgrade that.
    4. bkup_api additional subcommands .There are new additional subcommands added into bkup_api (which is a utility to backup oracle database on cloud) to simplify administering automatic backup.
    5. DBCS  on OCI now supports 16TB Storage volumes: DBCS deployments on OCI now supports 16TB of Storage volumes that is block volume. If you want to know the differences between OCI and OCI Classic then check our post here.

To know more in detail about these updates, go through the above recording.

If you want to create your own free Oracle account, then check our blog post here to do the same.

Note: Like above post, we keep our trainees updated with latest updates in our courses Cloud DBA Certification 1Z0-160 Training and Oracle Cloud DBA Training. You can get Step By Step Hands-On Activity Guides you must perform for Oracle Cloud DBA Certification here).

Did You Start Your Cloud Journey?   

Get a FREE Copy in your Inbox with Steps to Register for Oracle Cloud and get 300 USD FEE Credit to Practice and Join our Private Closed Facebook Group for Oracle Cloud Community

The post DBCS: What’s New in May 2018 Update appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers Steps to Register For FREE Oracle Cloud Trial Account, from one of the lessons in our Oracle Cloud IaaS (OCI) Architect Training. 

Note: If you want to learn more about Oracle Cloud Infrastructure (OCI) then register for FREE 90 minute masterclass from Oracle ACE & Author Atul Kumar to go from Complete Beginner To Oracle Certified Cloud (OCI) Architect What, Why & How

Register For Oracle Cloud Trial Account - YouTube

Steps To Register For FREE Oracle Cloud Trial Account

1- Go to the Oracle Cloud Home Page https://cloud.oracle.com/home
On top right click Try for Free

2- You will be redirected to page like below, click on Create a Free Account

3- You will then be redirected to the page

  • Fill out all the mandatory information like Cloud account name, Default data region, Email Address, and Fill your address and all other details.

Note: Some of the entries may be different depending on your country

Note: If you belong to APAC as India you will get 400 SDG or for UK 259 GBP for 30 days only, it will  change according to your Country location as for the US its $300 USD

4- Then in Verification Code Tab Provide your Mobile Number and click on Request Code (make sure country code is correct, I am doing this from INDIA so code +91)

5- You will get a message on your mobile phone (You have 30 Minutes on above page to update or request code again), Once you enter the Verification code, you should get the message.

6- On Credit Card detail Tab, Click on Add Payment Method.

  • Enter your credit card information if you’re asked for it.

Note: You may see a small charge of 1$ on your credit card statement. This is a verification hold, and it’s reversed after we validate the credit card and billing address. You won’t be charged after 30 Days unless you upgrade to a paid account after your free trial exiry (Trial is for 30 Days or 300 USD , whatever comes first).

7- Click Complete to submit your request for a new Oracle Cloud account.

  • Your cloud account is created immediately, and you receive a welcome email with your sign-in credentials for My Services. You can sign in to your account, and go through the Guided Journey to understand Oracle Cloud features and capabilities while you wait for your services to be provisioned. You can also start creating service instances from the Guided Journey as and when the services are provisioned in your account.
  • You’ll receive another email after all the services are provisioned and are ready to use. A few services that are provisioned may require additional sign-in credentials, which are in the welcome email.
FREE Master Class on OCI Architect:

Now, it’s your turn

Leave a comment when its all done and share this post with your colleagues who wish to learn Cloud

Did You Start Your Oracle Cloud Journey? NO!
So Your Next Taks is, Join FREE Webinar on Beginner to Oracle Certified Cloud (OCI) Architect: What, Why & How. Click on the image below to register for FREE.

The post [Video] How to Register For FREE Oracle Cloud Trial Account appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post is for WebLogic Beginners covering What is Weblogic Server, Weblogic Admin Tasks and Tools from our Oracle Weblogic Training (Lesson 2)

What Is Oracle WebLogic Server 12c - For Beginners - YouTube

What is Weblogic Server?
  • WebLogic Server is a Java EE compliant Application Server.
  • Application Server is a server on which we deploy the Applications.
  • An application server access other services like the database to store the data, sending messages across applications and integrates with external enterprise systems.
  • Weblogic Server is used in almost every Oracle Product such as SOA, OBIEE, OAM/OIM, EBS R12, Fusion Applications, OEM 13c etc.
  • WebLogic Server has different versions like 11g (10.3.6) and 12c
  • Latest WebLogic Server version as of May 2018 is 12.2.1.3
  • 12c Version of WebLogic Supports Multi-Tenancy (Mico-Containers aka Partitions)
  • Weblogic Server is also supported on Docker Container.
Weblogic Admin Common Tasks:

Some of the common tasks performed by WebLogic Admins are

  • Install Weblogic Server,Configure Domain
  • Deploy Applications
  • Migrate Domains from TEST/DEV to PROD
  • Integrate: IDM/LDAP & Third Party Systems
  • Troubleshoot Issues
  • Performance Tuning
  • Monitoring & Management
  • High Availability & Disaster Recovery Setup
Weblogic Admin Tools:

Some of the tools used by WebLogic Admins to perform common tasks mentioned above are

  • WebLogic Admin Console (GUI)
  • Fusion Middleware Control (GUI)
  • WebLogic Scripting Tool(Command Line Utility)
  • Restful Management Resource
  • Configuration Wizard
  • Apache ANT
  • SNMP Agents

Are you planning to Learn WebLogic Server or would like to check some of the common Oracle WebLogic Interview Questions then get the from here (sent over email)

Join Community

Join 3500+ Oracle Professionals like you to discuss Oracle Weblogic Server, Ask Questions or Help Others in Private Facebook Group for Oracle Weblogic Server .

What’s Next
  • What is WebLogic Domain?
  • How do you create WebLogic Domain?
  • Can multiple domains be created from single WebLogic Installation?
  • Can domain span across machines?

Leave a comment if you know answers or if you want to know an answer to these questions (share which one) and If I see enough questions then I’ll cover about WebLogic Domain

The post [Video] Oracle Weblogic Server: Weblogic Admin Tasks & Tools appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

We recently had a Masterclass on Oracle WebLogic Server covering What, Why & How in that webinar there were a lot of questions. Most of these questions were answered in Webinar however not all questions were covered because of time. We’ll be adding these questions over a period of time in Private Facebook Group for WebLogic Server here

This post covers weekly live show on our Facebook Page covering Oracle WebLogic Server and issues reported with WebLogic Server in Oracle EBS R12.2 asked in WebLogic Masterclass.

Q. I am working on Oracle EBS R12.2.3, My Questions is that OACore managed server is going into warning state frequently. I’ve increased Java Heap Size from 1 GB to 2 GB but still getting the same error sometimes. After collecting Garbage, it will be OK, but want to resolve the issue permanently. Need You Guidance …

  • What would you do in a situation like this?
  • What is JVM & Heap Size in JVM?
  • How do you know what is Heap Size Value and How do you change the value of Heap from 1GB to 2 GB?
  • What is Garbage Collection and How Often you should run it?
  • What does parameter -Xms, -Xmx, -XX:PermSize, -XX:MaxPermSize mean when you start JVM?

I’ve covered all this in Video below

Oracle WebLogic Server & EBS R12.2 Q/A: JVM, Heap, GC, Stack, Thread Dump - YouTube

Here is what Atul Covered in Weekly Live Show

  • 00:00-8:18: Introduction & Welcome
  • 8:18-15:47 What is WebLogic Server & Task Performed by WebLogic Admins
  • 15:47-17:15 Q: Managed Server in EBS (R12) going in Warning State
  • 17:15-30:06 Oracle E-Business Suite R12.2 Architecture, WebLogic Domain, Admin & Managed Server, Config Files for Domain in EBS R12.2
  • 30:06 – 41:00 What is JVM, JVM Parameters like -Xms, -Xmx, -XX:PermSize, -XX:MaxPermSize, Garbage Collection – GC (Major / Minor), JVM Tuning Guidelines, Q/A
  • 41:00- 50:00 Heap, Stack & Thread Dump, Warning State issue in EBS R12.2 for Managed Server
  • 50:00-56:14 Wrap-Up and FREE Training
Key Points
  1. JVM stands for Java Virtual Machine and has two main areas:
    • A) Heap (Young Gen + Old Gen)
    • B) Permanent Gen
  2. Garbage Collection is the process of looking at Objects in Heap and deleting unused ones. There are two types of GCs’: Major GC and Minor GC.
  3. Having a large heap size may not be always the solution to all performance issues in applications deployed on WebLogic Server. An objective of tuning should be to minimize time spent on GC to be as low as possible (<5% of Execution Time)

Now back to the original question

Q. I am working on Oracle EBS R12.2.3, My Questions is that OACore managed server is going into warning state frequently. I’ve increased Java Heap Size from 1 GB to 2 GB but still getting the same error sometimes. After collecting Garbage, it will be OK, but want to resolve the issue permanently. Need You Guidance …

If you are in a situation like this, How would you troubleshoot or approach to fix the issue (Leave a comment and see If you can help others)?

The post [Weekly Live] Oracle WebLogic Server/EBS R12.2 Q/A: JVM, Heap, GC, Stack & Thread Dump appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

We recently had a Masterclass on Oracle WebLogic Server covering What, Why & How in that webinar there were a lot of questions. Most of these questions were answered in Webinar however not all questions were covered because of time. We’ll be adding these questions over a period of time in Private Facebook Group for WebLogic Server here

This post covers weekly live show on our Facebook Page covering Oracle WebLogic Server and issues reported with WebLogic Server in Oracle EBS R12.2 asked in WebLogic Masterclass.

Q. I am working on Oracle EBS R12.2.3, My Questions is that OACore managed server is going into warning state frequently. I’ve increased Java Heap Size from 1 GB to 2 GB but still getting the same error sometimes. After collecting Garbage, it will be OK, but want to resolve the issue permanently. Need You Guidance …

  • What would you do in a situation like this?
  • What is JVM & Heap Size in JVM?
  • How do you know what is Heap Size Value and How do you change the value of Heap from 1GB to 2 GB?
  • What is Garbage Collection and How Often you should run it?
  • What does parameter -Xms, -Xmx, -XX:PermSize, -XX:MaxPermSize mean when you start JVM?

I’ve covered all this in Video below

Oracle WebLogic Server Q/A: JVM, Heap, GC, Stack & Thread Dump - YouTube

Here is what Atul Covered in Weekly Live Show

  • 00:00-8:18: Introduction & Welcome
  • 8:18-15:47 What is WebLogic Server & Task Performed by WebLogic Admins
  • 15:47-17:15 Q: Managed Server in EBS (R12) going in Warning State
  • 17:15-30:06 Oracle E-Business Suite R12.2 Architecture, WebLogic Domain, Admin & Managed Server, Config Files for Domain in EBS R12.2
  • 30:06 – 41:00 What is JVM, JVM Parameters like -Xms, -Xmx, -XX:PermSize, -XX:MaxPermSize, Garbage Collection – GC (Major / Minor), JVM Tuning Guidelines, Q/A
  • 41:00- 50:00 Heap, Stack & Thread Dump, Warning State issue in EBS R12.2 for Managed Server
  • 50:00-56:14 Wrap-Up and FREE Training
Key Points
  1. JVM stands for Java Virtual Machine and has two main areas:
    • A) Heap (Young Gen + Old Gen)
    • B) Permanent Gen
  2. Garbage Collection is the process of looking at Objects in Heap and deleting unused ones. There are two types of GCs’: Major GC and Minor GC.
  3. Having a large heap size may not be always the solution to all performance issues in applications deployed on WebLogic Server. An objective of tuning should be to minimize time spent on GC to be as low as possible (<5% of Execution Time)

Now back to the original question

Q. I am working on Oracle EBS R12.2.3, My Questions is that OACore managed server is going into warning state frequently. I’ve increased Java Heap Size from 1 GB to 2 GB but still getting the same error sometimes. After collecting Garbage, it will be OK, but want to resolve the issue permanently. Need You Guidance …

If you are in a situation like this, How would you troubleshoot or approach to fix the issue (Leave a comment and see If you can help others)?

The post [Weekly Live] Oracle WebLogic Server/EBS R12.2 Q/A: JVM, Heap, GC, Stack & Thread Dump appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post is Part I in two-part series covering steps on How to Download & Install Oracle Access Manager OAM 12c PS3(12.2.1.3.o). In Part II, I’ll cover How to create Schema using RCU, and Configure OAM Domain.  

What is OAM/IDM

If you don’t know already Oracle Access Manager (OAM) is Oracle’s recommended Single Sign-On (SSO) solution for Web Access Management and is used for Authentication & Coarse-Grained Authorization for both On-Premise and Cloud Web Applications. OAM is used to protect both Java & .NET applications including.

  • OAM is part of Oracle’s Identity & Access Management Suite (IDM), for the list of all Oracle IDM products Click Here
  • For documentation of IDM 12cPS3 check my previous post here  
High-Level Installation Steps
  • Install Certified Database for OAM & Fusion Infrastructure Schema. For List of Certified Databases, check Certification Matrix here
  • Install Certified JDK
  • Install Oracle Fusion Middleware Infrastructure 12.2.1.3
  • Install Oracle Identity & Access Management Software 12.2.1.3 (Note: Make sure IDM & FMW Infra software are installed in the same ORACLE_HOME)
  • Create Schema using Repository Creation Utility (RCU). We are going to use 12c RCU that comes as part of Fusion Middleware Infrastructure Install in an earlier step. For the 11g version of RCU, check here
  • Create WebLogic Domain covering Admin Server and Managed Server for OAM
  • Start WebLogic Admin & Managed Servers
  • Test OAM Consoles
Prerequisite  
  • At least 16 GB of physical memory & Oracle Enterprise Linux 6.6 or later
  • A certified Database
  • Operating System User credential like Oracle (this user will own IDM software)
  • SYS database user credentials (required to create the schema using RCU)
  • Oracle Java Development Kit (JDK) 1.8.0_131 or later (Click Here to download)
  • Oracle Fusion Middleware Infrastructure  12.2.1.3.0 (Click Here to download)
  • Oracle Access Management 12.2.1.3.0 (Click Here to download) Product, Oracle Identity and Access Management 12cPS3 (12.2.1.3.0) 
Assumption
  1. ORACLE_HOME= /u01/app/oracle/product/12.1.0.2/db_1
  2. You must install the Fusion Infrastructure(Weblogic Server) & Oracle Access Manager software in the same ORCALE_HOME directory (We are going to install under /u01/app/oracle/oam12c )
Low-Level Installation Steps  Step 1: Operating System, Database & JDK Installation

Make sure your operating system, Database, JDK ( Above jdk1.8.0_131+) are as per the OAM 12c Certification matrix:

 Step 2: Install Oracle Fusion Middleware Infrastructure

Note: This step will install WebLogic, Coherence, RCU and other required software for OAM.

1. Use the terminal window and run the Oracle Fusion Middleware Infrastructure fmw_12.2.1.3.0 10 installers as the oracle user. In my case installer is located in the /stage/oracle/fusion_infra/12.2.1.3.0/ directory.

Note: Make sure you set the environment variables as (In my case JDK 1.8.151 is installed under /usr/java)

  • export JAVA_HOME=/usr/java/jdk1.8.0_151
  • export PATH=$JAVA_HOME/bin:$PATH

The installer starts, and after a few seconds the “Fusion Middleware 12c Infrastructure Installation  – Step 1 of 8” window appears

2. On the Welcome screen, click Next

3. On Auto Updates screen, select Skip Auto Updates and click on Next (It’s preferred to download & apply updates separately)

4. Enter Oracle Home =/u01/app/oracle/oam12c (Note: ORACLE_HOME in 12c used to be Fusion Middleware Home in 11g ) and Click Next

5. On Installation Type screen, Select Fusion Middleware Infrastructure & Click on Next

6. On Prerequisites Checks screen, once 100% complete then click on Next

7. On Installation Summary screen, click Install (Make sure you check the Oracle Home Directory Location)

Note: You can also save Response File by clicking a button at the bottom, this response file can then be used as a template for silent install.

8. On Installation progress screen, let it complete to 100%

9. After a while, the installation process ends and the last window of the installation Complete appears, informing you that the installation was successful

Step 3: Install Oracle Access Management 12c

1. Launch a terminal window as Oracle and run the Oracle access manager 12.2.1.3.0 installer as the oracle user. In my case, installer is located in the /stage/oracle/oam/12.2.1.3.0/idm directory.

2. On the Welcome screen, click Next

3. On Auto Updates screen, select Skip Software updates and click Next (It’s preferred to download & apply updates separately)

4. Enter Oracle_Home =/u01/app/oracle/oam12c and Click Next

Note: Make sure that you install OAM in same Oracle Home as e Oracle Fusion Middleware Infrastructure in previous step

5. On Installation Type screen select Collocated Oracle identity and Access manager (Managed through WebLogic server) and click Next


Note:
 More on Standalone VS Collocated IDM in future posts

6.On Prerequisite Checks screen ensure that all checks complete successfully and click Next

7. On Installation Summary screen, click Install

8. Installation Progress will start. When it reaches 100% then Click Next

9. On Installation Complete screen, Click Finish.

Create Schema & Configure Domain
  • Next is to create Schema for OAM & Configure WebLogic Domain in Part II of this series
Related Posts Next Task For You

If you like this and would like to learn Oracle Identity & Access Management then get a FREE Mini-Course on IDM/OAM/OID from here

If you are looking for commonly asked interview questions for Oracle Access Manager then just click below and get that in your inbox.

The post Oracle Access Manager 12c (12.2.1.3.0): Download & Installation: Part I appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers Question asked by one of the trainees in Oracle GoldenGate Training covering How to change Parameter Files in Oracle GoldenGate.  Before I cover How to change parameter file, lets first understand What is Parameter File and Where is it used in Oracle GoldenGate

GoldenGate: What & Why DBAs & Data Architects Must Learn

Oracle GoldenGate is a heterogeneous product and supports many different platforms and databases. It is an extensive software package for real-time integration and replication.

If you are new to Oracle GoldenGate then check my previous post: What, Why & how to Learn Oracle GoldenGate

What are Parameter Files in Oracle GoldenGate?

Parameter Files are the heartbeat of each Oracle Goldengate Processes/Components i.e. Extract, Data Pump, Replicat, Manager (To know more about of Oracle GoldenGate Processes/Components Check Here).

Parameter files store the parameters for each Oracle Goldengate Process.. Each process in Goldengate has its own associated parameter file. Processes work according to parameters provided in the parameter file.

Golden Rules For Parameters
  • Parameter file resides in dirprm directory.
  • Every parameter has a default value.
  • Every parameter has a counter/opposite parameter.
  • The validity of a parameter in parameter file is there until its counter/opposite parameter is encounter in the parameter file.
  • A parameter is valid either for extract parameter file/Data Pump Parameter file or Replicat parameter file or it may be valid for all 3 parameter files.
  • A parameter is valid for tables following that parameter.
Where are Parameter Files Stored?

Parameter file resides in dirprm directory. $GG_HOME/dirprm 

How to Update Parameter Files?

Follow below steps to update the parameter file

  1. Take necessary approval for downtime related to Oracle Goldengate Process (Yes re-start is required).
  2. Stop the process. GGSCI> Stop EXT1  (Note: Here GGSCI is command line interface to manage GoldenGate & EXT1 is process name (Extract Process in my case) for which you need to change parameter)
  3. Open and Edit the process parameter file. GGSCI>edit param EXT1
  4. Once changes are made, save the changes and quit the vi editor
  5. Verify the changes are correct by viewing the parameter file. GGSCI> view param EXT1
  6. Once the changes are verified, start the process. GGSCI> start extract EXT1

Do you have any question related to Oracle GoldenGate, Post them under the comment or ask them in our Private Facebook Group for Oracle DBA’s & Apps DBA working on GoldenGate.

The post Oracle GoldenGate: How to Make Changes in Parameter Files appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers the Overview of  Oracle Internet Directory  (OID) Consoles, video lesson from our OID Training (OID course is also covered as Bonus in OAM Training). There are three console (GUI) to manage OID i.e.  OSDM (Oracle Internet Directory service manager). Weblogic & Fusion Middleware EM (Enterprise Manager) Console. 

Note: If you are new to Oracle Directory Services (ODS), then I highly recommend you to watch my previous Video Blog post about OID, OVD, OUD and ODSEE. Check out video on ODS and products that are part of ODS here  

Watch the Short Video which Covers  the ODSM, Weblogic and EM console.

  • Video starts with File System of OID, covering Instance Home, Coherence Home, WebLogic, Domain Home etc
  • It then explains how OID LDAP processes connects to OID Schema is database i.e. using tnsnames.ora 
  • It then explains where are OID Diagnostic logs for troubleshooting

OID Console Overview : ODSM, Wblogic, EM Consoles - YouTube

Oracle Internet Directory: ODSM Console

One of the most important OID Console is ODSM Console. Oracle Directory Service Manager (ODSM) Console, also used in OUD (Oracle Unified Directory).   ODSM is a Java application and can be deployed on both Admin and Managed Server.

  • ODSM is Java Application that can be deployed either on Admin Server or Managed Server
  • OUD 12c ODSM Console is name as OUDSM Console or OUD Service Manager.
  • To check the port for ODSM we can get it from WebLogic configuration  $DOMAIN_HOME/config/config.xml  or it can be accessed from WebLogic Console.
  • To access the ODSM URI is http://<Hostname.domain_name>:port_number/odsm

ODSM will connect to OID LDAP process, either using LDAP Port Number or LDAP Secure. (in the Video we have explained  in detail and also explain how it is accessible from server)

With the use of ODSM you can do all Configuration for OID and create object classes (collection of attribute), Password Policy, Create any User and Groups etc..

Oracle Internet Directory: Weblogic Console

The BEA WebLogic Server Administration Console is a Web browser-based, a graphical user interface that you use to manage a WebLogic Server domain. A WebLogic Server domain is a logically related group of WebLogic Server resources that you manage as a unit.

Use the Administration Console to:
  • Configure, start, and stop WebLogic Server instances
  • Configure WebLogic Server clusters
  • Configure WebLogic Server services, such as database connectivity (JDBC) and messaging (JMS)
  • Configure and deploy your applications
  • Monitor server and application performance
  • View server and domain log files and Lot more…

To use the Administration Console, use one of the supported Web browsers for your environment. See Browser Support for the WebLogic Server Console. If your Web browser is not on this list of supported browsers, you may experience functional or formatting problems when using the Administration Console.

To start the Administration Console:

  1. Start an Administration Server.
  2. Open one of the supported Web browsers and open the following URL:

http://hostname:port/console

 Oracle Internet Directory: EM Console

Oracle Internet Directory can login to EM  Console and Manage the OID server as start/stop the OID and DIP, Configure the DIP and OID.

To access the Oracle Internet Directory  Console:

  • Start Oracle internet Directory Admin server. we have used a sperate port number to start OID Admin server as “7003”
  • Navigate to the following URL: http://host_name.domain_name:port_number/em

For example: http://myhost.mycompany.com:7003/em

Note: You can find the exact URL, including the administration port number, in config.xml

If you like this and would like to learn Oracle Identity & Access Management then get a FREE Mini Course on IDM/OAM/OID from here

The post [Video] OID Consoles Overview: ODSM , Weblogic & EM appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers an issue & fix reported in our training while creating Oracle EBS R12 instance on Cloud using Oracle EBS Cloud Admin Tool where error reported was FATAL: Failed to connect to Oracle Cloud storage endpoint

Note: EBS Cloud Admin Utility is used to provision, manage & integrate Oracle E-Business Suite R12 on Oracle Cloud).

If you are new to Oracle EBS (R12) on Cloud then check Atul’s post on Role of Oracle AppsDBA (EBS) R12 in Cloud

Things Good to Know About EBS Cloud Admin Tool
  • It can provision a new EBS instance (including using Database Cloud Service or RAC on Cloud for Database Tier of EBS) on Oracle Public Cloud, Both Elastic Cloud as well as the Bare Metal Cloud (now called as Oracle Cloud Infrastructure: OCI).
  • You can use it to add an additional node for an Oracle EBS (R12) instance.
  • To Backup & Restore an EBS instance on the Cloud.
  • To Integrate Oracle EBS R12 with Oracle third-party software like Oracle SOA Suite, Oracle Identity, and Access Management Suite etc.
  • You also use this Oracle EBS Cloud Admin utility to Manage Oracle EBS (R12) Environment.
Issue:

When you provision Oracle EBS Environment on Cloud using EBS Cloud Admin Tool (by running ProvisionEBS.pl), it expects Compute & Storage Service Endpoints. You can get both these details from respective Cloud Storage & Compute Console.

After entering the values it gives an error like FATAL: Failed to connect to Oracle Cloud Storage Endpoint

Analysis:

The Above error is mainly due to two reasons:

1) You have given the wrong Site/ Data Center Code for Storage Cloud Service Endpoint when prompted (Note: An Account can have multiple Site inside Data Center) 

There are two things you can see in your cloud dashboard, one is Site and another is Data Center, so we have to use Data Center code not  Site

2) Geo-Replication policy for your Object Storage Classic is not set  (More on setting Geo Replication Policy at Replication Policy for Your Account)

Note: If your Cloud Account was created after March 2018, then once your Oracle Cloud Infrastructure Classic (OCI-C) Object Storage (For difference between OCI & OCI-C refer here ) , the replication policy for your account is set by default (This is as per Oracle Doc).

     However we have seen that once you open your Storage Classic console for the first time you will get a  below screen and you just need to select your site and then click on Set policy, it is one time activity.

Once these are two settings are done, this should fix error “Failed to connect to Oracle Cloud storage endpoint” . Run EBS Cloud Admin Tool one more time to provision Oracle EBS (R12) on Cloud

What’s Next

If you are an Oracle Apps DBA and just starting out your journey to Oracle public Cloud then we highly recommend you to download our FREE Guide that contains 3 Docs every Oracle Apps DBA must read in order to manage and migrate Oracle EBS R12 on Oracle Cloud. Click on below link to get the Guide.

Got a question on What you as Oracle Apps DBA should learn or Hitting any issue then leave a comment or post in our Private Facebook group for Oracle Cloud (3700+ Members) http://k21academy.com/joincloud

The post Oracle EBS Cloud Admin Tool Issue : FATAL: Failed to Connect to Oracle Cloud Storage Endpoint appeared first on Oracle Trainings.

Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview