출처 : http://docs.oracle.com/cd/E11882_01/server.112/e10819/intro.htm#BHCHIAFE
번역 : TexasCowboy
If you have Oracle Database Standard Edition at a release earlier than the new Oracle Database 11g release, then you can change it to Oracle Database Enterprise Edition by installing Oracle Enterprise Edition software and subsequently following the normal upgrade procedures, as described in Chapter 3, "Upgrading to the New Release of Oracle Database.".
Caution:
Performing this procedure deinstalls the Standard Edition software and results in deleting database files that exist under the Oracle home. Therefore, you must back up any database files under the current Oracle home that you need to keep. This is explained in steps 4 and 5. Also refer to "Known Issue with the Deinstallation Tool for Release 11.2.0.4".
To change your existing Standard Edition database to an Enterprise Edition database
Ensure that the release number of your Standard Edition server
software is the same release as Enterprise Edition server software.
사용중인 스탠다드 에디션 릴리즈 번호와 설치하려는 엔터프라이즈 에디션 릴리즈 번호가 동일한지 확인해라. ( 동일하지 않으면 안된다. )
For example, if your Standard Edition server software is release
11.1.0.6, then you must upgrade to release 11.1.0.6 of Enterprise
Edition.
Shut down your database.
데이타베이스를 중지시킨다.
If your operating system is Windows, then stop all Oracle services, including the OracleService
SID
Oracle service, where SID
is the instance name.
윈도우 운영체제를 사용중이라면 OracleService
SID Oracle Service를 포함한
모든 오라클 서비스를 중지시켜야 한다.
Make a backup copy of files under $Oracle_Home/network/admin
. This ensures that the listener is configured after you complete the steps in this procedure.$Oracle_Home/network/admin 폴더 안에 백업
파일을 넣는다.
Back up all database files and data under the current Oracle home that you need to keep.
On Linux, back up $Oracle_Home/dbs/
.
On Windows, back up $Oracle_Home/database/
.
DB파일을 모두 백업한다.
Edit the orabase_cleanup.lst
file found in the Oracle_Home/utl
directory and remove the "oradata" and "admin" entries. Refer to "Deinstallation
of the Oracle home in the earlier release of Oracle Database may result
in the deletion of the old Oracle base that was associated with it".Oracle_Home/utl 디렉토리 안에있는
orabase_cleanup.lst 파일을 수정해서 oradata와 admin 부분을 지워준다.
Deinstall the Standard Edition server software.
Run the deinstall
tool from the Oracle home. The deinstall tool is located in the $ORACLE_HOME/deinstall
directory for UNIX platforms, and in the ORACLE_HOME\deinstall
directory for Windows platforms.
IMPORTANT:
The deinstall tool deletes all existing database files
that reside under Oracle home, including data in the database.
Therefore, Oracle recommends that you retain a current backup of your
data.
스탠다드 에디션을 deinstall한다.
Oracle Home디렉토리 안에 deinstall디렉토리가 있고 그 안에서 deinstall실행파일을 찾을 수 있을 것이다.
deinstall명령은 현존하는 Oracle Home밑의 모든 DB파일과 데이타를 삭제하므로 백업을 해두는 것이 좋을 것이다.
Install Enterprise Edition server software using Oracle Universal Installer (OUI).
Select the same Oracle home that was used for the Standard Edition
that you uninstalled. During the installation, be sure to select
Enterprise Edition. When prompted, choose Software Only from the
Database Configuration screen.
OUI를 이용해서 엔터프라이즈 에디션을 설치한다. 스탠다드 에디션이 사용했던 Oracle Home과 동일한 경로를 Oracle Home으로 지정한다.
Start up your database.
데이타베이스를 시작한다.
Your database is now upgraded to Enterprise Edition.
orabase_cleanup.lst
file found in the $Oracle_Home
/utl
directory and remove the "oradata
" and "admin
" entries. Then proceed with the deinstallation.[오라클/oracle] jstat - Java Virtual Machine Statistics Monitoring Tool ( JVM 통계 모니터링 툴 ) (0) | 2015.04.20 |
---|---|
[오라클/oracle] 테이블 파티션 ( oracle table partitioning ) (0) | 2015.04.20 |
[오라클/oracle] 버전 및 에디션 정보 확인 방법 (0) | 2015.04.20 |
[오라클/oracle] EXP-00091 Exporting questionable statistics (0) | 2015.04.20 |
[오라클/oracle] 계정 생성/삭제, 권한, 테이블스페이스 지정 (0) | 2015.04.20 |