Monday, July 18, 2011

Tuesday, June 28, 2011

ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errors

After installing oracle SOA Suite 11.1.1.5 on Oracle XE I was getting the following issue
ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DEV_MDS.MDS_INTERNAL_SHREDDED"
ORA-06512: at line 1
 and the the soa server was not coming up.I followed the following steps and was able to run the server successfully.
  • Drop the SOA Schemas using the rcu.  
  • Connected to the  XE database server using the following steps and ran the following commands.
sqlpus
show parameter processes
by default “processes” should be 40. We should make it 300:
alter system set processes=300 scope=spfile;
conn / as sysdba
shutdown immediate
startup
conn / as sysdba
show parameter sga
alter system set sga_target=350M scope=spfile;
alter system set sga_max_size=350M scope=spfile;
shutdown immediate
startup

After fixing the above parameters.Set the following environmental variable and than run rcu.bat.
set RCU_JDBC_TRIM_BLOCKS=TRUE in the command prompt.
run rcu.bat from the command prompt.


Wednesday, May 25, 2011

Upgrading SOA Suite 11.1.1.4 to 11.1.1.5

Oracle has released the Oracle SOA Suite 11.1.1.5 and weblogic server 10.3.5.To Upgrade the SOA Suite from 11.1.1.4 to 11.1.1.5 follow the previous post of Upgrading WebLogic Server 10.3.4 to 10.3.5 and Upgrading Oracle SOA Suite 11.1.1.4 to 11.1.1.5.

Download the patch number 12395560 from support.oracle.com to upgrade to weblogic server 10.3.5.
Other softwares can be downloaded from the following link

http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html









Monday, April 11, 2011

Installing AIA Foundation Pack 11.1.1.4


PreRequisites for installing AIA Foundation Pack 11.1.1.4
  • Oracle SOA Suite 11.1.1.4.0
  • JDeveloper 11.1.1.4.0
  • AIA Foundation Pack Service Constructor for JDeveloper 11.1.1.4.0
    This extension creates Application Integration Architecture (AIA) Service Constructor to create an AIA based service component project. This extension is an online JDeveloper update. Start JDeveloper. From the menu choose Help > Check for Updates. In the Update Wizard, select Search Update Centers and ensure the first and second options are checked . Then ensure that Oracle AIA Foundation Pack Service Constructor is checked.
AIA Foundation Pack 11.1.1.4 which can be downloaded from the following link
http://www.oracle.com/technetwork/middleware/foundation-pack/downloads/fpdownloads-152617.html

Optional Softwares
  • Oracle Enterprise Repository
  • Oracle Service Registry
  • Oracle Business Process Analysis Suite
Start the node manager .Than start the weblogic server.Than start your soa_server from the admin console using the node manager.For starting the soa_server using the admin console goto servers>control and than start the server.It is mandatory to start the soa_server using the node manager.Once the servers are running,run the Setup.exe for the foundation pack.
Enter the JDK path.







Click on next and your installation is complete.
Note: I have not installed Oracle Service Registry and Oracle Service Repository so have skipped those screens while installation.

JAVA CAPS 6.3 Released

Oracle has released the next version of JAVA CAPS i.e 6.3.More can be read about it at the following link.
http://download.oracle.com/docs/cd/E21454_01/html/821-2528/gfishesbiplan_intro.html





Saturday, April 2, 2011

Enterprise Planning for Oracle Fusion Middeware

Anyone interested in doing planning and implementation for Oracle Fusion Middleware can use the following link as a startup for doing so.


http://download.oracle.com/docs/cd/E12839_01/cross.htm

Wednesday, February 16, 2011

How to uninstall Jdeveloper 11g

  • Go to the Oracle_home\utils\uninstall folder.
  • Click on uninstall.exe
  • Follow the screens than