dave malpass

Oracle Database 11g Express Edition Installation

Posted on November 3, 2011 by admin

Download Oracle XE from Oracle.

rpm -i oracle-xe-11.2.0-1.0.x86_64.rpm

Executing post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.

[root@database Disk1]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration

————————————————-

This will configure on-boot properties of Oracle Database 11g Express

Edition. The following questions will determine whether the database should

be starting upon system boot, the ports it will use, and the passwords that

will be used for database accounts. Press to accept the defaults.

Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same

password will be used for SYS and SYSTEM. Oracle recommends the use of

different passwords for each database account. This can be done after

initial configuration:

Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener…

—

echo “source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh” >> /home/oracle/.bash_profile

After you install Oracle Database XE, its graphical user interface is only available from the local server, but not remotely.

The following will correct the problem if necessary:

su – oracle

sqlplus / as sysdba

At the SQL prompt, enter the following command:

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

exit

-
reboot

access apex remotely now at http://hostname:8080/apex/apex_admin

user = admin
password = whateveruenteredatinstall

Posted in Computers | Tagged 11g, installation, linux, oracle xe | Leave a comment

Extending LVM volume on Linux root partition using XenServer

Posted on October 21, 2011 by admin

The first disk of a XenServer guest VM is called xvda, the second disk (the one we added) is called xvdb. We start with the creation of a Physical Volume (PV) on the extra disk.

pvcreate /dev/xvdb

Then we extend the existing Volume Group (VG) called VolGroup00.

vgextend VolGroup00 /dev/xvdb

Then we extend the Logical Volume (LV) by the size of the extra disk, in this case 8GB.

lvextend -L8G /dev/VolGroup00/LogVol00

Finally we resize the filesystem that uses this LV.

resize2fs /dev/VolGroup00/LogVol00

Posted in Computers | Leave a comment

Oracle Virtual Server 3.0.2 patch has been released

Posted on October 10, 2011 by admin

You will want to upgrade your 3.0.1 OVM Manager to the latest patch release 3.0.2.

Download the patch from http://support.oracle.com and the patch is called p13036236_30_Linux-x86-64.zip

Unzip and copy the iso to your OVMM machine.

mount -o loop OracleVM-Manager-3.0.x.iso /OVMCD

cd /OVMCD

./runUpgrader.sh

Posted in Computers | Leave a comment

Oracle Virtual Server 3.0 VM Migration from OVM 2.2

Posted on September 30, 2011 by admin

I know that this software is a new and fairly different version from OVM 2.2 but Oracle has been working on this over over 3 years! At least there should have been some documentation on how to migrate / move existing OVM 2.2 running VMs over to the new version. Gafff

Anyway, you can probably tell I have been at this for some time and frustrated. But here is how you do it.

Install new OVM 3.0.1 on new hardware. There is no Software upgrade at all.
Go into your OVM 2.x /OVS/running_pool directory and tar up individually your VMs like this

tar -cvzf vm1.tgz vm1/

Copy this vm1.tgz file to a running webserver inside your network (WHAT?!! YES!)
Once hosted on http://fred.my.lan/vm1.tgz you can import into your OVM 3.0 environment.
From the OVM 3.0 Console. Goto “Server Pools” / “Templates” / “Choose Blue Import Template” and add your internal webserver and file location http://fred.my.lan/vm1.tgz
When finished you will need to choose “Clone Template to VM” from that same menu on Server Pools.
This will just ask you some questions regarding the existin VM make sure you choose Xen PVM and update your network settings if needed, otherwise it won’t let you Clone.

More to come … help me

So must spent another few hours trying to get connected to the VM consoles. They used to have passwords associated with them which were stored in the vm.cfg. Apparently that hasn’t been fully implemented yet either https://forums.oracle.com/forums/thread.jspa?messageID=9899756

Connect to your VM through the OVM Manager using Right Click on each VM and choosing “Console”
The password is the Weblogic / OVM Server credentials that were entered when server was installed. “admin / whateverpassword”

—–

Found another issue with OVM 3.0

One of my 2 servers only had one interface so

Posted in Computers | Tagged Migration, Oracle, OVM 3.0 | Leave a comment

Oracle Virtual Server 3.0 Upgrade / Install

Posted on September 29, 2011 by admin

I am upgrading my OVM 2.2 Server and Manager components to 3.0.1

First of all, there is no clean upgrade path for the OVM Manager or Servers. You have to install new and then import your existing Virtual Servers as well as all VM Templates and resources.

My existing environment included 2 OVM 2.2 servers running on 2 x 8GB AMD x4 955′s and 1 OVM Manager running on OEL5 32 bit VirtualBox image.

Step 1

Install new OVM 3.01 manager on OEL 5.5 64 Linux or higher. I built this using VirtualBox running on my Winders7 AMD x6 8GB RAM system. The base architecture of the manager has changed from a simple OC4J based application server to a full Oracle Weblogic 11g using ADF framework. Needless to say, it need a bunch more resources.

VirtualBox Configuration:
OEL 5 update 5 64bit
4096GB RAM
35GB Disk
1 cpu core

The Network mode on the VirtualBox needed to be “Bridged” using an additional wireless USB adapter. This was due to the Manager needing to actuall be on the internal home network (pingable) as well as the OVM Manager needs to be able to access the NAS mounts for repository setup.

—
Please select an installation type:
1: Simple
2: Standard
3: Uninstall
4: Help

Select Number (1-4): 1

Starting simple installation …

Verifying installation prerequisites …

One password is used for all users created and used during the installation.
Enter a password for all logins used during the installation:
Enter a password for all logins used during the installation (confirm):

Verifying configuration …

Start installing the configured components:
1: Continue
2: Abort

Select Number (1-2): 1
Step 1 of 9 : Database …
Installing Database …

Retrieving Oracle Database 11g XE …
Installing Oracle Database 11g XE …
Configuring Oracle Database 11g XE …
Step 2 of 9 : Java …
Installing Java …
Step 3 of 9 : Database Schema …
Creating database schema ‘ovs’ …
Step 4 of 9 : WebLogic …
Retrieving Oracle WebLogic Server 11g …
Installing Oracle WebLogic Server 11g …

Step 5 of 9 : ADF …
Retrieving Oracle Application Development Framework (ADF) …
Unzipping Oracle ADF …
Installing Oracle ADF …

Step 6 of 9 : Oracle VM …
Retrieving Oracle VM Manager Application …
Extracting Oracle VM Manager Application …
Installing Oracle VM Manager Core …
Step 7 of 9 : Domain creation …
Creating Oracle WebLogic Server domain …
Starting Oracle WebLogic Server 11g …
Configuring data source ‘OVMDS’ …
Creating Oracle VM Manager user ‘admin’ …
Step 8 of 9 : Deploy …
Deploying Oracle VM Manager Core container …
Deploying Oracle VM Manager UI Console …
Deploying Oracle VM Manager Help …
Enabling HTTPS …
Granting ovm-admin role to user ‘admin’ …

Step 9 of 9 : Oracle VM Manager Shell …
Retrieving Oracle VM Manager Shell & API …
Extracting Oracle VM Manager Shell & API …
Installing Oracle VM Manager Shell & API …

Retrieving Oracle VM Manager Upgrade tool …
Extracting Oracle VM Manager Upgrade tool …
Installing Oracle VM Manager Upgrade tool …
Copying Oracle VM Manager shell to ‘/usr/bin/ovm_shell.sh’ …
Installing ovm_admin.sh in ‘/u01/app/oracle/ovm-manager-3/bin’ …
Installing ovm_upgrade.sh in ‘/u01/app/oracle/ovm-manager-3/bin’ …
Enabling Oracle VM Manager service …
Oracle VM Manager installed.

Installation Summary
——————–
Database configuration:
Database host name          : localhost
Database instance name (SID): XE
Database listener port      : 1521
Application Express port    : 8080
Oracle VM Manager schema    : ovs

Weblogic Server configuration:
Administration username : weblogic

Oracle VM Manager configuration:
Username                    : admin
Core management port        : 54321
UUID                        : 0004fb000001000004f4d09a3a740e9c

Passwords:
There are no default passwords for any users. The passwords to use for Oracle VM Manager, Oracle Database 11g XE, and Oracle WebLogic Server have been set by you during this installation. In the case of a default install, all passwords are the same.

Oracle VM Manager UI:

http://localhost.localdomain:7001/ovm/console

https://localhost.localdomain:7002/ovm/console

Please note that you need to install tight-vnc on this computer to access a virtual machine’s console.

For more information about Oracle Virtualization, please visit:

http://www.oracle.com/virtualization/

Oracle VM Manager installation complete

Next you need to make sure you have your existing Repository backed up or stored on NAS somewhere. This is because during the upgrade / migration, you will need to import your existing VMs.

Put in the 3.0.1 DVD and follow the 3 minute installation procedure basically just adding your hostname and IP address.

After completion you should have a generic 1 to 2 ethernet server that is capable of hosting your VMs

Network configuration is as follows:

bond0     Link encap:Ethernet  HWaddr 00:0E:2E:60:71:40
          inet addr:192.168.2.89  Bcast:192.168.2.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MASTER MULTICAST  MTU:1500  Metric:1
          RX packets:71434 errors:0 dropped:0 overruns:0 frame:0
          TX packets:116916 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:12097769 (11.5 MiB)  TX bytes:151946398 (144.9 MiB)

eth0      Link encap:Ethernet  HWaddr 00:0E:2E:60:71:40
          UP BROADCAST RUNNING SLAVE MULTICAST  MTU:1500  Metric:1
          RX packets:71434 errors:0 dropped:0 overruns:0 frame:0
          TX packets:116916 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:12097769 (11.5 MiB)  TX bytes:151946398 (144.9 MiB)
          Interrupt:20 Base address:0x2c00

eth1      Link encap:Ethernet  HWaddr 00:0E:2E:60:7C:9E
          BROADCAST MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)
          Interrupt:21 Base address:0x6800

lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:790 errors:0 dropped:0 overruns:0 frame:0
          TX packets:790 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:169064 (165.1 KiB)  TX bytes:169064 (165.1 KiB)

Posted in Computers | Tagged install, Oracle Virtual Server, OVM, Upgrade | Leave a comment

OuterBanks 2011

Posted on April 10, 2011 by admin

Stardate 4/8/11

Left Cleveland at 6:30pm headed south… hmmm

8 hours later very tired stopped at Best Western somewhere in Virgina..
Next morning had nice breakfast at the hotel included. Donuts, waffles mmm

4 and 1/2 hours later we arrived at the OuterBanks NC. Kill Devil Hills, NC to be exact. Amy had booked a beautiful condo on the beach with all the ameneties you could ask for.

Day 1

1st went to the Wright Brothers National Memorial Museum followed by the Wright Brothers National Monument…

Posted in Vacations | Leave a comment

Oracle Virtual Server quirks

Posted on February 13, 2011 by admin

The VNC console for OVM 2.2 doesn’t work out of the box. You need to add a few component so that your can manage your environment using TightVNC.

You may have noticed that when you clicked on the VNC Port to connect to VM, you received “load: class VncViewer.class not found”
This is because the tightvnc and ovm-console components aren’t installed by default.

To fix:

goto http://oss.oracle.com/oraclevm/manager/RPMS/ and download / install
ovm-console-1.0.0-2.i386.rpm
tightvnc-java-1.3.9-3.noarch.rpm

This allows IE and Chrome browser connections to manage Oracle Virtual Machines.

Posted in Computers | Tagged Oracle Virtual Server, VNC | Leave a comment

Victrola new toy!

Posted on January 30, 2011 by admin

Picked up this 1911 Victrola Talking Machine. Also known as a record player. Needed a little tuning but sounds amazing. How does so much sound come from a non-electric device? I should be refinishing it soon and will update with new pics.

Technology at its best!

Posted in Audio | Leave a comment

Google Down?

Posted on December 31, 2010 by admin

12:08 pm 12/31/10 can’t get to google, confirmed on a few PCs.

Posted in Uncategorized | Leave a comment

Redhat RAID5 setup

Posted on November 10, 2010 by admin

This article shows how to create a 3 SATA DISK RAID5 confgiuration using Oracle Enterprise Linux 5.5 aka Redhat 5.5.

I used a small 40GB drive the boot drive. This could have been anything including another Mirror but I didn’t go that nuts with my failover. I just wanted to make sure that if one of my primary DATA disks went bad, I would be able to recover with just buying another 54 dollar TB drive.

Load OEL 5.5 on 40GB IDE or SATA drive.
fdisk each of the SATA drives setting the format type to “fd”

Command (m for help): n

Command action

e extended

p primary partition (1-4)

Partition number (1-4): 1

First cylinder (1-121601, default 1):

Using default value 1

Last cylinder or +size or +sizeM or +sizeK (1-121601, default 121601):

Using default value 121601

Command (m for help): p

Disk /dev/sdc: 1000.2 GB, 1000204886016 bytes

255 heads, 63 sectors/track, 121601 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/dev/sdc1 1 121601 976760001 83 Linux

Command (m for help): t

Selected partition 1

Hex code (type L to list codes): fd

Changed system type of partition 1 to fd (Linux raid autodetect)

Command (m for help): w

The partition table has been altered!

Command (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 1First cylinder (1-121601, default 1): Using default value 1Last cylinder or +size or +sizeM or +sizeK (1-121601, default 121601): Using default value 121601
Command (m for help): p
Disk /dev/sdc: 1000.2 GB, 1000204886016 bytes255 heads, 63 sectors/track, 121601 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System/dev/sdc1 1 121601 976760001 83 Linux
Command (m for help): tSelected partition 1Hex code (type L to list codes): fdChanged system type of partition 1 to fd (Linux raid autodetect)
Command (m for help): wThe partition table has been altered!

Then run the following mdadm command line to create RAID 5 array

mdadm –create –verbose /dev/md0 –level=5 –raid-devices=3 /dev/sda1 /dev/sdb1 /dev/sdc1

Check your work to make sure the configuration is enabled.

cat /proc/mdstat

Personalities : [raid6] [raid5] [raid4]

md0 : active raid5 sdc1[3] sdb1[1] sda1[0]

1953522816 blocks level 5, 64k chunk, algorithm 2 [3/2] [UU_]

[>....................] recovery = 0.1% (1053748/976761408) finish=568.6min speed=28594K/sec

Next make your filesystem on /dev/md0

mkfs.ext3 /dev/md0

mke2fs 1.39 (29-May-2006)

Filesystem label=

OS type: Linux

Block size=4096 (log=2)

Fragment size=4096 (log=2)

244203520 inodes, 488380704 blocks

24419035 blocks (5.00%) reserved for the super user

First data block=0

Maximum filesystem blocks=0

14905 block groups

32768 blocks per group, 32768 fragments per group

16384 inodes per group

Superblock backups stored on blocks:

32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,

4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968,

102400000, 214990848

The configuration of your raid is unfortunately not saved until you run the following:

mdadm –detail –scan –verbose > /etc/mdadm.conf

Create your mount point directory

mkdir /mnt/DATA

Edit your /etc/fstab to include the following:

/dev/md0 /mnt/DATA ext3 defaults 1 2

mount your new 3 TB (now only 1.9 TB) drive.

mount -a