Troubleshooting: Cannot connect to the Oracle 10.2.0.4 Enterprise Management console

Issue

You cannot connect to the Oracle 10.2.0.4 Enterprise Management console.

Details

You cannot connect to the Oracle 10.2.0.4 Enterprise Management console due to a National Language Set mismatch between the Enterprise Management console and the Oracle database. This problem is documented in Oracle bug BUG:7112829 - ORA-12705 IN EM CONSOLE.

When this problem occurs, the console displays an error message similar to the following:

2008-04-16 14:27:52,335 [HttpRequestHandler-21263661] ERROR 
conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. 
ERROR = ORA-604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

Solution

1. Change to the ORACLE_HOME/bin directory.

2. Make a backup copy of the emwd.pl file

3. Stop the dbconsole process.

4. Open the emwd.pl file.

5. Search for the following section of the file:

   sub getDBCConsoleLaunchCmd()

6. Locate the following text:

   return "$JAVA_HOME/bin/java -server -Xmx512M -XX:MaxPermSize=96m"

7. Replace the line you found in step 6 with the following

   return "$JAVA_HOME/bin/java -server -Xmx512M -XX:MaxPermSize=96m -Duser.language=en -Duser.country=US"

   Note: This line you replaced occurs twice in the emwd.pl file. Both occurrences must be changed.

8. Restart the dbconsole process.