SELECT p1.name, p1.value val_inst1, p2.value val_inst2 FROM gv$parameter p1 JOIN gv$parameter p2 ON p1.name = p2.name WHERE p1.inst_id = 1 AND p2.inst_id = 2 AND p1.value != p2.value AND p1.name NOT IN (‘instance_number’, ‘instance_name’, ‘local_listener’,’thread’,’undo_tablespace’,’core_dump_dest’)
— set ORACLE env first export ORACLE_SID=ORCL12 export ORACLE_HOME=/oracle/….. oracle@oravm:~/ [ORCL12] rman target / Recovery Manager: Release 12.1.0.1.0 – Production on Wed Dec 27 09:45:33 2017 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All…
— get list of file descriptors # lsof /dev/mapper/XYZ_* — example output oracle 31814 oracle 256u BLK 253,7 0t0 20968 /dev/mapper/../dm-7 — above, fd 256 is open for update (could also be w (write)) –…
with preamble(c) as (select ‘create database ‘ + db_name() + ‘_Snapshot on’), files(c) as (select ‘(name=’ + name + ‘, filename=”’ + physical_name + ‘.ss”)’ + char(10) from sys.database_files where type = 0), filescoalesce (c)…
I experienced a strange problem when calling Powershell from nagios to check failover cluster status. Note – using old NRPE_NT nagios agent – no problem with NSClient++. The Get-Cluster cmdlet failed each time the script…
Run on both databases: select /*+ ORDERED */ substr(s.ksusemnm,1,10)||’-‘|| substr(s.ksusepid,1,10) “ORIGIN”, substr(g.K2GTITID_ORA,1,35) “GTXID”, substr(s.indx,1,4)||’.’|| substr(s.ksuseser,1,5) “LSESSION” , s2.username, substr( decode(bitand(ksuseidl,11), 1,’ACTIVE’, 0, decode( bitand(ksuseflg,4096) , 0,’INACTIVE’,’CACHED’), 2,’SNIPED’, 3,’SNIPED’, ‘KILLED’ ),1,1 ) “S”, substr(s2.event,1,10) “WAITING” from…
SQL select * from v$asm_diskgroup order by free_mb asmcmd asmcmd lsdg|awk ‘{sub(/\//,””,$14);print}’|tr -dc ‘[:print:]\n’|awk -v date=”$(date +”%Y-%m-%d %r”)” ‘{print $14 “\t\t” $9″\t\t”$8″ : ” date}’|sort -k 2 -n
export bcp <database.schema.tablename> out c:\raytemp\tablename.out -n -T -S”<server,port>” import bcp <database.schema.tablename> in c:\raytemp\tablename.out -n -T -S”<server,port>”
Microsoft document: Install SQL Server on Linux [root@oralintest ~]# curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server.repo [root@oralintest ~]# yum install mssql-server … Installed: mssql-server.x86_64 0:14.0.900.75-1 Complete! [root@oralintest ~]# /opt/mssql/bin/mssql-conf setup The license terms for this product can be…
[root@oralintest ~]# yum install tigervnc-server Loaded plugins: langpacks, ulninfo Resolving Dependencies –> Running transaction check —> Package tigervnc-server.x86_64 0:1.8.0-1.el7 will be installed –> Finished Dependency Resolution Dependencies Resolved =============================================================================================================================================================================== Package Arch Version Repository Size ===============================================================================================================================================================================…