Reset the Oracle XE database password for OVM 3.1.1.

You have installed Oracle OVM with the bundled XE database and after a time, you find that you can no longer log into the OVM Admin console.

You get an error similar to: Unexpected Error logging in.  Consult logs...

What has probably happened is that the ovs database password has expired in XE.  Now using the XE environment is unsupported and for demo purposes only.  In fact the new version of OVM ships with a bundled MySQL database and no longer the XE.  Even better, the bundled MySQL database is supported in production environments.  So this post is obsolete even before I finish writing it.

To be sure you are facing this problem, grep for OVMDS in /u01/app/oracle/ovm-manager-3/machine1/base_adf_domain/servers/AdminServer/logs/AdminServer.log

####<Jan 28, 2013 12:19:51 PM NZDT> <Warning> <JDBC> <ovm.e-it.co.nz> <AdminServer> <Odof Tcp Client Thread: /127.0.0.1:54321/128430> <<anonymous>> <> <0000JcuiwIkCslYFLrfP8A1GSLRc000002> <1359328791693> <WL-001129> <Received exception while creating connection for pool "OVMDS": ORA-28001: the password has expired

OK so the XE Database password needs resetting.

First some environment variables:

[root@ovm logs]# echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/xe
[root@ovm logs]# echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/u01/app/oracle/product/11.2.0/xe:/u01/app/oracle/product/11.2.0/xe/bin
[root@ovm logs]# echo $ORACLE_SID
XE

Now use sqlplus as follows: (OldPassWord is the one you used when you installed OVMM. The OVMM installer either prompted for this or you selected the option to use the same password for everything during install... Remember?)

[root@ovm bin]# sqlplus ovs/OldPassWord

SQL*Plus: Release 11.2.0.2.0 Production on Sat Feb 9 10:38:48 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-28001: the password has expired


Changing password for ovs
New password: NewPassw0rd
Retype new password: NewPassw0rd
 
Password changed

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> exit

Now you need to update the password stored in Weblogic that is used to connect to the database.  Happily there is an admin tool for this:
It's found in:   /u01/app/oracle/ovm-manager-3/bin

[root@ovm bin]# ./ovm_admin --modifyds XE localhost 1521

Oracle VM Manager Release 3.1.1 Admin tool

Please enter the Oracle VM Manager database schema : ovs

Please enter the schema password for ovs : NewPassw0rd
Please re-enter the password : NewPassw0rd


Please enter the password for weblogic : <password you used when you installed ovmm>

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Connecting to WebLogic server ...

Connected ...
Modifying Oracle VM Manager Data Store 'OVMDS'...
Modified Data Store successfully ...
Exiting...
Restart of Oracle VM Manager is required for Data Store change to take effect ...


Now restart OVMM.  I like to allow a minute between stop and start.  This takes a while on my test environment...

[root@ovm bin]# /etc/init.d/ovmm stop && sleep 60 && /etc/init.d/ovmm start

Finally you should be able to log into ovm console as you used to.  Same username and password you always used.

This process updates the backend XE database password only.  Thankfully this should all be old news as the new version ships with MySQL and password resets in MySQL are much simpler.  The big question and one which I have not yet figured out the answer to is: Will the new OVMM support an external MySQL database...  In Production...

Edit...
I had to edit the error message found in the AdminServer log on this blog because of the xml being interpreted instead of displayed... Fixed now thanks to: http://entities.online-toolz.com/tools/text-html-entities-convertor.php

Comments

Post a Comment

Popular posts from this blog

Automatically mount NVME volumes in AWS EC2 on Windows with Cloudformation and Powershell Userdata

Introduction This post explains how I go about with AWS Cloudformation and Powershell userdata scripts. attaching EBS volumes to Windows EC2 instances identifying them in the OS initializing them formatting them and assigning labels and drive letters. Prerequisites You should know something about Cloudformation and Powershell. The AWS Image you use for your EC2 instance should be one provided by AWS and should have the following utility already deployed to  C:\ProgramData\Amazon\Tools\ebsnvme-id.exe AWS Cloudformation Step I typically do not declare EBS Volumes together with the EC2 Instance declaration in Cloudformation but prefer to declare them as separate resources along with their own ebs attachment resources.  Here is an example EC2 instance with three additional volume declarations on top of the root volume which is automatically mounted on C:\ WindowsServerInstance: Type: AWS::EC2::Instance Properties: BlockDeviceMappings: - DeviceName: /dev/sda1
Read more

Extending the AD Schema on Samba4 - Part 2

Importing LDIF files into Samba4 and Active Directory This is part 2 of the Extending AD Schema on Samba4 series.  The examples below are tested using the Samba4 LAB I created.  If you want more information on how that works then please read  http://david-latham.blogspot.co.nz/2012/12/samba4-ga-release-virtualbox-lab.html For part one, please read http://david-latham.blogspot.co.nz/2012/12/extending-ad-schema-on-samba4.html Unfortunately the format of an ldif file for creating new attributes and classes in the Schema Configuration are differ between Samba4 and Microsoft. The tools are slightly different too.  So this article will attempt to make it all clear. Find all the latest versions of code on this post at  https://github.com/linuxplayground/yubikey-ldap/tree/master/microsoft-schema Samba4 - ldbadd & ldbmodify As far as I can tell the only way to create a new class with a custom attribute in Samba4 (on the Linux command line) is first add the attribute with ldbad
Read more

Python + inotify = Pyinotify [ how to watch folders for file activity ]

Sometimes it just might be handy to be able to watch a folder on a hard disk for changes. For example: A client app might drop small files on a shared folder. A server app might be watching the folder for just such an event. Once the file is created, the server will kick into action and perform whatever tasks are required. This all comes from my CD burning application. I am currently thinking that the client apps will drop small xml files containing information about what to burn onto a folder the webserver has access to and the cdburner service will be watching... The linux kernel provides inotify. This from wikipedia : notify is a Linux kernel subsystem that provides file system event notification. It was written by John McCutchan with help from Robert Love and later Amy Griffis to replace dnotify . It was included in the mainline kernel from release 2.6.13 (2005-06-18), and could be compiled into 2.6.12 and possibly earlier releases by use of a patch . Its function is essen
Read more