Very frequently i have seen DBAs having some misconception about the User managed Hot Backup.Most common questions are 1. When tablespace is in backup mode, do the DML activities updates the records? 2. Why there is no change in SCN? 3. Why is there excess redo generation during hot backup? Long time back,same questions were … Continue reading Oracle Hot Backup Concept
ORA-27102: out of memory
Recently i faced the below error while starting the test databases on Sun Solaris 10, SQL> startup ORA-27102: out of memory Solaris-AMD64 Error: 22: Invalid argument On asking to the team, came to know,that there was some issue, which they were not aware of.So it was time to investigate 🙂 Check the Alert log Starting … Continue reading ORA-27102: out of memory
Oracle Jobs not running
If the scheduler jobs are not running, and you want to know the reason for the same and diagnose, check the below OTN post http://forums.oracle.com/forums/thread.jspa?threadID=646581 Enjoy reading 🙂
sys as sysdba – insufficient privileges
Working on the Solaris server i always use " / as sysdba" to login to the database.While creating a backup scripts, i used sqlplus -s "sys@iddb as sysdba" Before testing the script, did a tnsping bash-3.00$ tnsping iddb TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 28-MAY-2010 17:00:44 Copyright (c) 1997, 2006, Oracle. … Continue reading sys as sysdba – insufficient privileges
Learn. Share. Repeat. 