Saturday, November 07, 2009

Peoplesoft VM : about the database image (in VMWare)

I created an virtual machine from the database server template downloaded from edelivery (OVM_EL5U2_X86_64_HCM91_PVM), here are my first screenshots and comments.

1. In Oracle VM Manager, list of the templates downloaded from edelivery :

2. In Oracle VM Manager, list of the virtual machines, created from the Peoplesoft templates :
3. First start of the database VM (OVM_EL5U2_X86_64_HCM91_PVM) :4. Once the VM is in running status, click on "console" button :

5. Enter the VM password :
6. Nice, we arrive on the database server, bare is progressing :
7. Don't configure the DHCP :
8. Give the IP address, netmask, DNS and server name :
9. I want the database start on server boot, and set my own database password :

10. My database name will be H91TMPLT :
11. Finally, first login onto the database server (default root password is ovsroot):


It quite a fast process, if we except the large amount Gb to download and to be created as virtual machine.

So far, only few remarks/bugs :
1. On the first boot of the machine I configured the database to be started on boot (step 9 above), , unfortunately it looks like the database and listener do not start automatically on the virtual machine start.
2. The /etc/oratab does not contain the database name I gave during the first VM setting, but only the following (it could explain the point 1) :
orcl:/u01/app/oracle/product/11.1.0/db_1:N

3. The database password given on the first VM boot are not taken in account, e.g. SYSTEM's password is manager, not the one I gave during the initialization (step 9 described above)
4. An other point, the image is about 60Gb, but less than 30Gb are used onto the VM, that's a pitty, so much wasting space onto the host for nothing :
[root@psovmdb ~]# df -k
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/xvda2 3177204 1039168 2138036 33% /
/dev/xvda1 31077 8277 21196 29% /boot
tmpfs 2097152 0 2097152 0% /dev/shm
/dev/xvdb1 9851308 4478364 4872524 48% /u01
/dev/xvdc1 25806268 19211972 5283396 79% /opt/oracle/psft/ptdb
[root@psovmdb ~]#
Speaking about size, note the database is only 16.3Gb datafiles :
SQL> select sum(bytes)/1024/1024 from dba_data_files
2 union all
3 select sum(bytes)/1024/1024 from dba_temp_files;

SUM(BYTES)/1024/1024
--------------------
16007
320
SQL>

5. Be aware, the SYSADM's password is in capital letter :
SQL> conn sysadm/sysadm
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn sysadm/SYSADM
Connected.
SQL>

6. Only English language is installed :
SQL> select language_cd from pslanguages where installed=1;

LANGUAGE_CD
------------
ENG
Well, enjoy it !

7. (added the 21st of MARCH 2010 ) : the password of PEOPLE and SYSADM is limited in time, please read my post here

Nicolas.

5 comments:

Sean said...

Hi Nicholas

Nice posting... what kind of hardware are you running all of this on? What is the host OS?

Cheers,
Sean Carroll
www.seanfcarroll.com

Nicolas Gasparotto said...

Sean,
It is a DELL PowerEdge 2900 III, OS is CentOS5.4, Oracle VMs images are running into VMWare 2.0.2.
Please, find all the description of my environment in my previous post :
http://gasparotto.blogspot.com/2009/11/oracle-vm-template-for-peoplesoft-in.html

I'll keep posting for App/Batch and Web server desfription as well.

Nicolas.

Ron said...

Nicholas, in the /etc/oratab, did you make any changes to that file and/or the db_1 directory?

Thanks,

*Ron

Nicolas Gasparotto said...

Ron, yes, I changed /etc/oratab with my dbname and ORACLE_HOME, but that does not help to start automatically the db.

Nicolas.

Unknown said...

could you please tell me what you did do to make the db start automatically if changing the /etc/oratab didn't work?