oracle 9i version patch


★★★★★ 엔진백업/데이터베이스 백업 필수임 ★★★★★

===============engine install=========================================

1. sql> shutdown immediate
2. c:\ lsnrctl stop
3. engine install

===============db patch===============================================

show parameter shared_pool_size
show parameter java_pool_size

alter system set shared_pool_size='150' scope=spfile;
alter system set java_pool_size='150' scope=spfile;


4. init parameter shared_pool_size, java_pool_size =150M 수정
5. sql> startup migrate
6. sql> show parameter shared_pool_size | java_pool_size => 확인
7. sql> spool catpatch.log
8. sql> @?/rdmbs/admin/catpatch.sql
9. sql> spool off
10. sql> startup
11. sql> spool utlrp.log
12. sql> @?/rdmbs/admin/utlrp.sql
13. sql> spool off
14. sql> shutdown immediate
15. init parameter shared_pool_size, java_pool_size => 원복
16. sql> startup
17. sql> select * from v$version;