Starting with the Oracle 11g database product, a utility named “adrci” has been added to provide the ability to: View alert logs Purge trace files, alert logs, incidents View traces files, alert logs Bundle incidents for Oracle Support etc. This blog just shows some of the basics – see Oracle’s docs. for a comprehensive view …
At least for v3 Intel Xeon processors here is what I had to do to get Dell Precision T5810 T7810 or T7910 workstations to boot off of NVMe flash drive on a PCIe card – real simple. Update the BIOS to the latest BIOS update – that will allow the legacy boot, or UEFI boot manager …
Recently I got this error when “datapatch”ing an Oracle instance that had been cloned (didn’t know that it had been cloned at the time). $ ./datapatch -verbose SQL Patching tool version 12.1.0.1.0 on Thu Feb 9 17:51:40 2017 Copyright (c) 2014, Oracle. All rights reserved. Connecting to database…OK Determining current state… Currently installed SQL Patches: …
Problems with 12c datapatch – the new opatch utility for 12c ORA-20001 Read More »
# work in progress – do not use yet # stop the agent on the target #logon to the OEM server (middle tier) emcli login -username=sysman emcli sync emcli get_targets | grep -i targetHomeName # now find the entry with “oracle_emd” – you must use that entry – another other entry can cause corruption oracle@sampson: …
http://www.ebay.com/itm/112295853176?ssPageName=STRK:MESELX:IT&_trksid=p3984.m1558.l2649
# restore an spfile – with no mount sqlplus / as sysdba startup nomount pfile=/path/initSID.ora # rman command rman target / RESTORE SPFILE FROM ‘/u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_09_13/o1_mf_s_601036454_2kkk8px2_.bkp’; # restore a control file with no mount mode sqlplus / as sysdba startup nomount pfile=/path/initSID.ora # rman commands restore controlfile from ‘/path-to-backup/c–30392xxx’; or restore controlfile from autobackup; # restore …
Patching with opatch (e.g. a PSU) will always change ONLY the last number (platform specific release number) – the way to determine this number for an Oracle database is: $ORACLE_HOME/OPatch/opatch lsinventory
add this to $ORACLE_HOME/sqlplus/admin/glogin.sql — setup a prompt with user name and connect set sqlprompt “_user’@’_connect_identifier > ” — set the default editor to vi define _editor=vi — from that point forward – all users will get the user that they are connected as and the SID / Connect Identifier embedded in their sqlprompt making …