DarkAngelStrike
DarkAngelStrike
/ gist:370a6fb1501860611bf5
Last active
October 13, 2015 17:33
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
| SQL> select patch_id, patch_uid, version, status, description | |
| 2 from dba_registry_sqlpatch | |
| 3 where bundle_series = 'PSU'; | |
| DESCRIPTION | |
| -------------------------------------------------------------------------------- | |
| Database Patch Set Update : 12.1.0.2.4 (20831110) | |
| SQL> create table t (x int, y varchar2(30)) row archival; |
DarkAngelStrike
/ gist:13516c760594f02233b7
Last active
October 30, 2015 16:44
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
| [oracle@rhec2lab1:/home/oracle]$ . oraenv | |
| ORACLE_SID = [+ASM] ? | |
| The Oracle base remains unchanged with value /u01/app/grid | |
| [oracle@rhec2lab1:/home/oracle]$ srvctl status asm | |
| ASM is running on rhec2lab1 | |
| [oracle@rhec2lab1:/home/oracle]$ srvctl config asm | |
| ASM home: <CRS home> | |
| Password file: +DATA/ASM/orapwasm |
DarkAngelStrike
/ gist:4ff054540670d40301ff
Created
November 3, 2015 16:20
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
| [oracle@rhec2lab1:/home/oracle]$ sqlplus / as sysdba | |
| SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 20 15:04:33 2015 | |
| Copyright (c) 1982, 2014, Oracle. All rights reserved. | |
| Connected to: | |
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production | |
| With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options |
DarkAngelStrike
/ gist:0552fbe7f5197da433ea
Created
November 3, 2015 16:20
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
| [oracle@rhec2lab1:/u01/app/oracle/product/12.1.0.2/db1/OPatch]$ ./datapatch -verbose | |
| SQL Patching tool version 12.1.0.2.0 on Tue Oct 20 16:00:27 2015 | |
| Copyright (c) 2015, Oracle. All rights reserved. | |
| Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_13061_2015_10_20_16_00_27/sqlpatch_invocation.log | |
| Connecting to database...OK | |
| Note: Datapatch will only apply or rollback SQL fixes for PDBs | |
| that are in an open state, no patches will be applied to closed PDBs. | |
| Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation |
DarkAngelStrike
/ gist:9f645036dfcaeb81ae4e
Last active
November 10, 2015 21:36
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
| [oracle@ATLAS:/home/oracle]$ cat /etc/redhat-release | |
| Red Hat Enterprise Linux Server release 6.4 (Santiago) | |
| [oracle@ATLAS:/home/oracle]$ uname -a | |
| Linux ATLAS 2.6.39-400.109.1.el6uek.x86_64 #1 SMP Tue Jun 4 23:21:51 PDT 2013 x86_64 x86_64 x86_64 GNU/Linux | |
| ##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~## | |
| # http://www.tecmint.com/how-to-enable-epel-repository-for-rhel-centos-6-5/ | |
| ##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~##--~~## |
DarkAngelStrike
/ gist:c0a6e67d4fa3d91a6a03
Last active
November 10, 2015 21:39
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
| [oracle@ATLAS:/home/oracle]$ rpm -qa|grep -i dbaastools | |
| dbaastools-1.0-1+15.3.6.0.0_150928.2115.x86_64 | |
| [oracle@ATLAS:/home/oracle]$ which dbaascli | |
| /usr/bin/dbaascli | |
| [oracle@ATLAS:/home/oracle]$ ls -ltra /usr/bin/dbaascli | |
| lrwxrwxrwx 1 root root 33 Sep 29 06:43 /usr/bin/dbaascli -> /var/opt/oracle/dbaascli/dbaascli | |
| [oracle@ATLAS:/var/opt/oracle/dbaascli]$ ll |
DarkAngelStrike
/ gist:850a55ce08483de9795a
Last active
January 19, 2016 19:26
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
| [root@em13c ~]# cat /etc/redhat-release | |
| Red Hat Enterprise Linux Server release 7.2 (Maipo) | |
| [root@em13c ~]# gcloud components update | |
| Your current Cloud SDK version is: 0.9.85 | |
| You will be upgraded to version: 92.0.0 | |
| ┌────────────────────────────────────────────────────────┐ |
DarkAngelStrike
/ gist:74d0f1453520f7e3be34
Last active
January 20, 2016 15:37
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
| root@sysdba:~$ gcloud compute firewall-rules list | |
| NAME NETWORK SRC_RANGES RULES SRC_TAGS TARGET_TAGS | |
| allow-agent default 0.0.0.0/0 tcp:3872 | |
| allow-bipub default 0.0.0.0/0 tcp:9803 | |
| allow-oms default 0.0.0.0/0 tcp:7803 | |
| allow-ons default 0.0.0.0/0 tcp:2016 | |
| allow-tns default 0.0.0.0/0 tcp:1521 | |
| default-allow-http default 0.0.0.0/0 tcp:80 http-server | |
| default-allow-https default 0.0.0.0/0 tcp:443 https-server | |
| default-allow-icmp default 0.0.0.0/0 icmp |
DarkAngelStrike
/ gist:e9db82e1c1c8d11fb228
Last active
February 4, 2016 17:44
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
| root@cloudshell:~$ gcloud compute instances create rh7 --image rhel-7 --zone us-central1-a --boot-disk-size 50GB --verbosity error | |
| Created [https://www.googleapis.com/compute/v1/projects/xxxxxx/zones/us-central1-a/instances/rh7]. | |
| NAME ZONE MACHINE_TYPE PREEMPTIBLE INTERNAL_IP EXTERNAL_IP STATUS | |
| rh7 us-central1-a n1-standard-1 xx.xxx.x.x xxx.xxx.xxx.xx RUNNING | |
| root@cloudshell:~$ gcloud compute config-ssh | |
| You should now be able to use ssh/scp with your instances. | |
| For example, try running: | |
| $ ssh rh7 |
DarkAngelStrike
/ kziaVrfyAcctStatInRootCbk.1
Created
May 8, 2017 02:48
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
| [oracle@server ~]$ sqlplus APEX_PUBLIC_USER/*****@127.0.0.1:1521/PDB | |
| SQL*Plus: Release 12.2.0.1.0 Production on Fri Apr 28 08:34:05 2017 | |
| Copyright (c) 1982, 2016, Oracle. All rights reserved. | |
| ERROR: | |
| ORA-00600: internal error code, arguments: [kziaVrfyAcctStatInRootCbk: !user], | |
| [APEX_PUBLIC_USER], [], [], [], [], [], [], [], [], [], [] |
OlderNewer