Postgresql Admin 1. Stop/Start /usr/pgsql-12/bin/pg_ctl stop -D /var/lib/pgsql/12/data/ Connect to DB psql --host=hostname --port=5432...

Validate Database after migration Validate Record select table_schema, table_name, (xpath('/row/cnt/text()', xml_count))[1]::text::int as...

Install Elasticsearch with Ansible Download from github git clone git@github.com:hanhduynguyen/ansible_elasticsearch.git cd...

Elasticsearch Common Query ES Query Search query fdsa fdsa ES Installation dfa Clean up ES fdas fdas GET /_cluster/health GET...

Solution: SELECT name FROM v$parameter WHERE isdeprecated =’TRUE’ ORDER BY name;

This is a 12c Grid Infrastructure quick reference DETAILS “crsctl stat res -t” output example This example is from a 12c GI Flex Cluster...

The source database on Windows is PROD1 and the target database is a 11g RAC database RACDB1. 1) Create the tablespace and the test...

Cause The flash_recovery_area is full. SQL>  archive log list; Database log mode Archive Mode Automatic archival Enabled Archive...

Step 1. Is listener version compatible to the database Check if you are using compatible listener version for your database version. If...

1. Create the environment SQL> connect / as sysdba Connected. SQL> drop user ebernal cascade; User dropped. SQL> purge dba_recyclebin;...

1. Set the ENCRYPTION_WALLET_LOCATION in $ORACLE_HOME/network/admin/sqlnet.ora Example: oracle@seclindbs /u01/app/oracle/product/12.1.0.2...

Step by Step to install oracle RAC 12c in Solaris VM ldm add-vcc port-range=5000-5100 primary-vcc0 primary Create the virtual disk server...

Prepare the disks For OCR or voting disk addition or replacement, new disks need to be prepared. Please refer to Clusteware/Gird...

1)How to Enable the Logical Domains Manager Daemon # svcadm enable ldmd # /opt/SUNWldm/bin/ldm list 2)Upgrading a System That Is Already...

Change homename to dev svccfg -s system/identity:node setprop config/nodename=”dev” svccfg -s system/identity:node setprop...

Oracle Error: ORA-1157 An ORA-01157 is issued whenever Oracle attempts to access a file but cannot find or lock the file. Error...

All Oracle support Analysts, DBAs and Consultants who have a role to play in recovering an Oracle database Loss due to Disk Failure...

BACKUP SCENARIOS a) Consistent backups A consistent backup means that all data files and control files are consistent  to a point in...

% rman target / log recover_table1.log RMAN> RECOVER TABLE SMEDS.”RECTEST” OF PLUGGABLE DATABASE T12CPDB1 UNTIL SEQUENCE 48 THREAD 1 ...

To show system-wide shared memory allocations, use the following command: # ipcs -ma T        ID    KEY    MODE      OWNER  GROUP CREATOR...