Reset Oracle ias_admin password

If you do not know current ias_admin password or it has been forgotten then follow the process mentioned below.


1. Go to $ORACLE_HOME/bin.

2. Stop the EM control.


./emctl stop iasconsole

3. Go to $ORACLE_HOME/sysman/j2ee/config .
4. Take a backup of jazn-data.xml file.

5. Open jazn.dat.xml file in editor.

vi jazn-data.xml

6. Search for an entry like below.

ias_admin
{903}8QkQ/crno3lX0f3+67dj6WxW9KJMXaCu


7. Remove the entire line that contains the property from jazn-data.xml.
8. Now reset the password of ias_admin like below.


$ORACLE_HOME/bin/emctl set password reset

9. Restart EM control as shown below.
$ORACLE_HOME/bin/emctl start iasconsole

10. Restart your machine (Optional).

Sailing for Marie Curie

Well I have sent off my deposit and been accepted on the Marie Curie Sailing Challenge on the 11th-14th July 2008.



Although I have raced offshore before, the last time was in the Fastnet Yacht race in 1999. So it's going to be a bit of a shock to find myself sitting on the side of a racing yacht again all day and night, apart from the frantic sail changes.

This time I am going to be sailing with family members David Coghlan and Gerard Nolan, for whom this will be their first experience of offshore yacht racing. So if it's horrible they will blame me.

I have a JustGiving fund raising page at http://www.justgiving.com/alannolandavies and hopefully some really generous people will donate lots of their money to the cause.

Goodbye Euro 2008

Lucky Me!!

I was lucky enough last night to be in the stands at Wembley when England lost 3-2 to Croatia and failed to qualify for the Euro 2008 Tournament in Austria/Switzerland next year.

As none of the other Home Teams (England, Scotland, Wales and Northern Ireland) managed to qualify for Euro 2008 I can only hope that they will create a UK 2008 so that we get to watch some football this summer.

DaylightMap

DaylightMap

Wow I've always wanted one of those clocks/pictures on the wall which shows where the current daylight is on the planet.

Now I have one on my desktop thanks to Sterling Udell

Cloning an Oracle9i Database

I have taken some screenshots of my progress as I cloned an Oracle9i Database (9.2.0.7) from one host to another.

The screenshots were placed in a Powerpoint presentation which I then uploaded to Google Docs and then published here http://docs.google.com/PresentationEditor?id=dfdhxn6d_139g669x9

follow the link above.

Pete Finnigan Oracle 11g Security presentation slides available

I talked yesterday at the UKOUG DBMS SIG in Chesford Grange (Le Meridien Warwick) which is very close to Warwick. The conference was very good in my opinion with lots of interaction and good discussion. I also particularly liked Julian's

read more | digg story

Google Gadgets For Your Webpage

Google Gadgets For Your Webpage

Wow this is fun, I have been adding Google Gadgets to my web pages as it makes them much more fun.

I need to look into how I develop my own gadgets.



this one is brilliant