{"id":151,"date":"2008-10-03T23:07:00","date_gmt":"2008-10-03T21:07:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2008\/10\/03\/oracle-upgrade\/"},"modified":"2010-08-24T22:44:07","modified_gmt":"2010-08-24T20:44:07","slug":"oracle-upgrade","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2008\/10\/03\/oracle-upgrade\/","title":{"rendered":"ORACLE UPGRADE"},"content":{"rendered":"<\/p>\n

podstawowa procedura upgarade dla wersji 10:<\/span><\/p>\n

1. przeczyta\u0107 dokument README.html
2. sprawdzi\u0107 System Requirements
3. ustawi\u0107 zmienn\u0105 systemow\u0105 $ORACLE_HOME
4. wy\u0142\u0105czy\u0107 wszystkie us\u0142ugi bazy
5. zainstalowa\u0107 patcha na binaria bazy (modyfikuje,dodaje tylko pliki binarne w $ORACLE_HOME)
6. wykona\u0107 skrypt sprawdzaj\u0105cy baz\u0119 danych:<\/p>\n

STARTUP UPGRADE
SPOOL preupgrade_check.log
@$ORACLE_HOME\/rdbms\/admin\/utlu102i.sql
SPOOL OFF<\/div>\n

7. sprawdzi\u0107 spool i zweryfikowa\u0107, po ewentualnej korekcie wykon\u0105\u0107 skrypt ponownie
8. wykona\u0107 upgrade bazy danych (modyfikuje obiekty w przestrzeni SYSTEM)<\/p>\n

STARTUP UPGRADE
SPOOL patch.log
@$ORACLE_HOME\/rdbms\/admin\/catupgrd.sql
SPOOL OFF<\/div>\n

9. wy\u0142\u0105czy\u0107 baz\u0119:<\/p>\n

SHUTDOWN IMMEDIATE<\/div>\n

10. uruchomi\u0107 baz\u0119 i skompilowa\u0107 pakiety:<\/p>\n

STARTUP
@$ORACLE_HOME\/rdbms\/admin\/utlrp.sql<\/div>\n

11.sprawdzi\u0107 komponenty po upgrade:<\/p>\n

SELECT comp_name,version,status FROM sys.dba_registry;<\/div>\n

OG\u00d3LNE:<\/span>
catupgrd.sql – wykonuje skrypty do upgrade, kt\u00f3re to z kolei tworz\u0105 i zmieniaj\u0105 tabele s\u0142ownikowe, widoki, typy, pakiety etc.,
czas upgrade poszczeg\u00f3lnych komponent\u00f3w:<\/p>\n

SELECT * FROM registry$log;<\/div>\n
podstawowa procedura upgarade dla wersji 9:<\/span>
przeczyta\u0107 dokument README.html
sprawdzi\u0107 System Requirements<\/p>\n

ALTER SYSTEM SET java_pool_size=150M scope=spfile
ALTER SYSTEM SET shared_pool_size =150M scope=spfile
wy\u0142\u0105czy\u0107 wszystkie us\u0142ugi bazy
zainstalowa\u0107 patcha na binaria bazy

<\/span>upgrade zainstalowanej bazy<\/p>\n

    \n
  • sqlplus \/nolog<\/li>\n
  • sql> STARTUP MIGRATE<\/li>\n
  • sql> SPOOL PATCH.LOG<\/li>\n
  • sql> @$ORACLE_HOME\/rdbms\/admin\/catpatch.sql<\/li>\n
  • sql> SPOOL OFF<\/li>\n<\/ul>\n

    zrestartowa\u0107 baz\u0119
    w razie problem\u00f3w naprawi\u0107 i wykona\u0107 ponownie
    wykona\u0107 plik do kompilacji pakiet\u00f3w<\/p>\n

      \n
    • sql> @$ORACLE_HOME\/rdbms\/admin\/utlrp.sql<\/li>\n<\/ul>\n

      sprawdzanie patchy:<\/span>
      @$ORACLE_HOME\/opatch\/opatch lsinventory
      @$ORACLE_HOME\/opatch\/opatch lsinventory -detail<\/div>\n","protected":false},"excerpt":{"rendered":"

      podstawowa procedura upgarade dla wersji 10: 1. przeczyta\u0107 dokument README.html2. sprawdzi\u0107 System Requirements3. ustawi\u0107 zmienn\u0105 systemow\u0105 $ORACLE_HOME4. wy\u0142\u0105czy\u0107 wszystkie us\u0142ugi bazy5. zainstalowa\u0107 patcha na binaria bazy (modyfikuje,dodaje tylko pliki binarne w $ORACLE_HOME)6. wykona\u0107 skrypt sprawdzaj\u0105cy baz\u0119 danych: STARTUP UPGRADESPOOL preupgrade_check.log@$ORACLE_HOME\/rdbms\/admin\/utlu102i.sqlSPOOL OFF 7. sprawdzi\u0107 spool i zweryfikowa\u0107, po ewentualnej korekcie wykon\u0105\u0107 skrypt ponownie8. wykona\u0107 upgrade bazy […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[69],"class_list":["post-151","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-upgrade"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=151"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/151\/revisions"}],"predecessor-version":[{"id":207,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/151\/revisions\/207"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}