(2) Output process record (partial content): Checking Status of Oracle software Stack-clusterware, ASM, RDBMS . . . . . . . . . . . . . . . ------------------------------------------------------------------------------------------------------- Oracle Stack Status ------------------------------------------------------------------------------------------------------- Host name CRS installed ASM HOME RDBMS installed CRS up ASM up RDBMS up DB Instance Name ------------------------------------------------------------------------------------------------------- INFA No no Yes no no yes infadb ------------------------------------------------------------------------------------------------------- Copying Plug-ins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Checking Best Practice Recommendations (PASS/WARNING/FAIL) * * * Collections and audit checks log file is /home/oracle/orachk/orachk_infa_infadb_080214_023723/log/orachk.log Checking for prompts In/home/oracle/.bash_profile on INFA for Oracle user ... ============================================================= Node NAME-INFA ============================================================= Collecting-active Sessions load balance for INFADB database Collecting-archived Destination Status for INFADB database ...... Collecting-memory Information Collecting-os Packages Collecting-operating system release information and kernel version Collecting-patches for RDBMS Home Collecting-number of semaphore operations per SEMOP system call Data collections completed. Checking best practices on INFA. -------------------------------------------------------------------------------------- INFO = User_dump_dest has trace files older than-infadb INFO = At some times checkpoints is not being completed for INFADB WARNING = one or more redo log groups is not multiplexed for INFADB WARNING = Shell Limit soft Nproc for DB are not configured according to recommendation ...... INFO = Consider investigating changes to the schema objects such as DDLs or new object creation for INFADB INFO = information about 11.2.0.3 support Best practice checking completed. Checking recommended patches on INFA. --------------------------------------------------------------------------------- Collecting patch inventory on oracle_home/dba/oracle/product/11.2.0/db_1 --------------------------------------------------------------------------------- 1 Recommended RDBMS patches for 112030 from/dba/oracle/product/11.2.0/db_1 on Infa --------------------------------------------------------------------------------- patch# RDBMS ASM Type patch-description --------------------------------------------------------------------------------- 18031683 no merge DATABASE PATCH SET UPDATE 11.2.0.3.10 (includes CPUAPR2014) --------------------------------------------------------------------------------- RDBMS Homes Patches Summary Report --------------------------------------------------------------------------------- Total patches applied in RDBMS applied on ASM oracle_home --------------------------------------------------------------------------------- 1 0 0/dba/oracle/product/11.2.0/db_1 --------------------------------------------------------------------------------- Detailed report (HTML)- /home/oracle/orachk/orachk_infa_infadb_080214_023723/orachk_infa_infadb_080214_ 023723.html UPLOAD (if required)- /home/oracle/orachk/orachk_infa_infadb_080214_023723.zip |