Understanding Oracle error messages within IBM Rational Synergy

Overview

This document details the most common Oracle error messages, common operations when the errors occur, and possible solutions to resolving the problem from within Rational Synergy. The following error code message information is based on actual past customer calls to Technical Support staff.

Detail

Error Message Codes:

ORA-27101: shared memory realm does not exist

Operation: Running ccmdb check, ccmdb backup, ccmdb pack, ccmdb dump


Solution: Verify that the ORACLE_HOME setting in the <dbpath>db/DBINFO file is correct. For example. If you patched the oracle instance this might have changed. Also verify that the environment variable ORACLE_SID is set correctly.

Operation: Trying to start a CMSynergy session
Operation: Runing 'ccmsrv status', 'ccmdb delete', 'ccmdb drop'.

Solution: Check that you really are entering the correct username and password. If the session starts successfully for the 'ccm_root' user, the issue may be with the permissions/ownership of the engine executable $CCM_HOME/bin/ccm_eng_ora. Run 'ccm_install -c' as user root to correct these, or check them manually as follows:

Solaris: Owner must be root, with sticky bit set: rwsr-sr-x.

HPUX: Owner is ccm_root, with sticky bit set: -rwsr-sr-x

Verify also that the filesystem where Synergy is installed is mounted with the 'suid' option (as opposed to 'nosuid'). Look at the output of 'mount' and you should see all the mount options listed.


If database authentication is in use and the password of the ccm_root account in Oracle has recently been changed, reset it in Synergy by running the 'ccmdb auth -d' command.

Operation: Trying to start a Synergy session


Solution: In 6.3 you must enable remote authentication even if the engine and informix database are on the same box, i.e. is not remote. It is planned to change this requirement in 6.4 but the solution is still relevant for non-local engines. in other words. where the engine is not running on the oracle server.




To enable remote authentication, set the following initialisation parameters for the oracle instance:



REMOTE_OS_AUTHENT to TRUE
REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE
OS_AUTHENT_PREFIX to OPS$

Operation: Trying to start a Synergy session
Operation: Running ccmdb upgrade


Solution: The full error text is generally:



Warning: The value of the 'active_model' attribute on the admin component version, ba, is not a model in this database.

Warning: Oracle: ORA-03127: no new operations allowed until the active operation ends


It occurs when the CHARACTER SET and/or the NATIONAL CHARACTER SET are set to a unicode character set, for example, UTF8. This is not supported. Changing them to WE8MSWIN1252 should solve the problem.

Operation: Any ccmdb* command


Solution: This can occur when you attempt to run the ccmdb* commands on a machine other than the Oracle Database Server. The ccmdb commands must be run on the Oracle Server. Remote usage is not currently supported. Note, the ccm* command may be run remotely (except the object registrar daemon, which must run on the Oracle Server),  the restriction only applies to the database administration commands, ccmdb*.

Operation: Running any ccm* or ccmdb* command.


Solution: This error has been most commonly seen during scheduled ccmdb check or ccmdb backup commands.  It occurs when the Synergy backup schedule clashes with Oracle maintenance activities.  To check/backup the databases, Synergy must have full access to the Oracle database.  The jobs need to be rescheduled so that they do not clash. 

Operation: Running any ccmsrv* or ccmdb* command.


Solution: Run "ccm_install -l" to ensure that the necessary links are created. If the environment variables SH_LIBPATH and LD_LIBRARY_PATH are set, ensure that they include $ORACLE_HOME/lib32. Because SYNERGY is a 32 bit application, it must be able to access the 32 bit libraries.