DanBrother的部落格

Steps to De-install Oracle 12c Management Agents:

1. Invoke the AgentDeinstall.pl script:
export AGENT_HOME=/u01/agent12cr2/core/12.1.0.4.0
$AGENT_HOME/perl/bin/perl $AGENT_HOME/sysman/install/AgentDeinstall.pl -agentHome $AGENT_HOME

Configuring Software Library in 12c Cloud Control [ID
1368035.1]
 
1. EM12c -> Setup Menu -> Provisioning and Patching -> Software Library
2. Software Library: Administration
   Storage Type : OMS Shared Filesystem
   Actions -> Add
   >>
   *Name: Software Library
   *Location: /data/SoftwareLibrary
  
    Click OK once finished.

Issue:
Cloud Control 12.1.0.2 : False Alerts about EMGC_GCDomain/instance1/ohs1 Target Down [ID 1496775.1]
 Solution:
1.  Go to My ORACLE SUPPORT and Download  the following patch:

[OEM 12c] How to suppress TNS-01190 The user is not authorized to execute the requested listener command ?
Solution:

 (Within OEM Cloud Control 12c)
1.Search Target Name => Listener
2. Click the LISTENER one at the time (RAC)
3. Oracle_Listener -> Monitoring -> Metric and Collection Settings
4. Under Metric -> TnsError -> TNSMsg : 
    TNS-[ ]*0*(1169|1189|12508|1190)
   => remove |1190
   => Click OK
   => Click OK

Error retrieving information from database. Exception: ORA-01882: timezone region not found
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 8
java.sql.SQLDataException: ORA-01882: timezone region not found
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 8
oracle.sysman.emSDK.app.exception.EMSystemException
Solution:
# $OMS_HOME/bin/emctl stop oms -all
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down
# grep "ZONE=" /etc/sysconfig/clock
>>
ZONE="Asia/Taipei"
# . oraenv
ORACLE_SID = [CCDB]
# sqlplus / as sysdba

Problem:
SCAN Listeners status becomes down after relocation in Grid Control 11g

Solution:
1. Target Search -> Go
2.
Click on "Monitor Configuration" link
3. Make sure
the information for Configuration Target: Cluster
    are filled out correctly
4. Press "Update" botton to refresh the status.
5. Re-check the
status of SCAN Listeners

Oracle 11g Grid Control Tablespace Space Used (%) Notification Rule Creation Procedures:

Workaround for NI cryptographic checksum mismatch error: 12599 (TNS-12599)
[Article ID 1150874.1]
In the alert.log shows:
>>
***********************************************************************

Oracle Enterprise Manager 11g Grid Control Maintenance Tips:
In the 11g Grid Control version, the OMS configuration files:emoms.properties and emomslogging.properties are no longer used. Instead, the OMS/Repository configuration and logging properties are now stored in the Repository Database itself.
 Stop the OMS by:

###############################################
# Prerequisites:
###############################################
1.
For ASM1 to be monitored properly, make sure orapw+ASM1 exists (Take first node as an example).
If not, then create a orapw+ASM1 using:
$GRID_HOME/bin/orapwd file=$GRID_HOME/dbs/orapw+ASM1
export ORACLE_SID=+ASM1
sqlplus / as sysasm
select * from v$pwfile_users;
>>
USERNAME SYSDB SYSOP SYSAS
--------------------- --------- --------- ----------
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE FALSE