Oracle ESB Web Service Returns a

When sending information to a ESB Web Service a javax.xml.soap.SOAPException: Message send failed: Connection refused is returned. Problem If you try and access a ESB webservice on a webserver other than localhost and port 8888 the following error message is returned and the ESB flow is not run: javax.xml.soap.SOAPException: Message send failed: Connection […]

ORA-20603: Updating timezone region of a target is not supported

Enterprise manager does not start after updating the database. The emdb.nohup has an ORA-20603: Updating timezone region of a target is not supported error message in it. The problem The timezones have been updated within the database. Solution As Oracle run: $ORACLE_HOME/bin/emctl resetTZ agent and follow the instructions.  You’ll need the sysman or sys password […]

Changing JMS Connection Password in Oracle SOA Suite

By default the the password for eis/Jms/TopicConnectionFactory JMS Connection is welcome1. This needs to be changed if the oc4jadmin password is not set to this. Problem After creating an ESB process you are unable to write to a JMS topic.  The following error message is displayed in the ESB Console: The Adapter Framework was unable […]

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

The database trying to be connected to is not running. Ensure the Oracle database is running and that the TNS entry you are using is correct. Resolution Start the Oracle Database   Windows start the OracleServiceXE service. Linux login as oracle and run dbstart.   Test TNS To test TNS run tnsping on the command […]

Oracle XE Tuning

Oracle XE is an excellent starter database, but under normal loads the out of the box parameters need to be increased. Database Sessions Increase the number of sessions that the database can handle at one time.  This will allow for more users to access the database. sqlplus /nolog SQL> show parameters sessions SQL> alter system […]

Oracle XE Backup

After installing Oracle XE you should setup backups. Backups for XE For Oracle XE there is ready a backup script that uses Oracle’s RMAN.   Setup Archive Log Mode After installing the database change it to archivelog mode: [oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release – Production on Sun May 25 01:28:00 2008 Copyright (c) […]