linuxrhel5下oracle10g102040升級102050操(編輯修改稿)
2025-07-16 14:13 本頁面
【文章內(nèi)容簡介】 tal Upgrade Time: 01:10:03DOCDOCDOCDOC The above PL/SQL lists the SERVER ponents in the upgradedDOC database, along with their current version and status.DOCDOC Please review the status and version columns and look forDOC any errors in the spool log file. If there are errors in the spoolDOC file, or any ponents are not VALID or not the current version,DOC consult the Oracle Database Upgrade Guide for troubleshootingDOC remendations.DOCDOC Next shutdown immediate, restart for normal operation, and thenDOC run to repile any invalid application objects.DOCDOCDOCSQL shutdown immediate。. 重編譯失效對象[oracle@TRH10g ~]$ sqlplus / as sysdba。SQL*Plus: Release Production on Wed Aug 28 14:22:16 2013Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.SQL @?/rdbms/admin/...PL/SQL procedure successfully pleted.. Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. GrantsPUBLICaccess to the synonyms.SQL @?/rdbms/admin/DOCDOCDOC The following statement will cause an ORA01722: invalid numberDOC error and terminate the SQLPLUS session if the user is not SYS.DOC Disconnect and reconnect with AS SYSDBA.DOCDOC...Synonym created.Grant succeeded.PL/SQL procedure successfully pleted. Runs all scripts required for or used with PL/SQL.SQL @?/rdbms/admin/DOCDOCDOC The following PL/SQL block will cause an ORA20000 error andDOC terminate the current SQLPLUS session if the user is not SYS.DOC Disconnect and reconnect with AS SYSDBA.DOCDOC...SQL BEGIN 2 (39。CATPROC39。, 3 (39。SYSTEM39。, 39。OUTLN39。, 39。DBSNMP39。))。 4 (39。CATPROC39。)。 5 。 6 。 7 END。 8 /PL/SQL procedure successfully pleted.SQL SQL SET SERVEROUTPUT OFF. 察看數(shù)據(jù)庫安裝的組件、版本、狀態(tài)SQL shutdown immediate。Database closed.Database dismounted.ORACLE instance shut down.SQL startup。ORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1267068 bytesVariable Size 180357764 bytesDatabase Buffers 100663296 bytesRedo Buffers 2924544 bytesDatabase mounted.Database opened.查看有無無效對象，有需要重新編譯SQLset linesize 500。SQLset pagesize 50。SQLcol object_name for a30。SQLselect owner,object_name,subobject_name,object_type,status from dba_objects where status39。VALID39。OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_TYPE STATUS OE ACCOUNT_MANAGERS VIEW INVALIDOE CUSTOMERS_VIEW VIEW
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1