It’s been awhile since I’ve published a post on my blog. I have so many things to share but not able to find time to share. Hopefully, very soon I will get back to blogging. Here’s a quick post on modifying SCAN listener port. We have been having archive log corruption issues since we setup Data Guard (sometime last week) on Oracle 11gR2 (220.127.116.11). The physical standby database is receiving the archive log files but unfortunately not able to perform media recovery as the archive logs are in malformed state. The customer is using CISCO switches between (more...)
Sangam11, AIOUG's annual conference is starting in the first week of December-2011. To be precise it's on 9th and 10th of December. The IT capital of India will be hosting 3rd annual meetup of AIOUG. World renowned experts like Murali Vallath, Arup Nanda, Hemant Chitale are leading the show. If you are in India then grab this opportunity to learn and network. For agenda and registrations click here.
The Second International NoCOUG SQL Challenge was published on 2/13/11 in the February 2011 issue of the NoCOUG Journal. The challenge was to find the secret message hidden in a seemingly random collection of words. Andre Araujo, Rob van Wijk, and Ilya Chuhnakov are the winners of this competition. Pythian was the sponsor of the competition and each winner will receive an Amazon Kindle. The full announcement can be read in the 100th issue of the NoCOUG Journal.
The old traditional export (exp) utility is hanging indefinitely at “exporting system procedural objects and actions” stage of the export.
[oracle@node1 ~]$ /orabackup/exp/prtdb/exp_prtdb.sh Export: Release 18.104.22.168.0 - Production on Sun Aug 14 21:39:03 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Tes Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set server uses WE8MSWIN1252 character set (possible charset (more...)
OS: RHEL 5.5 64-bit DB: Oracle Database 11gR2 Grid: Oracle Clusterware 11gR2 A database “adverten” is running on a Linux (64-bit) box. This database happens to be a two-node Oracle RAC database. The instance names of this database are “adverten1” and ““adverten2” respectively on the two nodes. I ran the RACcheck tool but unfortunately it does not list this database. However other databases running on this server are listed. Below is the excerpt from “raccheck” tool: List of running databases registered in OCR 1. clonedb 2. frisdb 3. All 4. None Believe me; the instance is there and running.