Durham Oracle

Compare columns in a table..

select settings_eil.param_name, settings_eil.PARAM_VALUE, settings_qa.param_name, settings_qa.PARAM_VALUE from settings_eil,settings_qa where settings_eil.param_name(+)=settings_qa.param_name order by settings_eil.param_name

expdp as sysdba

Needed to export a table but was not given any login details only the oracle user so at least had sysdba privs (did not want to create another dba directory so just used the DATA_PUMP_DIR) - after a couple of goes found this to work. If anyone knows a better way please let me know. I could have used a procedure from another post but this seemed easiest solution.

[oracle]$ expdp \"/ as sysdba\" directory=DATA_PUMP_DIR tables=FRM_MAIN.SETTINGS
Export: Release 12.2.0.1.0 - Production on Thu Jul 5 03:42:44 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA" directory=DATA_PUMP_DIR tables=FRM_MAIN.SETTINGS
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "FRM_MAIN"."SETTINGS" 14.25 KB 56 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/u01/app/oracle/product/12.2.0/dbhome/rdbms/log/expdat.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Thu Jul 5 03:43:09 2018 elapsed 0 00:00:24

Please note when going from 12.2 to 12.1 use the VERSION=12.1 option on 12.2 otherwise the import will fail and it is not obvious why !!!

Cluster check

Needed to quickly check cluster status -

(node info and ip addresses removed, NTP will fail as no internet connectivity so expected)

[grid@...01 ~]$ cluvfy stage -post crsinst -n node01, node02,node03,node04

....01,...02,....03,...04
Verifying Node Connectivity ...
Verifying Hosts File ...PASSED
Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED
Verifying subnet mask consistency for subnet "172.23.x.x" ...PASSED
Verifying subnet mask consistency for subnet "192.168.x.x" ...PASSED
Verifying Node Connectivity ...PASSED
Verifying Multicast check ...PASSED
Verifying Time zone consistency ...PASSED
Verifying Cluster Manager Integrity ...PASSED
Verifying User Mask ...PASSED
Verifying Cluster Integrity ...PASSED
Verifying OCR Integrity ...PASSED
Verifying CRS Integrity ...
Verifying Clusterware Version Consistency ...PASSED
Verifying CRS Integrity ...PASSED
Verifying Node Application Existence ...PASSED
Verifying Single Client Access Name (SCAN) ...
Verifying DNS/NIS name service '...ora-scan' ...
    Verifying Name Service Switch Configuration File Integrity ...PASSED
Verifying DNS/NIS name service 'ussanqnycora-scan' ...PASSED
Verifying Single Client Access Name (SCAN) ...PASSED
Verifying OLR Integrity ...PASSED
Verifying Voting Disk ...PASSED
Verifying ASM Integrity ...
Verifying Node Connectivity ...
    Verifying Hosts File ...PASSED
    Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED
    Verifying subnet mask consistency for subnet "172.23.x.x" ...PASSED
    Verifying subnet mask consistency for subnet "192.168.x.x" ...PASSED
Verifying Node Connectivity ...PASSED
Verifying ASM Integrity ...PASSED
Verifying Device Checks for ASM ...PASSED
Verifying ASM disk group free space ...PASSED
Verifying I/O scheduler ...
Verifying Package: cvuqdisk-1.0.10-1 ...PASSED
Verifying I/O scheduler ...PASSED
Verifying User Not In Group "root": grid ...PASSED
Verifying Clock Synchronization ...
CTSS is in Observer state. Switching over to clock synchronization checks using NTP
Verifying Network Time Protocol (NTP) ...
    Verifying '/etc/ntp.conf' ...PASSED
    Verifying '/etc/chrony.conf' ...PASSED
    Verifying '/var/run/chronyd.pid' ...PASSED
    Verifying Daemon 'chronyd' ...PASSED
    Verifying NTP daemon or service using UDP port 123 ...PASSED
    Verifying chrony daemon is synchronized with at least one external time source ...FAILED (PRVG-13606)
Verifying Network Time Protocol (NTP) ...FAILED (PRVG-1063)
Verifying Clock Synchronization ...FAILED (PRVG-1063, PRVG-13606)
Verifying VIP Subnet configuration check ...PASSED
Verifying Network configuration consistency checks ...PASSED
Verifying File system mount options for path GI_HOME ...PASSED
Post-check for cluster services setup was unsuccessful.
Checks did not pass for the following nodes:
...04,...03,...02,...01

Failures were encountered during execution of CVU verification request "stage -post crsinst".
Verifying Clock Synchronization ...FAILED
Verifying Network Time Protocol (NTP) ...FAILED