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…

Read More

ADRCI, Database, Oracle, , ,

Find the Oracle session that’s using a lot of resources on a Linux system

To find that, I did the following: [[email protected] marius]$ ps aux | sort -nrk 3,3 | head -n 10 oracle 28986 75.8 1.6 10739264 1602896 ? Rs Jan24 137897:06 ora_q002_DBINST oracle 23660 63.1 1.2 10730424 1221500 ? Rs Feb12 97718:28 ora_q003_DBINST oracle 8360 15.7 6.0 10734592 5970484 ? Ss May28 377:34 oracleDBINST (LOCAL=NO) oracle 2264…

Read More

SQL, Tuning, , ,

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…

Read More

3 CommentsDatabase, Oracle, Upgrade, , , , , , , ,

ORA-01203: wrong incarnation of this file – wrong creation SCN

Like in everyone else’s life, this kind of “happiness” is happening. This is what I got on one of my test STANDBY databases while I was trying to start the Recovery Manager: Managed Standby Recovery starting Real Time Apply Read of datafile ‘/u01/oradata/DB/filename.dbf’ (fno 113) header failed with ORA-01203 Rereading datafile 113 header failed with…

Read More

Dataguard, Oracle, Standby, ,