When using an Oracle XE database for hosting a fusion web application along with SOA.
Install the Universal edition (as against the Western Europe) edition of Oracle XE. The universal edition uses UTF8 character set which is recommended for SOA.
Once the database is installed you will have to change certain init param parameters. If not done the installer will crib about it and it might also fail.
Connect to the db using SQLPlus.
See the current value of the parameters by executing the commands as shown in the picture.
Alter the values of the parameters by executing the two command shown below.
Stop and restart the database;
Connect to it with SQLPlus.
Execute the show commands to check whether the parameter changes have taken effect.
Now you are all set to run the RCU and install the schemas.
No comments:
Post a Comment