Sandeep Panchal Blog

Representing years of research, planning, and development, Oracle Enterprise Manager 11g is set to be unveiled on April 22 by Oracle President Charles Phillips. If you are in the New York area, join Oracle President Charles Phillips and Oracle Senior Vice President Richard Sarwal for the launch of Oracle Enterprise Manager 11g. You can register here: http://bit.ly/bqUskZ It's also possible to show your interest or even if your attending at this LinkedIn event. http://events.linkedin.com/Oracle-Enterprise-Manager-11g-Launch-New/pub/258070 If you're not able to attende the Live event, don't worry about that, we will be live broadcasting it. You can register for that live webcast from this page: http://bit.ly/9Qnh5f More information can be found at    LinkedIn Group: Official Oracle Enterprise Manager group The official, made by Oracle, Oracle Enterprise Manager group, where you can find all the news around Enterprise Manager and connect with peers

I was testing "TOTAL RECALL" in 11g release 2 and found very interesting thing.... addition of any constraint on a table (e.g Primary Key)  will cause you to be unable to automatically read the historical data. I am working on 11gr2 and I am able to drop a column for a table which is being tracked in Total Recall. SQL> select TABLE_NAME,OWNER_NAME from DBA_FLASHBACK_ARCHIVE_TABLES; TABLE_NAME OWNER_NAME ------------------------------ ------------------------------ T RECALL Elapsed: 00:00:00.37 SQL> alter table recall.t drop column status; Table altered. Elapsed: 00:02:32.61 SQL> Bug or expected behaviour ? flashback data archive example of ORA-01466 SQL> create tablespace recall; Tablespace created. SQL> select FILE_NAME,BYTES/1024/1024 from dba_data_files where tablespace_name='RECALL'; FILE_NAME BYTES/1024/1024 ------------------------------------------------------------ --------------- +DATA/rac1db/datafile/recall.27...

[root@rac1 grid]# ./root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 2010-03-27 18:41:34: Checking for super user privileges 2010-03-27 18:41:34: User has super user privileges 2010-03-27 18:41:...

While install 11gr2 on RHEL 5 Warning for missing packages. gcc-4.1.2 elfutils-libelf-devel-0.125 glibc-devel-2.5 glibc-headers-2.5 gcc-c++-4.1.2 You will go in a loop if you keep finding this. [root@rac1 Server]# rpm -Uvh glibc-2.* gcc-4* warning: glibc-2.5-42.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 error: Failed dependencies: glibc-devel >= 2.2.90-12 is needed by gcc-4.1.2-46.el5.x86_64 [root@rac1 Server]# rpm -Uvh glibc-devel-2.5* warning: glibc-devel-2.5-42.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 error: Failed dependencies: glibc-headers is needed by glibc-devel-2.5-42.i386 glibc-headers = 2.5-42 is needed by glibc-devel-2.5-42.i386 glibc-headers is needed by glibc-devel-2.5-42.x86_64 glibc-headers = 2.5-42 is needed by glibc-devel-2.5-42.x86_64 [root@rac1 Server]# rpm -Uvh glibc-headers* warning: glibc-headers-2.5-42.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 error: Failed dependencies: kernel-headers i...

[oracle@rac1 ~]$ ulimit -p 16384 -bash: ulimit: pipe size: cannot modify limit: Invalid argument [oracle@rac1 ~]$ ulimit -p 16384 -bash: ulimit: pipe size: cannot modify limit: Invalid argument [oracle@rac1 ~]$ ulimit -n 65536 -bash: ulimit: open files: cannot modify limit: Operation not permitted [oracle@rac1 ~]$ ulimit -u 16384 -n 65536 -bash: ulimit: max user processes: cannot modify limit: Operation not permitted [oracle@rac1 ~]$ exit     Fix:   Add the following lines to the /etc/security/limits.conf file: oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536

How to check if the provided patch is an online patch. (rdbms patch) This can be applied while your database is running. cd $ORACLE_HOME/Opatch/opatch query is_online_patch 'dir' You will get the output . .. .. Patch is a online patch : True If this is true you can go ahead and do opatch apply

CSSCAN character set scanner utilities Basically 2 type of character set are available in Oracle. Single byte character sets and Multi-bytes character sets. Whenever we will perform character set migration from single bytes character sets to Multi-bytes character set then depending on the data size truncation can be occurred. For that case we need to increase the size of those columns. To find all those culprit columns we can use CSSCAN utility. CSSCAN Utility Usage: First of all we need to install CSSCAN utility. If CSSCAN utility is not installed in database the it will give following error. C:\> C:\>CSSCAN \"sys/*****@orcl as sysdba\" FULL=Y Character Set Scanner v2.0 : Release 10.1.0.4.0 - Production on Wed Feb 24 13:53:44 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production With the Partitioning, OLAP and Data Mining options CSS-00107: Character set migratio...

There was an issue today, A DBA from our team has installed four databases in same oracle home. For one of the Database, everything was working normal. For rest 3 DBA was getting this error while running any sql command.. SP2-0642: SQL*Plus internal error state 2131, context 0:0:0. Unsafe to proceed Oracle suggested to relink the Oracle executables and We checked the sudo bit on oracle executable also. Then, I compared the spfile for all four instances and found. The working Database had NLS_DATE_FORMAT = And Non working Databases were having NLS_DATE_FORMAT='DD-MM-YYYY' As the date format was different and after unsetting DD-MM-YYYY , all Databases worked fine. Now , I have a question , That all DB under one oracle home must have the same NLS_DATE_FORMAT  ? OR same NLS_Parameters. I will try to find more on this.

See the Oracle website at http://www.oracle.com/education/ For the latest information on all of Oracle’s certification paths, along with Oracle’s training resources. Oracle 11g Upgrade Paths Existing Oracle Professionals can upgrade their certification in several ways: An Oracle10g OCP can upgrade to 11g certification by passing the 1Z0-050 Oracle Database 11g: New Features for Administrators exam. An Oracle9i OCP can upgrade to 11g certification by passing the 1Z0-055 Oracle Database 11g: New Features for 9i OCPs exam. An Oracle8i OCP can upgrade to 10g by passing the 1Z0-045 Oracle Database 10g DBA New Features for Oracle8i OCPs exam, then separately passing the 10g to 11g upgrade exam. Oracle 7.3 and Oracle 8 DBAs must first upgrade to an Oracle9i certification with the 1Z0-035 Oracle9i DBA New Features for Oracle 7.3 and Oracle 8 OCPs exam and then upgrade the 9i certification to 11g with the 1Z0-055 Oracle Database 11g: New