Upload_Port/empbs/upload. [handshake has no peer]

I had to deploy an EM13c agent on an AIX box and I have noticed the following error in emoms_pbs.trc ( this is located on OMS box: /u01/app/oracle/em13c/gc_inst/em/EMGC_OMS1/sysman/log): oracle.sysman.emSDK.agent.comm.exception.VerifyConnectionException: unable to connect to http server at https://server1:3872/emd/main/. [handshake has no peer] After the agent was deployed, I tried to add targets using OMS graphical interface…

RMAN-05609: Must specify a username for target connection when using active duplicate

While I was trying to duplicate my database I got this error: orcl_pri> rman target / auxiliary sys@orcl_dr Recovery Manager: Release 12.1.0.2.0 – Production on Mon Apr 15 13:50:51 2019 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=XXXXXXXXXX) auxiliary database Password: connected to auxiliary database: ORCL…

How to drop a database

One of the ways is this: [oracle@srv3 ~]$ ps -eaf | grep pmon oracle 10435 10414 0 10:22 pts/1 00:00:00 grep –color=auto pmon oracle 31892 1 0 06:49 ? 00:00:00 ora_pmon_ORCL [oracle@srv3 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 22 10:22:55 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved.…

Monitoring PostgreSQL Replication

After I have built my postgres hosts using Vagrant, I’m doing the following tests in order to check my replication: pg_stat_replication view Run the following statement on the master / primary host: postgres=# SELECT * FROM pg_stat_replication; pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | backend_xmin |…

Postgres: PANIC: could not locate a valid checkpoint record

I recently started to play with Postgres and this was one of the errors I got from my setup when I was trying to bring up the database:   [Tue Nov 06 09:58:10 root@postgres-primary:~ ] $ su – postgres -c ‘/usr/pgsql-10/bin/pg_ctl -D $PGDATA start’ waiting for server to start….2018-11-06 09:58:37.346 UTC [21595] LOG: listening on…