Terms for faster switches

January 2nd, 2013

Backplane
Also known as switching fabric, the backplane refers to the internal hardware needed to move the frames betwen the ports of the switch or router.

Bandwidth
Speed of the traffic

Fowarding Rate
The rate of packet transfer per second needed to reach a certain traffic volume (throughput).
The forwarding rate depends on frame size.

Forwarding capability
The forarding capability of a backplane refers to the sum of the speeds of all ports (doubled–one for tx and another for rx direction).

Non-blocking
When the sum of the port speeds are not influenced by the existing traffic exchanged on all other ports.
In an ideal situation, the backplane is non-blocking.
This means every frame size (including the smallest ethernet standard–64 bytes). In most cases, devices are non-blocking for an average size of 400 bytes.

SQL Server Express download link

September 20th, 2012

SQL Management Studio Express download link

database: http://www.microsoft.com/en-us/download/details.aspx?id=7593
ssms : http://www.microsoft.com/en-us/download/details.aspx?id=8961

umm.. new youtube app won’t open youtube links

September 14th, 2012

So today marks the release of the new youtube app. I download it into my iphone login with a swipe and my subscriptions show up i guess on my home screen of recently added videos. thats kinda cool i guess. I play and find one i would like to share with people in Whatsapp. I paste the link. Others in whatsapp also install the new youtube app. Now there are complaints the new app doesn’t open the link in the new Youtube app. What gives!!!

Not only that, it seems the videos in the NEW youtube app won’t play higher quality video.

Are my expectations too high?

a log on setting up a good virtualbox oracle instance

September 13th, 2012

going to try this virtualbox build and see if this works
http://www.oracle.com/technetwork/server-storage/vm/template-1482544.html

so far it boots up.. now to figure out what to do next

noting this link for sql developer
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html?ssSourceSiteId=ocomen

Oracle VM boots up with no issues..
setting ip address/domain/root password
I see 2 links. Oracle VM Manager and Oracle VM Help
clicking Applications > Oracle Database 11g Express Edition
Click on Oracle VM Manager
- firefox starts up with the link Http://localhost:7001/ovm/console/faces/login.jspx?afrLoop
umm.. what is the default login?
docs say username admin and default password is “Welcome1″
I’m logged in..
I click online help > http://docs.oracle.com/cd/E17781_01/admin.112/e18585/toc.htm
I try to run SQL Command Line , it says to connect username/password
I try SQL> connect admin/Welcome1
ERROR:
ORA-01017: invalid username/password; logon denied

Hmm.. i’ll just move on
So onward to the section “2 Creating a Database User”
ah, says i need to use the system user
SQL>Connect
Enter user-name: system
Enter password: Welcome1
ERROR:
ORA-28002: the password will expire in 7 days

SQL> create user testuser identified by Welcome1;
SQL> grant connect, resource to testuser;
SQL> exit

onwards to installing SQL Developer
http://www.oracle.com/technetwork/developer-tools/sql-developer/
download rpm for sql developer
Applications > Programming > SQL Developer

[ovm@OracleTestSvr ~]$ cd /opt/sqldeveloper/
[ovm@OracleTestSvr sqldeveloper]$ sqldeveloper

Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.sqldeveloper/jdk

ok.. see if the $JAVA_HOME is set..
[ovm@OracleTestSvr ~]$ echo $JAVA_HOME

[ovm@OracleTestSvr ~]$ echo $PATH
/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/ovm/bin
[ovm@OracleTestSvr ~]$

ok its not.. lets see if its installed in the VM..

[ovm@OracleTestSvr ~]$ which java
/usr/bin/java
[ovm@OracleTestSvr ~]$java –version
java version “1.4.2″
gij (GNU libgcj) version 4.1.2 20080704 (Red Hat 4.1.2-51)

Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

ok download java 6
http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u26-download-400750.html
download the rpm for redhat to /ovm on the desktop
open terminal
$ cd /home/ovm
$ chmod a+x jdk-6u26-linux-i586-rpm.bin
$ ./jdk-6u26-linux-i586-rpm.bin

RPM Installation: can’t create transaction lock on /var/lib/rpm/__db.000
hmm.. oh yea, run it using su and try again
$ su
password:
[root@OracleTestSvr ovm]# jdk-6u26-linux-i586-rpm.bin

Unpacking JAR files…
rt.jar…
jsse.jar…
charsets.jar…
tools.jar…
localedata.jar…
plugin.jar…
javaws.jar…
deploy.jar…
Installing JavaDB
Preparing… ########################################### [100%]
1:sun-javadb-common ########################################### [ 17%]
2:sun-javadb-core ########################################### [ 33%]
3:sun-javadb-client ########################################### [ 50%]
4:sun-javadb-demo ########################################### [ 67%]
5:sun-javadb-docs ########################################### [ 83%]
6:sun-javadb-javadoc ########################################### [100%]

Java(TM) SE Development Kit 6 successfully installed.

Product Registration is FREE and includes many benefits:
* Notification of new versions, patches, and updates
* Special offers on Oracle products, services and training
* Access to early releases and documentation

Product and system data will be collected. If your configuration
supports a browser, the JDK Product Registration form will
be presented. If you do not register, none of this information
will be saved. You may also register your JDK later by
opening the register.html file (located in the JDK installation
directory) in a browser.

For more information on what data Registration collects and
how it is managed and used, see:
http://java.sun.com/javase/registration/JDKRegistrationPrivacy.html

Press Enter to continue…..
Done.
[root@OracleTestSvr ovm]#

[ovm@OracleTestSvr bin]$ echo $JAVA_HOME
/usr/java/jdk1.6.0_26/bin
[ovm@OracleTestSvr bin]$ SetJavaHome /usr/java/jdk1.6.0_26/bin
bash: SetJavaHome: command not found
[ovm@OracleTestSvr bin]$ sqldeveloper

Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.sqldeveloper/jdk
/usr/java/jdk1.6.0_26/

…SQL Developer starts
yay
Click connection > New Connection
Connection Name : xe
Username : testuser
Password : Welcome1
Connection type Basic
Hostname : localhost
Port: 1521
SID : xe

Click Test..
Status : Success
Click Connect..

database xe is added under the “Connections” Tree.

back to Terminal to get it back up on startup.
$ vi ~/.bash_profile

added the following lines:
export JAVA_HOME=/usr/java/jdk1.6.0_26/bin/java
export PATH=$PATH:/usr/java/jdk1.6.0_26/bin/java

[root@OracleTestSvr bin]# source ~/.bash_profile
[root@OracleTestSvr bin]# echo $JAVA_HOME
/usr/java/jdk1.6.0_26/bin/java
[root@OracleTestSvr bin]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/ovm/bin:/root/bin:/usr/java/jdk1.6.0_26/bin/java

Onward to the next section
http://docs.oracle.com/cd/E17781_01/admin.112/e18585/toc.htm#BJFCFGCA
4.2 Working with Database Objects
It suggests to do the short tutorial in the SQL Developer User’s Guide
http://docs.oracle.com/cd/E18464_01/doc.30/e17472/tut_library.htm#RPTUG20000
.. table BOOKS created using SQL Worksheet
.. table PATRONS created using SQL Worksheet
…table TRANSACTIONS created using SQL Worksheet
time to create a sequence to generate some test data in the PATRONS table
* this will simply be used in INSERT statements to generate unique primary key values. In this case, the Primary Key will start at 100 and increment up.

CREATE SEQUENCE patron_id_seq
START with 100
INCREMENT by 1;

Now for the actual insert
INSERT INTO partrons values (patron_id_seq.nextval,
‘Blow’, ‘Joe’, ‘123 Broadway Street’, ‘New York, NY 07676′ , null);

..populate data for Books table
..populate data for Patrons table
..populate data for Transactions.. ERRORS : looks like the Transaction_ID isn’t self incrementing
..go to TAble> Transactions > Triggers tab
..new trigger and created a trigger on Transaction_ID using Patron_id_seq
Note: this probably isn’t correct fix but it does allow the data insertion for the transaction table. This probably isn’t the correct way to correct the problem but its getting the data inserting from the example.
To further investigate I dropped the table and tried it again but this time I went through the properties of the left schema. Right clicked on Tables > New Table. Added the columns with checks. Clicked on the Advanced check box and added constraints. Then came my ‘ah ha’ moment. in the instructions there is a Column Sequences pane in the wizard which automatically creates the trigger for you to populate automatically and ensure each transaction id is unique. Re-created the foreign keys and hit OK. Ran the transaction table data inserts and everything blew in correctly as expected.

..I think this is a good place to save the image.

yosemite planning top 6 places

April 9th, 2012

So we’ve decided to plan a trip to yosemite national park.

My top 6 priority places in yosemite to visit list
1. maroposa grove (map)
2. tuolumne meadows
3. cathedral lakes trail
4. tenaya lake
5. four mile trail
6. raft merced river

1. wawoana meadow loop
2. gaylor lakes
3. tuolumne grove of giant sequoias
4. elizabeth lake
5. panorama trail
6. not close to anything : mono lake south tufa trail
7. taft point and fissures

Debating if i should do the http://www.yosemitepark.com/valley-floor-tour.aspx or just go straight into hiking the locations.

Free Shuttle map through the park.
need to list where the restroom and eat spots are.

excel 2003/2007: opening files in a new instance

March 26th, 2012

One of the biggest annoyances i’m dealing with is dealing with excel randomly opening a new file from the windows explorer and it opens up the new file in the existing excel window.

in other words.
if one excel file is open
click on a new excel file to open
it opens the file in the new excel.
oh how i wish excel was tabbed by documents the same fashion as chrome or firefox.
in the meantime I’ll just ask for it to open in a new window.

I followed this guy’s tutorial
http://forums.whirlpool.net.au/archive/850718

It looks like a bit of a long-winded solution, but from techrepublic.com.com/520…essageID=2254006 :

My Computer
Tools
Folder Options
File Types
Choose XLS
Go to Advanced

Uncheck “browse in same window” in advanced window.

Then highlight Open
Edit

Make sure in the Action box it says &Open

Make sure in the application used to perform action it says:
“C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE” “%1″

Check the box next to use DDE

Remove anything that is in DDE Message box and DDE Application Not Running box.

Make sure the application box says: EXCEL

And in the Topic box it says: System

there is also the Excel Advanced option to make it open in a new window:
There is a setting you can enable within Excel 2007, similar to the option there was in 2003, but just a different location due to the changed GUI of course:

1. Open one instance of Excel 2007
2. Click on the Office Button (top left hand corner)
3. Click Excel Options
4. Go to the Advanced section on the left
5. Scroll down to the “Display” heading
6. Tick “Show all windows in the Taskbar”
7. Close Excel

Existing problem is when you open from an email attachment, it still does the same thing.

Lockergnome forum has their solution:

http://help.lockergnome.com/office/Open-Excel-Files-Separate-Windows–ftopict706425.html

By the way, there is a way to solve the “can’t open if there are spaces in the filename”. To get separate windows AND be able to open all files, do this:

1. In Windows Explorer, choose the Tools/Folder Options menu.
2. Click on the File Types tab
3. Scroll down and select the “XLS Microsoft Excel Worksheet” item
4. Click the “Advanced” button
5. Uncheck the “Browse in same window” option

So far this is just like what everyone has been saying…BUT, it will give you problems opening files that have spaces in them. Continue on to fix that…

6. Click on “Open” in the Actions list
7. Click the “Edit” button
8. Click in the “Application used to perform action:” box
9. Scroll to the very end. It will say something like …EXCEL.EXE” /e %1
10. Put quotes around the %1, so it now ends with …EXCEL.EXE” /e “%1″
11. Click OK twice, Close once, and you should be in business

Buy the Excel BumpOut Button
A button that just pushes out the excel document out into a new instance.

Excel : quick and dirty script to change values in a spreadsheet

December 23rd, 2011

just a quick and dirty script to quickly blank out columns in a spreadsheet.

Sub clearout()
Dim rng As Range, row As Range, cell As Range
Set rng = Range(”I12:K33″)

For Each a In rng.Rows
For Each cell In a.Cells

cell.Value = “”
Next
Next
Set rng = Range(”C12:C33″)
For Each cell In rng.Cells

cell.Value = “”
Next
End Sub

Import active python modules from a folder.

July 26th, 2011

http://www.faqs.org/docs/diveintopython/odbchelper_divein.html
downloaded the file and then put it into a folder. c:\temp\python\ in my case with the commands:

>> import sys
>> sys.path.append(’c:\\temp\\python\\’)

MS Excel funny annoyance : can’t open worksheet in a new window (part 1)

May 30th, 2011

Here is a funny annoyance from MS Excel 2003/2007. When I click on windows explorer or
Sharepoint links to open excel files, they randomly open in the same instance of excel or they open in their own excel instance. So I took the liberty of producing a solution which does just that. Creating a button which pushes the selected worksheet “out” into a new Excel instance.

Here are some forseen issues:
- there needs to be a button in excel to activate the action
- Macro security
- error checking for read-only

excel vba : for loop cross cell copying

April 27th, 2011

quick assignment taking the value from a formulated cell to another and copying it to another and for loop it.

For i = 68 To 100
Range(”i” & i) = Range(”k” & i)
Next i