Share this
Install EBS 12.2.2 Vision in Virtualbox from OVM templates
by Pythian Marketing on Dec 20, 2013 8:54:00 AM
Update, 7 March 2014:
I don't often suggest this, but: stop reading this post! Oracle has (finally, yay!) released VM templates for EBS 12.2.3 that can be imported to Virtualbox directly! If you want an EBS 12.2 sandbox in Virtualbox, you don't need to follow the instructions in my blog post. Instead, review these two documents:
Oracle VM Virtual Appliances Available for E-Business Suite Release 12.2.3 (Steven Chan's blog)
and
Note 1620448.1: Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.3Section 2 of the My Oracle Support note should have all of the information you need to import the appliances into Virtualbox. It's all far less complicated: no rescue boot, no mkinitrd, no config file tweaking. Just download, unpack, import, and go!
Last year, I wrote a blog post about installing Oracle E-Business Suite 12.1.3 in Virtualbox using templates designed for Oracle VM Server. It was a surprisingly popular post, and I enjoyed engaging with a lot of enthusiastic readers in the comments. With minimal OS configuration, no installer to run, and automated scripts provided by Oracle to create the instance, the appeal of having an "out-of-the-box" EBS Vision instance was huge, especially for non-Apps DBAs. The ability to deploy these templates in Virtualbox increases their accessibility for EBS technology enthusiasts who lack access to OVM server.
Well, the EBS 12.2 OVM templates are out, so it's time to get busy with the new stuff! With a few small tweaks, easily illustrated in this blog post, you can have a working E-Business Suite 12.2.2 sandbox running in Virtualbox, without building your own servers from ground up, running an installer, or applying any patches.
What's different this time?
If you're familiar with the 12.1.3 version of these instructions, you'll notice a few differences in this post:
- No need to download a new kernel to replace the Xen kernel used by OVM. The kernel you need is already included; you just need to tell the server how to load it. This simplifies our lives quite a bit.
- We're building a single-node Vision instance this time, instead of multi-node. This was a pretty common request from readers of the 12.1.3 post, and I wanted to reduce the amount of VM resources I was using on my personal lab machine.
- The resource footprint of the VM has changed significantly, particularly the memory requirements. The introduction of WebLogic Server (WLS) to the E-Business Suite techstack, along with the duplicated apps tier filesystem required to support online patching, have bulked up an already-hefty Vision instance.
- You'll notice the "One hour of work!" tagline is missing from this post. It's probably still pretty close, since the long-running steps are hands-off, but I didn't use a stopwatch this time.
Finally, of course, you'll find that in general, the EBS 12.2 tech stack is a much different animal than 12.1. :)
Caveats
You really should not follow this guide if...
... you are an Apps DBA. Release 12.2 is very new. If you take this "shortcut," you are depriving yourself of a lot of learning opportunities: new install processes, patching practice, etc.
... you have an underpowered test system (< 2CPU, < 8GB RAM). The specs I'm using for this blog post are the bare minimum. You might be tempted to cut corners, but you'll be setting yourself up for pain later on.
... you don't know your license status. The OVM templates (and EBS software in general) are not "free to install, free to learn" content like you'll find on OTN. Tread carefully, and know what your support contract permits you to do!
... you need support from anyone (not even me, I can only point the way). OVM templates were not designed for use in VirtualBox, and furthermore, these templates were designed to be used in a multi-node (1 db tier, 1 app tier). This single-node Vision instance in VirtualBox is a double-Frankenstein job. Set your expectations accordingly.
... you have an OVM server at your disposal. Seriously, why jump through these hoops if you don't have to?
Okay, let's recap! No Apps DBAs, no underpowered test systems, no overpowered test systems, no support, no guarantees that it'll even work. Now that I've eliminated 90% of my potential audience, let's plow forward, shall we?
Ingredients
You will need:
- Oracle VirtualBox
- Lots of disk space. Final footprint will be about 325GB, but the intermediary file conversion steps require a lot of space. You should be fine with a 1 TB drive.
- 8GB of memory. Minimum. WLS is a beast, baby! Rawr!
- The previous requirement means that your host system needs to be capable of addressing that much memory, so a 32-bit host OS will not work here.
- 2 CPU cores, minimum. This will be slow enough as it is, why add the additional delay of db and app tier fighting each other for a single CPU core?
- OEL 5.x install media to act as a rescue boot disk. We don't need to download a new kernel, but we still need to boot in rescue mode to tinker a little bit.
- An understanding of some basic Linux systems administration tasks.
- Familiarity with configuring storage and network options in Virtualbox.
- Not strictly required, but a review of Note 1590941.1 would be a good idea. Most of the content is obviously set in an Oracle VM Server context, but there's some useful information there about extracting the templates and using the configuration scripts.
- Patience! Long downloads, file conversions...you're looking at hours of waiting for things to complete.
Configuration steps
When following these instructions, note that some of the commands and output may appear to be truncated. Even if you don't see a scrollbar, scroll right to get the rest of the content. Once I figure out a less awkward presentation method, I'll update.
- Download the templates
Connect to Oracle’s Software Delivery Cloud and download the files listed under Oracle VM Templates for Oracle E-Business Suite Release 12.2.2 Media Pack for x86 (64 bit)".For this exercise, you'll need to download "Oracle E-Business Suite Release 12.2.2 Application Tier Install X86 (64 bit), Parts 1-3 (Part numbers V41235-01 - V41237-01)" and "Oracle E-Business Suite Release 12.2.2 Vision Demo Database Tier Install X86 (64 bit), Parts 1-4 (Part numbers V41171-01 - V41173-01)." I also recommend clicking the “View Digest ” button near the top of the download page, and running md5sum on each of the downloaded zip files to make sure the checksums match that list."If you want to confirm that you're in the right place, Steven Chan's post announcing the templates has a screenshot of the Edelivery page. - Extract the templates
Note: If you’re using Windows and don’t have a Unix-like shell environment like Cygwin available, you may have to translate some of these steps to their Windows-y equivalents. Since we’re just concatenating and uncompressing files, I will assume you can do that. :-)- Unzip all the files you just downloaded (
unzip 'V41*.zip'
). This will produce two sets of files: OVM_OL5U9_X86_64_EBIZ12.2_VIS_DB_PVM.tgz.* (database tier template) and OVM_OL5U9_X86_64_EBIZ12.2_APPS_PVM.tgz.* (apps tier template). - Concatenate and uncompress the two sets of files:
zathras:EBS122OVMTempl time cat OVM_OL5U9_X86_64_EBIZ12.2_APPS_PVM.tgz* | tar xvz -C /Volumes/Epsilon3/EBS\ Software/EBS122OVMTempl
x OVM_OL5U9_X86_64_EBIZ12.2_APPS_PVM/
x OVM_OL5U9_X86_64_EBIZ12.2_APPS_PVM/vm.cfg
x OVM_OL5U9_X86_64_EBIZ12.2_APPS_PVM/EBS.img
x OVM_OL5U9_X86_64_EBIZ12.2_APPS_PVM/System.img
real 150m42.754s
user 12m38.850s
sys 6m37.271s
zathras:EBS122OVMTempl jpiwowar$ time cat OVM_OL5U9_X86_64_EBIZ12.2_VIS_DB_PVM.tgz.* | tar xvz -C '/Volumes/Epsilon3/EBS Software/EBS122OVMTempl'
x OVM_OL5U9_X86_64_EBIZ12.2_VIS_DB_PVM/
x OVM_OL5U9_X86_64_EBIZ12.2_VIS_DB_PVM/vm.cfg
x OVM_OL5U9_X86_64_EBIZ12.2_VIS_DB_PVM/EBS.img
x OVM_OL5U9_X86_64_EBIZ12.2_VIS_DB_PVM/System.img
real 154m40.689s
user 14m33.270s
sys 6m42.356s
- Unzip all the files you just downloaded (
- Convert the disk image files to VDI format
Use the vboxmanage command-line utility to convert the database System.img file and the EBS.img files from both tiers to VDI format. You'll note that the final size of the apps tier VDI file is much smaller than its source. This is expected; the VDI files are dynamic, and only contain about 50GB of data despite having a max size of 250GB. Also note that we're only converting the images we need; since this will be a single-node instance, we don't need the apps tier System.img file.
zathras:OVM_OL5U9_X86_64_EBIZ12.2_VIS_DB_PVM jpiwowar$ vboxmanage convertfromraw System.img /Volumes/Europa/OVM122/app/DBRoot.vdi; vboxmanage convertfromraw EBS.img /Volumes/Europa/OVM122/app/DBData.vdi
Converting from raw image file="System.img" to file="/Volumes/Europa/OVM122/app/DBRoot.vdi"...
Creating dynamic image with size 36284923904 bytes (34604MB)...
Converting from raw image file="EBS.img" to file="/Volumes/Europa/OVM122/app/DBData.vdi"...
Creating dynamic image with size 268435456000 bytes (256000MB)...
zathras:OVM_OL5U9_X86_64_EBIZ12.2_APPS_PVM jpiwowar$ vboxmanage convertfromraw EBS.img /Volumes/Europa/OVM122/app/AppSoftware.vdi
Converting from raw image file="EBS.img" to file="/Volumes/Europa/OVM122/app/AppSoftware.vdi"...
Creating dynamic image with size 268435456000 bytes (256000MB)... - Configure your VirtualBox VM
Since we're doing a single-node Vision install, we only need one VM. Here are the specs:- OS: Oracle Linux, 64-bit
- CPUs: 2
- Memory: 8GB (more if you have it available)
- Device boot order: CD-ROM, Hard Disk
- Storage: Attach Linux installation ISO to CD/DVD drive on the IDE controller and attach the three vdi files to the SATA controller, in the following order: DBRoot.vdi, DBData.vdi, AppSoftware.vdi
- Network: At least one network interface, either Host-only or Bridged. If you choose Host-only, I recommend adding a second interface that uses NAT, so you can reach external (non-host) networks from your VM. If you use Bridged networking you don't need this second interface.
The screenshot below shows the final configuration of my VM:
- Boot VM in rescue mode from the install CD (round 1)
Enter “linux rescue
” at the the boot: prompt to enter rescue mode:
Select the keyboard and language preferences that suit you, and select "No" when asked about configuring network interfaces. We don't need them at this stage.
Select "Continue" at the "Rescue" screen to look for a Linux installation.
If you attached your disks properly, you will get a "Duplicate Labels" warning. This is because both the Vision database and Apps software disks have the same LVM label (EBS). We will fix that in the next step. For now, keep going by selecting the "Reboot" option. DO NOT ACTUALLY RESTART YOUR VM FROM THE VIRTUALBOX MENU, JUST HIT 'ENTER'. You'll find that the "reboot button" does not in fact, reboot the VM. Take a moment to savor the irony, then move on.
Select OK when you get the sad news about not finding a Linux installation:
Now we can fix our pesky disk label problem, as shown below. Once complete, exit to reboot the VM so we can continue with the real work.When finished please exit from the shell and your system will reboot.
sh-3.2# e2label /dev/sdb1
EBS
sh-3.2# e2label /dev/sdc1
EBS
sh-3.2# e2label /dev/sdc1 EBSAPPS
sh-3.2# e2label /dev/sdc1
EBSAPPS
sh-3.2# exit - Boot VM in rescue mode from the install CD (round 2)
Follow the same steps as above to boot in rescue mode. This time, the rescue boot should find a Linux installation, and give you the option to mount it. This is where we'll make some adjustments to configure the server to use the correct kernel and mount both disks.- First, switch the root volume from from the rescue system to the OVM template
Your system is mounted under the /mnt/sysimage directory.
When finished please exit from the shell and your system will reboot.
sh-3.2# chroot /mnt/sysimage - Then, adjust /etc/fstab to include a mount point for the Apps tier filesystem. Make sure you set the last field in the EBS and EBSAPPS lines to '0' to avoid the possibility of a lengthy fsck of those volumes during boot.
sh-3.2# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 18G 2.2G 15G 14% /
/dev/sda1 99M 51M 44M 54% /boot
/dev/sdb1 247G 184G 50G 79% /u01
sh-3.2# cat /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-VM swap swap defaults 0 0
LABEL=EBS /u01 ext3 defaults 1 2
sh-3.2# cp /etc/fstab /etc/fstab.bak
sh-3.2# vi /etc/fstab
"/etc/fstab" 9L, 684C written
sh-3.2# cat /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-VM swap swap defaults 0 0
LABEL=EBS /u01 ext3 defaults 1 0
LABEL=EBSAPPS /u02 ext3 defaults 1 0
sh-3.2# mkdir /u02
sh-3.2# mount /u02
sh-3.2# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 18G 2.2G 15G 14% /
/dev/sda1 99M 51M 44M 54% /boot
/dev/sdb1 247G 184G 50G 79% /u01
/dev/sdc1 247G 53G 182G 23% /u02 - Finally, run mkinitrd make the system use the already-installed non-Xen kernel (make sure you get the whole command here, it may be truncated on the page).
sh-3.2# mkinitrd -v -f /boot/initrd-2.6.39-300.17.2.el5uek.img 2.6.39-300.17.2.el5uek
Creating initramfs
Modulefile is /etc/modprobe.conf
Looking for deps of module ehci-hcd
Looking for deps of module ohci-hcd
Looking for deps of module uhci-hcd
Looking for deps of module ext3: mbcache jbd
Looking for deps of module mbcache
Looking for deps of module jbd
Found root device sda2 for LABEL=/
Looking for driver for device sda2
Looking for deps of module pci:v00008086d00002829sv00000000sd00000000bc01sc06i01: libahci ahci libahci ahci
Looking for deps of module libahci
Looking for deps of module ahci: libahci
Looking for deps of module iscsi_tcp: scsi_transport_iscsi libiscsi libiscsi_tcp
Looking for deps of module scsi_transport_iscsi
Looking for deps of module libiscsi: scsi_transport_iscsi
Looking for deps of module libiscsi_tcp: scsi_transport_iscsi libiscsi
Looking for deps of module sr_mod: cdrom
Looking for deps of module cdrom
Looking for deps of module sd_mod: crc-t10dif
Looking for deps of module crc-t10dif
Looking for driver for device sda3
Looking for deps of module pci:v00008086d00002829sv00000000sd00000000bc01sc06i01: libahci ahci libahci ahci
Looking for deps of module xenblk: xen-blkfront
Looking for deps of module xen-blkfront
Looking for deps of module ide-disk
Looking for deps of module dm-mem-cache
Looking for deps of module dm-region_hash: dm-mod dm-log dm-region-hash
Looking for deps of module dm-mod
Looking for deps of module dm-log: dm-mod
Looking for deps of module dm-region-hash: dm-mod dm-log
Looking for deps of module dm-message
Looking for deps of module dm-raid45
Using modules: /lib/modules/2.6.39-300.17.2.el5uek/kernel/fs/mbcache.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/fs/jbd/jbd.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/fs/ext3/ext3.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/ata/libahci.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/ata/ahci.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/scsi_transport_iscsi.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/libiscsi.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/libiscsi_tcp.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/iscsi_tcp.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/cdrom/cdrom.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/sr_mod.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/lib/crc-t10dif.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/sd_mod.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/block/xen-blkfront.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/md/dm-mod.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/md/dm-log.ko /lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/md/dm-region-hash.ko
/sbin/nash -> /tmp/initrd.qO1496/bin/nash
/sbin/insmod.static -> /tmp/initrd.qO1496/bin/insmod
/etc/udev/rules.d/05-udev-early.rules -> /tmp/initrd.qO1496/etc/udev/rules.d/05-udev-early.rules
/sbin/firmware_helper.static -> /tmp/initrd.qO1496/sbin/firmware_helper
/sbin/udevd.static -> /tmp/initrd.qO1496/sbin/udevd
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/fs/mbcache.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/mbcache.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/fs/jbd/jbd.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/jbd.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/fs/ext3/ext3.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/ext3.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/ata/libahci.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/libahci.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/ata/ahci.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/ahci.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/scsi_transport_iscsi.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/scsi_transport_iscsi.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/libiscsi.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/libiscsi.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/libiscsi_tcp.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/libiscsi_tcp.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/iscsi_tcp.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/iscsi_tcp.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/cdrom/cdrom.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/cdrom.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/sr_mod.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/sr_mod.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/lib/crc-t10dif.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/crc-t10dif.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/scsi/sd_mod.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/sd_mod.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/block/xen-blkfront.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/xen-blkfront.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/md/dm-mod.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/dm-mod.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/md/dm-log.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/dm-log.ko' [elf64-x86-64]
copy from `/lib/modules/2.6.39-300.17.2.el5uek/kernel/drivers/md/dm-region-hash.ko' [elf64-x86-64] to `/tmp/initrd.qO1496/lib/dm-region-hash.ko' [elf64-x86-64]
/sbin/dmraid.static -> /tmp/initrd.qO1496/bin/dmraid
/sbin/kpartx.static -> /tmp/initrd.qO1496/bin/kpartx
Adding module mbcache
Adding module jbd
Adding module ext3
Adding module libahci
Adding module ahci
Adding module scsi_transport_iscsi
Adding module libiscsi
Adding module libiscsi_tcp
Adding module iscsi_tcp
Adding module cdrom
Adding module sr_mod
Adding module crc-t10dif
Adding module sd_mod
Adding module xen-blkfront
Adding module dm-mod
Adding module dm-log
Adding module dm-region-hash
sh-3.2#
- First, switch the root volume from from the rescue system to the OVM template
- Remove the rescue DVD from the VM (menu navigation: Devices->CD/DVD Devices->Remove disk from virtual drive) and exit to reboot the VM. Otherwise, it'll boot from the CD again. If you get a warning about the the drive being in use, choose the "force unmount" option; this won't hurt anything.
sh-3.2# exit
exit
sh-3.2# exit - Network configuration
When the VM reboots, it will run a script included with the OVM template that performs one-time configuration of the network and sets up the 12.2 Vision database. Make sure you choose an IP address which is compatible with your VM's primary network interface. In my case, that's the host-only network vboxnet0, 192.168.56.0/255.255.255.0.IMPORTANT: Before you enter any network configuration info, now would be an excellent time to take a snapshot of your VM (menu navigation: Machine->Take Snapshot). Once network configuration completes, the script will roll directly into configuring the database tier, and if anything breaks during that process, you might have to re-extract and re-convert the template files again. That's not a recipe for fun times. No, I totally didn't (re)-learn this the hard way, why do you ask? ;-)Answer the questions presented by the network configuration script. Unless you're doing something a bit weird, your answers should be similar to mine. Remember the IP, domain, and hostname you choose; you'll need them later.
Welcome to Oracle Linux Oracle Linux Server release 5.9
Press 'I' to enter interactive startup.
Starting udev: [ OK ]
Loading default keymap (us): [ OK ]
[ Some startup output snipped to improve readability.]
Starting oraclevm-template...
Regenerating SSH host keys.
Stopping sshd: [ OK ]
Generating SSH1 RSA host key: [ OK ]
Generating SSH2 RSA host key: [ OK ]
Generating SSH2 DSA host key: [ OK ]
Starting sshd: [ OK ]
=======================================
Configuring Oracle E-Business Suite...
=======================================
=======================================
Configuring the Network...
=======================================
Configuring the Network Interactively
Configuring network interface.
Network device: eth0
Hardware address: 08:00:27:75:30:B6
Do you want to enable dynamic IP configuration (DHCP) (Y|n)?n
Enter static IP address: 192.168.56.58
Enter netmask: [255.255.255.0] [enter to take default]
Enter gateway: 192.168.56.1
Enter DNS server: 8.8.8.8
Shutting down interface eth0: [ OK ]
Shutting down interface eth1: [ OK ]
Shutting down loopback interface: [ OK ]
Configuring network settings.
IP configuration: Static IP address
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
Bringing up interface eth1:
Determining IP information for eth1... done.
[ OK ]
Enter hostname (e.g, host.example.com): coriana6.local.org
Network configuration changed successfully.
IP configuration: Static IP address
IP address: 192.168.56.58
Netmask: 255.255.255.0
Gateway: 10.0.3.2
DNS server: 10.0.3.2
Hostname: coriana6.local.org
=======================================
Disabling the Linux Firewall...
======================================= - Configuration of db tier
After network configuration completes, the template deployment script will invoke Rapid Clone to configure the database tier. All you need to supply at the beginning is the desired SID for the database. Remember that for later, too. :-) When RapidClone completes, you will be prompted to select new passwords for the root and oracle users.==================================================
Prepare the Pairs File for Database Tier Clone...
===================================================
ORACLE_SID is not set in the Pairs File
Enter the Oracle Database SID :VIS122
==========================================================
Adding User oracle
==========================================================
==========================================================
Starting DB Tier configuration
==========================================================
Parameters Used for this Configuration...
The Pairs File :/u01/scripts/inst_db_pairs.txt
The Source context file used :/u01/install/11.2.0/appsutil/clone/context/db/CTXORIG.xml
The Target context file :/u01/install/11.2.0/appsutil/VIS122_coriana6.xml
==========================================================
The Configuration Used to Create this VM...
The Oracle E-Business Suite DBSID : VIS122
The Oracle E-Business Suite DB HostName : %HOSTNAME_NODOMAIN%
The Oracle E-Business Suite DB Domain Name :%DOMAIN%
The Oracle E-Business Suite DB TNS Port :1521
==========================================================
==========================================================
Cloning the DB Tier Context File
==========================================================
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adclonectx Version 120.30.12020000.4
Running:
/u01/install/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/11.2.0/appsutil/clone/bin/../jlib/ojdbc5.jar:/u01/install/11.2.0/appsutil/clone/bin/../jlib/xmlparserv2.jar:/u01/install/11.2.0/appsutil/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /u01/install/11.2.0/appsutil/clone/context/db/CTXORIG.xml -pairsfile /u01/scripts/inst_db_pairs.txt -out /u01/install/11.2.0/appsutil/VIS122_coriana6.xml -noprompt
Log file located at /u01/install/11.2.0/appsutil/log/CloneContext_1219031841.log
Report file located at /u01/install/11.2.0/appsutil/temp/portpool.lst
Complete port information available at /u01/install/11.2.0/appsutil/temp/portpool.lst
Creating the new Database Context file from :
/u01/install/11.2.0/appsutil/clone/context/db/adxdbctx.tmp
The new database context file has been created :
/u01/install/11.2.0/appsutil/VIS122_coriana6.xml
Log file located at /u01/install/11.2.0/appsutil/log/CloneContext_1219031841.log
contextfile=/u01/install/11.2.0/appsutil/VIS122_coriana6.xml
Check Clone Context logfile /u01/install/11.2.0/appsutil/log/CloneContext_1219031841.log for details.
Executing adcfgclone.pl on the Database Tier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.22
stty: standard input: Inappropriate ioctl for device
Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
Running Rapid Clone with command:
Running:
perl /u01/install/11.2.0/appsutil/clone/bin/adclone.pl java=/u01/install/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/install/11.2.0/appsutil/VIS122_coriana6.xml showProgress contextValidated=false
Beginning database tier Apply - Thu Dec 19 03:18:45 2013
/u01/install/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/install/11.2.0/oui -classpath /u01/install/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/install/11.2.0/appsutil/clone/jlib/ojdbc6.jar:/u01/install/11.2.0/appsutil/clone/jlib/java:/u01/install/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/install/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/install/11.2.0/appsutil/clone/jlib/oui/share.jar:/u01/install/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/u01/install/11.2.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /u01/install/11.2.0/appsutil/VIS122_coriana6.xml -stage /u01/install/11.2.0/appsutil/clone -showProgress
APPS Password : Log file located at /u01/install/11.2.0/appsutil/log/VIS122_coriana6/ApplyDBTier_12190318.log
| 0% completed
Log file located at /u01/install/11.2.0/appsutil/log/VIS122_coriana6/ApplyDBTier_12190318.log
Completed Apply...
Thu Dec 19 03:29:35 2013
Starting database listener for VIS122:
Running:
/u01/install/11.2.0/appsutil/scripts/VIS122_coriana6/addlnctl.sh start VIS122
Logfile: /u01/install/11.2.0/appsutil/log/VIS122_coriana6/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process VIS122 ...
Listener VIS122 has already been started.
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/11.2.0/appsutil/log/VIS122_coriana6/addlnctl.txt for more information ...
Cloning the DB Tier Completed Successfully
Logfile: /u01/install/11.2.0/appsutil/log/VIS122_coriana6/addlnctl.txt
You are running addlnctl.sh version 120.4
Shutting down listener process VIS122 ...
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-DEC-2013 03:29:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=coriana6.local.org)(PORT=1521)))
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/11.2.0/appsutil/log/VIS122_coriana6/addlnctl.txt for more information ...
You are running addbctl.sh version 120.1
Shutting down database VIS122 ...
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 19 03:29:35 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
addbctl.sh: exiting with status 0
==========================================================
Enabling the DB Service Startup on Boot
==========================================================
==========================================================
Starting the Oracle E-Business Suite DB Tier Services
==========================================================
Logfile: /u01/install/11.2.0/appsutil/log/VIS122_coriana6/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process VIS122 ...
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-DEC-2013 03:29:44
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/install/11.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/install/11.2.0/network/admin/VIS122_coriana6/listener.ora
Log messages written to /u01/install/11.2.0/admin/VIS122_coriana6/diag/tnslsnr/coriana6/vis122/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=coriana6.local.org)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=coriana6.local.org)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias VIS122
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 19-DEC-2013 03:29:45
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/11.2.0/network/admin/VIS122_coriana6/listener.ora
Listener Log File /u01/install/11.2.0/admin/VIS122_coriana6/diag/tnslsnr/coriana6/vis122/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=coriana6.local.org)(PORT=1521)))
Services Summary...
Service "VIS122" has 1 instance(s).
Instance "VIS122", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/11.2.0/appsutil/log/VIS122_coriana6/addlnctl.txt for more information ...
You are running addbctl.sh version 120.1
Starting the database VIS122 ...
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 19 03:29:45 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2230072 bytes
Variable Size 452987080 bytes
Database Buffers 1660944384 bytes
Redo Buffers 21725184 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
addbctl.sh: exiting with status 0
==========================================================
Changing passwords for the default users
==========================================================
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
Changing password for user root.
New UNIX password:
BAD PASSWORD: it is based on your username
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
=====================INSTALLATION SUMMARY============
The Oracle E-Business Suite DB HostName : coriana6.local.org
The Base Installation Directory : /u01/install
The Oracle Home Location : /u01/install/11.2.0
The Oracle E-Business Suite Data File Dir : /u01/install/data
The Oracle E-Business Suite DBSID : VIS122
The Oracle E-Business Suite DB TNS Port : 1521
==========================================================
Will continue in 10 seconds, or press any key to continue...
Template configuration disabled.
[ OK ] - Prepare the server for apps configuration
Before we can run the configuration script to configure the apps tier of the instance, we need to make a few adjustments. Please note: most of these steps will not be necessary if you're trying to create a two-node instance; they're only required because we're trying to cram two nodes into one server.- Log in as root and adjust permissions on the ping executable. Otherwise, you may encounter issues with concurrent manager startup. This would probably not be necessary if we were using the Apps tier template's root disk.
coriana6.local.org login: root
Password:
Last login: Wed Oct 16 03:42:27 on tty1
[root@coriana6 ~]# ls -l /bin/ping
-rwxr-xr-x 1 root root 37312 Jul 2 2009 /bin/ping
[root@coriana6 ~]# chmod u+s /bin/ping - Next, we need to change the configuration scripts and associated files to use the new mount point for the apps tier filesystems (/u01 is expected by default), and to disable the network configuration steps (since we aren't running the script on a new server, we don't need it):
[root@coriana6 ~]# cd /u02/install/scripts
[root@coriana6 scripts]# ls
apps_pairs.txt config.sh inst_apps_pairs.txt stopapps.sh
cleanup.sh ebizapps.rc startapps.sh
[root@coriana6 scripts]# perl -pi.old -e 's/u01/u02/g' *
[root@coriana6 scripts]# perl -pi.nonet -e 's/ovm_configure_network/echo "Skip ovm_configure_network"/g' config.sh
[root@coriana6 scripts]# diff config.sh config.sh.nonet
79c79
# Call ovm_configure_network function which is part of JeOS function library
115c115
ovm_configure_network
130c130
ovm_configure_network "$IP_ADDR" "$NET_MASK" "$GATEWAY" "$DNS_HOST" "$HOST_NAME"
- Log in as root and adjust permissions on the ping executable. Otherwise, you may encounter issues with concurrent manager startup. This would probably not be necessary if we were using the Apps tier template's root disk.
- Execute the apps tier config script
Now, we're finally ready to go! Execute the config.sh script (still connected as root), and answer the prompts with the values from the configuration of the database tier. I've left the output from my configuration run completely intact as a reference, but the only user inputs required are at the beginning of the process.Please note: Execution of this script will take quite a long time. It took at least an hour on my modest test system. Rapid Clone has to configure both the Run and Patch filesystems, and starts up the application services at the end. There is significant overhead involved in the multiple stops and starts of the WLS components during this process. This would not be as painful on a properly-sized system of course.
[root@coriana6 scripts]# ./config.sh
=======================================
Configuring Oracle E-Business Suite...
=======================================
=======================================
Configuring the Network...
=======================================
Configuring the Network Interactively
Skip ovm_configure_network
=======================================
Disabling the Linux Firewall...
=======================================
==========================================================
Adding User oracle
==========================================================
./config.sh: line 165: [: missing `]'
==================================================
Prepare the Pairs File for Application Tier Clone...
===================================================
==================================================
Checking if the FQDN is > 30 chars...
===================================================
The FQDN is less than 30 characters. Proceeding with the configuration
Database Tier Information is not set in the Pairs File
Prompting the user for Database Tier Information
Enter the Database Tier Host Name (without the domain) :coriana6
Enter the Database Tier Domain Name :local.org
Enter the Oracle Database SID :VIS122
Enter the TNS Listener Port Number :1521
==========================================================
Starting Apps Tier configuration
==========================================================
Parameters Used for this Configuration...
The Pairs File :/u02/install/scripts/inst_apps_pairs.txt
The Source context file used :/u02/install/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml
The Target context file :/u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml
==========================================================
Checking for the DB Host and Database
==========================================================
Pinging the Database Host coriana6.local.org...
The Database Host coriana6.local.org seem to be up
Proceeding with rest of the configuration...
Connected to Database VIS122 on coriana6...
==========================================================
Configuring the VM as a new Application Tier Node
==========================================================
==========================================================
Configuring the Application Tier File System (fs1)
==========================================================
==========================================================
Cloning the Application Tier Context File
==========================================================
Executing the command su oracle -c echo apps|./adclonectx.pl contextfile=/u02/install/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml pairsfile=/u02/install/scripts/inst_apps_pairs.txt outfile=/u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml nopromptmsg
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adclonectx Version 120.30.12020000.4
Running:
/u02/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/install/fs1/EBSapps/comn/clone/bin/../jlib/ojdbc5.jar:/u02/install/fs1/EBSapps/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/install/fs1/EBSapps/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /u02/install/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml -pairsfile /u02/install/scripts/inst_apps_pairs.txt -out /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml -noprompt
Log file located at /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/log/CloneContext_1219072110.log
Target System Base Directory set to /u02/install
Target System Current File System Base set to /u02/install/fs1
Target System Other File System Base set to /u02/install/fs2
Target System Fusion Middleware Home set to /u02/install/fs1/FMW_Home
Target System Web Oracle Home set to /u02/install/fs1/FMW_Home/webtier
Target System Appl TOP set to /u02/install/fs1/EBSapps/appl
Target System COMMON TOP set to /u02/install/fs1/EBSapps/comn
Target System Instance Top set to /u02/install/fs1/inst/apps/VIS122_coriana6
Report file located at /u02/install/fs1/inst/apps/VIS122_coriana6/admin/out/portpool.lst
Complete port information available at /u02/install/fs1/inst/apps/VIS122_coriana6/admin/out/portpool.lst
Creating the new APPL_TOP Context file from :
/u02/install/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml
Log file located at /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/log/CloneContext_1219072110.log
contextfile=/u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml
Check Clone Context logfile /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/log/CloneContext_1219072110.log for details.
Executing the command perl adcfgclone.pl appsTier /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.22
stty: standard input: Inappropriate ioctl for device
Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
Running:
/u02/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/install/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/java:/u02/install/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u02/install/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
stty: standard input: Inappropriate ioctl for device
Enter the Weblogic AdminServer password :
stty: standard input: Inappropriate ioctl for device
Running:
/u02/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/install/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/java:/u02/install/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u02/install/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u02/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/install/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/java:/u02/install/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u02/install/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource
Running Rapid Clone with command:
Running:
perl /u02/install/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u02/install/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u02/install/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml showProgress contextValidated=false
FMW Pre-requisite check log file location : /u02/install/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u02/install/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u02/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u02/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml -stage /u02/install/fs1/EBSapps/comn/clone -log /u02/install/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Thu Dec 19 07:21:38 2013
/u02/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u02/install/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/java:/u02/install/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u02/install/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u02/install/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml -stage /u02/install/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u02/install/fs1/inst/apps/VIS122_coriana6/admin/log/ApplyAppsTier_12190721.log
- 0% completed
Log file located at /u02/install/fs1/inst/apps/VIS122_coriana6/admin/log/ApplyAppsTier_12190721.log
\ 100% completed
Completed Apply...
Thu Dec 19 07:49:40 2013
Executing command: /u02/install/fs1/EBSapps/10.1.2/bin/sqlplus @/u02/install/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql
Do you want to startup the Application Services for VIS122? (y/n) [n] :
Services not started
==========================================================
Configuring the Application Tier File System (fs2)
==========================================================
Copying the Application Tier File System from fs1 to fs2
Executing the command su oracle -c perl adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.22
stty: standard input: Inappropriate ioctl for device
Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
Running:
/u02/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/install/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/java:/u02/install/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u02/install/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
stty: standard input: Inappropriate ioctl for device
Enter the Weblogic AdminServer password :
stty: standard input: Inappropriate ioctl for device
Running:
/u02/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/install/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/java:/u02/install/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u02/install/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u02/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/install/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/java:/u02/install/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u02/install/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource
Do you want to add a node (yes/no) [no] :
Running:
/u02/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u02/install/fs2/EBSapps/comn/clone/jlib/java:/u02/install/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/java:/u02/install/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u02/install/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_26497.lst -stage /u02/install/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_26497.err; echo $? > /tmp/adcfgclone_26497.res
Log file located at /u02/install/fs2/EBSapps/comn/clone/bin/CloneContext_1219075100.log
Target System File Edition type [run] :
Enter the full path of Run File System Context file :
Provide the values required for creation of the new APPL_TOP Context file.
Target System Fusion Middleware Home set to /u02/install/fs2/FMW_Home
Target System Web Oracle Home set to /u02/install/fs2/FMW_Home/webtier
Target System Appl TOP set to /u02/install/fs2/EBSapps/appl
Target System COMMON TOP set to /u02/install/fs2/EBSapps/comn
Target System Instance Top set to /u02/install/fs2/inst/apps/VIS122_coriana6
Target System Port Pool [0-99] :
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u02/install/fs2/inst/apps/VIS122_coriana6/admin/out/portpool.lst
Complete port information available at /u02/install/fs2/inst/apps/VIS122_coriana6/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /u01/install/11.2.0/appsutil/outbound/VIS122_coriana6
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : RC-00208: Error: Not a valid number
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /u01/install/11.2.0/appsutil/outbound/VIS122_coriana6
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : RC-00200: Error: Exception occurred while taking input from user
Creating the new APPL_TOP Context file from :
/u02/install/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u02/install/fs2/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml
Log file located at /u02/install/fs2/EBSapps/comn/clone/bin/CloneContext_1219075100.log
Check Clone Context logfile /u02/install/fs2/EBSapps/comn/clone/bin/CloneContext_1219075100.log for details.
Running Rapid Clone with command:
Running:
perl /u02/install/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u02/install/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u02/install/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u02/install/fs2/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml showProgress contextValidated=true
FMW Pre-requisite check log file location : /u02/install/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u02/install/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u02/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u02/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u02/install/fs2/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml -stage /u02/install/fs2/EBSapps/comn/clone -log /u02/install/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Thu Dec 19 07:51:20 2013
/u02/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u02/install/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/java:/u02/install/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u02/install/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u02/install/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u02/install/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u02/install/fs2/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml -stage /u02/install/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u02/install/fs2/inst/apps/VIS122_coriana6/admin/log/ApplyAppsTier_12190751.log
| 100% completed
Completed Apply...
Thu Dec 19 08:15:33 2013
Looking for incomplete CLONE record in ad_adop_session_patches table
The CLONE record status is no rows selected
Updating incomplete CLONE record to COMPLETED
==========================================================
Enabling the Apps Tier Service Startup on Boot
==========================================================
==========================================================
Enabling the NFS service for shared file system setup
==========================================================
==========================================================
Starting the Oracle E-Business Suite Application tier Services
==========================================================
Starting the Oracle E-Business Suite Application Tier Services
You are running adstrtal.sh version 120.24.12020000.7
The logfile for this session is located at /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/jtffmctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running jtffmctl.sh version 120.3.12020000.4
Validating Fulfillment patch level via /u02/install/fs1/EBSapps/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for VIS122 on port 9300 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/adopmnctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adopmnctl.sh version 120.0.12020000.2
Starting Oracle Process Manager (OPMN) ...
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/adapcctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adapcctl.sh version 120.0.12020000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl start: opmn is already running.
opmnctl startproc: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/adnodemgrctl.sh start -nopromptmsg
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adnodemgrctl.sh version 120.11.12020000.4
Calling txkChkEBSDependecies.pl to perform dependency checks for oacore
Perl script txkChkEBSDependecies.pl got executed successfully
Starting the Node Manager...
NMProcess:
NMProcess: Dec 19, 2013 8:17:48 AM weblogic.nodemanager.server.NMServerConfig initDomainsMap
NMProcess: INFO: Loading domains file: /u02/install/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.domains
NMProcess:
NMProcess: Dec 19, 2013 8:17:48 AM weblogic.nodemanager.server.NMServer
NMProcess: WARNING: Node manager configuration properties file '/u02/install/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.properties' not found. Using default settings.
NMProcess:
NMProcess: Dec 19, 2013 8:17:48 AM weblogic.nodemanager.server.NMServer
NMProcess: INFO: Saving node manager configuration properties to '/u02/install/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.properties'
Refer /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adnodemgrctl.txt for details
adnodemgrctl.sh: exiting with status 0
adnodemgrctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adnodemgrctl.txt for more information ...
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/rgf/TXK/txkChkEBSDependecies_Thu_Dec_19_08_17_07_2013/txkChkEBSDependecies_Thu_Dec_19_08_17_07_2013.log
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/adalnctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
adalnctl.sh version 120.3.12020000.2
Checking for FNDFS executable.
Starting listener process APPS_VIS122.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/adcmctl.sh start
Timeout specified in context file: 1000 second(s)
script returned:
****************************************************
You are running adcmctl.sh version 120.19.12020000.3
Starting concurrent manager for VIS122 ...
Starting VIS122_1219@VIS122 Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/adadminsrvctl.sh start -nopromptmsg
Timeout specified in context file: 1000 second(s)
script returned:
****************************************************
You are running adadminsrvctl.sh version 120.10.12020000.4
Starting WLS Admin Server...
Refer /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adadminsrvctl.txt for details
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adadminsrvctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.6
Starting forms_server1...
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.6
Starting oafm_server1...
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/admanagedsrvctl.sh start forms-c4ws_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.6
Starting forms-c4ws_server1...
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adforms-c4wsctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u02/install/fs1/inst/apps/VIS122_coriana6/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.6
Starting oacore_server1...
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /u02/install/fs1/inst/apps/VIS122_coriana6/logs/appl/admin/log/adstrtal.log for more information ... - At the end of the install, you'll get another opportunity to change the oracle and root passwords (remember, these scripts were designed to run on separate servers), and an install summary:
==========================================================
Change Passwords for the Default Users
==========================================================
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
Changing password for user root.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
===================INSTALLATION SUMMARY=============================
Oracle E-Business Suite Installation Top Level Directory : /u02/install
Oracle E-Business Suite Context File : /u02/install/fs1/inst/apps/VIS122_coriana6/appl/admin/VIS122_coriana6.xml
Oracle E-Business Suite Login Page : https://coriana6.local.org:8000/OA_HTML/AppsLogin
Oracle E-Business Suite Database Tier Host : coriana6.local.org
Oracle E-Business Suite Database SID : VIS122
Oracle E-Business Suite TNS_PORT : 1521
==================================================================
Will continue in 60 seconds, or press any key to continue...
Now what?
Now the real fun begins! If you have added your VM's IP and hostname to the local hosts file on your host machine, you can access your Vision instance at the URL listed after "Oracle E-Business Suite Login Page" at the end of the Apps tier Rapic Clone run. The default password for the admin user (SYSADMIN) is the same as it always is.
A few more things to note:
- Use the
startapps.sh
andstopapps.sh
scripts in/u02/install/scripts/
to (wait for it...) start and stop the Apps. Note that these scripts expect to be run by user oracle, not root. Also, these scripts have default passwords for the apps and weblogic users hard-coded in them, so if you change those passwords, you'll need to update the scripts. Or you can just use the normal service start/stop scripts, but these wrapper scripts sure are convenient. ;) - Similarly, you'll find start/stop scripts for database services in
/u01/scripts
(startdb.sh
andstopdb.sh
). These also need to be run as oracle. - Since this is a single-node system with both tiers owned by oracle, keeping your OS environment straight might take some practice. Try to remember to do database and apps work in separate sessions. To set the environment for the apps tier, use the script /u02/install/EBSapps.env (in most cases, you will want to set the "run" environment, e.g. "
. /u02/install/EBSapps.env run
" ). To set the environment for the database tier, invoke the /u01/install/11.2.0/SID_hostname.env file (e.g. ". /u01/install/11.2.0/VIS122_coriana6.env
"). If you're still learning Linux/Unix, please remember that you need to invoke these scripts with a leading "dot+space" as in the preceding examples, or the environment variable values will not be exported to your session. - The first time you try to log into your instance after starting it up, it will be probably be painfully slow. Subsequent logins and similar operations will merely be slow.
- The first time I visited the login page and the initial Navigator page for the Vision instance, I had a few "Unable to load" errors for some components on the page. I found that a refresh of the page resolved these issues. I had similar issues upon launching Forms. It takes time for some of these things to be cached, and the default timeout values on the server might not be configured for workstation-grade test systems.
- The WLS EM Console, if you need it, will be on port 7001 of your instance (e.g. https://coriana6.local.org:7001/em). Log in with user 'weblogic', with the password in the startapps.sh script.
- The WLS Admin console for your instance is also on port 7001, at the following URL: https://your_host.your_domain:7001/console (e.g. https://coriana6.local.org:7001/console). Log in to this interface with the 'weblogic' user, too.
- In general, unless you find issues with services not starting up cleanly, you probably won't need the WLS URLs very much. Unless you're an Apps DBA, and hopefully you're not, because I said at the very beginning that this post is not for Apps DBAs. ;-)
- Oh, and the 12.2.3 patchset has just been released, so if you'd like some patching practice... ;-)
I want to do something slightly different!
Maybe all of this just isn't weird enough, and you would like to either:
- Install the Production OVM templates instead of the Vision templates (Hi John!), or
- Deploy the Vision templates in a two-node configuration
In either case, you should be able to find your way based on the instructions in this post. The only "magic" happening here is rescue boot and mkinitrd command to allow the use of the non-Xen kernel. After that, most of the steps should be more or less the same. In the first case listed above (production database templates), the only thing that changes is which database templates you download: parts V41175-V41177 instead of parts V41171-V41173. While I haven't checked, presumably the network and db tier configuration script is going to be the same. In the second case (two-node configuration), you won't need to worry about changing disk labels or altering /etc/fstab, but you will have to convert the Apps root disk to a VDI file, and do the mkinitrd steps twice. Also, when allocating resources for the two-node instance, I recommend a minimum of 6GB of memory for the app tier and 2GB for the database tier. Please note that I haven't tried either approach; these are just educated guesses based on doc review and looking at the configuration scripts. If you're successful with either of these alternative deployments, I'd love to hear about it in the comments!
Ok, we're done! You can now give yourself (or an ORACLENERD you care about) the gift of an EBS 12.2.2 Vision instance, just in time for the holidays! Start downloading now, though, if you want to be ready by Christmas. ;)
Good luck, and happy playing!
Share this
- Technical Track (969)
- Oracle (400)
- MySQL (137)
- Cloud (131)
- Open Source (90)
- Google Cloud (83)
- DBA Lounge (76)
- Microsoft SQL Server (76)
- Technical Blog (74)
- Big Data (52)
- AWS (49)
- Google Cloud Platform (47)
- Cassandra (44)
- DevOps (41)
- Azure (38)
- Pythian (33)
- Linux (30)
- Database (26)
- Podcasts (25)
- Site Reliability Engineering (25)
- Performance (24)
- SQL Server (24)
- Microsoft Azure (23)
- Oracle E-Business Suite (23)
- PostgreSQL (23)
- Oracle Database (22)
- Docker (21)
- Group Blog Posts (20)
- Security (20)
- DBA (19)
- Log Buffer (19)
- SQL (19)
- Exadata (18)
- Mongodb (18)
- Oracle Cloud Infrastructure (OCI) (18)
- Oracle Exadata (18)
- Automation (17)
- Hadoop (16)
- Oracleebs (16)
- Amazon RDS (15)
- Ansible (15)
- Ebs (15)
- Snowflake (15)
- ASM (13)
- BigQuery (13)
- Patching (13)
- RDS (13)
- Replication (13)
- Data (12)
- GenAI (12)
- Kubernetes (12)
- Oracle 12C (12)
- Advanced Analytics (11)
- Backup (11)
- LLM (11)
- Machine Learning (11)
- OCI (11)
- Rman (11)
- Cloud Migration (10)
- Datascape Podcast (10)
- Monitoring (10)
- R12 (10)
- 12C (9)
- AI (9)
- Apache Cassandra (9)
- Data Guard (9)
- Infrastructure (9)
- Oracle 19C (9)
- Oracle Applications (9)
- Python (9)
- Series (9)
- AWR (8)
- Amazon Web Services (AWS) (8)
- Articles (8)
- High Availability (8)
- Oracle EBS (8)
- Percona (8)
- Powershell (8)
- Recovery (8)
- Weblogic (8)
- Apache Beam (7)
- Backups (7)
- Data Governance (7)
- Goldengate (7)
- Innodb (7)
- Migration (7)
- Myrocks (7)
- OEM (7)
- Oracle Enterprise Manager (OEM) (7)
- Performance Tuning (7)
- Authentication (6)
- ChatGPT-4 (6)
- Data Enablement (6)
- Database Performance (6)
- E-Business Suite (6)
- Fmw (6)
- Grafana (6)
- Oracle Enterprise Manager (6)
- Orchestrator (6)
- Postgres (6)
- Rac (6)
- Renew Refresh Republish (6)
- RocksDB (6)
- Serverless (6)
- Upgrade (6)
- 19C (5)
- Azure Data Factory (5)
- Azure Synapse Analytics (5)
- Cpu (5)
- Data Visualization (5)
- Disaster Recovery (5)
- Error (5)
- Generative AI (5)
- Google BigQuery (5)
- Indexes (5)
- Love Letters To Data (5)
- Mariadb (5)
- Microsoft (5)
- Proxysql (5)
- Scala (5)
- Sql Server Administration (5)
- VMware (5)
- Windows (5)
- Xtrabackup (5)
- Airflow (4)
- Analytics (4)
- Apex (4)
- Best Practices (4)
- Centrally Managed Users (4)
- Cli (4)
- Cloud FinOps (4)
- Cloud Spanner (4)
- Cockroachdb (4)
- Configuration Management (4)
- Container (4)
- Data Management (4)
- Data Pipeline (4)
- Data Security (4)
- Data Strategy (4)
- Database Administrator (4)
- Database Management (4)
- Database Migration (4)
- Dataflow (4)
- Dbsat (4)
- Elasticsearch (4)
- Fahd Mirza (4)
- Fusion Middleware (4)
- Google (4)
- Io (4)
- Java (4)
- Kafka (4)
- Middleware (4)
- Mysql 8 (4)
- Network (4)
- Ocidtab (4)
- Opatch (4)
- Oracle Autonomous Database (Adb) (4)
- Oracle Cloud (4)
- Pitr (4)
- Post-Mortem Analysis (4)
- Prometheus (4)
- Redhat (4)
- September 9Th 2015 (4)
- Sql2016 (4)
- Ssl (4)
- Terraform (4)
- Workflow (4)
- 2Fa (3)
- Alwayson (3)
- Amazon Relational Database Service (Rds) (3)
- Apache Kafka (3)
- Apexexport (3)
- Aurora (3)
- Azure Sql Db (3)
- Cdb (3)
- ChatGPT (3)
- Cloud Armor (3)
- Cloud Database (3)
- Cloud Security (3)
- Cluster (3)
- Consul (3)
- Cosmos Db (3)
- Cost Management (3)
- Covid19 (3)
- Crontab (3)
- Data Analytics (3)
- Data Integration (3)
- Database 12C (3)
- Database Monitoring (3)
- Database Troubleshooting (3)
- Database Upgrade (3)
- Databases (3)
- Dataops (3)
- Dbt (3)
- Digital Transformation (3)
- ERP (3)
- Google Chrome (3)
- Google Cloud Sql (3)
- Graphite (3)
- Haproxy (3)
- Heterogeneous Database Migration (3)
- Hugepages (3)
- Inside Pythian (3)
- Installation (3)
- Json (3)
- Keras (3)
- Ldap (3)
- Liquibase (3)
- Love Letter (3)
- Lua (3)
- Mfa (3)
- Multitenant (3)
- Mysql 5.7 (3)
- Mysql Configuration (3)
- Nginx (3)
- Nodetool (3)
- Non-Tech Articles (3)
- Oem 13C (3)
- Oms (3)
- Oracle 18C (3)
- Oracle Data Guard (3)
- Oracle Live Sql (3)
- Oracle Rac (3)
- Patch (3)
- Perl (3)
- Pmm (3)
- Pt-Online-Schema-Change (3)
- Rdbms (3)
- Recommended (3)
- Remote Teams (3)
- Reporting (3)
- Reverse Proxy (3)
- S3 (3)
- Spark (3)
- Sql On The Edge (3)
- Sql Server Configuration (3)
- Sql Server On Linux (3)
- Ssis (3)
- Ssis Catalog (3)
- Stefan Knecht (3)
- Striim (3)
- Sysadmin (3)
- System Versioned (3)
- Systemd (3)
- Temporal Tables (3)
- Tensorflow (3)
- Tools (3)
- Tuning (3)
- Vasu Balla (3)
- Vault (3)
- Vulnerability (3)
- Waf (3)
- 18C (2)
- Adf (2)
- Adop (2)
- Agent (2)
- Agile (2)
- Amazon Data Migration Service (2)
- Amazon Ec2 (2)
- Amazon S3 (2)
- Apache Flink (2)
- Apple (2)
- Apps (2)
- Ashdump (2)
- Atp (2)
- Audit (2)
- Automatic Backups (2)
- Autonomous (2)
- Autoupgrade (2)
- Awr Data Mining (2)
- Azure Sql (2)
- Azure Sql Data Sync (2)
- Bash (2)
- Business (2)
- Business Intelligence (2)
- Caching (2)
- Cassandra Nodetool (2)
- Cdap (2)
- Certification (2)
- Cloning (2)
- Cloud Cost Optimization (2)
- Cloud Data Fusion (2)
- Cloud Hosting (2)
- Cloud Infrastructure (2)
- Cloud Shell (2)
- Cloud Sql (2)
- Cloudscape (2)
- Cluster Level Consistency (2)
- Conferences (2)
- Consul-Template (2)
- Containerization (2)
- Containers (2)
- Cosmosdb (2)
- Costs (2)
- Cql (2)
- Cqlsh (2)
- Cyber Security (2)
- Data Discovery (2)
- Data Migration (2)
- Data Quality (2)
- Data Streaming (2)
- Data Warehouse (2)
- Database Consulting (2)
- Database Migrations (2)
- Dataguard (2)
- Datapump (2)
- Ddl (2)
- Debezium (2)
- Dictionary Views (2)
- Dms (2)
- Docker-Composer (2)
- Dr (2)
- Duplicate (2)
- Ecc (2)
- Elastic (2)
- Elastic Stack (2)
- Em12C (2)
- Encryption (2)
- Enterprise Data Platform (EDP) (2)
- Enterprise Manager (2)
- Etl (2)
- Events (2)
- Exachk (2)
- Filter Driver (2)
- Flume (2)
- Full Text Search (2)
- Galera (2)
- Gemini (2)
- General Purpose Ssd (2)
- Gh-Ost (2)
- Gke (2)
- Google Workspace (2)
- Hanganalyze (2)
- Hdfs (2)
- Health Check (2)
- Historical Trends (2)
- Incremental (2)
- Infiniband (2)
- Infrastructure As Code (2)
- Innodb Cluster (2)
- Innodb File Structure (2)
- Innodb Group Replication (2)
- Install (2)
- Internals (2)
- Java Web Start (2)
- Kibana (2)
- Log (2)
- Log4J (2)
- Logs (2)
- Memory (2)
- Merge Replication (2)
- Metrics (2)
- Mutex (2)
- MySQLShell (2)
- NLP (2)
- Neo4J (2)
- Node.Js (2)
- Nosql (2)
- November 11Th 2015 (2)
- Ntp (2)
- Oci Iam (2)
- Oem12C (2)
- Omspatcher (2)
- Opatchauto (2)
- Open Source Database (2)
- Operational Excellence (2)
- Oracle 11G (2)
- Oracle Datase (2)
- Oracle Extended Manager (Oem) (2)
- Oracle Flashback (2)
- Oracle Forms (2)
- Oracle Installation (2)
- Oracle Io Testing (2)
- Pdb (2)
- Podcast (2)
- Puppet (2)
- Pythian Europe (2)
- R12.2 (2)
- Redshift (2)
- Remote DBA (2)
- Remote Sre (2)
- SAP (2)
- SAP HANA Cloud (2)
- Sap Migration (2)
- Scale (2)
- Schema (2)
- September 30Th 2015 (2)
- September 3Rd 2015 (2)
- Shell (2)
- Simon Pane (2)
- Single Sign-On (2)
- Sql Server On Gke (2)
- Sqlplus (2)
- Sre (2)
- Ssis Catalog Error (2)
- Ssisdb (2)
- Standby (2)
- Statspack Mining (2)
- Systemstate Dump (2)
- Tablespace (2)
- Technical Training (2)
- Tempdb (2)
- Tfa (2)
- Throughput (2)
- Tls (2)
- Tombstones (2)
- Transactional Replication (2)
- User Groups (2)
- Vagrant (2)
- Variables (2)
- Virtual Machine (2)
- Virtual Machines (2)
- Virtualbox (2)
- Web Application Firewall (2)
- Webinars (2)
- X5 (2)
- scalability (2)
- //Build2019 (1)
- 11G (1)
- 12.1 (1)
- 12Cr1 (1)
- 12Cr2 (1)
- 18C Grid Installation (1)
- 2022 (1)
- 2022 Snowflake Summit (1)
- AI Platform (1)
- AI Summit (1)
- Actifio (1)
- Active Directory (1)
- Adaptive Hash Index (1)
- Adf Custom Email (1)
- Adobe Flash (1)
- Adrci (1)
- Advanced Data Services (1)
- Afd (1)
- After Logon Trigger (1)
- Ahf (1)
- Aix (1)
- Akka (1)
- Alloydb (1)
- Alter Table (1)
- Always On (1)
- Always On Listener (1)
- Alwayson With Gke (1)
- Amazon (1)
- Amazon Athena (1)
- Amazon Aurora Backtrack (1)
- Amazon Efs (1)
- Amazon Redshift (1)
- Amazon Sagemaker (1)
- Amazon Vpc Flow Logs (1)
- Amdu (1)
- Analysis (1)
- Analytical Models (1)
- Analyzing Bigquery Via Sheets (1)
- Anisble (1)
- Annual Mysql Community Dinner (1)
- Anthos (1)
- Apache (1)
- Apache Nifi (1)
- Apache Spark (1)
- Application Migration (1)
- Architect (1)
- Architecture (1)
- Ash (1)
- Asmlib (1)
- Atlas CLI (1)
- Audit In Postgres (1)
- Audit In Postgresql (1)
- Auto Failover (1)
- Auto Increment (1)
- Auto Index (1)
- Autoconfig (1)
- Automated Reports (1)
- Automl (1)
- Autostart (1)
- Awr Mining (1)
- Aws Glue (1)
- Aws Lake Formation (1)
- Aws Lambda (1)
- Azure Analysis Services (1)
- Azure Blob Storage (1)
- Azure Cognitive Search (1)
- Azure Data (1)
- Azure Data Lake (1)
- Azure Data Lake Analytics (1)
- Azure Data Lake Store (1)
- Azure Data Migration Service (1)
- Azure Dma (1)
- Azure Dms (1)
- Azure Document Intelligence (1)
- Azure Integration Runtime (1)
- Azure OpenAI (1)
- Azure Sql Data Warehouse (1)
- Azure Sql Dw (1)
- Azure Sql Managed Instance (1)
- Azure Vm (1)
- Backup For Sql Server (1)
- Bacpac (1)
- Bag (1)
- Bare Metal Solution (1)
- Batch Operation (1)
- Batches In Cassandra (1)
- Beats (1)
- Best Practice (1)
- Bi Publisher (1)
- Binary Logging (1)
- Bind Variables (1)
- Bitnami (1)
- Blob Storage Endpoint (1)
- Blockchain (1)
- Browsers (1)
- Btp Architecture (1)
- Btp Components (1)
- Buffer Pool (1)
- Bug (1)
- Bugs (1)
- Build 2019 Updates (1)
- Build Cassandra (1)
- Bundle Patch (1)
- Bushy Join (1)
- Business Continuity (1)
- Business Insights (1)
- Business Process Modelling (1)
- Business Reputation (1)
- CAPEX (1)
- Capacity Planning (1)
- Career (1)
- Career Development (1)
- Cassandra-Cli (1)
- Catcon.Pm (1)
- Catctl.Pl (1)
- Catupgrd.Sql (1)
- Cbo (1)
- Cdb Duplication (1)
- Certificate (1)
- Certificate Management (1)
- Chaos Engineering (1)
- Cheatsheet (1)
- Checkactivefilesandexecutables (1)
- Chmod (1)
- Chown (1)
- Chrome Enterprise (1)
- Chrome Security (1)
- Cl-Series (1)
- Cleanup (1)
- Cloud Browser (1)
- Cloud Build (1)
- Cloud Consulting (1)
- Cloud Data Warehouse (1)
- Cloud Database Management (1)
- Cloud Dataproc (1)
- Cloud Foundry (1)
- Cloud Manager (1)
- Cloud Migations (1)
- Cloud Networking (1)
- Cloud SQL Replica (1)
- Cloud Scheduler (1)
- Cloud Services (1)
- Cloud Strategies (1)
- Cloudformation (1)
- Cluster Resource (1)
- Cmo (1)
- Cockroach Db (1)
- Coding Benchmarks (1)
- Colab (1)
- Collectd (1)
- Columnar (1)
- Communication Plans (1)
- Community (1)
- Compact Storage (1)
- Compaction (1)
- Compliance (1)
- Compression (1)
- Compute Instances (1)
- Compute Node (1)
- Concurrent Manager (1)
- Concurrent Processing (1)
- Configuration (1)
- Consistency Level (1)
- Consolidation (1)
- Conversational AI (1)
- Covid-19 (1)
- Cpu Patching (1)
- Cqlsstablewriter (1)
- Crash (1)
- Create Catalog Error (1)
- Create_File_Dest (1)
- Credentials (1)
- Cross Platform (1)
- CrowdStrike (1)
- Crsctl (1)
- Custom Instance Images (1)
- Cve-2022-21500 (1)
- Cvu (1)
- Cypher Queries (1)
- DBSAT 3 (1)
- Dacpac (1)
- Dag (1)
- Data Analysis (1)
- Data Analytics Platform (1)
- Data Box (1)
- Data Classification (1)
- Data Cleansing (1)
- Data Encryption (1)
- Data Engineering (1)
- Data Estate (1)
- Data Flow Management (1)
- Data Insights (1)
- Data Integrity (1)
- Data Lake (1)
- Data Leader (1)
- Data Lifecycle Management (1)
- Data Lineage (1)
- Data Masking (1)
- Data Mesh (1)
- Data Migration Assistant (1)
- Data Migration Service (1)
- Data Mining (1)
- Data Modeling (1)
- Data Monetization (1)
- Data Policy (1)
- Data Profiling (1)
- Data Protection (1)
- Data Retention (1)
- Data Safe (1)
- Data Sheets (1)
- Data Summit (1)
- Data Vault (1)
- Data Warehouse Modernization (1)
- Database Auditing (1)
- Database Consultant (1)
- Database Link (1)
- Database Modernization (1)
- Database Provisioning (1)
- Database Provisioning Failed (1)
- Database Replication (1)
- Database Scaling (1)
- Database Schemas (1)
- Database Security (1)
- Databricks (1)
- Datadog (1)
- Datafile (1)
- Datapatch (1)
- Dataprivacy (1)
- Datascape 59 (1)
- Datasets (1)
- Datastax Cassandra (1)
- Datastax Opscenter (1)
- Datasync Error (1)
- Db_Create_File_Dest (1)
- Dbaas (1)
- Dbatools (1)
- Dbcc Checkident (1)
- Dbms_Cloud (1)
- Dbms_File_Transfer (1)
- Dbms_Metadata (1)
- Dbms_Service (1)
- Dbms_Stats (1)
- Dbupgrade (1)
- Deep Learning (1)
- Delivery (1)
- Devd (1)
- Dgbroker (1)
- Dialogflow (1)
- Dict0Dict (1)
- Did You Know (1)
- Direct Path Read Temp (1)
- Disk Groups (1)
- Disk Management (1)
- Diskgroup (1)
- Dispatchers (1)
- Distributed Ag (1)
- Distribution Agent (1)
- Documentation (1)
- Download (1)
- Dp Agent (1)
- Duet AI (1)
- Duplication (1)
- Dynamic Sampling (1)
- Dynamic Tasks (1)
- E-Business Suite Cpu Patching (1)
- E-Business Suite Patching (1)
- Ebs Sso (1)
- Ec2 (1)
- Edb Postgresql Advanced Server (1)
- Edb Postgresql Password Verify Function (1)
- Editions (1)
- Edp (1)
- El Carro (1)
- Elassandra (1)
- Elk Stack (1)
- Em13Cr2 (1)
- Emcli (1)
- End of Life (1)
- Engineering (1)
- Enqueue (1)
- Enterprise (1)
- Enterprise Architecture (1)
- Enterprise Command Centers (1)
- Enterprise Manager Command Line Interface (Em Cli (1)
- Enterprise Plus (1)
- Episode 58 (1)
- Error Handling (1)
- Exacc (1)
- Exacheck (1)
- Exacs (1)
- Exadata Asr (1)
- Execution (1)
- Executive Sponsor (1)
- Expenditure (1)
- Export Sccm Collection To Csv (1)
- External Persistent Volumes (1)
- Fail (1)
- Failed Upgrade (1)
- Failover In Postgresql (1)
- Fall 2021 (1)
- Fast Recovery Area (1)
- FinOps Strategy (1)
- Flash Recovery Area (1)
- Flashback (1)
- Fnd (1)
- Fndsm (1)
- Force_Matching_Signature (1)
- Fra Full (1)
- Framework (1)
- Freebsd (1)
- Fsync (1)
- Function-Based Index (1)
- GCVE Architecture (1)
- GPQA (1)
- Gaming (1)
- Garbagecollect (1)
- Gcp Compute (1)
- Gcp-Spanner (1)
- Geography (1)
- Geth (1)
- Getmospatch (1)
- Git (1)
- Global Analytics (1)
- Gmail (1)
- Gmail Security (1)
- Google Analytics (1)
- Google Cloud Architecture Framework (1)
- Google Cloud Data Services (1)
- Google Cloud Partner (1)
- Google Cloud Spanner (1)
- Google Cloud VMware Engine (1)
- Google Compute Engine (1)
- Google Dataflow (1)
- Google Datalab (1)
- Google Grab And Go (1)
- Google Sheets (1)
- Gp2 (1)
- Graph Algorithms (1)
- Graph Databases (1)
- Graph Inferences (1)
- Graph Theory (1)
- GraphQL (1)
- Graphical User Interface (Gui) (1)
- Grid (1)
- Grid Infrastructure (1)
- Griddisk Resize (1)
- Grp (1)
- Guaranteed Restore Point (1)
- Guid Mismatch (1)
- HR Technology (1)
- HRM (1)
- Ha (1)
- Hang (1)
- Hashicorp (1)
- Hbase (1)
- Hcc (1)
- Hdinsight (1)
- Healthcheck (1)
- Hemantgiri S. Goswami (1)
- Hortonworks (1)
- How To Install Ssrs (1)
- Hr (1)
- Httpchk (1)
- Https (1)
- Huge Pages (1)
- HumanEval (1)
- Hung Database (1)
- Hybrid Columnar Compression (1)
- Hyper-V (1)
- Hyperscale (1)
- Hypothesis Driven Development (1)
- Ibm (1)
- Identity Management (1)
- Idm (1)
- Ilom (1)
- Imageinfo (1)
- Impdp (1)
- In Place Upgrade (1)
- Incident Response (1)
- Indempotent (1)
- Indexing In Mongodb (1)
- Influxdb (1)
- Information (1)
- Infrastructure As A Code (1)
- Injection (1)
- Innobackupex (1)
- Innodb Concurrency (1)
- Innodb Flush Method (1)
- Insights (1)
- Installing (1)
- Instance Cloning (1)
- Integration Services (1)
- Integrations (1)
- Interactive_Timeout (1)
- Interval Partitioning (1)
- Invisible Indexes (1)
- Io1 (1)
- IoT (1)
- Iops (1)
- Iphone (1)
- Ipv6 (1)
- Iscsi (1)
- Iscsi-Initiator-Utils (1)
- Iscsiadm (1)
- Issues (1)
- It Industry (1)
- It Teams (1)
- JMX Metrics (1)
- Jared Still (1)
- Javascript (1)
- Jdbc (1)
- Jinja2 (1)
- Jmx (1)
- Jmx Monitoring (1)
- Jvm (1)
- Jython (1)
- K8S (1)
- Kernel (1)
- Key Btp Components (1)
- Kfed (1)
- Kill Sessions (1)
- Knapsack (1)
- Kubeflow (1)
- LMSYS Chatbot Arena (1)
- Large Pages (1)
- Latency (1)
- Latest News (1)
- Leadership (1)
- Leap Second (1)
- Limits (1)
- Line 1 (1)
- Linkcolumn (1)
- Linux Host Monitoring (1)
- Linux Storage Appliance (1)
- Listener (1)
- Loadavg (1)
- Lock_Sga (1)
- Locks (1)
- Log File Switch (Archiving Needed) (1)
- Logfile (1)
- Looker (1)
- Lvm (1)
- MMLU (1)
- Managed Instance (1)
- Managed Services (1)
- Management (1)
- Management Servers (1)
- Marketing (1)
- Marketing Analytics (1)
- Martech (1)
- Masking (1)
- Megha Bedi (1)
- Metadata (1)
- Method-R Workbench (1)
- Metric (1)
- Metric Extensions (1)
- Michelle Gutzait (1)
- Microservices (1)
- Microsoft Azure Sql Database (1)
- Microsoft Build (1)
- Microsoft Build 2019 (1)
- Microsoft Ignite (1)
- Microsoft Inspire 2019 (1)
- Migrate (1)
- Migrating Ssis Catalog (1)
- Migrating To Azure Sql (1)
- Migration Checklist (1)
- Mirroring (1)
- Mismatch (1)
- Model Governance (1)
- Monetization (1)
- MongoDB Atlas (1)
- MongoDB Compass (1)
- Ms Excel (1)
- Msdtc (1)
- Msdtc In Always On (1)
- Msdtc In Cluster (1)
- Multi-IP (1)
- Multicast (1)
- Multipath (1)
- My.Cnf (1)
- MySQL Shell Logical Backup (1)
- MySQLDump (1)
- Mysql Enterprise (1)
- Mysql Plugin For Oracle Enterprise Manager (1)
- Mysql Replication Filters (1)
- Mysql Server (1)
- Mysql-Python (1)
- Nagios (1)
- Ndb (1)
- Net_Read_Timeout (1)
- Net_Write_Timeout (1)
- Netcat (1)
- Newsroom (1)
- Nfs (1)
- Nifi (1)
- Node (1)
- November 10Th 2015 (1)
- November 6Th 2015 (1)
- Null Columns (1)
- Nullipotent (1)
- OPEX (1)
- ORAPKI (1)
- O_Direct (1)
- Oacore (1)
- October 21St 2015 (1)
- October 6Th 2015 (1)
- October 8Th 2015 (1)
- Oda (1)
- Odbcs (1)
- Odbs (1)
- Odi (1)
- Oel (1)
- Ohs (1)
- Olvm (1)
- On-Prem To Azure Sql (1)
- On-Premises (1)
- Onclick (1)
- Open.Canada.Ca (1)
- Openstack (1)
- Operating System Monitoring (1)
- Oplog (1)
- Opsworks (1)
- Optimization (1)
- Optimizer (1)
- Ora-01852 (1)
- Ora-7445 (1)
- Oracle 19 (1)
- Oracle 20C (1)
- Oracle Cursor (1)
- Oracle Database 12.2 (1)
- Oracle Database Appliance (1)
- Oracle Database Se2 (1)
- Oracle Database Standard Edition 2 (1)
- Oracle Database Upgrade (1)
- Oracle Database@Google Cloud (1)
- Oracle Exadata Smart Scan (1)
- Oracle Licensing (1)
- Oracle Linux Virtualization Manager (1)
- Oracle Oda (1)
- Oracle Openworld (1)
- Oracle Parallelism (1)
- Oracle Rdbms (1)
- Oracle Real Application Clusters (1)
- Oracle Reports (1)
- Oracle Security (1)
- Oracle Wallet (1)
- Orasrp (1)
- Organizational Change (1)
- Orion (1)
- Os (1)
- Osbws_Install.Jar (1)
- Oui Gui (1)
- Output (1)
- Owox (1)
- Paas (1)
- Package Deployment Wizard Error (1)
- Parallel Execution (1)
- Parallel Query (1)
- Parallel Query Downgrade (1)
- Partitioning (1)
- Partitions (1)
- Password (1)
- Password Change (1)
- Password Recovery (1)
- Password Verify Function In Postgresql (1)
- Patches (1)
- Patchmgr (1)
- Pdb Duplication (1)
- Penalty (1)
- Perfomrance (1)
- Performance Schema (1)
- Pg 15 (1)
- Pg_Rewind (1)
- Pga (1)
- Pipeline Debugging (1)
- Pivot (1)
- Planning (1)
- Plsql (1)
- Policy (1)
- Polybase (1)
- Post-Acquisition (1)
- Post-Covid It (1)
- Postgresql Complex Password (1)
- Postgresql With Repmgr Integration (1)
- Power Bi (1)
- Pq (1)
- Preliminar Connection (1)
- Preliminary Connection (1)
- Privatecloud (1)
- Process Mining (1)
- Production (1)
- Productivity (1)
- Profile In Edb Postgresql (1)
- Programming (1)
- Prompt Engineering (1)
- Provisioned Iops (1)
- Provisiones Iops (1)
- Proxy Monitoring (1)
- Psu (1)
- Public Cloud (1)
- Pubsub (1)
- Purge (1)
- Purge Thread (1)
- Pythian Blackbird Acquisition (1)
- Pythian Goodies (1)
- Pythian News (1)
- Python Pandas (1)
- Query Performance (1)
- Quicksight (1)
- Quota Limits (1)
- R12 R12.2 Cp Concurrent Processing Abort (1)
- R12.1.3 (1)
- REF! (1)
- Ram Cache (1)
- Rbac (1)
- Rdb (1)
- Rds_File_Util (1)
- Read Free Replication (1)
- Read Latency (1)
- Read Only (1)
- Read Replica (1)
- Reboot (1)
- Recruiting (1)
- Redo Size (1)
- Relational Database Management System (1)
- Release (1)
- Release Automation (1)
- Repair (1)
- Replication Compatibility (1)
- Replication Error (1)
- Repmgr (1)
- Repmgrd (1)
- Reporting Services 2019 (1)
- Resiliency Planning (1)
- Resource Manager (1)
- Resources (1)
- Restore (1)
- Restore Point (1)
- Retail (1)
- Rhel (1)
- Risk (1)
- Risk Management (1)
- Rocksrb (1)
- Role In Postgresql (1)
- Rollback (1)
- Rolling Patch (1)
- Row0Purge (1)
- Rpm (1)
- Rule "Existing Clustered Or Clustered-Prepared In (1)
- Running Discovery On Remote Machine (1)
- SQL Optimization (1)
- SQL Tracing (1)
- SSRS Administration (1)
- SaaS (1)
- Sap Assessment (1)
- Sap Assessment Report (1)
- Sap Backup Restore (1)
- Sap Btp Architecture (1)
- Sap Btp Benefits (1)
- Sap Btp Model (1)
- Sap Btp Services (1)
- Sap Homogenous System Copy Method (1)
- Sap Landscape Copy (1)
- Sap Migration Assessment (1)
- Sap On Mssql (1)
- Sap System Copy (1)
- Sar (1)
- Scaling Ir (1)
- Sccm (1)
- Sccm Powershell (1)
- Scheduler (1)
- Scheduler_Job (1)
- Schedulers (1)
- Scheduling (1)
- Scott Mccormick (1)
- Scripts (1)
- Sdp (1)
- Secrets (1)
- Securing Sql Server (1)
- Security Compliance (1)
- Sed (Stream Editor) (1)
- Self Hosted Ir (1)
- Semaphore (1)
- Seps (1)
- September 11Th 2015 (1)
- Serverless Computing (1)
- Serverless Framework (1)
- Service Broker (1)
- Service Bus (1)
- Shared Connections (1)
- Shared Storage (1)
- Shellshock (1)
- Signals (1)
- Silent (1)
- Slave (1)
- Slob (1)
- Smart Scan (1)
- Smtp (1)
- Snapshot (1)
- Snowday Fall 2021 (1)
- Socat (1)
- Software Development (1)
- Software Engineering (1)
- Solutions Architecture (1)
- Spanner-Backups (1)
- Sphinx (1)
- Split Brain In Postgresql (1)
- Spm (1)
- Sql Agent (1)
- Sql Backup To Url Error (1)
- Sql Cluster Installer Hang (1)
- Sql Database (1)
- Sql Developer (1)
- Sql On Linux (1)
- Sql Server 2014 (1)
- Sql Server 2016 (1)
- Sql Server Agent On Linux (1)
- Sql Server Backups (1)
- Sql Server Denali Is Required To Install Integrat (1)
- Sql Server Health Check (1)
- Sql Server Troubleshooting On Linux (1)
- Sql Server Version (1)
- Sql Setup (1)
- Sql Vm (1)
- Sql2K19Ongke (1)
- Sqldatabase Serverless (1)
- Ssh User Equivalence (1)
- Ssis Denali Error (1)
- Ssis Install Error E Xisting Clustered Or Cluster (1)
- Ssis Package Deployment Error (1)
- Ssisdb Master Key (1)
- Ssisdb Restore Error (1)
- Sso (1)
- Ssrs 2019 (1)
- Sstable2Json (1)
- Sstableloader (1)
- Sstablesimpleunsortedwriter (1)
- Stack Dump (1)
- Standard Edition (1)
- Startup Process (1)
- Statistics (1)
- Statspack (1)
- Statspack Data Mining (1)
- Statspack Erroneously Reporting (1)
- Statspack Issues (1)
- Storage (1)
- Stored Procedure (1)
- Strategies (1)
- Streaming (1)
- Sunos (1)
- Swap (1)
- Swapping (1)
- Switch (1)
- Syft (1)
- Synapse (1)
- Sync Failed There Is Not Enough Space On The Disk (1)
- Sys Schema (1)
- System Function (1)
- Systems Administration (1)
- T-Sql (1)
- Table Optimization (1)
- Tablespace Growth (1)
- Tablespaces (1)
- Tags (1)
- Tar (1)
- Tde (1)
- Team Management (1)
- Tech Debt (1)
- Technology (1)
- Telegraf (1)
- Tempdb Encryption (1)
- Templates (1)
- Temporary Tablespace (1)
- Tenserflow (1)
- Teradata (1)
- Testing New Cassandra Builds (1)
- There Is Not Enough Space On The Disk (1)
- Thick Data (1)
- Third-Party Data (1)
- Thrift (1)
- Thrift Data (1)
- Tidb (1)
- Time Series (1)
- Time-Drift (1)
- Tkprof (1)
- Tmux (1)
- Tns (1)
- Trace (1)
- Tracefile (1)
- Training (1)
- Transaction Log (1)
- Transactions (1)
- Transformation Navigator (1)
- Transparent Data Encryption (1)
- Trigger (1)
- Triggers On Memory-Optimized Tables Must Use With (1)
- Troubleshooting (1)
- Tungsten (1)
- Tvdxtat (1)
- Twitter (1)
- U-Sql (1)
- UNDO Tablespace (1)
- Upgrade Issues (1)
- Uptime (1)
- Uptrade (1)
- Url Backup Error (1)
- Usability (1)
- Use Cases (1)
- User (1)
- User Defined Compactions (1)
- Utilization (1)
- Utl_Smtp (1)
- VDI Jump Host (1)
- Validate Structure (1)
- Validate_Credentials (1)
- Value (1)
- Velocity (1)
- Vertex AI (1)
- Vertica (1)
- Vertical Slicing (1)
- Videos (1)
- Virtual Private Cloud (1)
- Virtualization (1)
- Vision (1)
- Vpn (1)
- Wait_Timeout (1)
- Wallet (1)
- Webhook (1)
- Weblogic Connection Filters (1)
- Webscale Database (1)
- Windows 10 (1)
- Windows Powershell (1)
- WiredTiger (1)
- With Native_Compilation (1)
- Word (1)
- Workshop (1)
- Workspace Security (1)
- Xbstream (1)
- Xml Publisher (1)
- Zabbix (1)
- dbms_Monitor (1)
- postgresql 16 (1)
- sqltrace (1)
- tracing (1)
- vSphere (1)
- xml (1)
- October 2024 (2)
- September 2024 (7)
- August 2024 (4)
- July 2024 (2)
- June 2024 (6)
- May 2024 (3)
- April 2024 (2)
- February 2024 (2)
- January 2024 (11)
- December 2023 (10)
- November 2023 (11)
- October 2023 (10)
- September 2023 (8)
- August 2023 (7)
- July 2023 (2)
- June 2023 (13)
- May 2023 (4)
- April 2023 (6)
- March 2023 (10)
- February 2023 (6)
- January 2023 (5)
- December 2022 (10)
- November 2022 (10)
- October 2022 (10)
- September 2022 (13)
- August 2022 (16)
- July 2022 (12)
- June 2022 (13)
- May 2022 (11)
- April 2022 (4)
- March 2022 (5)
- February 2022 (4)
- January 2022 (14)
- December 2021 (16)
- November 2021 (11)
- October 2021 (7)
- September 2021 (11)
- August 2021 (6)
- July 2021 (9)
- June 2021 (4)
- May 2021 (8)
- April 2021 (16)
- March 2021 (16)
- February 2021 (6)
- January 2021 (12)
- December 2020 (12)
- November 2020 (17)
- October 2020 (11)
- September 2020 (10)
- August 2020 (11)
- July 2020 (13)
- June 2020 (6)
- May 2020 (9)
- April 2020 (18)
- March 2020 (21)
- February 2020 (13)
- January 2020 (15)
- December 2019 (10)
- November 2019 (11)
- October 2019 (12)
- September 2019 (16)
- August 2019 (15)
- July 2019 (10)
- June 2019 (16)
- May 2019 (20)
- April 2019 (21)
- March 2019 (14)
- February 2019 (18)
- January 2019 (18)
- December 2018 (5)
- November 2018 (16)
- October 2018 (12)
- September 2018 (20)
- August 2018 (27)
- July 2018 (31)
- June 2018 (34)
- May 2018 (28)
- April 2018 (27)
- March 2018 (17)
- February 2018 (8)
- January 2018 (20)
- December 2017 (14)
- November 2017 (4)
- October 2017 (1)
- September 2017 (3)
- August 2017 (5)
- July 2017 (4)
- June 2017 (2)
- May 2017 (7)
- April 2017 (7)
- March 2017 (8)
- February 2017 (8)
- January 2017 (5)
- December 2016 (3)
- November 2016 (4)
- October 2016 (8)
- September 2016 (9)
- August 2016 (10)
- July 2016 (9)
- June 2016 (8)
- May 2016 (13)
- April 2016 (16)
- March 2016 (13)
- February 2016 (11)
- January 2016 (6)
- December 2015 (11)
- November 2015 (11)
- October 2015 (5)
- September 2015 (16)
- August 2015 (4)
- July 2015 (1)
- June 2015 (3)
- May 2015 (6)
- April 2015 (5)
- March 2015 (5)
- February 2015 (4)
- January 2015 (3)
- December 2014 (7)
- October 2014 (4)
- September 2014 (6)
- August 2014 (6)
- July 2014 (16)
- June 2014 (7)
- May 2014 (6)
- April 2014 (5)
- March 2014 (4)
- February 2014 (10)
- January 2014 (6)
- December 2013 (8)
- November 2013 (12)
- October 2013 (9)
- September 2013 (6)
- August 2013 (7)
- July 2013 (9)
- June 2013 (7)
- May 2013 (7)
- April 2013 (4)
- March 2013 (7)
- February 2013 (4)
- January 2013 (4)
- December 2012 (6)
- November 2012 (8)
- October 2012 (9)
- September 2012 (3)
- August 2012 (5)
- July 2012 (5)
- June 2012 (7)
- May 2012 (11)
- April 2012 (1)
- March 2012 (8)
- February 2012 (1)
- January 2012 (6)
- December 2011 (8)
- November 2011 (5)
- October 2011 (9)
- September 2011 (6)
- August 2011 (4)
- July 2011 (1)
- June 2011 (1)
- May 2011 (5)
- April 2011 (2)
- February 2011 (2)
- January 2011 (2)
- December 2010 (1)
- November 2010 (7)
- October 2010 (3)
- September 2010 (8)
- August 2010 (2)
- July 2010 (4)
- June 2010 (7)
- May 2010 (2)
- April 2010 (1)
- March 2010 (3)
- February 2010 (3)
- January 2010 (2)
- November 2009 (6)
- October 2009 (6)
- August 2009 (3)
- July 2009 (3)
- June 2009 (3)
- May 2009 (2)
- April 2009 (8)
- March 2009 (6)
- February 2009 (4)
- January 2009 (3)
- November 2008 (3)
- October 2008 (7)
- September 2008 (6)
- August 2008 (9)
- July 2008 (9)
- June 2008 (9)
- May 2008 (9)
- April 2008 (8)
- March 2008 (4)
- February 2008 (3)
- January 2008 (3)
- December 2007 (2)
- November 2007 (7)
- October 2007 (1)
- August 2007 (4)
- July 2007 (3)
- June 2007 (8)
- May 2007 (4)
- April 2007 (2)
- March 2007 (2)
- February 2007 (5)
- January 2007 (8)
- December 2006 (1)
- November 2006 (3)
- October 2006 (4)
- September 2006 (3)
- July 2006 (1)
- May 2006 (2)
- April 2006 (1)
- July 2005 (1)
No Comments Yet
Let us know what you think