a Flo + a Blog = a Flog my ブログ

12Dec/110

wbadmin to include all volumes

I am not sure why but I ended having to use wbadmin to do a full backup of a server. I usually do a -criticalonly to get a bare-bone restore of some windows 2008 r2 servers but I needed a include everything a specific server had.

I took me almost an hour to figure out how to use the -include parameter.

As from technet or the embedded help:

-include       Specifies the comma-delimited list of items to include in the
backup. You can include multiple volumes. Volume paths can be
specified using volume drive letters, volume mount points, or
GUID-based volume names. If you use a GUID-based volume
name, it should be terminated with a backslash (\). You can
use the wildcard character (*) in the file name when
specifying a path to a file. Should be used only when the
-backupTarget parameter is used.

This said if I listed the volumes separated by a comma it would not let me. So just to save time to someone trying to do something like: wbadmin start backup -backuptarget:\\somewhere\here -systemstate -vssfull -allcritical -quiet -include:a:,b:,c:,d:,e:[...] to put the list of volumes to include between double quotes. -include:"a:,b:,c:,d:,e:[...]"

I cannot believe that this is not mentioned anywhere.

12Oct/110

Use google maps API from google docs

I am looking for a dojo where I could go practice to. I needed to find out which one would be closest to my work or home place...

I had that list of address representing some place of interests - all of the aikido dojos. And course I knew my home address. While google doc offered me an easy way to map all of those addresses on a map, I wanted to get some extra information such as the duration or distance for directions between my place and the listed address.

With the following formula one can easily find plenty of information:

For a duration

=INDEX(importXML("http://maps.googleapis.com/maps/api/directions/xml?origin="&SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE( D2 ;CHAR(13);" ");CHAR(10);" ")); " "; "+")&"&destination="&SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE( $D$9 ;CHAR(13);" ");CHAR(10);" ")); " "; "+")&"&sensor=false" ; "//leg/duration/text[last()]" ) ; 1)

For a distance

=INDEX(importXML("http://maps.googleapis.com/maps/api/directions/xml?origin="&SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE( D2 ;CHAR(13);" ");CHAR(10);" ")); " "; "+")&"&destination="&SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE( $D$9 ;CHAR(13);" ");CHAR(10);" ")); " "; "+")&"&sensor=false" ; "//leg/distance/text[last()]" ) ; 1)

You will understand that my home address would be in the cell D9 and that each address are in a D# cell.

Of course using the XPath Syntax, you can refer to any of the xml tag and get the value you need in a cell as you notice that the only difference between those are the parsing I am doing with //leg/distance.

importXML is pretty neat for parsing into xml data but use it with moderation as you can only use it 50 times in a spreadsheet.

16Aug/110

Big Brother client installation on UNIX/Linux

Following procedure explains the steps for installing Big Brother client on UNIX/Linux servers and information about all the supported files. I could not really find this anywhere easily broke down, I hope this helps a few...

Installation Steps
Create user bb on the server to be monitored.Assign 1984 uid to the Big Brother user.

useradd -u 1984 -c "Big Brother monitoring" bb

Copy the latest BB client tar file from your repository to bb home directory of the monitored server.

su - bb
scp root@yourrepo:/home/bb/software/BBCLT-aix6.1-bbc4.30-bbpe.tar .

Decompress the tar file in the bb home directory

In the bb home directory
tar -xvf BBCLT-aix6.1-bbc4.30-bbpe.tar

Exit from bb home directory as the BB client should be installed using root account.
From root user go to /home/bb/bbc4.30-bbpe/install and execute bbconfig file.After executing bbconfig file, it will ask to accept the License agreement.
After accepting the License agreement, the installation process will ask to enter a few details.

OS [aix] is the default so you can hit enter directly
It will ask for the userid for Big Brother which will be "bb".

The installation process will add a service in /etc/init.d which will start at boot.

At this point the BB client is not started as bb-hosts file is missing or empty.

Information about bb-hosts file
The bb-hosts file in present in /home/bb/bbc4.30-bbpe/etc.This file holds the information about the host and the BBDisplay,BBPAGER and BBNET.
BBDISPLAY is the server which will display all the monitored servers.
BBPAGER is the server which sends email alerts.
BBNET is the server which performa all Network tests.

Sample bb-hosts file.If the first line or name of the monitored host does not match the entry in the bb-hosts file then the bb client will not start.

0.0.0.0         monitoredsrv #must name uname -n
0.0.0.0         displaysrv # BBNET BBDISPLAY BBPAGER

Once all the changes are done then we are good to start the BB client.
The entry of the monitored server in bb-hosts file should also match with the entry in BB server's bb-hosts file.

I forgot to mention that to start and stop BB you can use the following:

su - bb -c "cd /home/bb/bbc4.30-bbpe;./runbb.sh start"

su - bb -c "cd /home/bb/bbc4.30-bbpe;./runbb.sh stop"

19Jul/110

My WebLogic 10.3 does not start

I was coming back from a pretty good weekend doing renovation when I am called as one of the application resting on a WebLogic Server (WLS) was inaccessible to users.

A quick round up at the WLS console showed that one of the server doesn't want to start nor restart.

Having a look at the logs for that specific server - you know under logs directory of that server - showed that amount other errors caused by this there was a problem with the diagnostic file.

.../domain/servers/WebLogicAdmin (or managed server)/data/store/default/XXXXX.dat (WLS_DIAGNOSTICS000000.DAT).

the diagnostic file? I never remembered setting any diag mode up and apparently the diag option is off. Anyhow quickly reading of the OTN, some people mentioned deleting the file as it could be corrupted.

That trick never worked for my case. I indeed deleted the WLS_DIAG*.WLS and any .lok under ../Oracle/Middleware/user_projects/domains/canp8/servers files around but nothing.

I eventually had to delete the following directories under each server for which that error occurred. I stopped WLS and for each server I deleted the /data, /tmp and /logs. then starting WLS, it seemed to like not finding them and created a new clean structure. However that was not the end of the troubleshooting as it would complain about the port for one of the server to be already taken by something else.

Indeed, the port seems to be taken by some WLS ghost process of the same name with a different UID. I did not want to look further and decided to shutdown the whole WLS box clean and restart it.

It did the trick for me... perhaps it will do it for you. I still wonder what those files are for and why they would get corrupted and prevent a server from starting up.

8Jun/110

Windows 2008 x Data Protector: Can not connect to the SCM (Service Control Manager)

I noticed this a while ago but a colleague came to me with this problem. Luckily - and because I have short memory, I documented the process accordingly - which he did not read... anyways.

With windows 2008R2, in order to deploy the client to the server - locally or remotely - one will need to make sure the account used to deploy the agent is in the inet password account list and part of the install server user list. If not it will need to be added as follow.

C:\Program Files\OmniBack\bin>omniinetpasswd -add youraccount@domain.net

C:\Program Files\OmniBack\bin>omniinetpasswd.exe -inst_srv_user youraccount@domain.net

Use -list to get a list of users already in the list. If you do not add your account, you will have to use the backup service account to deploy any clients.