In the ERP world I have always been in the Oracle E-Business camp. Nothing against SAP just never had any reason to work with it but know a few lads who do. Obviously, Oracle 'E-Biz' has an Oracle database at the back of it and most SAP sites use Oracle too (as far as I can tell) even though SAP is database independent. I feel SAP and E-Biz is a bit like the Solaris or Linux, X-Box or PS4 debate. It really depends on what you want.
However HANA which is a in memory "vertical" database and is supposed to be very quick can be used with SAP and is prob one of the reasons why you might go down the SAP road. Oracle have had "TimesTen" around for a long time but I have never worked anywhere that would pay for it or had a need to use it.
There is a lot of debate on the web but if anyone has any real world experience of both please let me know. Really quick in-memory databases are great but for a lot of sites they want a Ford Transit for load not a Ferrari for speed.
http://www.oracle.com/technetwork/database/options/dbim-vs-sap-hana-2215625.pdf
Grid Infrastructure Removal / ASM disks Oracle VM box
These notes from Oracle Base can be used to remove a failed Grid Infrastructure install but I have added the piece below as I hit a problem with ASM disks on Oracle Virtual box.
https://oracle-base.com/articles/rac/clean-up-a-failed-grid-infrastructure-installation
Following a failed RAC attack install, tried to delete and then add the asm disks.
However, Oracle Virtaul box holds onto the disk information and won't let you add a disk with the same name. The solution is to use vboxmanage from the cmd prompt.
In the example below, removes the 5gig ASM disk.
C:\Program Files\Oracle\VirtualBox>vboxmanage list hdds
UUID: a35460c0-eef6-4bc5-a706-66dbddce04d7
Parent UUID: base
State: inaccessible
Type: shareable
Location: C:\racattack12c\asm1.vdi
Storage format: VDI
Capacity: 5120 MBytes
Encryption: disabled
UUID: 266df39c-8e4b-40cf-8c34-500d69ee1ab9
Parent UUID: base
State: created
Type: normal (base)
Location: C:\racattack12c\collabn2.vdi
Storage format: VDI
Capacity: 30720 MBytes
Encryption: disabled
UUID: cfec563f-a1a2-489c-922c-808fbaa3e984
Parent UUID: base
State: created
Type: normal (base)
Location: C:\racattack12c\collabn1.vdi
Storage format: VDI
Capacity: 30720 MBytes
Encryption: disabled
C:\Program Files\Oracle\VirtualBox>vboxmanage closemedium a35460c0-eef6-4bc5-a706-66dbddce04d7 --delete
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
C:\Program Files\Oracle\VirtualBox>vboxmanage list hdds
UUID: 266df39c-8e4b-40cf-8c34-500d69ee1ab9
Parent UUID: base
State: created
Type: normal (base)
Location: C:\racattack12c\collabn2.vdi
Storage format: VDI
Capacity: 30720 MBytes
Encryption: disabled
UUID: cfec563f-a1a2-489c-922c-808fbaa3e984
Parent UUID: base
State: created
Type: normal (base)
Location: C:\racattack12c\collabn1.vdi
Storage format: VDI
Capacity: 30720 MBytes
Encryption: disabled
--Syntax to resize disk
C:\Program Files\Oracle\VirtualBox>.\VBoxManage.exe modifyhd "C:\Users\206545\VirtualBox VMs\collabn1\collabn1.vdi" --resize 20480
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Headless
In the good old days, most Unix boxes needed to have a keyboard, video and mouse plugged in or they got most upset. One solution is to use KVM over IP from the likes of Avocent. You plug a dongle into the back of the server and use the network to access the box remotely.
Another option is to go headless (needs some config changes) by enabling ssh, VNC, etc then disconnecting the monitor, keyboard and mouse. Power up a second computer on the same network, start the ssh client and log on to the headless server. You will find little difference between working from the console and the remote access connection. I only mention this as it a term a lot of IT people
never come across. In the Windows world there is something called "Server Core" installation and I think that is the closest you can get to a headless server. If anyone with a Windows background would like to enlighten us please feel free.
One thing I would advise is to fit your racks with switched rack power distribution Units (PDUs) to provide advanced load monitoring combined with remote on/off switching control of individual outlets for power cycling, delayed power sequencing, and outlet use management. At least then
you can try the switch it back off and back on again approach (handy on Sunday mornings or 3am call outs) but be aware this is last resort, always shutdown gracefully if you can.
Subscribe to:
Posts (Atom)