This section provides suggested solutions for some common problems related to the use of Connection Manager. 11.2.1 CMAN Refuses to Start 11.2.1.1 Symptom You issue a CMCTL START command to start Connection Manager, and you receive the following messages: ADMIN Status: (STATUS=(VERSION=8.1.6.0.0)(STARTED=26-SEP-2000 10:27:37)(STATE=RUNNING)) Failed to start service, error 0. TNS-04002: CMCTL: error while starting the Connection Manager The Connection Manager Administrator (CMADMIN) has started, but the Connection Manager Gateway (CMGW) has not. 11.2.1.2 Possible solution The problem may lie in your cman.ora file. Check the number of parentheses in the address list entry for cman. If the address list can't be parsed because the syntax is incorrect, cman won't start and you'll get an error such as the one shown here. 11.2.2 CMADMIN Is Running and Cannot Be Stopped 11.2.2.1 Symptom The Connection Manager Administrator (CMADMIN) process is running by itself and won't shut down when you issue a CMCTL STOP command. 11.2.2.2 Possible solution There are two possible solutions for this problem. CMCTL STOP stops both CMADMIN and CMAN, but only if they are both running. If CMADMIN is running by itself, you should be able to stop it using the CMCTL STOP ADM command. If you are running on Windows NT, another solution is to go to the Services control panel, and stop the CMAdmin service. 11.2.3 You Have Hung Connections 11.2.3.1 Symptom Clients have connected via Connection Manager, and the Connection Manager instance has subsequently been aborted. The clients , of course, are no longer connected to the database instance, but their connections still show up when you query the V$CIRCUIT view. The sessions are "stuck." Because they count against the maximum number of sessions that you allow for a dispatcher, they are preventing other users from connecting. 11.2.3.2 Possible solution Check to see if you have enabled connection pooling. Look for (POOL = YES) in your MTS_DISPATCHERS parameter setting. Try setting (POOL = NO) and see if the problem goes away. When you use connection pooling (i.e., POOL = YES), you should use Oracle's resource limit features to reclaim idle client sessions. |