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…
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:
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:
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…
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:
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.…
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…
Please check this post Database upgrade from 10.2.0.5.0 to 11.2.0.4
The following document is the best one you can start documenting yourself from: 11gr2-upgrade-bp-apr2012-1610082.pdf From the above document, I followed: Note 251.1: Database Upgrades from 10.2 to 11.2 On that note, on the PLAN tab, I followed: Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1) In this document you’ll find a bunch of…
