Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Changing Character Set causes failure in EM UI Load.

Hello All
I am following this step to change the Oracle DB Character Set to UTF-8. However once I set this and restart the Oracle DB, The Enterprise Manager UI never comes up.
STEPS
Login to SQLPlus Client using SYS as SYSDBA.
To find Character set in Oracle DB.
SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';
To update Character set in Oracle.
Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';
To Commit changes.
commit;
To recycle Oracle DB for changes to take effect. SHUTDOWN.
SHUTDOWN IMMEDIATE.
To recycle Oracle DB for changes to take effect. STARTUP.
STARTUP
Now Open EM UI and access via a browser.
Error seen in browser.
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in a response. Please consult the application log for details.
NOTE : If I stop and start Oracle Database without making the UTF-8 query changes as suggested in our AM / RM documentation. Everything works fine. Hence it seems to me that when we make that change as per our needs, something cascading gets ruptured. Has anyone seen such an issue, when using Oracle as the Store.
Regards
Hubert
Answers
-
>Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';
Above renders null & void any support contract between you & Oracle.
I hope you have a good backup that was completed before your fatal modification.
-
-
See the strongly worded warning in Oracle Support Note "Changing Or Choosing the Database Character Set ( NLS_CHARACTERSET ) (Doc ID 225912.1)"
Hemant K Chitale
-
To update Character set in Oracle. Update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET' Or name = 'NLS_CHARACTERSET';
As stated, this is not supported - it will corrupt your database beyond repair. You will have to restore from a good backup taken before this statement was issued.
The supported methods are documented -
http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch11charsetmig.htm#NLSPG467