How to drop a database using DBCA in silence mode
I have a 19c database which I would like to drop it using DBCA utility. If we cannot use GUI, we have this command instead: Let’s see how it goes on my side: Looks good 🙂
DBCA cannot Delete Existing Database with DBT-10201
This is happening when one is trying to delete a database using DBCA utility. The reason for the failure is that there is no information about the database in /etc/oratab: Let’s reproduce it: Let’s add the information of the database into /etc/oratab file: Let’s try again to drop it: Happy ending 🙂
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Most probably you did a shutdown abort in order to speed up the bounce process 🙂 so you can set your database into archivelog mode.Below, you can find an example of how one can reproduce this error: The solution is an easy one. All you have to do is to bring you database in OPEN…
How to spin up an Oracle DG environment with 1 primary and 2 standbys using Vagrant
I know is not the most optimized Vagrantfile written out there but, I’m going to post only the Vagrantfile for the moment and soon I will upload also the files used to create the databases and broker config: And the result would be something like this:
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…
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:
How to drop a database
One of the ways is this: [[email protected] ~]$ 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 [[email protected] ~]$ 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.…
DIA-48322: Relation [INCIDENT] of ADR V[2] incompatible with V[2] tool
I got this issue while using ADRCI tool to maintain the logs. This is how I fixed it: [[email protected] ~]$ adrci ADRCI: Release 11.2.0.3.0 – Production on Wed May 31 09:43:29 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = “/u01/app/oracle” adrci> show homes ADR Homes: diag/diagtool/user_oracle/host_3933716914_11 diag/clients/user_oracle/host_3933716914_11 diag/rdbms/dbinst/DBINST…
