alexblyth
alexblyth
/ dbaascli_dbimage_activateBP.txt
Created
May 12, 2020 06:00
View dbaascli_dbimage_activateBP.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
alexblyth
/ cswlib_download_19440.txt
Created
May 12, 2020 05:00
View cswlib_download_19440.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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. |
alexblyth
/ create_exacs_json_explainer.tsv
Last active
May 5, 2020 00:34
View create_exacs_json_explainer.tsv
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
alexblyth
/ create_exacs_ocicli.json
Created
May 5, 2020 00:06
View create_exacs_ocicli.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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", |
View cross_region_db_ref.csv
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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); |