How to check SERIAL number of Exadata Hardware

You can check SERIAL NUMBER of your hardware using this simple command below:

cd /opt/oracle.cellos
./CheckHWnFWProfile -S

Best Regards,
Paulo Portugal

Cannot login with celladmin on Exadata Storag Servers (CELLS)

Login as root and reset failed login attempt for celladmin user using this command below and try again:

/sbin/pam_tally2 --reset=0 -u celladmin

Best Regards,
Paulo Portugal

How to check Bundle Patch applies to Exadata Database

Query below can be used to check in which Bundle Patch (BP)  your Exadatabase Database is running.

#######################################################################
select substr(action_time,1,30) action_time,
  substr(id,1,10) id,
  substr(action,1,10) action,
  substr(version,1,8) version,
  substr(BUNDLE_SERIES,1,6) bundle,
  substr(comments,1,20) comments
from registry$history;

ACTION_TIME                     ID                                       ACTION     VERSION    BUNDLE                         COMMENTS
------------------------------- ---------------------------------------- ---------- ---------- ------------------------------ --------------------
26-DEC-12 04.04.43.992511 PM    0                                        APPLY      11.2.0.3   PSU                            Patchset 11.2.0.2.0
31-JAN-13 10.06.31.615873 PM    14                                       APPLY      11.2.0.3   EXA                            BP14
#######################################################################

Best Regards,
Paulo Portugal

Change the date/time in all Exadara servers using dcli

This command below will change the data of all database nodes listed in files dbs_group. The date format used is MMDDHHMIYYYY

dcli -g /home/oracle/dbs_group -l root date  022511522013

Best Regards,
Paulo Portugal

Get EM Cloud 12c plugin status using emcli

emcli get_plugin_deployment_status -plugin_id=oracle.sysman.xa


Best Regards,
Paulo Portugal

New agentca for EM Grid Control 12c

In old Grid Control 10g, to force a reconfiguration of all targets for an agent we used "agentca -f" command.

For Cloud Control 12c we now use this command below:

/u01/app/oracle/product/12.1.0/agent_1/core/12.1.0.2.0/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/oracle/product/12.1.0/agent_1/core/12.1.0.2.0 ACTION=Configure MODE=Perform


Best Regards,
Paulo Portugal

How to find files and zip using dcli on Exadata:

This command below will find files of date Jan 13 2008 and zip all to /tmp/osw.zip in all databse nodes os exadata that are listed in file dbs_group.

dcli -l root -g dbs_group 'cd /opt/oracle.oswatcher/osw/archive; find . -name "*13.01.28*" -exec zip /tmp/osw.zip {} \;'

Best Regards,
Paulo Portugal

EXPDP/IMPDP show error ORA-39006 and ORA-39213: Metadata processing is not available

When trying to expdp or impdp you got error below:

#################################################################################################
Export: Release 11.2.0.3.0 - Production on Tue Mar 5 11:57:03 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available
#################################################################################################

Run the procedure below to fix the problem:

sqlplus / as sysdba

SQL> execute sys.dbms_metadata_util.load_stylesheets;


Best Regards,
Paulo Portugal