tag:blogger.com,1999:blog-34441612625121958732024-02-20T07:34:44.801-03:00Paulo PortugalOracle, RAC,Exadata, SRVCTL, Cluster, Streams, XStream, TimesTen, Data Guard, Replication , Security, Database Vault, FGA, RLS, Backup and Recovery, RMAN, Performance and Tuning, Flashback, OID, BPEL, OTM, EBS, E-Business, Certification, OCP, OCM, Opatch, SRVCTL, Oracle Golden GatePaulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.comBlogger205125tag:blogger.com,1999:blog-3444161262512195873.post-84213946490363029742016-05-10T22:11:00.001-03:002016-05-10T22:11:30.698-03:00Some Best Practices in Configuring your RMAN Backup with Exadata<div dir="ltr" style="text-align: left;" trbidi="on">
1-Do not use internal parameters _backup_ksfq_bufsz and _backup_ksfq_bufcnt if your database is newer than 11.2.0.2. These parameters are set automatically after this release<br />
<br />
2-Try to use between 2 and 8 channels per instance while backing up your database<br />
<br />
3-For incremental backups, use FILESPERSET 1. It will be better when restoring single files<br />
<br />
4-Create a service to use in your backups. For example, BAKUP service_name.<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-49917554380492609712016-02-19T11:32:00.000-02:002016-02-19T11:32:01.512-02:0012.1.2.3.0 Exadata - Quorum Disks - Increase the availability of your Voting and CRS Files <div dir="ltr" style="text-align: left;" trbidi="on">
If you have a QH of EH and want to increase the availability of your voting and css files, you can do so by multiplexing them in DB Nodes using a new feature called QUORUM Disks.<br />
<br />
All the steps necessary are described here:<br />
<br />
https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/db_server.htm#DBMMN22700<br />
<br />
<br />
They are done using the quorumdiskmgr found at /opt/oracle.SupportTools<br />
<br />
<br />
<ol style="color: #222222; font-family: Tahoma, sans-serif;">
<li><pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; color: black; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve"># /opt/oracle.SupportTools/quorumdiskmgr --create --config --owner=grid --group=oinstall --network-iface-list="ib0, ib1"</pre>
</li>
</ol>
<br />
Best Regard,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-47015970382143922432016-02-11T10:14:00.002-02:002016-02-11T10:14:53.601-02:00Thew db_performance_profile parameter - IORM Exadata 12.1.2.1.0 and above<div dir="ltr" style="text-align: left;" trbidi="on">
The new PROFILE type of IORM on versions above 12.1.2.1.0 make things simple:<br /><br />CellCLI> ALTER IORMPLAN DBPLAN=(<br />(name=dimond, share=10, limit=100, type=profile),<br />(name=gold, share=5, limit=60, type=profile),<br />(name=silver, share=1, limit=20, type=profile))<br /><br /><br />Go to your database and run this change:<br /><br />SQL> alter system set db_performance_profile=gold scope=spfile;<br /><br /><br />With that we do not need to specify/change plan directives every time we create new databases.<br />
<br />Best Regards,<br />Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-54158707206516047872016-02-10T21:33:00.002-02:002016-02-10T21:33:37.295-02:00Increasing your Capacity-on-Demand on Database Servers - Exadata<div dir="ltr" style="text-align: left;" trbidi="on">
If you want to increase the number of licensed cores in your DB Servers you can use this command below:<br />
<br />
resourceControl -capacity_on_demand {display | disable | enable}<br />[-cores number_of_cores] [-force]<br />
<br />
<br />
Remember that you cannot decrease once you increase this number.<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-69234143760207214962016-02-10T21:15:00.001-02:002016-02-10T21:15:53.755-02:00Exadata I/O Instance Capping<div dir="ltr" style="text-align: left;" trbidi="on">
A great feature to use in newer versions of Exadata is I/O Latency Capping. Together with this configuration example "CellCLI> ALTER CELL iotimeoutthreshold = '5s'" you can told your Exa to point to a block mirror that is in a faster disk. Do not set it before checking your I/O information in AWR and other tools/commands. Best Regards,<br /><br />
<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-74386167267222647972016-01-13T12:11:00.002-02:002016-01-13T12:11:41.055-02:00Installing the Backup Module of ZDLRA is simple<div dir="ltr" style="text-align: left;" trbidi="on">
1-Download the file at http://www.oracle.com/technetwork/database/availability/oracle-zdlra-backup-module-2279224.html<br />
<br />
<br />
2-Unzip and install using this command example that you can find in README.txt file<br />
<br />
<pre>% java -jar ra_install.jar -dbUser joe -dbPass Oracle
-serviceName DBS.REGRESS.RDBMS.DEV.US.ORACLE.COM
-host slc08uth.us.oracle.com
-walletDir $ORACLE_HOME/dbs/ra_wallet -libDir $ORACLE_HOME/lib/
-proxyHost www-proxy.smallcompany.com
Recovery Appliance Install Tool, build 2014-08-07
Recovery Appliance credentials are valid.
Recovery Appliance wallet created in directory /orclhome/dbs/ra_wallet.
Recovery Appliance initialization file /orclhome/dbs/rat1.ora created.
Downloading Recovery Appliance Software Library from file ra_linux64.zip.
Download complete.
Extracted file /orclhome/lib/libra.so</pre>
<br />
<br />
That's it.<br />
<br />
You finished this step.<br />
<br />
Best Regards,<br />
Paulo Portugal <br />
<br />
<br />
<br /></div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-91966885041037929672015-12-24T12:49:00.003-02:002015-12-24T12:49:45.078-02:00The new restore control file restore from service<div dir="ltr" style="text-align: left;" trbidi="on">
Now we can restore a control file from service using a simple command:<br />
<br />
<pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve">RMAN> RESTORE STANDBY CONTROLFILE FROM SERVICE SOURCEMASTER;</pre>
<pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve">
</pre>
<pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve">
</pre>
<pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve">Best Regards,</pre>
<pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve">Paulo Portugal</pre>
</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-89836105954168468802015-12-24T12:35:00.002-02:002015-12-24T12:35:21.889-02:00Creating SPARSE Diskgroup - Exadata Snapshot Clones<div dir="ltr" style="text-align: left;" trbidi="on">
<pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve">create diskgroup DG_SPARSE
normal redundancy
disk 'o/*/SPARSE_*'
attribute
'compatible.asm' = '12.1.0.2',
'compatible.rdbms' = '12.1.0.2',
'cell.smart_scan_capable' = 'true',
'cell.sparse_dg' = 'allsparse',
'au_size' = '4M';</pre>
<pre class="oac_no_warn" dir="ltr" style="background-color: #eeeeee; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px; border-top-left-radius: 4px; border-top-right-radius: 4px; font-size: 12px; padding: 0.5ex 1ex;" xml:space="preserve">
</pre>
</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-19724918459979539042015-11-04T17:58:00.000-02:002015-11-04T17:58:11.447-02:00Using Rapid Home Provisioning Tool on DB12c<div dir="ltr" style="text-align: left;" trbidi="on">
This tool can be used to create rapid clone providing clients, add and delete roles for users, add delete and import images and others.<br />
<br />
Examples:<br />
<br />
--Check actual images:<br />
<br />
rhpctl query image<br />
<br />
--Get more details of certain image:<br />
<br />
rhpctl query image -image MYDB12<br />
<br />
--Get workingcopy details <br />
rhpctl query workingcopy -image MYDB12<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-35959554074205219662015-10-21T13:16:00.003-02:002015-10-21T13:16:38.807-02:00The right I/O tool to test disk performance - VDBENCH<div dir="ltr" style="text-align: left;" trbidi="on">
Thanks to Henk Vandenbergh for developing this great tool.<br />
<br />
Simple to use and a lot of resources and options. Works in almost all OS:<br />
<br />
This example below was used in my mac laptop.<br />
<br />
<br />
pportugal@dhcp-adc-twvpn-3-vpnpool-10-154-105-192 [] /Users/pportugal/Downloads/vdbench50403> ./vdbench -t<br />
<br />
<br />
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.<br />
Vdbench distribution: vdbench50403 Mon May 04 9:22:37 MDT 2015<br />
For documentation, see 'vdbench.pdf'.<br />
<br />
13:13:52.968 Created output directory '/Users/pportugal/Downloads/vdbench50403/output'<br />
13:13:53.137 input argument scanned: '-f/var/folders/r5/v8vgh1v10z52rfn4b4nlsd8h0000gp/T/parmfile'<br />
13:13:53.305 Starting slave: /Users/pportugal/Downloads/vdbench50403/vdbench SlaveJvm -m localhost -n localhost-10-151021-13.13.52.936 -l localhost-0 -p 5570<br />
13:13:53.698 All slaves are now connected<br />
13:13:53.805 Vdbench will attempt to expand a disk file if the requested file size is a multiple of 1mb<br />
13:13:53.805 lun=/var/folders/r5/v8vgh1v10z52rfn4b4nlsd8h0000gp/T/quick_vdbench_test does not exist or is too small. host=localhost<br />
13:13:55.002 Starting RD=SD_format; I/O rate: Uncontrolled MAX; elapsed=(none); For loops: threads=2 iorate=max<br />
13:13:55.164 All sequential workloads on all slaves are done.<br />
13:13:55.164 This triggers end of run inspite of possibly some non-sequential workloads that are still running.<br />
<br />
Oct 21, 2015 interval i/o MB/sec bytes read resp read write resp resp queue cpu% cpu%<br />
rate 1024**2 i/o pct time resp resp max stddev depth sys+u sys<br />
13:13:56.088 1 320.00 40.00 131072 0.00 0.606 0.000 0.606 21.419 1.845 0.2 NaN NaN<br />
13:13:56.099 avg_1-1 0.00 0.00 0 0.00 0.000 0.000 0.000 0.000 0.000 0.0 NaN NaN<br />
13:13:57.001 Starting RD=rd1; I/O rate: 100; elapsed=5; For loops: None<br />
<br />
Oct 21, 2015 interval i/o MB/sec bytes read resp read write resp resp queue cpu% cpu%<br />
rate 1024**2 i/o pct time resp resp max stddev depth sys+u sys<br />
13:13:58.011 1 74.00 0.07 1024 51.35 0.028 0.025 0.031 0.126 0.018 0.0 NaN NaN<br />
13:13:59.007 2 105.00 0.10 1024 53.33 0.029 0.025 0.033 0.073 0.013 0.0 NaN NaN<br />
13:14:00.007 3 105.00 0.10 1024 49.52 0.026 0.022 0.029 0.052 0.012 0.0 NaN NaN<br />
13:14:01.006 4 107.00 0.10 1024 51.40 0.026 0.023 0.029 0.067 0.013 0.0 NaN NaN<br />
13:14:02.022 5 96.00 0.09 1024 54.17 0.027 0.025 0.029 0.081 0.012 0.0 NaN NaN<br />
13:14:02.046 avg_2-5 103.25 0.10 1024 52.06 0.027 0.024 0.030 0.081 0.012 0.0 NaN NaN<br />
13:14:03.002 Vdbench execution completed successfully. Output directory: /Users/pportugal/Downloads/vdbench50403/output<br />
<br />
pportugal@dhcp-adc-twvpn-3-vpnpool-10-154-105-192 [] /Users/pportugal/Downloads/vdbench50403><br />
<br />
<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-4205836564865989962015-10-16T18:24:00.000-03:002015-10-16T18:24:00.968-03:00Enabling New Flash Cache Compression on Exadata Cells<div dir="ltr" style="text-align: left;" trbidi="on">
The flash cards F40 and F80 support flash cache compression and uncompressed tables for example can reach a 4 times compression ratio.<br />
<br />
To enable compression follow these steps:<br />
<br />
1-Flush all the flash cache in cell<br />
<br />
CellCLI> alter flashcache all flush<br />
<br />
2-Drop the flashcache<br />
<br />
CellCLI> drop flashcache all<br />
<br />
3-Drop all flash log<br />
<br />
CellCLI> dorp flashlog all<br />
<br />
4-Drop all cell flash cache disks<br />
<br />
CellCLI> drop celldisk all flashdisk<br />
<br />
5-On Cell that you want to enable flash cache compression run:<br />
<br />
CellCLI> alter cell flashCacheCompress = TRUE<br />
<br />
6-Create cell disk with flash disks<br />
<br />
CellCLI> create celldisk all flashdisk<br />
<br />
7-Create flash log<br />
<br />
CellCLI> create flashlog all<br />
<br />
8-Finally create flashcache<br />
<br />
CellCLI> create flashcache all<br />
<br />
Best Regards,<br />
Paulo Portugal<br />
<br />
ps: for X3 run<br />
CellCLI> alter cell flashCacheCompX3Support = TRUE </div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-71174583557366042732015-10-14T19:09:00.002-03:002015-10-14T19:09:26.142-03:00Create Sparse Grid Disks on Exadata Virtualized<div dir="ltr" style="text-align: left;" trbidi="on">
Exadata Virtualized is there and one very nice feature is the Sparse Grid Disks.<br />
<br />
With SGD you can create a disk that allocate space dynamically. So you can have a virtual size can be much bigger than the actual physical size. <br />
<br />
Example of how to create a Sparse Grid Disk and Sparse Disk Group:<br />
<br />
create griddisk S_GD1 ... virtualsize=100g;<br />
<br />
create diskgroup ... S_DG1 'spare grid disks here' ;<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-66670477359254726372015-08-12T14:44:00.003-03:002015-08-12T14:44:34.046-03:00Restore only a PDB is simple - Test done in Oracle Cloud<div dir="ltr" style="text-align: left;" trbidi="on">
If you dropped a table and want to restore to a restore point for example just run these commands below:<br />
<br />
set decryption identified by oracle;<br />
alter pluggable database MYPDB close;<br />
restore pluggable database MYPDB to restore point myrestorepoint;<br />
recover pluggable database MYPDB to restore point myrestorepoint;<br />
alter pluggable database MYPDB open resetlogs;<br />
<br />
I tested it using a cloud database and a cloud database backup in Oracle Cloud. Everything works perfectly.<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-66867967665995268452015-07-31T13:32:00.003-03:002015-07-31T13:32:46.080-03:00OISP and ZFS for Database 12c<div dir="ltr" style="text-align: left;" trbidi="on">
One big reason to upgrade your database to 12c version if you have ZFS is that with ZFS you will have the benefit of having Oracle Intelligent Storage Protocol. Oracle ZFS have 5 categories that could take care of different kind of database files and deals differently with each one making than work faster using different parameter values behind the scenes.<br />
<br />
For more information check Oracle Documentation regarding ZFS and OISP.<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-29172681631037999722015-06-26T23:15:00.001-03:002015-06-26T23:15:16.684-03:00Errors RMAN-03002 and RMAN-06571 While running SWITCH DATABASE TO COPY on Standby Database<div dir="ltr" style="text-align: left;" trbidi="on">
If you are doing a rollforward of a standby database and in the middle of the process got errors like below:<br />
<br />
RMAN-00571: ===========================================================<br />
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />
RMAN-00571: ===========================================================<br />
RMAN-03002: failure of switch to copy command at 06/26/2015 23:08:53<br />
RMAN-06571: datafile 301 does not have recoverable copy<br />
<br />
<br />
Don't worry, you just need to catalog the datafile in question using this command below:<br />
<br />
catalog datafilecopy '+DG_EBS_DATA/bwebspr_glt_p7/datafile/apps_ts_tx_idx.584';<br />
<br />
<br />
You can also use this query below to build the command to you quickly:<br />
<br />
select 'catalog datafilecopy '''||name||''';' from v$datafile where file#=301;<br />
<br />
<br />
<br />
After doing that for all problematic datafiles you can finish your rollforward process.<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-71597223614065565402015-05-20T22:58:00.001-03:002015-05-20T22:58:20.181-03:00RMAN-03002 ORA-19504 ORA-17502 ORA-15001 ORA-15040 <div dir="ltr" style="text-align: left;" trbidi="on">
I was trying to restore a standby control file to create a new standby database and got this error:<br />
<br />
RMAN> run {<br />
allocate channel c1 device type disk;<br />
restore standby controlfile from '/home/orab2b/copia_ctl_stby.ctl';<br />
release channel c1;<br />
}<br />
2> 3> 4> 5><br />
using target database control file instead of recovery catalog<br />
allocated channel: c1<br />
channel c1: SID=36 instance=BWB2BPR1 device type=DISK<br />
<br />
Starting restore at 20-MAY-15<br />
<br />
released channel: c1<br />
RMAN-00571: ===========================================================<br />
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />
RMAN-00571: ===========================================================<br />
RMAN-03002: failure of restore command at 05/20/2015 22:49:50<br />
ORA-19504: failed to create file "+FRA/bwb2bpr/controlfile/control01.ctl"<br />
ORA-17502: ksfdcre:3 Failed to create file +FRA/bwb2bpr/controlfile/control01.ctl<br />
ORA-15001: diskgroup "FRA" does not exist or is not mounted<br />
ORA-15040: diskgroup is incomplete<br />
ORA-15040: diskgroup is incomplete<br />
ORA-19600: input file is control file (/home/orab2b/copia_ctl_stby.ctl)<br />
ORA-19601: output file is control file (+FRA/bwb2bpr/controlfile/control01.ctl)<br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
To fox that, run this command below as GRID_HOME owner:</div>
<div>
<br /></div>
<div>
[bwdp0248-+ASM1]/u01/app/11.2.0.4/grid/bin> ./setasmgidwrap o=/u01/app/oracle/product/11.2.0.4/dbb2b/bin/oracle --HERE USE YOUR ORACLE RDBMS HOME</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
This fix my problem.</div>
<div>
<br /></div>
<div>
Best Regards,</div>
<div>
Paulo Portugal</div>
<div>
<br /></div>
</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com1tag:blogger.com,1999:blog-3444161262512195873.post-82224267197832842742015-05-04T03:52:00.003-03:002015-05-04T03:52:21.530-03:00CellCLI> list cell CELL-01519: Cannot talk to the Management Server (MS). Error: ; nested exception is: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Bad response: 404 Not Found CellCLI> exit<div dir="ltr" style="text-align: left;" trbidi="on">
Hi guys,<br />
<br />
I already got problems when I set my cell virtual machine with memory less than 1GB and also when I commented out the "127.x.x.x" ip address in /etc/hosts file. But this error below was new for me.<br />
<br />
To fix that in your TEST virtual machine of Exadata Cell, just do these following steps:<br />
<br />
1-Stop the MS service<br />
<br />
<br />
<br />
2-Redeploy the MS oc4j:<br />
<br />
<br />
3-Start the MS processes:<br />
<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal<br />
<br />
<br /></div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-14183341220494862542015-03-26T13:50:00.001-03:002015-05-04T04:02:35.967-03:00Great White Paper for 12c In-Memory Advisor<div dir="ltr" style="text-align: left;" trbidi="on">
In this link below you can find a great white paper for In Memory Advisor:<br />
<br />
http://www.oracle.com/technetwork/database/manageability/info/twp-in-memory-advisor-bp-2430474.pdf<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-82756746503708073272015-03-10T18:16:00.000-03:002015-03-10T18:16:10.129-03:00Using DBMS_PASSTHROUGH to run command in SQL Server from Oracle<div dir="ltr" style="text-align: left;" trbidi="on">
This simple example below update a table in SQL Server from Oracle:<br />
<br />
declare<br /> l_num_rows number;<br />begin<br /> l_num_rows := dbms_hs_passthrough.execute_immediate@TMMASTER ('USE ORAIntegration_V2_test');<br /> commit;<br /> execute immediate 'alter session close database link TMMASTER';<br /> commit;<br /> <br /> l_num_rows := dbms_hs_passthrough.execute_immediate@TMMASTER ('UPDATE trans SET a=333 WHERE a=222 ');<br /> commit;<br /> <br />-- l_num_rows := dbms_hs_passthrough.execute_immediate@TMMASTER ('COMMIT TRANSACTION');<br /> commit;<br /><br /><br /> execute immediate 'alter session close database link TMMASTER';<br /> commit;<br />end;<br /><br /><br /><br />select * from trans@TMMASTER;<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-8330754621313210282015-03-06T13:54:00.004-03:002015-03-06T13:54:54.761-03:00The new Oracle Exadata Deployment Assistant - Fev 2015 - Elastic Rack, OVM, COD<div dir="ltr" style="text-align: left;" trbidi="on">
Already including X5, Zero Data Loss and Super Cluster configuration options:<br />
<br />
http://www.oracle.com/technetwork/database/exadata/oeda-download-2076737.html<br />
<br />
<br />
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS 明朝";
mso-font-charset:78;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<br />
<div class="MsoNormal">
The new OEDA have options to install Exadata, Zero Data Loss
and Super Cluster</div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-QBtPRToGV0g/VPnagj0JkRI/AAAAAAAAuG0/YyFPgVmUpx8/s1600/Untitled1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-QBtPRToGV0g/VPnagj0JkRI/AAAAAAAAuG0/YyFPgVmUpx8/s1600/Untitled1.png" height="255" width="320" /> </a></div>
<div class="separator" style="clear: both; text-align: center;">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS 明朝";
mso-font-charset:78;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
</div>
<div class="MsoNormal">
With Elastic option you can customize your Exadata (19 DB
Nodes and 3 Cells for example) The maximum number os cell+db nodes is 23.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-qFQJgD45HCM/VPna0QvfErI/AAAAAAAAuHc/iLHgROZvVoU/s1600/Untitled2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-qFQJgD45HCM/VPna0QvfErI/AAAAAAAAuHc/iLHgROZvVoU/s1600/Untitled2.png" height="258" width="320" /></a></div>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS 明朝";
mso-font-charset:78;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<span style="font-family: Cambria; font-size: 12.0pt; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "MS 明朝"; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">The Hardware Options now have the Elastic Rack
with Flash Disks (HP disks does not exists anymore) or HC Disks.</span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-CabgrtDbmJI/VPnagtj_6UI/AAAAAAAAuG4/jV3Gp7XGDpc/s1600/Untitled3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-CabgrtDbmJI/VPnagtj_6UI/AAAAAAAAuG4/jV3Gp7XGDpc/s1600/Untitled3.png" height="256" width="320" /></a></div>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS 明朝";
mso-font-charset:78;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<span style="font-family: Cambria; font-size: 12.0pt; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "MS 明朝"; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">You can choose to have a Virtualized Exadata or
all physical db nodes. Also you can choose COD to save money on your software
licenses.</span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-2t6HScsrJp8/VPnahG68RlI/AAAAAAAAuHQ/92znP_L2yuI/s1600/Untitled4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-2t6HScsrJp8/VPnahG68RlI/AAAAAAAAuHQ/92znP_L2yuI/s1600/Untitled4.png" height="256" width="320" /></a></div>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS 明朝";
mso-font-charset:78;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<br />
<div class="MsoNormal">
Here you see one RAC with 19 nodes and 3 cells.<span style="mso-spacerun: yes;"> </span>This is only one from many possibilities:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-wkb4yJy0Jmc/VPnahTDGcQI/AAAAAAAAuHA/e96O0MdWR98/s1600/Untitled5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-wkb4yJy0Jmc/VPnahTDGcQI/AAAAAAAAuHA/e96O0MdWR98/s1600/Untitled5.png" height="258" width="320" /></a></div>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS 明朝";
mso-font-charset:78;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1791491579 18 0 131231 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Cambria;
mso-ascii-font-family:Cambria;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"MS 明朝";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Cambria;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<br />
<div class="MsoNormal">
At the end, your template shows something like that:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-tEPzoa-_NHc/VPnah8n9l-I/AAAAAAAAuHM/n6CtwWeXaLg/s1600/Untitled6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-tEPzoa-_NHc/VPnah8n9l-I/AAAAAAAAuHM/n6CtwWeXaLg/s1600/Untitled6.png" height="113" width="320" /></a></div>
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-54890942618983277332015-03-06T13:04:00.001-03:002015-03-06T13:04:33.615-03:00DBMS_SCHEDULER CREDENTIAL ORA-27486 privilegios insuficientes <div dir="ltr" style="text-align: left;" trbidi="on">
If you create an external job and is using a credential that already exists in another schema you will face this error below if not provide the necessary privilege for the using running the job :<br />
<br />
SQL> conn / as sysdba<br />
SQL> exec dbms_scheduler.run_job('MY_JOB');<br />BEGIN dbms_scheduler.run_job('MY_JOB'); END;<br /><br />*<br />ERROR at line 1:<br />ORA-27486: privilegios insuficientes<br />ORA-06512: em "SYS.DBMS_ISCHED", line 196<br />ORA-06512: em "SYS.DBMS_SCHEDULER", line 486<br />ORA-06512: em line 1<br />
<br />
<br />
Fix:<br />
<br />
You should connect with the credential owner and grant the execute on that credential to the other user:<br />
<br />
--Connect with the credential owner:<br />
SQL> conn edi/edi<br />
SQL> grant execute on edi.edi_credential to sys;<br />
--Connect back to SYS<br />
SQL> conn / as sysdba<br />Connected.<br />SQL> exec dbms_scheduler.run_job('MY_JOB');<br /><br />PL/SQL procedure successfully completed.<br /><br />SQL> <br />
<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-54569512290870826442015-03-05T14:16:00.001-03:002015-03-05T14:17:17.195-03:00The new DBMCLI utility on Exadata 12.1<div dir="ltr" style="text-align: left;" trbidi="on">
For you that is used to use CELLCLI in storage nodes on Exadata, now from 12.1 release that is a new DBMCLI for database nodes also.<br />
<br />
Like the CELLCLI the DBMCLI can be used to manage the database server. Some commands are below:<br />
<br />
DBMCLI> LIST METRICDEFINITION DS_CPUT DETAIL<br />
<br />
DBMCLI> LIST METRICDEFINITION WHERE name LIKE 'DS_SWAP_*' -<br />
ATTRIBUTES name, metricType, description<br />
<br />
<br />
DBMCLI> LIST METRICCURRENT DS_FANS DETAIL<br />
<br />
<br />
DBMCLI> LIST METRICCURRENT WHERE objectType = 'DBSERVER' AND - <br />
metricValue != 0 ATTRIBUTES name, metricObjectName, -<br />
metricValue, collectionTime<br />
<br />
DBMCLI> LIST METRICHISTORY DS_TEMP WHERE alertState='critical' DETAIL<br />
<br />
DBMCLI> LIST METRICHISTORY WHERE objectType = 'DBSERVER' AND metricValue != 0 -<br />
AND collectionTime > '2014-08-12T09:10:51-07:00' -ATTRIBUTES name, -<br />
metricObjectName, metricValue, collectionTime<br />
<br />
<br />
DBMCLI> ALTER ALERTHISTORY 1671443714 -<br />
examinedBy="jdoe"<br />
<br />
DBMCLI> ALTER ALERTHISTORY ALL examinedBy="jdoe"<br />
<br />
DBMCLI> ALTER DBSERVER iaasMode="on"<br />
DBMCLI> ALTER DBSERVER iaasIdleInUse=true, iaasReason=reason<br />
<br />
DBMCLI> ALTER DBSERVER smtpServer='my_mail.example.com', -<br />
smtpFromAddr='john.doe@example.com', -<br />
smtpFrom='John Doe', -<br />
smtpToAddr='jane.smith@example.com', -<br />
snmpSubscriber=((host=host1),(host=host2)), -<br />
notificationPolicy='clear', -<br />
notificationMethod='mail,snmp'<br />
<br />
<br />
All the documentation is here:<br />
<br />
http://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951 <br />
<br />
Best Regars,<br />
Paulo Portugal <br />
<br /></div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-29589470839939648782015-03-04T18:38:00.002-03:002015-03-04T18:38:25.903-03:00Find files in ASM using ASMCMD find command<div dir="ltr" style="text-align: left;" trbidi="on">
This single example will find all PARAMETER FILEs that you have in your ASM instance:<br />
<br />
ASMCMD> find --type PARAMETERFILE . *<br />
<br />
The types that can be used are these below:<br />
<br />
SQL> select distinct TYPE from v$asm_file;<br /><br />TYPE<br />----------------------------------------------------------------<br />ARCHIVELOG<br />ASMPARAMETERFILE<br />CHANGETRACKING<br />CONTROLFILE<br />DATAFILE<br />DATAGUARDCONFIG<br />OCRFILE<br />ONLINELOG<br />PARAMETERFILE<br />TEMPFILE<br /><br />10 rows selected.<br />
<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-48602912890760070322015-03-03T17:47:00.001-03:002015-03-03T17:47:19.795-03:00TOTAL_MB of V$ASM_DISK shows wrong value (diff from real OS space)<div dir="ltr" style="text-align: left;" trbidi="on">
If you are checking your space in V$ASM_DISK and face a problem where the TOTAL_MB is different from the real size of that disk execute the command below to workaround this problem:<br />
<br />
alter diskgroup DG_NFE_DATA resize disk DG_NFE_DATA_0000;<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal</div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com0tag:blogger.com,1999:blog-3444161262512195873.post-86140034036279467432015-02-20T20:07:00.002-02:002015-02-20T20:07:36.471-02:00Check IB Switchs on Exadata (ibqueryerrors.pl)<div dir="ltr" style="text-align: left;" trbidi="on">
A quick and simple way to check the healthy of your IB Switches in Exadata is this one below:<br />
<br />
1-Check using this command below:<br />
<br />
ibqueryerrors.pl -rR -s PortRcvSwitchRelayErrors,PortXmitDiscards,PortXmitWait,VL15Dropped<br />
<br />
<br />
2-If you got something line that:<br />
<br />
GUID 0x10e040687aa0a0 port ALL: [LinkErrorRecoveryCounter == 152] [PortRcvErrors == 5]<br /> GUID 0x10e040687aa0a0 port 1: [LinkErrorRecoveryCounter == 12]<br />
<br />
and this value is not increasing a lot, you can clear these errors and continue with your life without any problem but if this number are increasing quickly or are too high (30k, 65k or more) it is better to open an SR to check the IB hardware.<br />
<br />
3-Clear the count so when you run some tool like RACchk or the new ORAchk you will not be warned about these little errors.<br />
<br />
[root@ex01dbadm01 ORAchk]# ibclearcounters <br /><br />## Summary: 25 nodes cleared 0 errors<br />[root@ex01dbadm01 ORAchk]# <br />
<br />
<br />
<br />
Best Regards,<br />
Paulo Portugal <br />
<br /></div>
Paulo Portugalhttp://www.blogger.com/profile/17897476487933376033noreply@blogger.com1