CN106484842A - A kind of method that oracle database changes character set - Google Patents
A kind of method that oracle database changes character set Download PDFInfo
- Publication number
- CN106484842A CN106484842A CN201610877034.8A CN201610877034A CN106484842A CN 106484842 A CN106484842 A CN 106484842A CN 201610877034 A CN201610877034 A CN 201610877034A CN 106484842 A CN106484842 A CN 106484842A
- Authority
- CN
- China
- Prior art keywords
- database
- character set
- sql
- oracle
- alter
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method that oracle database changes character set, belong to IT O＆M field, the present invention solves the problems, such as because of oracle database character set mistake, oracle database is built again with the workload of place increase and the working time wasting, and the technical scheme of employing is：Step is：（1）Completely close a node 1；（2）, operate in node 2, modification cluster_database parameter be false, become single example；（3）, on node 2 close data base, restart data base；（4）, order is executed respectively on node 2；（5）, restart starter node 1 after data base.
Description
Technical field
The present invention relates to a kind of IT O＆M field, specifically a kind of oracle database modification character set
Method.
Background technology
During IT O＆M, test development environment needs to build the substantial amounts of oracle database environment of deployment, often occurs
The problem that application information is inaccurate and leads to oracle database environment to repeat deployment, it is much unnecessary to bring to operation maintenance personnel
Repetitive operation, especially oracle database character set change problem bring to numerous O＆M engineers no small
Trouble, is generally intended to oracle database is built storehouse to complete again if necessary to change character set.So both increase
The workload of operation maintenance personnel has delayed the project cycle of test development personnel again.
Content of the invention
The technical assignment of the present invention is a kind of method providing oracle database to change character set, to solve because of Oracle
Database character set mistake and oracle database is built again place increase workload and waste working time problem.
The technical assignment of the present invention is realized in the following manner, a kind of method that oracle database changes character set,
Step is：
（1）Completely close a node 1；
（2）, operate in node 2, modification cluster_database parameter be false, become single example；
（3）, on node 2 close data base, restart data base；
（4）, order is executed respectively on node 2；
（5）, restart starter node 1 after data base.
Step（1）In, execute following code under oracle user：srvctl stop nodeapps -n name1；root
Following code is executed under user：crsctl stop crs （General depending on/opt/app/crs/bin/ is according to practical situation）.
Step（2）In, code is：SQL> alter system set cluster_database=false scope=
spfile.
Step（4）In, data base is started to and under RESTRICTED pattern, does character set change：
SQL> conn /as sysdba
Connected
SQL> shutdown immediate；
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup mount
ORACLE instance started
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION；
System altered
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0；
System altered
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0；
System altered
SQL> alter database open；
Database altered
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK；
ALTER DATABASE CHARACTER SET ZHS16GBK
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set.
Step（4）In, if run into prompting character set content being：Fresh character collection is necessary for the superset of old character set, now, jumps
The inspection crossing superset is altered：
SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK；
Database altered
SQL> select * from v$nls_parameters；
19 rows selected
SQL> alter system set cluster_database=true scope=spfile.
Step（5）In, code is：crsctl start crs（General in/opt/app/crs/bin/ according to actual feelings
Depending on condition）.
The method that a kind of oracle database of the present invention changes character set has advantages below：
1st, the present invention apply be directed to test development environment to Oracle character set urgent temporary changes and deployment Oracle
Before environment, character set selects mistake and needs the scene of urgent modification；
2nd, carry out oracle database character set modification using this method and do not need Oracle is built again storehouse operation decreasing work
Measure and save the time；
3rd, it is that emergent modification character set provides feasible method；
4th, easy to operate, application is easy, thus, have good value for applications.
Specific embodiment
The method changing character set to a kind of oracle database of the present invention with reference to specific embodiment is made in detail below
Explanation.
Embodiment：
The method that a kind of oracle database of the present invention changes character set, step is：
（1）Completely close a node 1；
（2）, operate in node 2, modification cluster_database parameter be false, become single example；
（3）, on node 2 close data base, restart data base；
（4）, order is executed respectively on node 2；
（5）, restart starter node 1 after data base.
Step（1）In, execute following code under oracle user：srvctl stop nodeapps -n name1；root
Following code is executed under user：crsctl stop crs （General depending on/opt/app/crs/bin/ is according to practical situation）.
Step（2）In, code is：SQL> alter system set cluster_database=false scope=
spfile.
Step（4）In, data base is started to and under RESTRICTED pattern, does character set change：
SQL> conn /as sysdba
Connected
SQL> shutdown immediate；
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup mount
ORACLE instance started
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION；
System altered
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0；
System altered
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0；
System altered
SQL> alter database open；
Database altered
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK；
ALTER DATABASE CHARACTER SET ZHS16GBK
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set.
Step（4）In, if run into prompting character set content being：Fresh character collection is necessary for the superset of old character set, now, jumps
The inspection crossing superset is altered：
SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK；
Database altered
SQL> select * from v$nls_parameters；
19 rows selected
SQL> alter system set cluster_database=true scope=spfile.
Step（5）In, code is：crsctl start crs（General in/opt/app/crs/bin/ according to actual feelings
Depending on condition）.
By specific embodiment above, described those skilled in the art can readily realize the present invention.But should
Work as understanding, the present invention is not limited to above-mentioned specific embodiment.On the basis of disclosed embodiment, described technical field
Technical staff can the different technical characteristic of combination in any, thus realizing different technical schemes.
In addition to technical characteristic described in except description, it is the known technology of those skilled in the art.
Claims (6)
1. a kind of oracle database changes the method for character set it is characterised in that step is：
（1）Completely close a node 1；
（2）, operate in node 2, modification cluster_database parameter be false, become single example；
（3）, on node 2 close data base, restart data base；
（4）, order is executed respectively on node 2；
（5）, restart starter node 1 after data base.
2. a kind of oracle database according to claim 1 changes the method for character set it is characterised in that step（1）
In, execute following code under oracle user：srvctl stop nodeapps -n name1；Under root user, execution is as follows
Code：crsctl stop crs.
3. a kind of oracle database according to claim 1 changes the method for character set it is characterised in that step（2）
In, code is：SQL> alter system set cluster_database=false scope=spfile.
4. a kind of oracle database according to claim 1 changes the method for character set it is characterised in that step（4）
In, data base is started to and under RESTRICTED pattern, does character set change：
SQL> conn /as sysdba
Connected
SQL> shutdown immediate；
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup mount
ORACLE instance started
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION；
System altered
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0；
System altered
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0；
System altered
SQL> alter database open；
Database altered
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK；
ALTER DATABASE CHARACTER SET ZHS16GBK
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set.
5. a kind of oracle database according to claim 1 changes the method for character set it is characterised in that step（4）
In, if run into prompting character set content being：Fresh character collection is necessary for the superset of old character set, and now, the inspection skipping superset is done
Change：
SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK；
Database altered
SQL> select * from v$nls_parameters；
19 rows selected
SQL> alter system set cluster_database=true scope=spfile.
6. a kind of oracle database according to claim 1 changes the method for character set it is characterised in that step（5）
In, code is：crsctl start crs.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610877034.8A CN106484842A (en) | 2016-09-29 | 2016-09-29 | A kind of method that oracle database changes character set |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610877034.8A CN106484842A (en) | 2016-09-29 | 2016-09-29 | A kind of method that oracle database changes character set |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106484842A true CN106484842A (en) | 2017-03-08 |
Family
ID=58269137
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610877034.8A Pending CN106484842A (en) | 2016-09-29 | 2016-09-29 | A kind of method that oracle database changes character set |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106484842A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130132345A1 (en) * | 2011-06-06 | 2013-05-23 | Sybase, Inc. | Replication Support For Heterogeneous Data Types |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool for migrating from AIX platform to K-UX platform |
| CN105138603A (en) * | 2015-08-07 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool for migrating from HPUX platform to KUX platform |
-
2016
- 2016-09-29 CN CN201610877034.8A patent/CN106484842A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130132345A1 (en) * | 2011-06-06 | 2013-05-23 | Sybase, Inc. | Replication Support For Heterogeneous Data Types |
| CN104573122A (en) * | 2015-02-09 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool for migrating from AIX platform to K-UX platform |
| CN105138603A (en) * | 2015-08-07 | 2015-12-09 | 浪潮电子信息产业股份有限公司 | Oracle database migration tool for migrating from HPUX platform to KUX platform |
Non-Patent Citations (2)
| Title |
|---|
| HANK、YOON: "oracle 11g rac 修改字符集", 《HTTPS://WWW.BBSMAX.COM/A/PRDBZWL9DN/》 * |
| ITEYE_8917: "oracle 查看、修改字符集编码", 《HTTPS://BLOG.CSDN.NET/ITEYE_8917/ARTICLE/DETAILS/82030790》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109299150B (en) | Configurable multi-data-source adaptation rule engine solution method | |
| CA2856308C (en) | Program flow control monitoring routines, related methods and systems | |
| JP2016164775A (en) | Field device commissioning system and method | |
| CN110427204A (en) | A kind of automation gray scale dissemination method based on container and service grid | |
| CN102368216A (en) | Process implementation method based on automatic project building | |
| CN105404966A (en) | Construction method of construction process quality color rendering module based on BIM | |
| CN107861392A (en) | The data management platform and method of a kind of intelligent appliance | |
| CN103605814B (en) | Information processing method and information processing system in substation transformation process | |
| CN109656607A (en) | A kind of full address scaling method that supporting super large nominal data amount and system | |
| CN104199433A (en) | Centralized controlling auxiliary pre-warning system in heat-engine plant | |
| CN102984737A (en) | Unified parameter configuration method and device for wireless network | |
| CN101615815A (en) | Collocation method to different acquisition units parameter reorganization demonstration in the electric power monitoring system | |
| US9304963B2 (en) | Data table structure for self-organized management of communication with functional modules coupled via backplane assembly based on received module description including control logic | |
| CN103458045B (en) | Dynamic deployment method and system of distributed cluster | |
| CN103412775A (en) | Method for refreshing BMC firmware intelligently and automatically | |
| CN106294852A (en) | A kind of method that monitors for a long time to storage data | |
| CN106484842A (en) | A kind of method that oracle database changes character set | |
| CN105320785B (en) | A kind of operating mode automatic Generation and device calculated for load of wind turbine generator | |
| WO2024078191A1 (en) | Load setting method, apparatus and system | |
| CN105179156A (en) | Offline control program testing system and method of pump storage group | |
| CN105265034A (en) | Feeder and mounter | |
| CN107726552B (en) | A kind of matching process of general-purpose line control machine | |
| CN100596126C (en) | A wireless packet domain gateway performance self-adapting method and device | |
| CN107729184B (en) | System component service self-healing method | |
| CN105359462B (en) | The method and apparatus that test SDN builds new flow velocity rate |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170308 |
|
| WD01 | Invention patent application deemed withdrawn after publication |