Skip to content

Instantly share code, notes, and snippets.

View dbaascli_dbimage_activateBP.txt
DBAAS>dbimage activateBP
Executing command dbimage activateBP
Command Error
Command: dbimage activateBP
activateBP available images
CMD : dbaascli dbimage activateBP --bp <> --version <>
args :
--bp : bundle patch version. Mandatory paramter. Examples: APR2017, JAN2017, OCT2016
--version : database version. Mandatory paramter. Examples: 11204, 12102, 12201, 18000, 19000
--cdb : yes/no Default is no
View cswlib_download_19440.txt
DBAAS>cswlib download
Executing command cswlib download
Command Error
Command: cswlib download
CSWLIB download/update dbnid bits
CMD : dbaascli cswlib download <optional_args>
args :
--version : database version. Mandatory paramter. Examples: 11204, 12102, 12201
--bp : bundle patch version. Mandatory paramter. Examples: APR2017, JAN2017, OCT2016
--bp_update : To indicate whether update the default db images. The valid values are yes and no, default is no.
View create_exacs_json_explainer.tsv
Parameter Example Value Explaination
adminPassword Complex#$@Password123 Admin password for both the database
availabilityDomain rMTbAP-MELBOURNE-1-AD-1 Availability Domain for the ExaCS. I happen to be using Melbourne AU
autoBackupEnabled true Automatic backups enabled?
backupSubnetId ocid1.subnet.oc1.ap-melbourne-1.aaaaaaaasgzvm5bpgch44qtplg52cpseyg2r4ziaaaaaaaaaaaaaaaaerdsq ExaCS needs a separate backup network. Enter the OCID for this network here
clusterName clustername1 The name of the RAC cluster
compartmentId ocid1.compartment.oc1..aaaaaaaasl3uge72u5xemtqwrpzo2t3tfjawv4k33haaaaaaaaaaaaaaaaja Compartment OCID that you wan the ExaCS in
cpuCoreCount 8 Initial OCPUs allocated across the ExaCS nodes
databaseEdition ENTERPRISE_EDITION_EXTREME_PERFORMANCE ENTERPRISE_EDITION_EXTREME_PERFORMANCE is the only option if you're creating an ExaCS
dbName dbname Database name for initial DB
View create_exacs_ocicli.json
{
"adminPassword": "Complex#$@Password123",
"availabilityDomain": "rMTb:AP-MELBOURNE-1-AD-1",
"autoBackupEnabled": true,
"backupSubnetId": "ocid1.subnet.oc1.ap-melbourne-1.aaaaaaaasgzvm5bpgch44qtplg52cpseyg2r4ziaaaaaaaaaaaaaaaaerdsq",
"clusterName": "clustername1",
"compartmentId": "ocid1.compartment.oc1..aaaaaaaasl3uge72u5xemtqwrpzo2t3tfjawv4k33haaaaaaaaaaaaaaaaja",
"cpuCoreCount": 8,
"databaseEdition": "ENTERPRISE_EDITION_EXTREME_PERFORMANCE",
"dbName": "dbname",
@alexblyth
alexblyth / cross_region_db_ref.csv
Last active Dec 4, 2019
Database Reference Material
View cross_region_db_ref.csv
PHX IAD
Primary Standby
Service Name dbha_phx1pp.db.phx.oraclevcn.com dbha_iad1pq.db.iad.oraclevcn.com
DB Name dbha dbha
db_unique_name dbha_phx1pp dbha_iad1pq
Host1 10.1.2.12 10.2.2.12
Host2 10.1.2.13 10.2.2.13
db_domain db.phx.oraclevcn.com db.iad.oraclevcn.com
sys WElcome01#- WElcome01#-
WElcome01#- WElcome01#-
View x
CmdUtils.makeSearchCommand({
name: "oerr10gr2",
url: "http://www.oracle.com/pls/db102/error_search?search={QUERY}",
icon: "http://www.oracle.com/favicon.ico",
description: "Searches www.oracle.com"
});
View x
CmdUtils.makeSearchCommand({
name: "oerr10gr2",
url: "http://www.oracle.com/pls/db102/error_search?search={QUERY}",
icon: "http://www.oracle.com/favicon.ico",
description: "Searches www.oracle.com"
});
View x
CmdUtils.CreateCommand({
name: "check-tech-news",
execute: function() {
var windowManager = Components.classes["@mozilla.org/appshell/window-mediator;1"].getService(Components.interfaces.nsIWindowMediator);
var browserWindow = windowManager.getMostRecentWindow("navigator:browser");
var browser = browserWindow.getBrowser();
browser.loadOneTab("http://slashdot.org", null, null, null, false, false);
browser.loadOneTab("http://arstechnica.com", null, null, null, false, false);