如何更改ERP數據庫字符集－sys用戶根本無法登陸

ityilong

在網上找了以些相關的文檔，發現ERP的sys用戶根本無法登陸，所以搞不成功，不知道那位還有其他的方法，我向改成UTF8的，我裝的時候沒有在意，結果輸入漢字就成了？？了


用sys用户登录sqlplus，执行
update props$ set value$='UTF8' where name='NLS_CHARACTERSET';
然后重新启动数据库
切记，修改完了一定要重起数据库！

附ORACLE文檔：

主题:	Oracle Applications NLS Release Notes, Release 11i (11.5.10.2)
	文档 ID:	注释:316804.1	类型:	README
	上次修订日期:	29-JUL-2005	状态:	PUBLISHED

Oracle® Applications NLS Release Notes Release 11i (11.5.10.2) Part No. B19302-01

Copyright © 2000, 2005.  Oracle. All rights reserved.
Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Oracle® Applications NLS Release Notes
Release 11i (11.5.10.2)
Part No. B19302-01
July 2005
Click here to access the PDF version of this document.PDF version of this document.
These release notes update and supplement Installing Oracle Applications and Upgrading Oracle Applications with information specific to National Language Support (NLS) installations. You should use both this document and the appropriate manual when you install or upgrade Oracle Applications NLS systems.
The Oracle Applications Release Notes also contain important information about your installation or upgrade. You must read and perform the tasks in both documents. Check OracleMetaLink for the most current copy before you begin to install translated software.

Additional Information: See the following OracleMetaLink documents for more information: Oracle Applications Translation Scope and Availability (Doc ID: 185637.1).

1 Documentation Accessibility Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/Accessibility of Code Examples in Documentation JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
2 Prerequisite Patches for All Customers None at this time.
3 Determining Which NLS Software to Use To determine the appropriate NLS software for installing translated languages in your system, refer to the instructions in the following table. You must repeat the instructions for each non-English language you install.
If you plan to...
Follow these instruction...
Install language(s) other than American English in a Release 11.5.10.2 system
Use the Oracle Applications Release 11.5.10.2 NLS software, and follow the instructions in this document.
Upgrade existing language(s) in a Release 10.7 or 11.0 system during an upgrade to 11.5.10.2
Use the Oracle Applications Release 11.5.10.2 NLS software, and follow the instructions in this document.
Upgrade existing language(s) in any Release 11i system during an upgrade to 11.5.10.2
Follow the instructions in the Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions to upgrade both US and NLS software.


4 Installing Translations Translations can be installed in two ways: during a new installation using Rapid Install or by using AutoPatch. This section contains installation steps for each method. Use the following table to decide which method best suits your needs, then go to that section and complete the instructions.
If you...
Follow the instructions in this section...
Chose additional languages in the Rapid wizard, and want to complete the NLS software installation for those languages.
Installing Translations Using Rapid Install
Are upgrading a 10.7 or 11.0 system with existing active languages and want to complete the upgrade of the existing languages to 11.5.10.2.
Installing Translations Using Rapid Install
Have already upgraded to 11.5.10.2 and want to install and register a new language.
Installing Translations Using AutoPatch


4.1 Installing Translations Using Rapid Install Using Rapid Install to create a new, first-time Oracle Applications system installs the language files for each additional non-American English language you indicate on the Select Additional Languages screen in the Rapid Install wizard. These languages are automatically registered as active in your system.
Similarly, during an upgrade of an existing Release 10.7 or 11.0 system, Rapid Install recognizes and installs the files for all non-American English languages that are currently registered as active in your existing database.
After Rapid Install has completed the installation or upgrade process, follow the steps in this section to finish installing the non-American English language(s).

Caution: If you have registered languages between releases with the OAM License Manager, these steps do not apply. Instead, follow the instructions in the next section Installing Translations Using AutoPatch.

1.
Update multilingual tables.
To update all multilingual tables in your system, go to the AD Administration main menu, and choose the Maintain Applications Database Entities submenu. Then, run the Maintain Multi-lingual Tables task. See Chapter 4 in Oracle Applications Maintenance Utilities for more information about running tasks in AD Administration.
2.
Apply language patch driver for each active language.
Applying a patch driver loads seed data translations into the database and compiles all the translated files needed at runtime.
Complete only the set of steps that applies to your Release 11.5.10 system.
For new 11.5.10.2 systems with additional languages:
If you have completed the installation of a new Release 11.5.10.2 Oracle Applications system, use AutoPatch with the nocopyportion option to apply u11510nls.drv for each active language. It is located in the $AU_TOP/admin/driver/<LANG> directory. For example:
cd $AU_TOP/admin/driver/<LANG>adpatch options=nocopyportion For 10.7 or 11.0 systems with existing languages upgraded to 11.5.10.2:
If you have successfully upgraded your system using Rapid Install 11.5.10.2, use AutoPatch with the nocopyportion option to apply u11510upgnls.drv for each active language. It is located in $AU_TOP/admin/driver/<LANG>. For example:
cd $AU_TOP/admin/driver/<LANG>adpatch options=nocopyportion Perform this step for each language that is registered as active in your system. If you have a multi-node system, see Applying Patches to a Multi-Node System in Oracle Applications Maintenance Procedures. For complete information about AutoPatch, see Oracle Applications Maintenance Utilities.
3.
Complete the post-install tasks.
The Post-install Tasks contain instructions for finishing the language installations.
4.2 Installing Translations Using AutoPatch To install a new language in an existing system, regardless of whether it is a newly created Release 11.5.10.2 system or an existing system you have just upgraded to 11.5.10.2, you must apply each language using the language software and AutoPatch.
Complete the following steps in the order listed.
1.
Change language configuration.
Use the Oracle Applications Manager (OAM) License Manager tool to change the language configuration or activate a new language in an existing system. See Registering Languages in Oracle Applications Maintenance Procedures for more information.
Note that the language you add must be supported by the current character set in your system.
2.
Update multilingual tables.
To update all multilingual tables in your system, go to the AD Administration main menu, and choose the Maintain Applications Database Entities submenu. Then, run the Maintain Multi-lingual Tables task. See Chapter 4 in Oracle Applications Maintenance Utilities for more information about running tasks in AD Administration.
3.
Create language patch area(s).
Complete the following steps to create a language patch area:
·
Choose a directory that contains enough space for the NLS updates (about 10 GB for each language).
·
Create a subdirectory called nls11i10 in this directory. This subdirectory is the <NLS_update_directory>.
·
Mount the NLS DVD software or copy the NLS DVD to a permanent file system. This is the <NLS_media_location>.
·
Populate the <NLS_update_directory> as follows:
UNIX:
$ cd <NLS_media_location>/Disk1/nls/stage$ ./adcrptop.sh <NLS_update_directory> \     <NLS_media_location>/Disk1/nls/stage For example, to unload the Portuguese software from DVD to /d1/oracle/patch/nls11i10:
$ cd /mnt/Disk1/nls/stage$ ./adcrptop.sh /d1/oracle/patch/nls11i10 /mnt/Disk1/nls/stage Windows:
C:/> cd <NLS_media_location>C:/> adcrptop.cmd <NLS_update_directory> \      <NLS_media_location>\Disk1\nls\stage For example, to unload the Portuguese software from DVD (E:\) to d:\oracle\patch\nls11i10:
C:/> cd e:\Disk1\nls\stageE:/> adcrptop.cmd d:\oracle\patch\nls11i10 \      e:\Disk1\nls\stage

Note: You can perform this step while the Maintain Multi-lingual Tables task in Step 2 is running.

Additional Information: For more information about copying DVDs during an installation, see Set Up the Stage Area in Chapter 1 of Installing Oracle Applications.

1.
Install the translations.
Each language directory in the patch area you created in Step 3 will contain two drivers:
u11510nls.drv – for a newly created Rapid Install 11.5.10.2 system
u11510upgnls.drv – for all other systems, including any type of upgrade.
Run AutoPatch and specify the appropriate driver. Repeat for each new language.
If you are installing multiple languages, you have the option of merging the drivers for all languages and running AutoPatch once.
For each language patch area, determine the appropriate driver for your system and delete the driver you will not use. Then, use AD Merge Patch to merge all language patch areas.
Run AutoPatch and specify the merged language driver, when prompted.

Additional Information: See Applying Multiple Patches to an NLS Installation in Chapter 3 of Oracle Applications Maintenance Procedures.

2.
Complete the post-install tasks.
The Post-install Tasks section contain instructions for finishing the language installations.
5 Post-install Tasks After you install translations, complete the following tasks to finish the installation.
5.1 Install Font Files For dynamic image generation, font files are required on the Web server (Oracle HTTP server, powered by Apache) to support the active Applications languages. Unicode font files are shipped with Oracle Applications, and should be installed if either of the following conditions applies to your installation:
·
Multiple languages from different native character sets are active
·
The operating system of the node that contains the Web server is not configured with the required language support for the active languages
If you require the font files, refer to Install Oracle Unicode Fonts for Dynamic Image Generation in Oracle Applications on OracleMetaLink.
5.2 Restart the Apache Service On the node that contains the Web server, restart the Apache service to enable the new languages on the login page.
UNIX:
$ cd <COMMON_TOP>/admin/scripts/<SID>_<node_name>$ adapcctl.sh stop$ adapcctl.sh start Windows:
C:\> cd <COMMON_TOP>\admin\scripts\<SID>_<node_name>C:\> adapcctl.sh stopC:\> adapcctl.sh start5.3 Install Online Help The latest consolidated American English online help patch is 3275245. Refer to OracleMetaLink (Doc ID: 185637.1) for the translation scope and availability of this patch.
For each language that has an online help patch, unzip the patch to a temporary location on the node that contains the core AD directories (admin, ad, au, and fnd — also known as the administration server). Follow the directions in the readme.txt file. You do not have to require users to log off the system to perform this task.
6 Special Instructions The instructions in this section apply only to the customers indicated in the boldface headings.
6.1 Customers Using Hebrew or Arabic Translations Note the following information:
For Hebrew translations only:
You cannot use the Hebrew ISO character set IW8ISO8859P8 on the application tier servers. All other character sets supported by Oracle can be used (for example UTF8 or IW8MSWIN1255). You can use any character set that Oracle supports on the database tier (including the ISO character sets).
For both Hebrew and Arabic translations:
Use the PASTA utility (FNDPSTAX) for printing. For more information, see Chapter 6 in Oracle Applications System Administrator's Guide.
6.2 Customers Who Changed Base Language to American English You must update the seed data in the non-multilingual tables to American English. If you do not, the data remains in the old base language.
Copy usbase.zip from any Oracle Applications Release 11i language software to the patch directory and unzip it. Using AutoPatch, apply the u11510us.drv driver (located in the US directory) to update the base language seed data. Apply the driver only on the node that contains the AD core technology directories (also known as the administration server).

Caution: Perform this step only if you previously had a non-American English base language and have changed it to American English. Applying this patch under any other circumstance will cause the loss of translated seed data.

7 Current Revisions Log The following sections were changed in the Oracle Applications NLS Release Notes, Release 11i (11.5.10.2).
Section Heading
Summary of Changes
29 July 2005

Initial Release of 11.5.10.2










character set for UFT8
update sys.props$
set value$ = 'UTF8' where name = ''NLS_NCHAR_CHARACTERSET''

$ sqlplus ‘/ as sysdba’
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT EXCLUSIVE;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE NATIONAL CHARACTER SET UTF8;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;

if error messge occured as the following show
ORA-12717: Cannot ALTER DATABASE NATIONAL CHARACTER SET when NCLOB data exists
use the folloing command

$ sqlplus ‘/ as sysdba’
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT EXCLUSIVE;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE UTF8;
SQL> SHUTDOWN IMMED

jessie

不是说字符集一般不能改吗? 不知道这个.
有人 发过专门讲字符集的帖子,你看一下.

jojoz

Alter database character set zhs16gbk

jessie

有那么简单就改了吗?

jojoz

可参考这个贴子
http://www.eygle.com/archives/2004/09/nls_character_set_03.html