Posted in db2 on February 23, 2011

On Linux, the DB2 installed binaries are locally stored in directory /opt/ibm/db2/V9.5. On AIX, HP-UX or Solaris operating systems, DB2 is installed under /opt/IBM/db2/V9.5. Use the db2level command to determine where the installed code has been locally installed in your machine.

Read more …

Add to orkut

Posted in course on May 14, 2012

Wysheid  is a leading database training and support center based on Bangalore. Wysheid is currently offering training on Oracle 11g R2 RAC  . The duration of this course is 40 hrs . Please contact us at 9900591413 for additional information.

Read more …

Add to orkut

Posted in db2, student_questions on March 21, 2012

In db2 the maximum number of character supported for a database name is 8.

 

The following are the limitation for the db2 database names.

Read more …

Add to orkut

Posted in student_questions on August 31, 2011
  1. Login as grid owner
  2. Set the enviornment for ASM instance as below
  3. $ . oraenv   —> when it ask for sid give  the ASM instance name
  4. $ srvctl config scan

Read more …

Add to orkut

Posted in student_questions on August 22, 2011

1) Your client assigned a case to create a user exactly similar to that of another user. How you will achive that.
2) The client told you to refresh a schema from one db to another database , how you can do that.
3) Create a database of following specification in command line mode

Read more …

Add to orkut

Posted in course on August 21, 2011

Wysheid  is a leading database training and suport center based on Bangalore.Wysheid is currently offering training on Oracle 11g R2 RAC  training. The duration of this course is 40 hrs . Please contact us at 9900591413 for additional information.

Read more …

Add to orkut

Posted in student_questions on August 21, 2011

GNOME Terminator

Terminator allows multiple terminals in one window. Using SSHMenu with Terminator instead of Gnome-Terminal allows a user to split their terminal window and to see multiple terminals at a single glance (i.e. without swapping between tabs). You can see some screenshots here. Even though they show an older version, you’ll get a good idea of how handy it

Read more …

Add to orkut

Posted in student_questions on August 21, 2011

Oracle 10gR2 RAC On Linux 5.5 Using VirtualBox 4

This article describes the installation of Oracle 10g release 2 (10.2.0.1) RAC on Linux (Oracle 5.5) using Virtual Box 4 with no additional shared disk devices.

Read more …

Add to orkut

Posted in rac on July 7, 2011

  • Identify the sessions to be killed , along with the instance_id  from gv$session

Read more …

Add to orkut

Posted in db2 on March 4, 2011

For the better performance for Oracle and db2 database in linux enviornment , the appropriate kernel setting are important Use 'ipcs -l' command to find out the current kernel setting for linux OS .

Read more …

Add to orkut

Copyright 2011 ©  Wysheid Database Consulting
Designed by : Treatment for Anxiety
Coded by : Panic Away | Anxiety Treatment | Anxiety Cure