Undo segments status is PARTLY AVAILABLE

Alert log shows:

SMON: about to recover undo segment 309
SMON: mark undo segment 309 as available
SMON: about to recover undo segment 312
SMON: mark undo segment 312 as available
SMON: about to recover undo segment 40


To fix:

Check which segments have status PARTLY AVAIABLE and if you do not have any in-doubt transaction (dba_2pc_pending , v$transaction, etc) them:

alter rollback segment XXXXX online;

Best Regards,
Paulo Portugal

Resseting Oracle VM Manager Password for ADMIN or Any other user

1-Login to database as SYS user or OVS user

2-Take a backup from OVS_USER table
create table OVS_USER_BKP as select * from OVS_USER;

3-Run the command below:
UPDATE OVS_USER set password='testepasswd' where account_name='ADMIN';
commit;

4-Encrypt the password with this command below:
UPDATE OVS_USER set password=create_encrypt_passwd('testepasswd') where account_name='$USER';
commit;


Best Regards,
Paulo Portugal

Mount ISO on Linux

1-Create directory to be used
mkdir -p /mnt/disk

2-Mount using command below:
mount -o loop OracleVM-Manager-2.2.0.iso /mnt/disk


Best Regards,
Paulo Portugal

Creating OVS repository - Oracle VM

1-Create partition using fdisk

2-Make ocfs2
mkfs.ocfs2 /dev/sda4

3-Create repository
./opt/ovs-agent-2.3/utils/repos.py -n /dev/sda4 --options rw,sync

4-List ID for repository
./opt/ovs-agent-2.3/utils/repos.py -l

5-Mark it as a ROOT repos
./opt/ovs-agent-2.3/utils/repos.py -r 12d25384-1eda-4e95-9f91-1b6f304a5587


Best Regards,
Paulo Portugal

adopmnctl.sh httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

If you got message below:

"adopmnctl.sh httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory"

Apply patch 6078836 (that can be downloaded from Metalink).

Best Regards,
Paulo Portugal

Installing RPM packages for EBS R12

RPM packages elfutils-libelf-devel-0.125 and elfutils-libelf-devel-static-0.125 are pre-req for installing Oracle EBS R12.

When you first try to install it separately, it shows failed dependencies error.

To fix it you must install both packages together as follows:

##############################
rpm -Uvh elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:elfutils-libelf-devel-s########################################### [ 50%]
2:elfutils-libelf-devel ########################################### [100%]
##############################

Best Regards,
Paulo Portugal

How to change WEBLOGIC Console admin password for 11g (10.3)

1-First set environment variables
export BEAHOME=/u01/app/oracle/product/middleware
export DOMAIN_HOME=$BEAHOME/user_projects/domains/base_domain
export CLASSPATH=$CLASSPATH:$BEAHOME/wlserver_10.3/server/lib/weblogic.jar
cd $DOMAIN_HOME/bin
. ./setDomainEnv.sh

2- Now execute the command below to create the new password
cd ../security
mv DefaultAuthenticatorInit.ldift oldDefaultAuthenticator
java weblogic.security.utils.AdminAccount weblogic new_password . --DON'T FORGET THE "."


3- If it exists remove boot.properties file

cd ../servers/AdminServer
mv data data_old
cd security/
mv boot.properties oldboot.properties

4- Restart Weblogic server

cd $DOMAIN_HOME./startWebLogic.sh

Best Regards,
Paulo Portugal