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














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.
Hi Nicholas
ReplyDeleteNice posting... what kind of hardware are you running all of this on? What is the host OS?
Cheers,
Sean Carroll
www.seanfcarroll.com
Sean,
ReplyDeleteIt 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?
ReplyDeleteThanks,
*Ron
Ron, yes, I changed /etc/oratab with my dbname and ORACLE_HOME, but that does not help to start automatically the db.
ReplyDeleteNicolas.
could you please tell me what you did do to make the db start automatically if changing the /etc/oratab didn't work?
ReplyDelete