Tuesday, August 30, 2011

Cloning of ORACLE_HOME in Oracle 11g

Cloning of ORACLE_HOME in Oracle 11g:

We have to clone ORACLE_HOME for few of the reasons like
1)Whenever a mount point disk space is insufficient.
2)Copy the software from one machine to other withour intstalling.

When we are doing Cloning of the ORACLE_HOME(i.e software) in Oracle11g we need to specify ORACLE_BASE by executing clone.pl perl script below is the experiment to do this ORACLE_HOME cloning for Oracle 10g ORACLE_HOME the steps remain the same only difference is ORACLE_BASE environment variable is not required.We have to request for the downtime of 30 minutes for performing this task because after cloning ORACLE_HOME

we need to verify and change the below things:

1).bash_profile(.profile on solaris,hp/ux,aix) file on linux.

2)/etc/oratab file(/var/opt/oracle/oratab on solaris) on linux.

3)listener.ora file in $TNS_ADMIN($ORACLE_HOME/network/admin) path.

4)expdp(export job script) and RMAN scripts or other scripts using ORACLE_HOME and ORACLE_BASE


Step 1:Collect the environment variable of your current ORACLE_HOME from the .bash_profile (.profile in any other unix environment):

Below are the current settings:

# .bash_profile

export ORACLE_BASE=/u01/oracle11g

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH


Step 2:Set the Display environmet variable:

DISPLAY=":0.0" export DISPLAY
(or)
xclock -display machine_name:0.0


Step 3:Now,zipped and extract using tar in a mount point where you have sufficient diskspace:


$ export OLD_ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
$ cd $OLD_ORACLE_HOME/..
$ tar -cvf /u05/TAR_ORACLE_HOME1/OH.tar /u01/oracle11g/product/11.2.0/dbhome_1

Note:
tar -cvf destination_location source_location
Where:Destination_location=u05/TAR_ORACLE_HOME1/OH.tar
Source_location=/u01/oracle11g/product/11.2.0/dbhome_1

Step 4:Destination ORACLE_HOME Creation:

[oracle@testnode1 u03]$ cd /u05
[oracle@testnode1 u05]$ mkdir app
[oracle@testnode1 u05]$ cd app/
[oracle@testnode1 app]$ ls
[oracle@testnode1 app]$ mkdir db11g2
[oracle@testnode1 app]$ cd db11g2/
[oracle@testnode1 db11g2]$ mkdir product
[oracle@testnode1 db11g2]$ cd product/
[oracle@testnode1 product]$ pwd
/u05/app/db11g2/product
[oracle@testnode1 product]$ mkdir 11.2
[oracle@testnode1 product]$ cd 11.2/
[oracle@testnode1 11.2]$ pwd
/u05/app/db11g2/product/11.2


export ORACLE_BASE=/u05/app/db11g2
export ORACLE_HOME=/u05/app/db11g2/product/11.2

[oracle@testnode1 11.2]$ pwd
/u05/app/db11g2/product/11.2
$cd /u05/app/db11g2/product/11.2
$ tar -xvf /u05/TAR_ORACLE_HOME1/OH.tar

=>This will create the ORACLE_HOME as present is /u01 mount point in /u05 mount point
Next,

$export PATH=$ORACLE_HOME/bin:$PATH
$export ORACLE_HOME=/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1
$echo $ORACLE_HOME
/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1
$cd /u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1
$perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_HOME=/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1 ORACLE_BASE=/u05/app/db11g2/product/11.2/u01/oracle11g ORACLE_HOME_NAME=OraDb11g_home2

Result:
--------------------------------------

WARNING:
The following configuration scripts need to be executed as the "root" user.
/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts

The cloning of OraDb11g_home_2 was successful.
Please check '/u01/oraInventory/logs/cloneActions2011-08-29_04-23-59PM.log' for more details.
[oracle@testnode1 dbhome_1]$
[oracle@testnode1 dbhome_1]$
[oracle@testnode1 dbhome_1]$


Step 5:Execute root.sh script:
Log in as "root"
[oracle@testnode1 dbhome_1]$ su
Password:
[root@testnode1 dbhome_1]# cd /u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1
[root@testnode1 dbhome_1]#pwd
/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1
[root@testnode1 dbhome_1]# sh root.sh
Check /u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1/install/root_testnode1.in.bosch.com_2011-08-29_16-32-46.log
for the output of root script

Step 6:Copy the spfiles and password files:

Copy the spfiles and password files of Databases from previous $ORACLE_HOME/dbs( $ORACLE_HOME/database in windows)
to new $ORACLE_HOME/dbs path

Step 7:Post ORACLE_HOME clonning steps are as given below:


1)Modify .bash_profile file:

If we have created separate profile for each databases environment than we have update there and
check we are able to login the Database successfully

vi .bash_profile

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/u05/app/db11g2/product/11.2/u01/oracle11g
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export sq='sqlplus "/as sysdba"'
export ORACLE_SID=TESTDB1

:wq =>save and quit.

2)Modify /etc/oratab file.

Modify the /etc/oratab entry in linux with the neW ORACLE_HOME path

# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
#TESTDB2:/u01/oracle11g/product/11.2.0/dbhome_1:Y
#TESTDB1:/u01/oracle11g/product/11.2.0/dbhome_1:Y

#New ORACLE_HOME
TESTDB2:/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1:Y
TESTDB1:/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1:Y

3)Modify listener.ora file

If we are not able to connect from other machine or client machine after ORACLE_HOME cloning don't get shocked as we have to update listener.ora with the new ORACLE_HOME path.Before modifying listener.ora file create a backup file
if it does not exists.Now you cand set the new ORACLE_HOME path here as given below.

[oracle@testnode1 oracle11g]$ cd $TNS_ADMIN
[oracle@testnode1 admin]$ pwd
/u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1/network/admin
[oracle@testnode1 admin]$ ls -altr
-rw-r--r-- 1 oracle dba 431 May 13 15:36 sqlnet.ora
-rw-r--r-- 1 oracle dba 959 Aug 29 17:15 tnsnames.ora
-rw-r--r-- 1 oracle dba 405 Aug 29 19:32 listener.ora_bkp29082011
-rw-r--r-- 1 oracle dba 461 Aug 29 19:34 listener.ora
drwxr-xr-x 3 oracle dba 4096 Aug 30 11:04 .
[oracle@testnode1 admin]$ vi listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =testnode1)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = TESTDB1)
(ORACLE_HOME = /u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1)
)
(SID_DESC =
(SID_NAME = TESTDB2)
(ORACLE_HOME = /u05/app/db11g2/product/11.2/u01/oracle11g/product/11.2.0/dbhome_1)
)
)

:wq =>save and quit.

4)Modify expdp(export job script) and RMAN scripts or other scripts using ORACLE_HOME and ORACLE_BASE for their executions.
If we don't modify the Backup scripts or other scripts using ORACLE_HOME and ORACLE_BASE than next morning we might see backups or jobs getting failed so please make sure you modify the ORACLE_HOME and ORACLE_BASE.

Now,we can test ourself in our local system whether we are able to connect to the Databases with the new ORACLE_HOME and than request the end users to use the system.Thus our task can be successfully completed.


Hope it helps.

Enjoy DBA tasks.

Best regards,

Rafi.


















Wednesday, August 24, 2011

Compiling JSP files automatically and manually in R12

Hi,
In R12 Application we can compile JSP files
1)Automatically or
2)Manually
Below are some useful steps to do the compilation of JSP files:

1)Automatic JSP files compilation:

Command to complie jsp files automatically has some changes compared to 11i (See metalink notes 458338.1):

2)Manual JSP files compilation:
Preparatory Step: Set the Oracle Application environment.
# su - applmgr
$ cd /oraAPP/apps/apps_st
$TEST_node1.env

We can follow below steps to compile a single jsp file (seeded or custom) in Oracle Applications 11i/R12.

1)Copy the jsp file to $COMMON_TOP/webapps/oacore/html (this location translates to $OA_HTML):

Note:We can use 'winscp' to copy the jsp file from windows to linux in a frequent manner each time.

Placing the file under $OA_HTML enables end users to access the file using the url http://hostname.domain:port/OA_HTML/[jspfile.jsp]

2)Give ownership and permission for 'applmgr'(Application file system owner) to compile jsp file.

#chown applmgr:dba /oraAPP/apps/apps_st/comn/webapps/oacore/html/test1.jsp
#chmod -R 755 /oraAPP/apps/apps_st/comn/webapps/oacore/html/test1.jsp

3) Flush and Compile the jsp file using 'applmgr' user:
# su - applmgr
$ cd $OAH_TOP/html =>location of all jsp files

-bash-3.2$ /oraAPP/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/ojspCompile.pl --compile --flush -p 2
logfile set: /oraAPP/inst/apps/VIS_kor300949v20ebs/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
loading deplist...8052
enumerating jsps...8054
updating dependency...2
parsing jsp...2
writing deplist...8053
initializing compilation:
eliminating children...5985 (-2069)
translating and compiling:
translating jsps...5985/5985 in 6m51s
compiling jsps...5985/5985 [failed: 1] in 17m11s
Finished!

Note:
Linux/Unix:
cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 2

Windows:
cd %FND_TOP%\patch\115\bin
perl -x ojspCompile.pl –compile –flush

4)Restart the Middle Tier(applications) services:

For Stopping the Middle-Tier services in R12:

-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ ./adstpall.sh
Enter the APPS username: apps

Enter the APPS password:
The logfile for this session is located at /oraAPP/inst/apps/TESTDB_TESTNODEebs/logs/appl/admin/log/adstpall.log

For Starting the Middle-Tier Services in R12:

-bash-3.2$ ./adstrtal.sh

You are running adstrtal.sh version 120.15


Enter the APPS username: apps

Enter the APPS password:
The logfile for this session is located at /oraAPP/inst/apps/TESTDB_TESTNODEebs/logs/appl/admin/log/adstrtal.log

Once the Middle-Tier services are started successfully,We have to check the URL for JSP file.

5)Verify the URL:

The URL format will be as given below:
http://hostname.domain:port/OA_HTML/[jspfile.jsp]


Hope it helps...

Happy Apps DBA learning.


Best regards,

Rafi.



Saturday, August 20, 2011

Setting the Oracle Environment for various Oracle Database versions

Hi,
When in we install different Oracle Software in our machine.It is very important we set the correct PATH and ORACLE_HOME environment variables in order to connect them always.Below is one such way which will be helpful.

Error messages:

C:\Windows\system32>sqlplus
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Pre-requistic step:

On Windows OS:

Delete the environment variable 'PATH' by going to computer=>properties=>Advanced
system properties=>Advanced=>Environment variable=>path and delete this Click OK.

On linux OS:
We have to remove the 'PATH' variable from .bash_profile or we can set separate .bash_profile for each Oracle Database versions and we have to use export in place of set command.

C:\>set ORACLE_HOME=
C:\>set PATH=%ORACLE_HOME%\bin;%PATH%
C:\>set ORACLE_SID=
C:\>sqlplus "/ as sysdba"

Oracle 11g:

Pre-requistics step:Make sure you started the services for Oracle 11g listener
and Database in your machine(services.msc at run prompt and start Oracle 11g listener and Database services).

set ORACLE_HOME=D:\app\RafiAlvi\product\11.2.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%
set ORACLE_SID=ORCL
sqlplus "/as sysdba"

Oracle 10g:

Pre-requistics step: Make sure you are started services for Oracle 10g listener and Database in your machine.

set ORACLE_HOME=D:\oracle\product\10.2.0\db_1
set PATH=%ORACLE_HOME%\bin;%PATH%
set ORACLE_SID=TESTDB
sqlplus "/as sysdba"

Hope it helps.


Best regards,

Rafi.





Thursday, August 18, 2011

Apex Deployment on Weblogic Server

Hi,
I started my Oracle fusion middleware journey with some good experiments.
Below are the steps which I performed for deploying Apex on Weblogic Server.
(Installation and configuration of Weblogic Server I will cover in separate post and Apex installation and configuration you can get from Apex_tasks Label link)

Apex can be integrated with weblogic by follwing below experiment:


I)
Case study:

WebLogic Server and APEX:
When a WebLogic Server (WLS) is the primary Web server, accessing APEX pages though the WLS requires a proxy. The configuration of APEX generally follows one of two configurations – Apache with mod_plsql or the Embedded PL/SQL gateway. When WebLogic (without Apache) is the main HTTP server, getting APEX to surface on the same port as WebLogic requires some form of proxy.

Overall Approach:
This solution creates a very simple Web Application that invokes a Java Proxy Servlet when a user tries to access APEX pages. Wrapping this Web Application around the Java Proxy Servlet lets the WLS serve APEX without any port conflicts. The WLS Proxy Servlet is a fully documented out of the box tool.
To create and deploy the Web Application simply build the files outlined in this document, deploy the application and then access APEX.

Exploded deployment:

For convenience, this solution takes advantage of the exploded deployment feature of the WLS. In addition to the ability to deploy jar, war and ear files, the WLS can deploy Web Applications as an exploded directory that contains the same contents of the archive file. An exploded archive directory contains the same files and directories as a jar archive. However, the files and directories reside directly in the file system instead of as a single archive file (JAR). This example uses the exploded deployment style to create the Web Application for this example.
Default WebLogic application
The default Web Application is what the server sends to browser clients who do not specify a recognized URI (or specify only “/” as the URI). Each server has only one default Web Application and for this solution to work, this application must be set as the default. If there is already a default, this servlet could be added to the existing application by using an exploded deployment of the default with modification to the web.xml to register the APEX proxy.

II)

Pre-requisites:

1)An Oracle database successfully serving APEX pages. The APEX instance may be on the same or different machine and served from either Apache or the Embedded PL/SQL gateway. In this example, APEX uses the xdb feature of Database which is included in Oracle 11g Database and database is running on the same machine as the WebLogic server and natively appears at the http://10.47.33.10:8080/apex URL.
Database side task:
Open the Apex http port from the Database side
SQL> begin
dbms_xdb.sethttpport('8080');
end;
/

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport as "HTTP-Port"
from dual;

HTTP-Port
----------
8080

2) An Oracle WebLogic Server 10.3(11g) running a Node Manger, the Administration Console and a Managed server. This example uses a domain created specifically for this exercise named APEXDemo. The WLS Administration console uses port 7001 and the SOA Managed Server uses port 8001.We are using SOA Managed Server for Deploying Apex

3) There is no other “default” WebLogic application for the Managed Server.

III)Experiment:

Create the APEX Proxy Servlet
1)Create the following directory structure somewhere on disk. This experment assumes the / root disk is used. Note: the apexproxy.war directory name mimics the normal J2EE naming convention for Web Application archive (WAR).

Create the directory structure as given below in linux OS:

#mkdir APEX_PROXY
#cd /APEX_PROXY
#mkdir apexproxy.war
#cd /APEX_PROXY/apexproxy.war

Rest of the steps with screen shots very well documented in the below link:

http://christopherbeck.wordpress.com/2008/09/15/weblogic-server-and-apex/

Thanks Christopherbeck.

Enjoy Oracle Fusion Middleware learning

Best regards,

Rafi.

















Tuesday, August 16, 2011

Apex listener starting issue

Hi,
Usually we start the apex listener as given below,But when you see the error messages as given below don't get shock as it is because the apex war file is not able to pick the right jdk version(jdk6) while starting apex listener.

Error message:-bash-3.2$ java -Dapex.images=/apex_4.0.2/apex/images -Dapex.port=8080 -jar apex.war
INFO: Starting: /apex_4.0.2/apex.war
See: 'java -jar apex.war --help' for full range of configuration options
INFO: Extracting to: /tmp/apex
SEVERE: method java.lang.System.console with signature ()Ljava.io.Console; was not found.
java.lang.NoSuchMethodError: method java.lang.System.console with signature ()Ljava.io.Console; was not found.
at ____embedded.____EntryPoint.apexImages(____EntryPoint.java:104)
at ____embedded.____EntryPoint.main(____EntryPoint.java:91)


Solution: Installed the jdk6 update version latest one and execute the .war file directly as given below.

# rpm -Uvh jdk-6u26-linux-i586-rpm.bin

Go to the path where we unzip the apex_listener.zip file:

In an EBS R12 environment don't set the environment for oracle or apps and execute the 'apex.war' file with 'oracle' user.

-bash-3.2$ ./apex.war
INFO: Starting: /apex_listener_status/apex.war
See: 'java -jar apex.war --help' for full range of configuration options
INFO: Extracting to: /tmp/apex
Enter the path to the directory containing the APEX static resources
Example: /Users/myuser/apex/images
or press Enter to skip: /apex_4.0.2/apex/images/
INFO: Using classpath: file:/tmp/apex/apex/____embedded/start.jar:file:/tmp/apex/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:file:/tmp/apex/apex/WEB-INF/lib/ojmisc.jar:file:/tmp/apex/apex/WEB-INF/lib/commons-fileupload-1.2.1.jar:file:/tmp/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/tmp/apex/apex/WEB-INF/lib/ucp.jar:file:/tmp/apex/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/tmp/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/tmp/apex/apex/WEB-INF/lib/apex.jar:file:/tmp/apex/apex/WEB-INF/lib/je-4.0.103.jar:
INFO: Starting Embedded Web Container in: /tmp/apex
Enter a username for the APEX Listener Administrator [adminlistener]: admin
Enter a password for admin:
Confirm password for admin:
Enter a username for the APEX Listener Manager [managerlistener]: apex
Enter a password for apex:
Confirm password for apex:
Aug 17, 2011 3:22:06 AM ____bootstrap.Deployer deploy
INFO: Will deploy application path=/tmp/apex/apex/WEB-INF/web.xml
Aug 17, 2011 3:22:10 AM ____bootstrap.Deployer deploy
INFO: deployed application path=/tmp/apex/apex/WEB-INF/web.xml
Using config file: /tmp/apex/apex-config.xml

In Database side:

alter user apex_public_user identified by apex_public_user;

Listener configuration:
URL: http://:/apex/listenerConfigure

where:host=ipadrress/machine name,port:8080(default)

Now,
We are ready to configure the apex listener and carry the remaining workspace administration tasks or leave to the apex team to do rest of the task.


Happy APEX learning.


Best regards,

Rafi.







Tuesday, August 9, 2011

Step by step Oracle SOA suite 11g installation on RHEL 5.3

Hi,
Below are the lists of steps I have followed for installing Oracle SOA Suite 11g,I have not put screenshots but tried to put explain without screenshots.

Oracle SOA Suite 11g Installation plan:


Downloads:
1)DATABASE :11.2.0.1.0(x86 32-bit LINUX):
2)WEBLOGICSERVER
3)RCU(REPOSITORY CREATION UTILITY
4) SOA
5) JDEVELOPER
6)SOA EXTENSION

Preparatory step:

[oracle@fmwtestnode /]$ mkdir Web_logic_soft
[oracle@fmwtestnode /]$ su
Password:
[root@fmwtestnode /]# mkdir Oracle11gR2soft
[root@fmwtestnode /]# chown oracle:oinstall /Oracle11gR2soft/
[root@fmwtestnode /]# chmod -R 755 /Oracle11gR2soft/
[root@fmwtestnode /]# mkdir Web_logic_soft
[root@fmwtestnode /]# mkdir Jdev_soft
[root@fmwtestnode /]# mkdir SOA_SUITE_11g_soft
[root@fmwtestnode /]# chown -R oracle:oinstall /Web_logic_soft/
[root@fmwtestnode /]# mkdir Reposit_create_soft
[root@fmwtestnode /]# chown -R oracle:oinstall /Jdev_soft/
[root@fmwtestnode /]# chown -R oracle:oinstall /SOA_SUITE_11g_soft/
[root@fmwtestnode /]# chown -R oracle:oinstall Reposit_create_soft/
[root@fmwtestnode /]# chmod -R 755 /Oracle10gsoft/
[root@fmwtestnode /]# chmod -R 755 /Web_logic_soft/
[root@fmwtestnode /]# chmod -R 755 /Reposit_create_soft/
[root@fmwtestnode /]# chmod -R 755 /Jdev_soft/
[root@fmwtestnode /]# chmod -R 755 /SOA_SUITE_11g_soft/


Check your browser:
Enterprise Manager requires Firefox 3, Safari 4+ or IE 7+.
BAM requires IE 7 or 8


Check your JDK:
The WebLogic server installation exe is packaged with a JDK. The JDeveloper exe also comes with a JDK.
If you are going to install WebLogic server and JDeveloper on the same machine,we use the JDK from WebLogic for JDeveloper too. However, if you are going to install on separate machines, you need to have Oracle Sun Java 1.6 update 21+ JDK for JDeveloper. You can get it from the Oracle Sun downloads page. Be sure to get the JDK not the JRE: http://java.sun.com/products/archive/


Installations:

1)Install the database:
Check my previous post for Oracle Database 11g rel2 installation on linux.

2) Install WebLogic server:

Weblogic pre-installation steps:
Check the Certification matrix to check the supported Weblogic server for
Various Operating system.For our operating system RHEL 5.3 the supported
Weblogic server software is 10.3.

SQL> select name from v$database;

NAME
---------
FMWDB

SQL> select status from v$instance;

STATUS
------------
OPEN
SQL> show parameter processes
SQL> alter system set processes=1000 scope=spfile;
SQL> shutdown immediate
SQL> startup
SQL> show parameter processes

[root@fmwtestnode /]# mkdir -p Middleware/SOASuite11gR1
[root@fmwtestnode /]# chown oracle:oinstall /Middleware/SOASuite11gR1/
[root@fmwtestnode /]# chmod -R 755 /Middleware/SOASuite11gR1/

We have to create Middleware home directory for installation FUSION MIDDLEWARE COMPONENTS in this particular by granting the ownership to the ‘oracle’ user with all the required privileges


1)DATABASE
2)WEBLOGIC SERVER
3)RCU
4)SOA
5)JDeveloper
6)SOA Extension

Once your database is ready, we can install the next step, the WebLogic server.
When you are ready to install, complete the following:

I granted all the ownership to the oracle user and permission where the executable of weblogic software is present.I launched the installation on vm server as follows:


Here ,I have entered the Fusion Middlware Home path which has all the ownership and permission so that ‘oracle’ user can install weblogic server here.

Choose 'Graphical' method to install Weblogic server to have pictorial representation:

Press ‘Enter’ and proceed……..

Press ‘Enter’……..

Make uninformed to ‘yes’ as shown below in screenshot and proceed:

Select Typical, click Next

Press ‘Enter’ and proceed……..

Here,As we see above Along with Weblogic platform 10.3.5.0,JDKs and other JDBC ,weblogic server plugins and other products get installed…

Press ‘Enter’ proceed…….

That’s it.Weblogic installation is proceeding as see in the above screen shot…………..

First JDK files are installed,OCM,domains…….


As we see from the screenshot Weblogic installation Completed successfully….
Press ‘Enter’ and it is done……….

Once the Weblogic installation is done we need to Configure Domain,And we have to make sure weblogic server is up & running.

What is a weblogic server domain?>
A domain is the basic administration unit for Weblogic Server instances. A domain consists of an Administration Server and Managed application servers and resources. The main configuration file in the domain is config.xml, which is in the domain directory(where you install your weblogic server domain) under config directory.
We can use Administration Server to do the configuration tasks. A web based console comes with the domain installation, where an administrator can login and perform the administration tasks.
Weblogic domain can have multiple servers in a cluster or multiple clusters. A domain can have an Administration Server which can act as an Administration Server and managed server. This architecture is mostly used by the developers in developing and deploying applications in there local environments.
Production and Development Modes

Weblogic domain can be configured in two different modes:
1.Development Mode
2.Production Mode

1. Development Mode: In the development mode of configuration,Weblogic server domain has minimum security and is used for the development of application purposes. In this mode, you can also auto-deploy the application.
2. Productions Mode: This is the final mode of the domain configuration, where you deploy the application which will be directly used by the customers. This is a very important environment, with maximum security.
Now, as we got a general idea on what a weblogic server domain is, we will now configure the weblogic server domain on Linux operating system can be done as follows:

Step 1: Go to /Middleware/SOASuite11gR1/wlserver_10.3/common/bin and look for file name "config.sh".


[oracle@fmwtestnode bin]$ cd /Middleware/SOASuite11gR1/wlserver_10.3/common/bin
[oracle@fmwtestnode bin]$ ls -altr
total 128
-rwxr-x--- 1 oracle oinstall 13740 Jul 28 11:10 wlsifconfig.sh
drwxr-x--- 11 oracle oinstall 4096 Jul 28 11:10 ..
-rwxr-x--- 1 oracle oinstall 761 Jul 28 11:11 wlst.sh
-rwxr-x--- 1 oracle oinstall 31126 Jul 28 11:11 wlscontrol.sh
-rwxr-x--- 1 oracle oinstall 3298 Jul 28 11:11 upgrade.sh
-rwxr-x--- 1 oracle oinstall 2087 Jul 28 11:11 unpack.sh
-rwxr-x--- 1 oracle oinstall 1448 Jul 28 11:11 stopDerby.sh
-rwxr-x--- 1 oracle oinstall 4082 Jul 28 11:11 startDerby.sh
-rwxr-x--- 1 oracle oinstall 2579 Jul 28 11:11 pack.sh
-rwxr-x--- 1 oracle oinstall 2274 Jul 28 11:11 config.sh
-rwxr-x--- 1 oracle oinstall 2122 Jul 28 11:11 config_builder.sh
-rwxr-x--- 1 oracle oinstall 22511 Jul 28 11:11 commEnv.sh
-rwxr-x--- 1 oracle oinstall 2746 Jul 28 11:11 setPatchEnv.sh
-rwxr-x--- 1 oracle oinstall 4156 Jul 28 16:36 startManagedWebLogic.sh
drwxr-xr-x 3 oracle oinstall 4096 Jul 28 16:36 servers

Step 2: Run the 'config.sh' file for the domain configuration.
‘Config.sh’ will do the Domain Configure.There are 3 ways you can do this configuration
1)Graphical
2)Console
3)Silent
We are using ‘Graphical’ method as it display all the information to our screen…
For doing this we need to set the ‘DISPLAY’ as follows:
Check ‘xclock’ command is working and showing the current time.If it shows than we just need to export ‘DISPLAY’ environment Variable.

$xclock
$ export DISPLAY
$./config.sh

Proceed with the configuration,supply 'weblogic' user with credential.Choose
Development or Production depending on our requirement and obtain the
final URL.After completion of Domain configuration,we will obtain:

Domain Location:/Middleware/SOASuite11gR1/user_projects/domain/base_domain
Admin Server URL:http://fmwtestnode.apac.xyz.com:7001/console


3)Install database schema using RCU (REPOSITORY CREATING UTILITY)

Useful pre-requistics steps:

[oracle@fmwtestnode admin]$ hostname
fmwtestnode.apac.bosch.com
[oracle@fmwtestnode admin]$ tnsping fmwdb

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 29-JUL-2011 18:26:23

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/u01/app//product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = fmwdb.apac.bosch.com)))
TNS-12541: TNS:no listener
[oracle@fmwtestnode admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-JUL-2011 18:26:30

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /u01/app//product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app//product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/diag/tnslsnr/fmwtestnode/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmwtestnode.apac.bosch.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 29-JUL-2011 18:26:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app//product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/diag/tnslsnr/fmwtestnode/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmwtestnode.apac.bosch.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@fmwtestnode admin]$ tnsping fmwdb

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 29-JUL-2011 18:26:40

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/u01/app//product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = fmwdb.apac.bosch.com)))
OK (30 msec)

2) Please do below step in Database side,If you are installing all the Oracle Fusion Middleware products,For SOA installation alone setting open_cursors=300,but as we are installating all the Oracle Fusion middleware products we need to set open_cursors=1000.

Conn “/as sysdba” in Database.

SQL> alter system set open_cursors=1000;

System altered.

SQL> show parameter open_cursors

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000

Now it is time to set up the database schema.
Note: If we have installed SOA 11g before and you are not upgrading, you must drop your existing database schema before reinstalling or create a second schema for this installation. We cannot reuse an existing schema.

Configure Schema using RCU
Now create the new schema.

Give the ownership and permission to ‘oracle’ user to run the repository creation utility.

[root@fmwtestnode /]# chown oracle:oinstall /Reposit_create_soft/
[root@fmwtestnode /]# chmod -R 755 /Reposit_create_soft/

[root@fmwtestnode Reposit_create_soft]# su - oracle
[oracle@fmwtestnode ~]$ pwd
/home/oracle
[oracle@fmwtestnode ~]$ cd /Reposit_create_soft/
[oracle@fmwtestnode Reposit_create_soft]$ ls -altr
total 389240
-rwxr-xr-x 1 root root 398173821 Jul 26 18:53 ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip
drwxr-xr-x 2 oracle oinstall 4096 Jul 27 10:36 .
drwxr-xr-x 37 root root 4096 Jul 28 10:26 ..
[oracle@fmwtestnode Reposit_create_soft]$ unzip ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip

[oracle@fmwtestnode /]$ cd Reposit_create_soft/
[oracle@fmwtestnode Reposit_create_soft]$ ls -altr
total 389244
drwxr-xr-x 32 oracle oinstall 4096 Apr 26 05:04 rcuHome
-rwxr-xr-x 1 root root 398173821 Jul 26 18:53 ofm_rcu_linux_11.1.1.5.0_disk1_1of1.zip
drwxr-xr-x 37 root root 4096 Jul 28 10:26 ..
drwxr-xr-x 3 oracle oinstall 4096 Jul 28 11:41 .
[oracle@fmwtestnode Reposit_create_soft]$ cd rcuHome/
[oracle@fmwtestnode rcuHome]$ ls
assistants common inventory jdk lib nls oraInst.loc plsql rcu relnotes sqlplus xdk
BC4J css javavm jlib modules oracleRoot.sh owm portal rdbms root.sh srvm
bin instantclient jdbc ldap network oracore perl precomp readme.htm sqlj util
[oracle@fmwtestnode rcuHome]$ cd bin


Go to path ‘/Reposit_create_soft_/rcuHome/bin’ as seen in the screenshot.

$ export Display

On Linux(UNIX):
./rcu

Give all the permission to the ‘rcu’ file to launch the installation:

Note: During installation, give the details of the Oracle database created in step 2, select all the SOA schemas to install and select default settings for all other options during the installtion.

Login as ‘root’ user:
#xhost +
To set display correctly and for avoiding java related errors:


$./rcu =>For installing repository Creation Utility.



On the welcome screen, click Next
Select Create

Click Next
Enter the database information
Before that:
[oracle@fmwtestnode admin]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 29 18:19:44 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user sys identified by fmwsysdba;

User altered.


Enter the information as above.

Click Next

When complete, click OK. The utility moves to the next page – with a slight delay, just wait for it.

On the Select Components screen, enter DEV in the field for creating a new prefix.
Select the component SOA,DATA INTEGRATOR and BPM Infrastructure and all the components for our Oracle Fusion Middleware setup..
Dependent schemas are selected automatically.


Click Next
The pre-requisites for this step are checked.


Please do below step in Database side and click ok:

Conn “/as sysdba” in Database.

SQL> alter system set open_cursors=1000;

System altered.

SQL> show parameter open_cursors

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000

When completed, click OK



Select the radio button to Use the same password for all schemas.
Enter a schema password. The password welcome123 is assumed in this document, but we should choose your own secure password or a different one for each schema and be sure to record your passwords as you will need them later


Click Next

Accepting the defaults, click Next


When the pre-requisites for this step are completed, click OK

Click Create to create the tables. This takes about 60 minutes,as we are creating the repository
For all the fusion middleware products. ‘Portal’ repository creation take more than 30 minutes.

I took screenshots of this step:


COMPLETION SUMMARY :

When completed, click Close
Our Repository Creation for All fusion Middleware product is Completed…

4)Install SOA Suite 11g:


1. Download the software from here:
http://download.oracle.com/otn/nt/middleware/11g/ofm_soa_generic_11.1.1.5.0_disk1_1of1.zip
Also present in our shard drive:
\\bmh2fs01\bmhapp01_projects\Ebs1_Vss\DB_services\FMW\FMW_SOFTWARES\ORACLE_SOA_SUITE_INSTALL_SOFT

Once the schema has been created, you are ready to install the SOA server.
Login as ‘root’ user:

#xserver +
#xclock

Perform the following:
unzip ofm_soa_generic_11.1.1.5.0_disk1_1of2.zip

[root@fmwtestnode /]# cd SOA_SUITE_11g_soft/
[root@fmwtestnode SOA_SUITE_11g_soft]# unzip ofm_soa_generic_11.1.1.5.0_disk1_2of2.zip
[root@fmwtestnode SOA_SUITE_11g_soft]# ls
Disk1 Disk2 Disk3 Disk4 Disk5

Give 'Oracle' user ownership and permission to install Oracle SOA Suite software.
root@fmwtestnode /]#chown Oracle:ointall /SOA_SUITE_11g_soft/Disk*
Login as ‘oracle’ user and do the Oracle SOA software installation:

[oracle@fmwtestnode Disk1]# cd /SOA_SUITE_11g_soft/Disk1/
[oracle@fmwtestnode Disk1]# ls -altr
total 108
-rwxrwxr-x 1 root root 73728 Aug 21 2009 setup.exe
-rwxrwxr-x 1 root root 11460 Oct 28 2009 runInstaller
drwxrwxr-x 10 root root 4096 Nov 4 2009 install
drwxr-xr-x 5 root root 4096 Nov 4 2009 .
drwxrwxr-x 9 root root 4096 Nov 4 2009 doc
drwxr-xr-x 13 root root 4096 Nov 4 2009 stage
drwxr-xr-x 5 oracle oinstall 4096 Aug 1 13:59 ..

Login as ‘root’ user:
#xhost +
To set display correctly and for avoiding java related errors:

$./runInstaller -jreLoc /Middleware/SOASuite11gR1/jdk160_24


When the install wizard welcome screen comes up, click Next

Now ,All Prerequistics checks are passed…With no errors……..

Click Next


On the Specify Installation Location screen, select the Middleware home:
/Middleware/SOASuite11gR1/
Accept the default Oracle home: Oracle_SOA1

Click Next

I created one response file to see the installation flow,Before going for install.

Click Install

Thats it SOA Installation started Successfully,

click Next…
Very much happy to see below screen.Our Oracle SOA suite 11g installation finished successfully.

Click Finish………


Create the SOA domain:


1. Perform the following:
$cd /Middleware/SOASuite11gR1/Oracle_SOA1/common/bin
$./config.sh


Choose Extend to existing Weblogic domain
Click 'Next'



Select Generate a domain configured automatically to support the following products:
Check all to select all the products…
Domains

Click 'Next'


Name:weblogic
Pass:weblogic123


Click ‘Next’


Select the JRocket SDK as it will yield beter performance for Oracle SOA and leave Development Mode checked

Check 'Oracle SOA Suite - 11.1.5.0 [Oracle_SOA1]'
Check 'Oracle Enterprise Manager - 11.1.1.0 [oracle_common]'
Check 'Oracle Business Activity Monitoring - 11.1.5.0 [Oracle_SOA1]'
Click 'Next'
Click 'Next'
User password: welcome123
Confirm user password: welcome123
Click 'Next'
Click 'Next'
Check 'BAM Schema', 'SOA Infrastructure', 'User Messaging Service', 'OWSM MDS Schema', 'SOA MDS Schema'
DBMS/Service: orcl.ipnweb.com
Host Name: oradev.ipnweb.com
Schema Password: welcome1
Click 'Next'
Click 'Next'
Click 'Next'

Click 'Create'

If all are successful, click Next, otherwise click Previous and correct any errors.

Now you must choose whether to have your server run as a managed server or in a single server configuration.
As we have chosen the developer’s configuration, there will be one admin server and one managed server for BAM.
Don’t check any of the boxes here and click Next, unless you want to make changes to the default configuration

Click Next



This is the summary page for the Configuration. Click Extend to extend to the domain.
Wait for the create to finish – takes just a minute

Check the box to start the admin server and Click Done.

Add the machine entry:
We have to add the host entry in windows 'hosts' file.

Internet explorer settings:
Go to Tools=>Internet Options=>Connections=>LAN Settings and Uncheck Use automatic configuration script =>click ok =>click ok

Now access the Admin Server URL:

Admin Server URL:
http://fmwtestnode.apac.abc.com:7001

Note:We have to use compatible version of Oracle Repository creation utility and Oracle SOA i.e If rcu is 11.1.1.5.0 than use SOA also with the same version
11.1.1.5.0

Happy Oracle SOA learning...

Best regards,

Rafi.

Integrating APEX 4.0.2 with E-business Suite Release 12.1.1

This summary is not available. Please click here to view the post.