Archive for June, 2011

How To Check Oracle Licencing

Posted: June 28, 2011 in Misc
Tags: ,

$ sqlplus “/ as sysdba”
SQL> select * from v$version;
SQL> exit
Here is some sample output from 11g Standard Edition:

BANNER
——————————————————————————–
Oracle Database 11g Release 11.2.0.1.0 – 64bit Production
PL/SQL Release 11.2.0.1.0 – Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 – Production
NLSRTL Version 11.2.0.1.0 – Production

What is the difference between the Enterprise, Standard and Personal Editions of Oracle?
Submitted by admin on Sat, 2005-10-15 04:19

Oracle Enterprise Edition:

Enterprise Edition is the full (top of the range) version or the Oracle Database Server. Options like RAC, Partitioning, Spatial, etc. can be purchased separately to enhance the functionality of the database.

Oracle Standard Edition:

Standard Edition is designed for smaller businesses and enterprises. It offers a subset of the features/ functionality implemented in Enterprise Edition. Database options like Data Guard, Partitioning, Spatial, etc. is not available with Standard Edition (from 10g one can use RAC with Standard Edition). Standard Edition can only be licensed on servers with a maximum capacity of four processors.

Oracle Standard Edition One:

Standard Edition One is a low cost, entry-level version of the Oracle Standard Edition database server. Standard Edition One can only be licensed on small servers with a maximum capacity of two processors.

Oracle Personal Edition:

Personal Oracle is a single user version of the database server. It is mostly the same as Enterprise Edition, but doesn’t support advanced options like RAC, Streams, XMLDB, etc.

Oracle Lite:

Oracle Light is a database engine that can be used on mobile platforms like cell phones and PDA’s.

Oracle XE:

Express Edition (XE) is a free, downloadable version of the Oracle database server. Oracle XE can only be used on single processor machines. It can only manage up to 4 GB of data and 1 GB of memory. ISVs can embed XE in 3rd party products and redistribute it freely.

Advertisements

Got this from one of the EMC Engineer of how to collect Log for Brocade B-Series Switch . I am not a master of Brocade switching but this helps me out .
Goal       How to collect logs from a Brocade B-Series switch from a Windows 2000 host with Hyperterminal or Putty

Goal       How to use Hyperterminal.

Fact       Product: Connectrix All Brocade B-Series switches

Fact       OS: Microsoft Windows 2000

Fact       OS: Microsoft Windows Server 2003

Fact       OS: Microsoft Windows XP

Note       Brocade B-Series: What logs and when to collect them from a Brocade switch, during normal and troubleshooting circumstances. emc93016

Note       Brocade B-Series: How to collect a logs from a Brocade B-Series switch from a UNIX host. emc10350

Fix

For FOS version 4.4.x and above, the supportsave output is required for support issue’s. To collect the supportsave outputs you need to have an ftp service running on a separate host.

For FOS version below 4.4.x, collect the supportshow output.

Supportsave via IP:

  1. Start the program hyperterminal (Start Programs > Accessories > Communications > Hyperterminal).
  2. Make a new connection and pick a name for connection and an icon.
  3. A box appears with title “Connect to”. Change the connect using modem to TCP/IP (Winsock), then enter IP address of Brocade switch. Click OK button.
  4. Login into Brocade switch (default user: admin default password: password).
  5. Run command supportsave. Enter the IP address were the ftp server is running. It will report on the screen that it is collecting the RASLOG, TRACE and SUPPORTSHOW. After command completes.
  6. Type quit and close hyperterminal.

Alternative to Hyperterminal is to use the Free windows Tool PuTTY

  1. Start the standalone Putty application
  2. Select SSH or Telnet as the connection type and put in the IP of the Brocade switch.
  3. Hit connect and you will be presented with a prompt for login, you may have to approve connection if this is your first time connecting.
  4. Login to the Brocade switch using your credentials.
  5. Run command supportsave.  Follow prompts to enter IP o the FTP server.
  6. Exit putty session by typing quit, gather logs from FTP location.

Supportsave via serial cable:

  1. Start the program hyperterminal (Start Programs > Accessories > Communications > Hyperterminal).
  2. Make a new connection and pick a name for connection and an icon.
  3. A box appears with title “Connect to”. Change the connect using com 1 or com 2 (depending were the serial cable is connected to.). Click OK button.
  4. Change the com1 or com2 properties to “default”.
  5. Login into Brocade switch (default user: admin default password: password)
  6. Run command supportsave. Enter the IP address were the ftp server is running. It will report on the screen that it is collecting the RASLOG, TRACE and SUPPORTSHOW. After command completes.
  7. Type quit and close hyperterminal.

Supportshow via IP:

  1. Start the program hyperterminal (Start Programs > Accessories > Communications > Hyperterminal).
  2. Make a new connection and pick a name for connection and an icon.
  3. A box appears with title “Connect to”. Change the connect using modem to TCP/IP (Winsock), then enter IP address of Brocade switch. Click OK button.
  4. Login into Brocade switch (default user: admin default password: password), then start capture text (Transfer > Capture text > File C:\supportshow.txt).
  5. Run command supportshow. After command completes, stop capture text (Transfer > Capture text > Stop).
  6. Type quit and close hyperterminal.

Alternative to Hyperterminal is to use the Free windows Tool PuTTY

  1. Start the standalone Putty application
  2. Select SSH or Telnet as the connection type and put in the IP of the Brocade switch.
  3. On the left hand column, select ‘logging’ and on the right hand side choose ‘all session output’
  4. Name the log file (default is putty.log in the putty.exe directory’
  5. Hit connect and you will be presented with a prompt for login, you may have to approve connection if this is your first time connecting.
  6. Login to the Brocade switch using your credentials.
  7. Run command supportshow, the screen will output all supportshow information and will add it to the log file specified in step 4.
  8. Exit putty session by typing quit, gather log from selected location

Supportshow via serial cable:

  1. Start the program hyperterminal (Start Programs > Accessories > Communications > Hyperterminal).
  2. Make a new connection and pick a name for connection and an icon.
  3. A box appears with title “Connect to”. Change the connect using com 1 or com 2. Click OK button.
  4. Change the com1 properties to “default”.
  5. Login into Brocade switch (default user: admin default password: password), then start capture text (Transfer > Capture text > File C:\supportshow.txt).
  6. Run command supportshow. After command completes, stop capture text (Transfer > Capture text > Stop).
  7. Type quit and close hyperterminal.

Note

PuTTY can be used to collect logs but are not officially supported by or recommended by EMC.

VMotion fails at 10 percent

Posted: June 22, 2011 in VMware
Tags: ,

A common problem I see is when VMotion fails at the 10% mark with a timeout. You might see a dialog popup which says-

Operation timed out
Tasks: A general system error occurred:
Failed waiting for data. Error 16. Invalid argument

The VMware Knowledgebase writers have assembled a great list of possible reasons for this problem and I keep a printed out copy on my cubicle wall for this (ie: I didn’t write this)

Each step provides instructions or a link to a document with further details on how to eliminate possible causes and take corrective action to resolve the timeout. The steps are ordered in the most appropriate sequence to isolate the issue and identify the proper resolution.

  1. Verify that restarting the VMware Management Agents do not resolve the issue. For more information, see Restarting the Management agents on an ESX Server (1003490).
  2. Verify that VMkernel networking configuration is valid. For more information, see Unable to set VMkernel gateway as there are no VMkernel interfaces on the same network (1002662).
  3. Verify that VMkernel network connectivity exists using vmkping. For more information, see Testing vmkernel network connectivity with the vmkping command (1003728).
  4. Verify that Console OS network connectivity exists. For more information, see Testing network connectivity with the Ping command (1003486).
  5. Verify that Name Resolution is valid on ESX. For more information, see Identifying issues with and setting up name resolution on ESX Server (1003735).
  6. Verify that time is synchronized across environment. For more information, see Verifying time synchronization across environment (1003736).
  7. Verify that valid limits are set for the VM being VMmotioned. For more information, see VMware VMotion fails if target host does not meet reservation requirements (1003791).
  8. Verify that hostd is not spiking the console. For more information, see Checking for resource starvation of the ESX Server service console (1003496).
  9. Verify that VM is not configured to use a device that is not valid on target host. For more information, see Troubleshooting migration compatibility error: Device is a connected device with a remote backing (1003780).

***UPDATE (2/12/2010) There is now a great video on YouTube on how to fix this problem here: http://www.youtube.com/watch?v=42n-osx64ek

Note: If VMotion continues to fail at 10 percent after trying the steps in this article, open a case with tech support


Symptoms

In VMware View virtual machines running Windows 7, you experience these symptom:
  • When configuring dual monitors using the PCoIP protocol, the display does not span both the monitors.
  • The display appears only in one half of each monitor.
  • The other half of the monitors is rendered blank.
  • This issue does not occur when using the RDP protocol.

Resolution

To resolve this issue:
  1. In the desktop pool settings, ensure that the maximum number of monitors and the maximum resolution are selected.
  2. Ensure that the resolution of the monitors being used on the client machine is within the maximum resolution selected under the desktop pool settings. If the resolution of the monitor is higher, increase the resolution for the virtual machine. For more information, see Adding video resolution modes to Windows guest operating systems (1003).
  3. Run the System Configuration Utility (msconfig.exe) on the Windows 7 virtual machine and ensure that the No GUI boot and Base Video options are deselected.
  4. Restart the virtual machine.

Ref : Vmware


Nice Script to display Date and time .
Ref : http://bashscript.blogspot.com/

#!/bin/bash
# SCRIPT: digclock.sh
# USAGE:  ./digiclock &
# PURPOSE: Displays time and date in the top right corner of the
#          screen using tput command.
# To stop this digclock use command "kill pid"
################################################################

####################### VARIABLE DECLARATION ###################

 # To place the clock on the appropriate column, subtract the
 # length of $Time and $Date, which is 22, from the total number
 # of columns

  Columns=$(tput cols)
  Startpoint=$(($Columns-22))

 # If you're in an X Window System terminal,you can resize the
 # window, and the clock will adjust its position because it is
 # displayed at the last column minus 22 characters.

  Color1=`tput setab 2`        # Green background color for time
  Color2=`tput setab 6`        # Cyan  background color for date
  Normal=`tput sgr0`           # back to normal screen colors

####################### MAIN PROGRAM ###########################

# The script is executed inside a while without conditions

while :
do
  Time=`date +%r`
  Date=`date +"%d-%m-%Y"`
  tput sc                   #Save the cursor position&attributes
  tput cup 0 $Startpoint

 # You can also use bellow one liner
 # tput cup 0 $((`tput cols`-22))
 # But it is not efficient to calculate cursor position for each
 # iteration. That's why I placed variable assignment before
 # beginning of the loop.

 # print time and date in the top right corner of the screen.

  echo -n $Color1$Time $Color2$Date$Normal

 # restore the cursor to whatever was its previous position

  tput rc

 # Delay for 1 second

  sleep 1

done