Question & Answer
Question
What do the Oracle error messages within IBM Rational Synergy mean, and how can they be resolved?
Answer
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. ORA-01017: invalid username/password 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. ORA-01004: default username feature not supported; logon denied 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_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: Oracle: ORA-03127: no new operations allowed until the active operation ends ORA-12545: Connect failed because target host or object does not exist 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*. ORA-01089: immediate shutdown in progress - no operations are permitted 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. fatal: $ORACLE_HOME/lib/libclntsh.so.9.0: wrong ELF class: ELFCLASS64 Killed 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. |
Historical Number TB247 |
Historical Number
TB247;KB8201
Was this topic helpful?
Document Information
Modified date:
22 December 2020
UID
swg21325758