![]() ![]() 1 oracle oinstall 41134 Feb 8 18:01 components.properties 1 oracle oinstall 14016 Feb 8 18:01 parameters.propertiesĭrwxr-xr-x. 1 oracle oinstall 100166 Feb 8 18:01 preupgrade_messages.properties 1 oracle oinstall 455876 Feb 8 18:01 preupgrade_package.sql 1 oracle oinstall 7884 Feb 8 18:01 preupgrade_driver.sql 1 oracle oinstall 15085 Feb 8 18:01 dbms_registry_extended.sql Processes in Instance: EnterpriseManager0.oemmach01.~]$ cd /home/oracle/bkp/labdb03_upgrade Oracle 10g Application Server Control is not bin]$ cd bin]$. Oracle Enterprise Manager 10g Release 5 Grid ControlĬopyright (c) 1996, 2009 Oracle Corporation. Oracle Database Packages and Types 10.1.0.4.0ĬOMPAT_CORE_VERSION NOT NULL VARCHAR2(32) SQL> select comp_name,version from dba_registry SQL> exec dbms_t_scheduler_attribute ('SCHEDULER_DISABLED','FALSE') To upgrade the repository database,we will follow the normal procedure to upgrade a database. NOTE: This will upgrade only OMS ORACLE_HOME and Agent ORACLE_HOME and will not upgrade the repository database. Unzip the software to any temporary directory and follow the below video to upgrade OEM from 10201 to 10205. SQL> select count(*) from dba_scheduler_running_jobs where SLAVE_PROCESS_ID IS NOT NULL SQL> exec dbms_t_scheduler_attribute ('SCHEDULER_DISABLED','TRUE') SQL> select count(*) from dba_jobs_running SQL> select a.instance_name as sid, b.value as jobqueue from gv$instance a, gv$parameter b where a.inst_id = b.inst_id and b.name='job_queue_processes' SQL> execute emd_maintenance.remove_em_dbms_jobs rw-r-r- 1 oracle oracle 10558 /u01/app/oracle/oem/db10g/rdbms/admin/b rw-r-r- 1 oracle oracle 5697 /u01/app/oracle/oem/db10g/rdbms/admin/b '/u01/app/oracle/product/10.2.0/oms10g/rdbms/admin/b' Permission askm]$ locate b b b b b b b b b b b b b b b b b b b b b b b b b b b b b > askm]$ cat askm]$ for i in `cat filelist` do chmod 644 $i askm]$ for i in `cat filelist` do ls -lrt $i done If the permission is not set to 664 for the below files, you will get a permission denied error during the upgrade. SQL> select object_name, object_type from all_objects where status'VALID' and object_name like 'DBMS%' The admin_recompile_invalid.sql script is available under /sysman/admin/emdrep/sql/core/latest/admin/ Where is the Oracle home directory of the Oracle Management Service (OMS). ![]() If there are rows, then run the below SQL bin]$ locate bin]$ SQL> select object_name, object_type from all_objects where owner='SYSMAN' and status 'VALID' SQL> exec emd_maintenance.analyze_emd_schema('SYSMAN') Verify that the Shared pool size of the repository database is set to a min value of 512MB. Use your convinient way to backup the database) Last successful heartbeat to OMS : 22:34:20īackup OMS oracle home ( you can use tar -cvzf to backup the OMS oracle home )īackup Repository database ( This is database backup. Size of XML files pending upload(MB) : 0.00Īvailable disk space on upload filesystem : 43.08% ![]() Total Megabytes of XML files uploaded so far : 5.50 Oracle Enterprise Manager 10g Release 10.2.0.1.0.Īgent Home : /u01/app/oracle/oem/agent10gĪgent binaries : /u01/app/oracle/oem/agent10g WebCache | WebCacheAdmin | 2265 | bin]$ bin]$. Ias-component | process-type | pid | status Logs are generated in directory bin]$ bin]$. Oracle 10g Application Server Control is running. Oracle Enterprise Manager 10g Release 10.2.0.1.0Ĭopyright (c) 1996, 2005 Oracle Corporation. SQL> select component_name,version from sysman.mgmt_versions Oracle Workspace Manager 10.1.0.2.0 VALID Oracle Database Packages and Types 10.1.0.4.0 VALID Oracle Database Catalog Views 10.1.0.4.0 VALID ![]() SQL> select comp_name,version,status from dba_registry
0 Comments
Leave a Reply. |