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 […]
Monthly Archives: May 2007
Oracle XE Client Connection String
Oracle XE Client does not come with sqlnet therefore you need to connect to the database using a connection string. Oracle XE Connection String username/password@[//]host[:port][/service_name] port is required if the port number is not 1521. service_name defaults to XE.
Viewing Oracle Application Server JMS Queues
When developing BPEL and ESB applications it is necessary to see if the message you sent actually made it on the queue. Using Hermes is an excellent way to view an application server queues and topics. Problem Need to view messages on a JMS Queue or Topic that you have published a message to. […]
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 […]
Updating VMware Server Serial Number
How to update a linux VMware servers serial number from a windows VMware console. Get the serial number from http://www.vmware.com Open up the VMware Server Console on the windows machine and login to the linux server as root. Click on Help -> Enter Serial Number Enter all the information required.
Installing Cygwin for Windows XP
Instructions on how to install Cygwin on Windows XP, setup ssh and create a shortcut for rxvt. Pre-Install Download setup.exe from http://www.cygwin.com/ Install Run setup.exe The basic tools required are: openssh rxvt Other packages will also be installed in order to support these. Click Here to view a movie on how to do this. Post-Install Run cygwin. Click Here to […]
Setting up VMware Server on Linux
Instructions on how to setup VMware server on linux and access it from a windows machine. Pre-Setup Download VMware server rpm for Linux from http://www.vmware.com and register for a free serial number. The current version is 1.0.3. Setup access to the server. See Installing Cygwin for Windows XP for instructions on how to setup access to the linux server. […]
ORA-01033: ORACLE initialization or shutdown in progress
The Oracle database is in the process of initializing or shutting down. Typically this occurs when the database service is in the process of starting or stopping. Resolution Wait for the database service to start. If it does not start check the database alert.log to see what the underlying issue is.
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 […]