One of the reasons for getting this error might be that the sqlnet.ora does not contain the proper settings like in this particular case: As you can see there is nothing set in sqlnet.ora. Therefor when I was trying to reinstate a former PRIMARY as STANDBY, I was seeing in alert log of the reinstated…
I was trying to install EM13 v4 and I got the following error: I’m using Oracle 19c as repository database. The solution for this is: And restart the database 🙂
I got a freenas server where I’m putting all my VMs and I wanted this time to use a ISCSI share to perform the OS installation. This is how I discover my ISCSI targets: I have created a VM on Virtualbox but I haven’t created any disks.The following command will attache a ISCSI target to…
While cloning a schema within the same database, I encountered the following exception: While I was interested in importing only table data, I have created the following PARFILE: And the execution was looking like this: This is happening due to the fact that when executing the import, the impdp is trying to create those objects…
While cloning a schema within the same database, I encountered the following exception: While I was interested in importing only table data, I have created the following PARFILE: And the execution was looking like this: This is happening due to the fact that when executing the import, the impdp is trying to create those objects…
Hi,This is how you can change the character set of your Oracle DB. Checking the actual values: We want to change NLS_CHARACTERSET to WE8ISO8859P1 which is now WE8MSWIN1252. I checked again and:
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…
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…
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.…
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 |…
