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

Display number values in words

--Create emp table
create table emp
(emp_name varchar2(30),
sal number);

--Insert some data
insert into emp values ('Nome1',1300);
insert into emp values ('Nome2',1400);
insert into emp values ('Nome3',2300);
insert into emp values ('Nome4',5300);
insert into emp values ('Nome5',11300);
commit;

--Query and get number into words
col sal for 99999
col "Extenso" for a70
select sal, (to_char(to_date(sal,'j'), 'jsp')) "Extenso" from emp;

set linesize 140
col parameter for a30
select * from v$nls_valid_values where value like '%BRA%';
alter session set NLS_LANGUAGE='BRAZILIAN PORTUGUESE';
alter session set NLS_TERRITORY='BRAZIL';
export LANG=pt_BR

Regards,
Paulo Portugal