What I have learn and do during in this training?

For the first month, in classroom, we learn what is Oracle about, this things that Oracle just not about database but more than that. In training class room, we all have been provided the study materials. In order to make sure what we understand the trainers teach us about the topics, the tasks was given, to make us a clear understand how it works and to see whether what problem will is occurs in that situation. Certain tasks give problems that how we solve it. The tools we use which is computer using Windows OS but we use the Oracle VM to the tasks. We not just learn about database but others application which is Oracle VM, FilleZilla which is to transfers file from another place and many more. In Oracle VM, we install Linux OS and use it to perform a task that given by the trainers.  When I got a task sometimes got problem, so doing it again and understand what the problem is, from there I learn the mistake, that is need to be follow the steps. I’m also learn using the CLI which is for me is hard to when it don’t have the GUI and I’m rarely using it, but it is good for me to know and learn using it. In class training also give the task that we have to group discussion and to present it to others. This give me a good relations with other in the class and create a great bond. That all I think for in classroom training.  It is good to us to improve our soft skills and understand what we a presenting about.

Next, we got training job at Medini 6 for 2 months. I choose Technical Architecture, just choose it because I’m into it but not all of my heart. I will do my best. From start, the trainer gives me a task which is I have to setup OVMM.  So I first heard it, so what I do is Google and ask my trainer. It took me a week to complete it, just because I’m doing many errors during that time. My friends help me a lot to solve it. Then after done, I’m learn which is need to be understand what doing the task, it is clearly my fault because I didn’t take it seriously. My trainer once said this” where is your step, show me where your guide”, use the step as a Kung Fu book. To learn something we must have a guide, without guidance, we will lost. In that time, I learn many types of software, which using putty, Xmin, and many. It is seems like important in doing this task, And Im also first time using it, a bit awkward to use it, and it takes time to me to able using properly. Second task, I have to create VM in OVMM, it took me a week to complete, go some error that which I didn’t know what I do, then I redo back. Then the error still have, so my friends and trainer help. Suddenly taadaaaa, solve but it just beginning, it just installing part, when to open the VM, also got problem, everything got problem, but still with my friends support me to complete the task, and I manage to complete task. In mean time also, we support each other to complete task that were given. This TA team, helps me a lot and the trainers also give some advice how to solve it. 

After all this, got sit for Oracle exam, so we take the DBA exam which is TA and SQL team, we do the discussion about the exam how to pass the exam, and many of them pass the exam including me, Thanks to all that help me  a lot, sorry for being hard. I’m slow learner when come about IT things or new things.


For any question can visit:

www.vtcholding.com

What I have learn about OBIEE ?

OBIEE stands for Oracle Business Intelligence Enterprise Edition. Business intelligence refers to the many activities that a firm does to collect information about their market of their competitors.

OBIEE Architecture
The entire system architecture is known as BI Domain.

1. Weblogic Server Domain
   Consists: Managed server module
                : Admin server module
   Both services have the Java module to triggers the Java services

2. Admin Server
   Contains: Java components – Administering the system.
   Responsible to trigger the start, stop kind of admin activity for the peer Manager server processes.

3. Managed Server
   Provides the run-time environment for the Java-based services & applications within the system. 

4. Node Manager 

   It is a distinct & separate Java utility. 

   Responsible for providing processes management services to the Admin server & Managed server. 

   Triggers the auto start, stop and restart activities.

5. Oracle Weblogic Server

  Java EE application server which provides support for the deploymet of Oracle BI Java components.

6. Fussion Middleware Control

  Is a browser based tool used to monitor, manage & configure Oracle Business Intelligence omponents.

7. Java Components

    Deployed as Java EE application

8. Administrative Components

   Enterprise Management applications & JMX Mbeans for managing all configuration and in-time settings for Oracle BI.

JMX MBeans – Java components that provide programmatic acces for managing a BI domain

9. Oracle BI Publisher

   Provides an enterprise reporting solution for authoring, managing & delivering all types of highly formatted documents to employees, customers & suppliers.

10. Oracle BI Office

      Helps integrate Oracle BI and MS Office products

11. Oracle RTD (Real Time Decisions)

   Helps companies to make better decisions in real time with its enterprise analytics software solutions.

12. Oracle BI Security Services

      Helps the integration of the Oracle BI server with the Oracle fusion middleware security platform.

13. Oracle BI SOA Services

     Enable objects in the Oracle BI presentation catalog to invoke analysis, agents and conditions.

14. Oracle BI Plugin

   This routes HTTP & SOAP (Simple Object Access Protocol) request to Oracle BI presentation services.

15. System Components

     These are deployed ass non-JEE components such as processes & services created in C++ & J2SE.

16. Oracle BI Server

      It provides significant query & data access capabilities.

      Provides support to access & manage the enterprise semantic model.

17. Oracle BI Presentation Services

     Is responsible to provide the framework & interface in order to present business data to web clients.

18. Oracle BI Scheduler

      Supports extensible scheduling for analysis to be delivered to users at specific times.

19. Oracle BI JavaHost

    Helps Oracle BI presentation services to support Java tasks for Oracle BI scheduler, Oracle BI publisher & graph generation.

20. Oracle BI Cluster Controller

     This components distributes requests to the BI Servers, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.

Below is the figure of OBIEE Architecture 11G

Installation Overview

1. Installation Package 

        a. Oracle BI EE 

        b. Oracle BI Publisher

        c. Oracle BI Add-in for Microsoft Office

        d. Oracle BI Administration Tool

Tasks in the Oracle BI Installation Procedure

Step 1:

Method installation media can use either:

• Oracle Business Intelligence installation DVD

• Oracle Technology Network (OTN)

• Oracle Software Delivery Cloud

Step 2:

• Complete the installation planning requirements. 

• Make sure that your system environment meets the installation requirements for Oracle Fusion Middleware, Oracle Business Intelligence & the Repository Creation Utility (RCU).

Step 3: 

• Have a DB installed & have the required database schemas loaded. 

• Oracle BI requires certain schemas to be installed in a supported DB. 

• Ensure that a supported DB is running & then run RCU to create the necessary schemas.

Step 4:

• Install Oracle BI

Step 5:

• Configure Oracle BI

Repository Creation Utility (RCU)

• Use RCU to create the Metadata Services (MDS) and Business Intelligence Platform (BIPLATFORM) schemas in the databse.

• Before install, transfer all OBIEE installer to VM, unzip rcuHome, run command cd RCU_HOME/bin and ./rcu

OBIEE Installation

• Unzip all 5 zip file 

• Unzip obi_LINUXX64_11.1.1.9.0_disk1of5

• Once finished unzip all 5 files, navigate to bishiphome/Disk1

• Run ./runInstaller

Starting & Stopping Oracle BI

Start OBIEE steps

1. Start DB

2. Start OBIEE which is require 4 steps (in order)

        a. Weblogic

        b. Node Manager

        c. Managed Server

        d. Oracle Process Manager & Notification Server (OPMN)

To STOP Oracle BI start from d to a

RPD & Catalog Deployment

1. Login EM : eg: http://<host>:7001/em

Below is the figure of the EM 11G

That's all. For any question can visit:

www.vtcholding.com

What have I learn about Oracle DB ?

Oracle is a corporation. It makes software to create and manage databases – so-called Database Management Systems. The latest version of the database is Oracle 12c. Oracle consists of many tools that allow you to create an application with ease and flexibility. User must determine how to implement the requirements using the features available in Oracle, along with its tools. Several of the more useful features available to Oracle application developers are integrity constraints, stored procedures and packages, database triggers, cost-based optimizer, shared SQL, locking and sequences.

So what is database? A Database is an organised collection of data. As example, you own an address book or phone? That’s a database. The addresses and phone numbers are organised which all contacts that start with A being grouped separately than contacts name start with B or C. this grouping are called tables.

A Relational Database is a database in which the data is organised according to type with the relationships being maintained between the differing types. As example, use example before, imagine all the names grouped together and all the phone numbers grouped together in another list; and all the addresses in a third. On their own these individual lists might be interesting but not useful; but if this establish the relationship between the lists – this address is where that person lives and that’s their phone number – then database takes shape.

A database management system (DBMS) is software that controls the storage, organization, and retrieval of data. Typically, a DBMS has the following elements:

• Kernel code: This code manages memory and storage for the DBMS.
• Repository of metadata: This repository is usually called a data dictionary
• Query language: This language enables applications to access the data.

In general, a database management system (DBMS) must be able to reliably manage a large amount of data in a multi-user environment so that many users can concurrently access the same data. All this must be accomplished while delivering high performance to the users of the database.

Oracle Architecture is provides a basic understanding of the ''Big Picture'' including the concepts and terminology of the Oracle Server. Below show the architecture of Oracle.

Starting Oracle and Other Important Information is provides the knowledge of how to set up your account and other system environment variables. It will also provide information about how Oracle is currently setup, which user will require, and the steps you must take to report any problems. SQL*Plus (Terminal Monitor) is provides a summary of the commands that you will require in order to create tables and manipulate the database. SQL Loader is provides a summary of the commands that user will require to allow user to load data from a file to the database. Below show the figure of SQL Loader.

SQL Commands is provides the syntax of some of the SQL Commands in Oracle to help user get started. Below show the figure of SQL Commands.

Oracle Database 12c supports customers at lower IT costs and delivers a higher quality service by enabling consolidation onto database clouds and engineered systems like Oracle Exadata and Oracle Database Appliance. It’s proven to be fast, reliable, secure and easy to manage for all types of database workloads including enterprise applications, data warehouses and bid data analysis.

Moving your database and database powered applications to Oracle Database often requires significant application and data model updates as non-Oracle technologies must be implemented to work with existing Oracle structures, data types, proprietary SQL and procedural languages (PLSQL.) Oracle Database 12c includes many new features which minimize database and application changes to accommodate applications not originally developed for Oracle Database.

For any question can visit:

www.vtcholding.com

GBS Iskandar - Campus Connect

GBS Iskandar Campus Connect Oracle Training & Certification Program is a program collaboration with i2M Ventures Sdn Bhd (i2M), Universiti Teknologi Malaysia (UTM) and Vision Technology Consulting Sdn Bhd (VTC) in UTM Johor Bahru Campus. The program introduces participants to Service-Oriented Architecture (SOA) concepts, the OSA approach to integration, and the Oracle Fusion Middleware 11g products that support and SOA implementation. The aim program is not just  to develop high-skilled Oracle’s technologies but also to give participants real environment work in VTC’s Iskandar Puteri office at Medini 6 during the training. The participants are among final year students that have been selected to participate in this program. A total of 43 students from UTM, UiTM, UTHM & UNISZA has been selected to participate in the Campus Connect Program.

The Program duration is 3 months which is 1 month class room training and 2 months on job training. The program is using two training mechanism which is in class training and job training. For the class training is the participants learned about the Oracle Virtualization, Oracle Linux, Oracle Database, Oracle SQL and Oracle Business Intelligence Enterprise Edition (OBIEE). The participants are given the tasks and group project to feel like how the actual work is working.  Participants learn the theory of the sylibus that the trainer teach about the Oracle environment, this give the participants not to think that Oracle just not about Database but its more than that. The class training is for starting point that the participants to get more about the Oracle. With the task, assignment given, the participants will learn how it works more details and give them understanding.

For the job training, the participants will be divided into based on what they want such as Database Administrator, Technical Architect, PL/SQL Developer and Business Intelligence Developer. All this jobs are demand job that related with Oracle work scope. All the jobs are given to the participants to feel the real experience during the job training. With the task that given by the trainer, the participants will learn how to complete the task even though sometimes they need to explore by them self. With the job environment, the participants will feel the pressure or hard times to complete the task, it will make the participant more matured and know how to solve it.  

With all of this, the participants will also sit for the Oracle professional certification exam during this training. With the certificate, the participants will be recognized by their skills and knowledge. This program will be a great advantage to the participants before entering the real work environment. 

Thanks to i2M Ventures Sdn Bhd (i2M), Universiti Teknologi Malaysia (UTM) and Vision Technology Consulting Sdn Bhd (VTC) give the opportunities to join the program. Thanks also to GBS ISKANDAR provide to participants for  a specialised programme to facilitate businesses to locate GBS Operations in Iskandar Puteri, Iskandar Malaysia. The programme is managed by i2M Ventures Sdn Bhd (i2M ), a wholly-owned subsidiary of Khazanah Nasional Bhd, the Malaysian government’s investment arm. 

With GBS ISKANDAR, companies and participants will be able to enjoy expert facilitation in order to meet their GBS location requirements, covering key areas such as talent, infrastructure, liveability and incentives. Additionally, qualified companies will enjoy privileged access to customised incentives provided by GBS Iskandar.

In real world of IT, is about how fast you learn, not how much you know. With this opportunity, its helps the participants more confident to step into real work and more prepared.  

For any question can visit:

www.vtcholding.com