DOC> messages reported with each object(using SHOW ERRORS) to see if they
DOC> point to system misconfigurationor resource constraints that must be
DOC> fixed before attempting torecompile these objects.
DOC>#
?
OBJECTS WITH ERRORS
-------------------
? ? ? ? ? ? ? ? 0
?
DOC> The following query reports thenumber of errors caught during
DOC> recompilation. If this number isnon-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORSto see if any of these errors
DOC> are due to misconfiguration orresource constraints that must be
DOC> fixed before objects can compilesuccessfully.
DOC>#
?
ERRORS DURING RECOMPILATION
---------------------------
? ? ? ? ? ? ? ? ? ? ? ? 0
?
PL/SQL procedure successfully completed
SQL> shutdown? immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
?
Total System Global Area 7516192768 bytes
Fixed Size? ? ? ? ? ? ? ? 2107936 bytes
Variable Size? ? ? ? ? 1258292704 bytes
Database Buffers? ? ? ? 6241124352 bytes
Redo Buffers? ? ? ? ? ? ? 14667776 bytes
Database mounted.
Database opened.
?
SQL> select * from v$version;? ? //查看数据库版本
BANNER
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise EditionRelease 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE? ? 10.2.0.5.0? ? Production
TNS for Linux: Version 10.2.0.5.0 -Production
NLSRTL Version 10.2.0.5.0 - Production
到此为止，升级工作初步完成