Thursday, April 9, 2015

How to Setup Oracle SOA 12c Environment

 
The following will describe the step by step process of installing and configuring the SOA 12c on Windows box.
For any oracle product installation, please download required binaries from Oracle e delivery .
 
Prerequisites : Database setup has been completed and create the schema;s with RCU.
SOA 12c1.1.3 Server Edition
clip_image002
clip_image004
clip_image006
clip_image008
clip_image010
clip_image012
clip_image014
clip_image016
clip_image018
clip_image020
clip_image022
clip_image024
clip_image025
Now From WE8MSWIN1252 TO AL32UTF8
Execute the following commands in sqlplus connected as "/ AS SYSDBA":
1. SHUTDOWN IMMEDIATE;
2. STARTUP MOUNT; 
3. ALTER SYSTEM ENABLE RESTRICTED SESSION; 
4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
5. ALTER SYSTEM SET AQ_TM_PROCESSES=0; 
6. ALTER DATABASE OPEN; 
7. ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
8. SHUTDOWN IMMEDIATE;
9. STARTUP; 
1) Check where are your PDB installed(below my example):
SQL> select name from v$services;
NAME
—————————————————————-
pdborcl
weblogicXDB
weblogic
SYS$BACKGROUND
SYS$USERS
2) Alter your database:
SQL>  alter pluggable database all open;
3) insert the correct service name. On my case, is pdborcl:
clip_image027
clip_image029
clip_image031clip_image033
clip_image035
clip_image036
clip_image038
Domain Creation:
clip_image040
clip_image042
clip_image044
clip_image046
Weblogic/welcome123
clip_image048
clip_image050
clip_image052
clip_image054
clip_image056
clip_image058
clip_image060
clip_image062
clip_image064
clip_image066
clip_image068
clip_image070
clip_image072
clip_image074
clip_image076
clip_image078
clip_image080
clip_image082
































































How to setup Oracle Database 12c on Windows

 

Database Setup.

1. Download the Binaries from Oracle

2. Extract the zip files

clip_image002

clip_image004

clip_image005

clip_image007

clip_image009

clip_image010

clip_image012

clip_image014

clip_image016

clip_image018

clip_image020

clip_image022

clip_image024

clip_image026

clip_image028

clip_image030

clip_image032

clip_image034

clip_image036

clip_image038

clip_image040

eg :Provided same password as the one I created before oracle/oracle123

clip_image042

clip_image044

clip_image046

clip_image047

clip_image048

clip_image049

clip_image051

Oracle Database installation/setup 03/19/2015

Created new Windows User : oracle/oracle123

Gloabal DataBase : orcl

https://hostname:5500/em

sys/oracle123

clip_image053

clip_image054