Showing posts with label Middleware. Show all posts
Showing posts with label Middleware. Show all posts

Friday, March 11, 2016

Error Starting WebLogic Admin Server - Could not reserve enough space for object heap

The first time that I ran may WebLogic admin Server, I encountered the following error:
Could not reserve enough space for object heap.
I resolved this by creating a new environment variable called EXTRA_JAVA_PROPERTIES with the "-Xms512m -Xmx251m"
Try starting WebLogic server, it should start!!!!

Tuesday, March 8, 2016

How to create ODI Domain - Windows???

Configuration - Create ODI Domain
Execute config.cmd as shown below
 Select "Create a new domain" and choose the location, Click "Next"
Choose following templates from available templates, Click "Next"

  •  Basic WebLogic Server Domain – 12.2.1 [wlserver]*
  • Oracle Enterprise Manager Plugin for ODI – 12.2.1 [em]
  • Oracle Enterprise Manager – 12.2.1 [em]
  • Oracle Data Integrator – Agent – 12.2.1 [odi]
  • Oracle Data Integrator – Agent Libraries – 12.2.1 [odi]
  • Oracle Data Integrator SDK Shared Library Template – 12.2.1 [odi]
  • Oracle Data Integrator – Console – 12.2.1 [odi]
  • Oracle JRF – 12.2.1 [oracle_common]
  • WebLogic Coherence Cluster Extension – 12.2.1 [wlserver], Click "Next"
Enter Application Location,  Click "Next"
 Create Administrator Account, Click "Next"
Choose "Production Mode", Click "Next"
Provide database connection information for schema <Prefix>_STB (Configured via Repository Creation Utility - RCU), Click "Get RCU Configuration" you should see result log as below, Click "Next"
Check database connection information (Schema, password, database service, listener port and hostname) - You should see this information while creating repository using RCU, Click "Next"
You should see next screen as below, Click "Next"
Give SUPERVISOR username and password (you should get this while creating Repository using RCU), Click "Next"

Configure Admin Server, Click "Next"
Configure Node Manager, Click "Next"
Configure ODI Manager Server, Click "Next"
 Click "Next", Configuration without Cluster
Default value and Click "Next"
Click "Add" and Configure Unix Machine, Click "Next"
 Add AdminServer and ODI_Server1 to the Unix machine, Click "Next"
Check Configuration Summary and Click "Create" 

Domain Creation is completed!!!

Oracle Data Integrator (ODI) - Repository Creation Utility (RCU)

Configuring Database Schemas: RCU Configuration
Prerequisites:
The Database is already installed - In my case 12c Database
RDBMS Version : 12.1.0.2.0
Database User  : SYS
Character Set   : AL32UTF8'
Start Repository Creation Utility as shown in below screenshot
Welcome screen, Click "Next"
Choose "Create Repository" and then "System Load and Product Load", Click "Next"
 Database Connection Details

  • Database Server Name or IP Address
  • Database Listener Port
  • Database Service name
  • Database user (with DBA or SYSDBA priveliges)

 Repository Creation Utility will check Prerequisites, you should see below, Click "OK" 
 Choose Components "AS Common Schemas" and "Oracle Data Integrator", click "Next"
 RCU will check Prerequisites, you should see below, Click "OK"
 Define password for main and auxiliary schema users, click "Next"
Define

  • Supervisor Password
  • Work Repository type D - Development and E - Execution
  • Work Repository Password, Click "Next"

 Map and Create tablespaces, Click "Next"
 RCU will create Tablespaces, Click "OK"
 Summary, Click "Create"
Summary
 Repository Creation Done, Click "Close"

How to Install Oracle Data Integrator (12.1.3.0.0) - ODI - Windows???

First we need to install JDK latest version, I installed jdk1.8.0_73. You can find the latest version from below link
Now download Oracle Data  12.1.3.0.0. You can download from "Oracle Software Delivery Cloud" @ https://edelivery.oracle.com/ (You should have Oracle support ID and its password)
Choose Product and Platform and press "Continue"
 Choose "Oracle Fusion Middleware 12c (12.1.3.0.0) Data Integrator" and click "Continue"
Choose corresponding ZIP file and click on "Download All"
Set environmental variable JAVA_HOME and then execute below command. If JAVA_HOME not configured you have to go to the location where JAVA is located. From there you have to execute command as shown in below screenshot.
Welcome, Click "Next"
Determine the Oracle ODI location, Click "Next"
Installation type, Choose Standalone Installation or Enterprise Installation according to your needs, Click "Next"
Prerequisite Checks, Click "Next". All Prerequisite Checks should Pass
Installation Summary, Click "Install"
 Installation Progress, Click "Next"
 Installation completed, Click "Finish"

How to install WebLogic Server (12.1.3.0.0 ) ???

First we need to install JDK latest version, I installed jdk1.8.0_73. You can find the latest version from below link
Now download WebLogic Server 12.1.3.0.0. You can download from "Oracle Software Delivery Cloud" @ https://edelivery.oracle.com/ (You should have Oracle support ID and its password)
Choose Product and Platform and press "Continue"
Choose "Oracle Fusion Middleware 12c (12.1.3.0.0) Infrastructure" and click "Continue"
Choose corresponding ZIP file and click on "Download All"
Set environmental variable JAVA_HOME and then execute below command. If JAVA_HOME not configured you have to go to the location where JAVA is located. From there you have to execute command as shown in below screenshot.
Installer will do some necessary check likes CPU, Monitor, Swap etc. If everything looks good then Oracle Universal Installer will start 
Welcome Page, Click "Next"
 Determine the Oracle (Middleware) Home, Click "Next"
 Choose "Fusion Middleware Infrastructure" and click "Next"
 All check must be successful. Click "Next"
 Installation summary, Click "Install"
 Installation Progress, Click "Next"
 Installation Completed, Click "Finish"
 Check WebLogic Server Installation

How to Create TEMPORARY tablespace and drop existing temporary tablespace in oracle 11g/12c

1. Create Temporary Tablespace Temp create temporary tablespace temp2 tempfile '/mnt/mnt04/oradata/temp01.dbf'size 2000M;  2. Move D...