Display the nodes in the cluster Run the olsnodes command on all cluster nodes and see that it returns a list of all the nodes in each case. # cd /u01/app/11.2.0/grid/bin # ./olsnodes ac_test # CRS Commands: Check if auto…
Background ========== We had been performing flashback testing on a dev database testing upgrade rollback options. The testing plan was as follows:- 1. Cold database backup 2. Create GRP 3. Application upgrade 4. Flashback database 5. Application upgrade 6. Flashback…
There’s nothing more a Brit likes than a good queue, and what can make a tech loving Brit happier than a good queue??? An advanced queue – thats what! An old school offering from Oracle8 that still has massive scope…
col name for a32 col size_mb for 999,999,999 col reclaimable_mb for 999,999,999 col used_mb for 999,999,999 col pct_used for 999 SELECT name , ceil( space_limit / 1048576 ) SIZE_MB , ceil( space_used / 1048576 ) USED_MB , ceil( space_reclaimable /…
I was doing some testing with data guard and cascading databases and came across the following error whilst trying to create a 2nd standby on the same server as the first:- oracle:tst_pstby2 >srvctl add database -d tst_pstby2 -n tstlive -o…
Symptoms I am trying to build a dataguard configuration and when attempting to connect to the auxiliary instance RMAN fails with ORA-01031 errors. RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges I then tried connecting directly via sqlplus sqlplus “@…
Been looking upgrading to 12c recently and with that comes the upgrade of the rman catalog. The current plan was to leave the RDBMS at 11g but upgrade the catalog to 12.1.0.2 to cover the new databases. From experience it…
Until recently I was not aware that this was even a thing, but the version of the catalog database that you use can be higher than the RDBMS version running the CATALOG database. How is is this achieved i hear…
Been doing alot of RMAN related work and realised that I’ve not got anything up here to reference so here is the start of a few RMAN articles. This article assumes that you know what RMAN is and understand what…
Just started messing around with OUEL7 installations before going on site to help install a new RAC cluster. One issue that I noticed almost straight after the installation completed was it took AGES to login to the terminal using ssh.…
myoracledbablog 