How to drop EM13c repository – the nice way
If you want to cleanup your EM13c installation, you would like to drop EM repository information as well. This is the way to do it: Have fun!
ORA-16623: member detected role change
Playing with dataguard failover scenarios I bumped into this error: That’s due to inconsistent information within the broker files from both servers. To fix this, we can do this:
TNS-12564: TNS:connection refused while reinstating a failed database
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…
13.4: Installing OMS to 13.4 Fails With Error: Check if all adaptive features parameters are unset
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 🙂
How to attach a iscsi to a Virtualbox VM
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…
ORA-02304: invalid object identifier literal while executing IMPDP
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…
ORA-02304: invalid object identifier literal while executing IMPDP
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…
Changing the Oracle Database Characterset
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:
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…