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 -kSpeaking about size, note the database is only 16.3Gb datafiles :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 ~]#
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 :
Well, enjoy it !SQL> select language_cd from pslanguages where installed=1;
LANGUAGE_CD
------------
ENG
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:
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
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.
Nicholas, in the /etc/oratab, did you make any changes to that file and/or the db_1 directory?
Thanks,
*Ron
Ron, yes, I changed /etc/oratab with my dbname and ORACLE_HOME, but that does not help to start automatically the db.
Nicolas.
could you please tell me what you did do to make the db start automatically if changing the /etc/oratab didn't work?
Post a Comment