hilverd / vagrant-ubuntu-oracle-xe Goto Github PK

View Code? Open in Web Editor NEW

287.0 32.0 96.0 65 KB

Install Oracle 11g XE in a Vagrant virtual machine running Ubuntu 12.04.

License: MIT License

PLSQL 4.18% Shell 21.75% Puppet 74.07%

vagrant-ubuntu-oracle-xe's Introduction

Oracle XE 11g on Ubuntu 12.04 using Vagrant

This project enables you to install Oracle 11g XE in a virtual machine running Ubuntu 12.04, using Vagrant and Puppet.

Acknowledgements

This project was created based on the information in Installing Oracle 11g R2 Express Edition on Ubuntu 64-bit by Manish Raj, and the GitHub repository vagrant-oracle-xe by Stefan Glase. The former explains how to install Oracle XE 11g on Ubuntu 12.04, without explicitly providing a Vagrant or provisioner configuration. The latter has the same purpose as this project but uses Ubuntu 11.10.

Thanks to André Kelpe, Brandon Gresham, Charles Walker, Chris Thompson, Jeff Caddel, Joe FitzGerald, Justin Harringa, Mark Crossfield, Matthew Buckett, Richard Kolb, and Steven Hsu for various contributions.

Requirements

You need to have Vagrant installed.
The host machine probably needs at least 4 GB of RAM (I have only tested 8 GB of RAM).
As Oracle 11g XE is only available for 64-bit machines at the moment, the host machine needs to have a 64-bit architecture.
You may need to enable virtualization manually.

Installation

Check out this project:

  git clone https://github.com/hilverd/vagrant-ubuntu-oracle-xe.git

Install vbguest:

  vagrant plugin install vagrant-vbguest

Download Oracle Database 11g Express Edition for Linux x64. Place the file oracle-xe-11.2.0-1.0.x86_64.rpm.zip in the directory modules/oracle/files of this project. (Alternatively, you could keep the zip file in some other location and make a hard link to it from modules/oracle/files.)
Optional: To get Flyway integration, download ojdbc6.jar for JDK 1.6 from Oracle Database 11g Release 2 11.2.0.4 JDBC Drivers, and place it in the directory oracle-jdbc of this project.

Migrations are in data-with-flyway/src/main/resources/database/migrations. See data-with-flyway/README.md for more instructions. Many thanks to Nicholas Blair for contributing this feature.
Run vagrant up from the base directory of this project. The first time this will take a while -- up to 30 minutes on my machine. Please note that building the VM involves downloading an Ubuntu 12.04 base box which is 323MB in size.

These steps are also shown in an asciicast made by Daekwon Kang:

Connecting

You should now be able to connect to the new database at localhost:1521/XE as system with password manager. For example, if you have sqlplus installed on the host machine you can do

sqlplus system/manager@//localhost:1521/XE

To make sqlplus behave like other tools (history, arrow keys etc.) you can do this:

rlwrap sqlplus system/manager@//localhost:1521/XE

You might need to add an entry to your tnsnames.ora file first:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

Troubleshooting

Errors when Unzipping

If you get an error containing /usr/bin/unzip -o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 2 during vagrant up, then the zip file you have downloaded is probably corrupted. This can be fixed by re-downloading, replacing the corrupted file, and running vagrant reload --provision.

Memory

It is important to assign enough memory to the virtual machine, otherwise you will get an error

ORA-00845: MEMORY_TARGET not supported on this system

during the configuration stage. In the Vagrantfile 512 MB is assigned. Lower values may also work, as long as (I believe) 2 GB of virtual memory is available for Oracle, swap is included in this calculation.

Concurrent Connections

If you want to raise the limit of the number of concurrent connections, say to 200, then according to How many connections can Oracle Express Edition (XE) handle? you should run

ALTER SYSTEM SET processes=200 scope=spfile

and restart the database.

Alternatives

You may also want to consider a Docker-based solution such as docker-oracle-xe-11g.

vagrant-ubuntu-oracle-xe's People

Contributors

Stargazers

Watchers

Forkers

thomasleyer codenamev cwalker67 rjdkolb vunovati satie buckett teaforthecat corporate-gadfly bane73 puneetjaiswal dillera spaceo mrmanc cloudqq payne marcioalmada rollxx sgomezvillamor produtec sfraser aruder77 leanthis ajorpheus luizrobertofreitas padington crazycode asifiqbal ardumont sebbrousse d-smith sambitdixit sergeybogevolny palchicz dongjinmedia armandorvila janes verdacom andyyes yajra marcelmorgan bahlaouane-hamza nblair mcgurgu rsarro kalranitin hafizhassan roniemicro antonio-rostaing-ntt rsakamot wfriesen pigor paulojeronimo gugabcosta amidia clementbeudot xetius kamilsmuga esternocleidomastoideo slachiewicz kjcaputa artemabalmasov dinhhientran decisionbrain mba811 yannisgr imlinon ernane jpfrancois kodfarki raymatthes kimwer wdwtlwnd rponte rajibsaha-minted adityai helgecph morganyvm snzip diegonobre fafonso mma73k olavz anter01 pricillatan jkorotkiewicz i048752 marz6759 mardukbp

vagrant-ubuntu-oracle-xe's Issues

Forward To A Different Port

I got the following error when doing Vagrant up, probably because I have OracleXE installed on my host as well.
It might be worth choosing a more random host port to forward to.

Vagrant cannot forward the specified ports on this VM, since they
would collide with some other application that is already listening
on these ports. The forwarded port to 1521 is already in use
on the host machine.

To fix this, modify your current projects Vagrantfile to use another
port. Example, where '1234' would be replaced by a unique host port:

  config.vm.network :forwarded_port, guest: 1521, host: 1234

Sometimes, Vagrant will attempt to auto-correct this for you. In this
case, Vagrant was unable to. This is usually because the guest machine
is in a state which doesn't allow modifying port forwarding

how to connect as sysdba?

System / Manager cannot connected as SYSDBA "Insufficient Privillege"

-o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 9 instead of one of [0]

Hi,

This is the complete error message I get. I've tried with a couple of different versions of the zip file, any ideas?

==> default: err: /Stage[main]/Oracle::Xe/Exec[unzip xe]/returns: change from notrun to 0 failed: /usr/bin/unzip -o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 9 instead of one of [0] at /tmp/vagrant-puppet/modules-f41c281661b26b1bcf1fd36302640a11/oracle/manifests/init.pp:154

Should note that the download comes in a folder as an .rpm file.

If I rename it I get the 9 error, if i zip it I get the 2 error that you mentioned previously.

Puppet unzip [oracle zip] returned 2 instead of one of [0]

I get this error in the log when I do Vagrant up:

==> default: err: /Stage[main]/Oracle::Xe/Exec[unzip xe]/returns: change from notrun to 0 failed: /usr/bin/unzip -o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 2 instead of one of [0] at /tmp/vagrant-puppet/modules-79fe1534dfe8664ac594dd7ac064a9c7/oracle/manifests/init.pp:154

I have the file oracle-xe-11.2.0-1.0.x86_64.rpm.zip in modules/oracle/files.

Any ideas?

Problem with desploy

Hello, I did all the steps you mentioned until the connection. I can't connect to the DB.

$ vagrant reload --provision
==> default: Attempting graceful shutdown of VM...
==> default: Clearing any previously set forwarded ports...
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
default: Adapter 1: nat
==> default: Forwarding ports...
default: 1521 => 1521 (adapter 1)
default: 22 => 2222 (adapter 1)
==> default: Running 'pre-boot' VM customizations...
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
default: SSH address: 127.0.0.1:2222
default: SSH username: vagrant
default: SSH auth method: private key
default: Error: Connection timout. Retrying...
==> default: Machine booted and ready!
==> default: Checking for guest additions in VM...
default: The guest additions on this VM do not match the installed version of
default: VirtualBox! In most cases this is fine, but in rare cases it can
default: prevent things such as shared folders from working properly. If you see
default: shared folder errors, please make sure the guest additions within the
default: virtual machine match the version of VirtualBox you have installed on
default: your host and reload your VM.
default:
default: Guest Additions Version: 4.2.0
default: VirtualBox Version: 4.1
==> default: Setting hostname...
==> default: Mounting shared folders...
default: /vagrant => /home/jportella/Virtualizacion/vagrant_scripts/vagrant-ubuntu-oracle-xe
default: /tmp/vagrant-puppet-1/manifests => /home/jportella/Virtualizacion/vagrant_scripts/vagrant-ubuntu-oracle-xe/manifests
default: /tmp/vagrant-puppet-1/modules-0 => /home/jportella/Virtualizacion/vagrant_scripts/vagrant-ubuntu-oracle-xe/modules
==> default: Running provisioner: shell...
default: Running: inline script
/etc/profile.d/oracle-env.sh: line 3: /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh: No such file or directory
stdin: is not a tty
America/New_York

Current default time zone: 'America/New_York'
Local time is now: Wed Mar 12 21:45:38 EDT 2014.
Universal Time is now: Thu Mar 13 01:45:38 UTC 2014.

==> default: Running provisioner: puppet...
Running Puppet with base.pp...
/etc/profile.d/oracle-env.sh: line 3: /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh: No such file or directory
stdin: is not a tty
warning: Could not retrieve fact fqdn
warning: Host is missing hostname and/or domain: oracle
info: Applying configuration version '1394675141'
notice: /Stage[main]/Oracle::Server/Exec[apt-update]/returns: executed successfully
notice: /Stage[main]/Oracle::Xe/File[/tmp/oracle-env.sh]/ensure: defined content as '{md5}c874e5a7a4cc6b15ff68055335c136fb'
notice: /Stage[main]/Oracle::Xe/File[/tmp/xe.rsp.orig]/ensure: defined content as '{md5}b79c95d12321f3eb55d855082d1d6831'
notice: /Stage[main]/Oracle::Server/File[/tmp/60-oracle.conf]/ensure: defined content as '{md5}61b22d59fdc07f9fa6929ab74f5b6e99'
info: /Stage[main]/Oracle::Server/File[/tmp/60-oracle.conf]: Scheduling refresh of Exec[procps]
notice: /Stage[main]/Oracle::Server/File[/tmp/S01shm_load]/ensure: defined content as '{md5}4bc498d6cd7b4de9e417f4eeb8bd0cff'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/parameter.rb:165:in fail' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/type/exec.rb:125:insync'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:114:in apply_parameter' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:62:inperform_changes'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:60:in each' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:60:inperform_changes'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:133:in evaluate' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:49:inapply'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:84:in eval_resource' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:104:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:493:in thinmark' /opt/vagrant_ruby/lib/ruby/1.8/benchmark.rb:308:inrealtime'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:492:in thinmark' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:104:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:386:in traverse' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:99:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/resource/catalog.rb:141:in apply' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:122:inretrieve_and_apply_catalog'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:161:in benchmark' /opt/vagrant_ruby/lib/ruby/1.8/benchmark.rb:308:inrealtime'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:160:in benchmark' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:121:inretrieve_and_apply_catalog'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:152:in run' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application/apply.rb:229:inmain'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application/apply.rb:149:in run_command' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:416:in hook' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:407:in exit_on_fail' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util/command_line.rb:69:in execute' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/bin/puppet:4 /opt/vagrant_ruby/bin/puppet:19:inload'
/opt/vagrant_ruby/bin/puppet:19
err: /Stage[main]/Oracle::Xe/Exec[unzip xe]/returns: change from notrun to 0 failed: /usr/bin/unzip -o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 2 instead of one of [0] at /tmp/vagrant-puppet-1/modules-0/oracle/manifests/init.pp:154
notice: /Stage[main]/Oracle::Xe/Exec[alien xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Exec[alien xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Xe/Package[oracle-xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Package[oracle-xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Server/File[/tmp/chkconfig]/ensure: defined content as '{md5}8c59ff9592660f1de08162729d19373e'
notice: /Stage[main]/Oracle::Xe/Exec[dos2unix xe.rsp]/returns: executed successfully
notice: /Stage[main]/Oracle::Xe/Exec[configure xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Exec[configure xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Xe/Service[oracle-xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Service[oracle-xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Xe/Exec[run chkconfig]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Exec[run chkconfig]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Server/Exec[procps]: Triggered 'refresh' from 1 events
notice: /Stage[main]//Node[oracle]/User[vagrant]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]//Node[oracle]/User[vagrant]: Skipping because of failed dependencies
notice: Finished catalog run in 49.50 seconds
The following SSH command responded with a non-zero exit status.
Vagrant assumes that this means the command failed!

puppet apply --verbose --trace --modulepath '/tmp/vagrant-puppet-1/modules-0:/etc/puppet/modules' --manifestdir /tmp/vagrant-puppet-1/manifests --detailed-exitcodes /tmp/vagrant-puppet-1/manifests/base.pp || [ $? -eq 2 ]

Stdout from the command:

warning: Could not retrieve fact fqdn
warning: Host is missing hostname and/or domain: oracle
info: Applying configuration version '1394675141'
notice: /Stage[main]/Oracle::Server/Exec[apt-update]/returns: executed successfully
notice: /Stage[main]/Oracle::Xe/File[/tmp/oracle-env.sh]/ensure: defined content as '{md5}c874e5a7a4cc6b15ff68055335c136fb'
notice: /Stage[main]/Oracle::Xe/File[/tmp/xe.rsp.orig]/ensure: defined content as '{md5}b79c95d12321f3eb55d855082d1d6831'
notice: /Stage[main]/Oracle::Server/File[/tmp/60-oracle.conf]/ensure: defined content as '{md5}61b22d59fdc07f9fa6929ab74f5b6e99'
info: /Stage[main]/Oracle::Server/File[/tmp/60-oracle.conf]: Scheduling refresh of Exec[procps]
notice: /Stage[main]/Oracle::Server/File[/tmp/S01shm_load]/ensure: defined content as '{md5}4bc498d6cd7b4de9e417f4eeb8bd0cff'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/parameter.rb:165:in fail' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/type/exec.rb:125:insync'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:114:in apply_parameter' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:62:inperform_changes'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:60:in each' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:60:inperform_changes'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:133:in evaluate' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:49:inapply'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:84:in eval_resource' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:104:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:493:in thinmark' /opt/vagrant_ruby/lib/ruby/1.8/benchmark.rb:308:inrealtime'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:492:in thinmark' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:104:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:386:in traverse' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:99:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/resource/catalog.rb:141:in apply' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:122:inretrieve_and_apply_catalog'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:161:in benchmark' /opt/vagrant_ruby/lib/ruby/1.8/benchmark.rb:308:inrealtime'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:160:in benchmark' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:121:inretrieve_and_apply_catalog'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:152:in run' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application/apply.rb:229:inmain'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application/apply.rb:149:in run_command' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:416:in hook' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:407:in exit_on_fail' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util/command_line.rb:69:in execute' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/bin/puppet:4 /opt/vagrant_ruby/bin/puppet:19:inload'
/opt/vagrant_ruby/bin/puppet:19
err: /Stage[main]/Oracle::Xe/Exec[unzip xe]/returns: change from notrun to 0 failed: /usr/bin/unzip -o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 2 instead of one of [0] at /tmp/vagrant-puppet-1/modules-0/oracle/manifests/init.pp:154
notice: /Stage[main]/Oracle::Xe/Exec[alien xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Exec[alien xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Xe/Package[oracle-xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Package[oracle-xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Server/File[/tmp/chkconfig]/ensure: defined content as '{md5}8c59ff9592660f1de08162729d19373e'
notice: /Stage[main]/Oracle::Xe/Exec[dos2unix xe.rsp]/returns: executed successfully
notice: /Stage[main]/Oracle::Xe/Exec[configure xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Exec[configure xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Xe/Service[oracle-xe]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Service[oracle-xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Xe/Exec[run chkconfig]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Exec[run chkconfig]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Server/Exec[procps]: Triggered 'refresh' from 1 events
notice: /Stage[main]//Node[oracle]/User[vagrant]: Dependency Exec[unzip xe] has failures: true
warning: /Stage[main]//Node[oracle]/User[vagrant]: Skipping because of failed dependencies
notice: Finished catalog run in 49.50 seconds

Stderr from the command:

/etc/profile.d/oracle-env.sh: line 3: /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh: No such file or directory
stdin: is not a tty

$vagrant ssh :
Welcome to your Vagrant-built virtual machine.
Last login: Wed Mar 12 21:37:39 2014 from 10.0.2.2
-bash: /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh: No such file or directory

$ls:
Disk1 oracle-xe-11.2.0-1.0.x86_64.rpm.zip postinstall.sh

Error:
Error de E/S: Connection reset.

I hope you can help me find the error.

configuring NFS

Hello, I wanted to configure this VM to use NSF. When I attempt to change the Vagrantfile to

 config.vm.network :private_network, ip: '192.168.50.50'
 config.vm.synced_folder ".", "/home/vagrant/vagrant-ubuntu-oracle-xe", :nfs => true, :mount_options => ["dmode=777","fmode=666"]

rather than the default (taking away the port forwarding) I get the following error. I'm guesing this may not have anything to do with your specific VM? Any pointers on where to take this are appreciated.

   The following SSH command responded with a non-zero exit status.
Vagrant assumes that this means the command failed!

set -e
mkdir -p /home/vagrant/vagrant-ubuntu-oracle-xe
mount -o vers=3,udp,dmode=777,fmode=666 192.168.50.1:/Users/ryber/Developer/vagrant-ubuntu-oracle-xe /home/vagrant/vagrant-ubuntu-oracle-xe
if command -v /sbin/init && /sbin/init --version | grep upstart; then
  /sbin/initctl emit --no-wait vagrant-mounted MOUNTPOINT=/home/vagrant/vagrant-ubuntu-oracle-xe
fi


Stdout from the command:



Stderr from the command:

stdin: is not a tty
mount.nfs: an incorrect mount option was specified

/usr/bin/apt-get -y update returned 100 instead of one of [0]

I'm sure this is an issue due to my new-ness to vagrant and puppet.

When I run 'vagrant up' it seems to run fine until:

err: /Stage[main]/Oracle::Server/Exec[apt-update]/returns: change from notrun to 0 failed: /usr/bin/apt-get -y update returned 100 instead of one of [0] at /tmp/vagrant-puppet/modules-0/oracle/manifests/init.pp:5

If I run 'vagrant ssh' to connect to the vagrant machine and try and run /usr/bin/apt-get -y update, I get:

vagrant@oracle:~$ /usr/bin/apt-get -y update
E: Could not open lock file /var/lib/apt/lists/lock - open (13: Permission denied)
E: Unable to lock directory /var/lib/apt/lists/
E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied)
E: Unable to lock the administration directory (/var/lib/dpkg/), are you root?

I notice that vagrant is not mentioned in the sudeors file. Should it be?

Many thanks,

Symlink to oracle zip?

First, I admit up-front it's a bit of a "6 of one, half-dozen of the other"-situation... and I'm not positive if it will actually work or not.. but I'm wondering if you might consider adding a symlink for where the oracle zip SHOULD be and have it directed somewhere outside of the vagrant box?

There are a few benefits (I think):

you only copy the file once to the standard location
you can setup the box as many times as you want without doing anything extra
you don't mistakenly lose the file if you destroy and rm -rf the vagrant box

Small things, I know, but it seems a small change too.

Something like this, I guess:

ln -s ~/vagrant/vagrant_resources/oracle-xe-11.2.0-1.0.x86_64.rpm.zip ~/vagrant/vagrant-ubuntu-oracle-xe/modules/oracle/files/oracle-xe-11.2.0-1.0.x86_64.rpm.zip

Folders will not mount under Virtualbox 5

I am using Virtualbox 5 and the following error is given:

Failed to mount folders in Linux guest. This is usually because
the "vboxsf" file system is not available. Please verify that
the guest additions are properly installed in the guest and
can work properly. The command attempted was:

mount -t vboxsf -o uid=`id -u vagrant`,gid=`getent group vagrant | cut -d: -f3`,dmode=777,fmode=666 home_vagrant_vagrant-ubuntu-oracle-xe /home/vagrant/vagrant-ubuntu-oracle-xe
mount -t vboxsf -o uid=`id -u vagrant`,gid=`id -g vagrant`,dmode=777,fmode=666 home_vagrant_vagrant-ubuntu-oracle-xe /home/vagrant/vagrant-ubuntu-oracle-xe

The error output from the last command was:

stdin: is not a tty

Virtualbox guest additions is installed but it is 4.3.12.

To fix this, the version of GA needs to be updated.

Maybe it could be an optional install and we can place the ISO into a directory for bootstrapping?

Running Oracle Database Entreprise Edition

Does installing Oracle Entreprise Edition require the same steps ? because I downloaded it in 2 zipped files, do I need to place them both in modules/oracle/files" or make them one zip ? please let me know.

Vagrant hangs on Vagrant UP

Hi, my box hangs forever in the line below, never existing or finishing. I've waited for hours.

Windows 7 + Cmder (cmd like app), other Vagrant boxes run fine.

vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Clearing any previously set forwarded ports...
==> default: Fixed port collision for 22 => 2222. Now on port 2200.
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
    default: Adapter 1: nat
==> default: Forwarding ports...
    default: 1521 => 1521 (adapter 1)
    default: 22 => 2200 (adapter 1)
==> default: Running 'pre-boot' VM customizations...
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
    default: SSH address: 127.0.0.1:2200
    default: SSH username: vagrant
    default: SSH auth method: private key
    default: Warning: Connection timeout. Retrying...
    default:
    default: Vagrant insecure key detected. Vagrant will automatically replace
    default: this with a newly generated keypair for better security.
    default:
    default: Inserting generated public key within guest...
    default: Removing insecure key from the guest if its present...
    default: Key inserted! Disconnecting and reconnecting using new SSH key...
==> default: Machine booted and ready!
==> default: Checking for guest additions in VM...
    default: The guest additions on this VM do not match the installed version of
    default: VirtualBox! In most cases this is fine, but in rare cases it can
    default: prevent things such as shared folders from working properly. If you see
    default: shared folder errors, please make sure the guest additions within the
    default: virtual machine match the version of VirtualBox you have installed on
    default: your host and reload your VM.
    default:
    default: Guest Additions Version: 4.2.0
    default: VirtualBox Version: 4.3
==> default: Setting hostname...
==> default: Mounting shared folders...
    default: /home/vagrant/vagrant-ubuntu-oracle-xe => C:/Users/cfontes/workspace/vagrant-ubuntu-oracle-xe
    default: /tmp/vagrant-puppet/modules-fb5c2476a4c1607ee38dc67d79edccbe => C:/Users/cfontes/workspace/vagrant-ubuntu-oracle-xe/modules
    default: /tmp/vagrant-puppet/manifests-a11d1078b1b1f2e3bdea27312f6ba513 => C:/Users/cfontes/workspace/vagrant-ubuntu-oracle-xe/manifests
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default: America/New_York
==> default:
==> default: Current default time zone: 'America/New_York'
==> default: Local time is now:      Mon Aug 24 13:18:11 EDT 2015.
==> default: Universal Time is now:  Mon Aug 24 17:18:11 UTC 2015.
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default: Running provisioner: puppet...
==> default: Running Puppet with base.pp...
==> default: stdin: is not a tty
==> default: warning: Could not retrieve fact fqdn
==> default: warning: Host is missing hostname and/or domain: oracle
==> default: info: Applying configuration version '1440436707'
==> default: notice: /Stage[main]/Oracle::Swap/Exec[create swapfile]/returns: executed successfully
==> default: notice: /Stage[main]/Oracle::Swap/Exec[add swapfile entry to fstab]/returns: executed successfully
==> default: notice: /Stage[main]/Oracle::Server/Exec[apt-update]/returns: executed successfully
==> default: notice: /Stage[main]/Oracle::Server/Package[dos2unix]/ensure: ensure changed 'purged' to 'present'
==> default: notice: /Stage[main]/Oracle::Server/User[syslog]/groups: groups changed '' to 'adm,syslog'
==> default: notice: /Stage[main]/Oracle::Server/Package[rlwrap]/ensure: ensure changed 'purged' to 'present'
==> default: notice: /Stage[main]/Oracle::Server/Package[unixodbc]/ensure: ensure changed 'purged' to 'present'
==> default: notice: /Stage[main]/Oracle::Server/Package[alien]/ensure: ensure changed 'purged' to 'present'
==> default: notice: /Stage[main]/Oracle::Swap/Exec[set up swapfile]/returns: executed successfully
==> default: notice: /Stage[main]/Oracle::Xe/File[/tmp/oracle-env.sh]/ensure: defined content as '{md5}e10ac9cfd22a648c0e7c5f18b4f19aab'
==> default: notice: /Stage[main]/Oracle::Xe/File[/bin/awk]/ensure: created
==> default: notice: /Stage[main]/Oracle::Xe/File[/home/vagrant/oracle-xe-11.2.0-1.0.x86_64.rpm.zip]/ensure: defined content as '{md5}dd7881a55569d890241f11cd0eeb7d48' ==> default: notice: /Stage[main]/Oracle::Xe/File[/var/lock/subsys]/ensure: created
==> default: notice: /Stage[main]/Oracle::Xe/File[/var/lock/subsys/listener]/ensure: created
==> default: notice: /Stage[main]/Oracle::Xe/Exec[dos2unix oracle-env.sh]/returns: executed successfully

vagrant up don't complete

Hi,

The vagrant up don't complete, i get this error :

err: /Stage[main]/Oracle::Xe/Exec[alien xe]/returns: change from notrun to 0 failed: Command exceeded timeout at /tmp/vagrant-puppet/modules-0/oracle/manifests/init.pp:126

I am on mac os X.6.8, vagrant 1.3.4 and virtualBox 4.2.18.

the output :

default' up with 'virtualbox' provider...
[default] Box 'precise64' was not found. Fetching box from specified URL for
the provider 'virtualbox'. Note that if the URL does not have
a box for this provider, you should interrupt Vagrant now and add
the box yourself. Otherwise Vagrant will attempt to download the
full box prior to discovering this error.
Downloading or copying the box...
Extracting box...te: 1686k/s, Estimated time remaining: 0:00:01)
Successfully added box 'precise64' with provider 'virtualbox'!
[default] Importing base box 'precise64'...
[default] Matching MAC address for NAT networking...
[default] Setting the name of the VM...
[default] Clearing any previously set forwarded ports...
[default] Creating shared folders metadata...
[default] Clearing any previously set network interfaces...
[default] Preparing network interfaces based on configuration...
[default] Forwarding ports...
[default] -- 22 => 2222 (adapter 1)
[default] -- 1521 => 1521 (adapter 1)
[default] Running 'pre-boot' VM customizations...
[default] Booting VM...
[default] Waiting for machine to boot. This may take a few minutes...
[default] Machine booted and ready!
[default] Setting hostname...
[default] Mounting shared folders...
[default] -- /vagrant
[default] -- /tmp/vagrant-puppet/manifests
[default] -- /tmp/vagrant-puppet/modules-0
[default] Running provisioner: shell...
[default] Running: inline script
stdin: is not a tty
America/New_York

Current default time zone: 'America/New_York'
Local time is now: Wed Oct 9 05:32:33 EDT 2013.
Universal Time is now: Wed Oct 9 09:32:33 UTC 2013.

[default] Running provisioner: puppet...
Running Puppet with base.pp...
stdin: is not a tty
warning: Could not retrieve fact fqdn
warning: Host is missing hostname and/or domain: oracle
info: Applying configuration version '1381311159'
notice: /Stage[main]/Oracle::Swap/Exec[create swapfile]/returns: executed successfully
notice: /Stage[main]/Oracle::Swap/Exec[add swapfile entry to fstab]/returns: executed successfully
notice: /Stage[main]/Oracle::Server/Exec[apt-update]/returns: executed successfully
notice: /Stage[main]/Oracle::Server/User[syslog]/groups: groups changed '' to 'adm,syslog'
notice: /Stage[main]/Oracle::Server/File[/etc/rc2.d/S01shm_load]/ensure: defined content as '{md5}4bc498d6cd7b4de9e417f4eeb8bd0cff'
notice: /Stage[main]/Oracle::Server/Package[rlwrap]/ensure: ensure changed 'purged' to 'present'
notice: /Stage[main]/Oracle::Server/Package[unixodbc]/ensure: ensure changed 'purged' to 'present'
notice: /Stage[main]/Oracle::Server/Package[alien]/ensure: ensure changed 'purged' to 'present'
notice: /Stage[main]/Oracle::Swap/Exec[set up swapfile]/returns: executed successfully
notice: /Stage[main]/Oracle::Xe/File[/bin/awk]/ensure: created
notice: /Stage[main]/Oracle::Xe/File[/home/vagrant/oracle-xe-11.2.0-1.0.x86_64.rpm.zip]/ensure: defined content as '{md5}dd7881a55569d890241f11cd0eeb7d48'
notice: /Stage[main]/Oracle::Xe/File[/var/lock/subsys]/ensure: created
notice: /Stage[main]/Oracle::Xe/File[/var/lock/subsys/listener]/ensure: created
notice: /Stage[main]/Oracle::Xe/File[/tmp/xe.rsp]/ensure: defined content as '{md5}b79c95d12321f3eb55d855082d1d6831'
notice: /Stage[main]/Oracle::Server/File[/sbin/chkconfig]/ensure: defined content as '{md5}8c59ff9592660f1de08162729d19373e'
notice: /Stage[main]/Oracle::Server/Package[libaio1]/ensure: ensure changed 'purged' to 'present'
notice: /Stage[main]/Oracle::Server/Package[bc]/ensure: ensure changed 'purged' to 'present'
notice: /Stage[main]/Oracle::Xe/File[/etc/profile.d/oracle-env.sh]/ensure: defined content as '{md5}c874e5a7a4cc6b15ff68055335c136fb'
notice: /Stage[main]/Oracle::Swap/File[/swapfile]/mode: mode changed '0644' to '0600'
notice: /Stage[main]/Oracle::Swap/Exec[enable swapfile]/returns: executed successfully
notice: /Stage[main]/Oracle::Server/Package[unzip]/ensure: ensure changed 'purged' to 'present'
notice: /Stage[main]/Oracle::Xe/Exec[unzip xe]/returns: executed successfully
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/parameter.rb:165:in fail' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/type/exec.rb:103:insync'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:114:in apply_parameter' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:62:inperform_changes'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:60:in each' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:60:inperform_changes'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction/resource_harness.rb:133:in evaluate' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:49:inapply'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:84:in eval_resource' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:104:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:493:in thinmark' /opt/vagrant_ruby/lib/ruby/1.8/benchmark.rb:308:inrealtime'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:492:in thinmark' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:104:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:386:in traverse' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/transaction.rb:99:inevaluate'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/resource/catalog.rb:141:in apply' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:122:inretrieve_and_apply_catalog'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:161:in benchmark' /opt/vagrant_ruby/lib/ruby/1.8/benchmark.rb:308:inrealtime'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util.rb:160:in benchmark' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:121:inretrieve_and_apply_catalog'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/configurer.rb:152:in run' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application/apply.rb:229:inmain'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application/apply.rb:149:in run_command' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:416:in hook' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:407:in exit_on_fail' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/application.rb:309:inrun'
/opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/lib/puppet/util/command_line.rb:69:in execute' /opt/vagrant_ruby/lib/ruby/gems/1.8/gems/puppet-2.7.19/bin/puppet:4 /opt/vagrant_ruby/bin/puppet:19:inload'
/opt/vagrant_ruby/bin/puppet:19
err: /Stage[main]/Oracle::Xe/Exec[alien xe]/returns: change from notrun to 0 failed: Command exceeded timeout at /tmp/vagrant-puppet/modules-0/oracle/manifests/init.pp:126
notice: /Stage[main]/Oracle::Xe/Package[oracle-xe]: Dependency Exec[alien xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Package[oracle-xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Server/File[/etc/sysctl.d/60-oracle.conf]/ensure: defined content as '{md5}61b22d59fdc07f9fa6929ab74f5b6e99'
info: /Stage[main]/Oracle::Server/File[/etc/sysctl.d/60-oracle.conf]: Scheduling refresh of Exec[procps]
notice: /Stage[main]/Oracle::Server/Exec[set up shm]/returns: executed successfully
notice: /Stage[main]/Oracle::Xe/Exec[configure xe]: Dependency Exec[alien xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Exec[configure xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Xe/Service[oracle-xe]: Dependency Exec[alien xe] has failures: true
warning: /Stage[main]/Oracle::Xe/Service[oracle-xe]: Skipping because of failed dependencies
notice: /Stage[main]/Oracle::Server/Exec[procps]: Triggered 'refresh' from 1 events
notice: /Stage[main]//Node[oracle]/User[vagrant]: Dependency Exec[alien xe] has failures: true
warning: /Stage[main]//Node[oracle]/User[vagrant]: Skipping because of failed dependencies
info: Creating state file /var/lib/puppet/state/state.yaml
notice: Finished catalog run in 628.84 seconds
No error message

need root password

Hi, could anyone please let me know what the root password for this box is?
Also, I want the oracle user password.

Thank you,
Harsha.

/usr/bin/unzip -o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 2

err: /Stage[main]/Oracle::Xe/Exec[unzip xe]/returns: change from notrun to 0 failed: /usr/bin/unzip -o oracle-xe-11.2.0-1.0.x86_64.rpm.zip returned 2 instead of one of [0] at /tmp/vagrant-puppet-4/modules-0/oracle/manifests/init.pp:154

Got this on my first vagrant up attempt. Executed vagrant up again and it went away.

Use uppercase XE as the default SID instead of lowercase

Howdy,

First off, let me just say I'm loving what you've done here. I work for a non-profit open source group (http://www.kuali.org) and your method for easily installing Oracle 11g is spreading like crazy amongst the developers in our group.

This isn't really an "issue" per se. Was just wondering if you would consider changing the default from "xe" to "XE" in the JDBC url.

When you install Oracle 11g, "XE" is the default SID the Oracle installer uses. This would make your vagrant/puppet method for installing 11g pretty much a drop in replacement for the Oracle installer with that tweak.

All the tools/config our developers work with locally have the jdbc url setup as "jdbc:oracle:thin:@localhost:1521:XE"

Also, thought I'd pass along that this works great for installing Oracle 11g on Mac OSX. It installed perfectly fine, and I've been using 11g for about a week with no issues.

Thanks for this!

box set up but oracle server is not working online

i finished the installation and ssh'd into the system, but i cannot open the db at address localhost:1521/XE. the address is un-reachable. is there something else to configure?

sudo service oracle-xe status says:

vagrant@oracle:~$ sudo service oracle-xe status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 21-NOV-2014 08:43:18

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))

STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 21-NOV-2014 07:59:31
Uptime 0 days 0 hr. 43 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully

Mention Size In README

As someone who is new to vagrant and on a slow connection I didn't quite grasp how it all worked and installed Ubuntu.
You should probably mention in the README the size of the base box that will get downloaded when doing vagrant up to clarify this.

vagrant up hangs

Hi guys,

I've been following your instructions on my Windows machine. Something goes wrong and I have "vagrant up" hanging.

These are the last lines in the ouput of "vagrant up --debug" :

INFO host: Detected: windows!
INFO runner: Preparing hooks for middleware sequence...
INFO runner: 2 hooks defined.
INFO runner: Running action: #Vagrant::Action::Builder:0x36f3300
INFO warden: Calling IN action: #VagrantPlugins::HyperV::Action::CheckEnabled:0x27efa30
INFO interface: output: Verifying Hyper-V is enabled...
INFO interface: output: ==> default: Verifying Hyper-V is enabled...
==> default: Verifying Hyper-V is enabled...
INFO subprocess: Starting process: ["c:\Windows\System32\WindowsPowerShell\v1.0/powershell.EXE", "-NoProfile", "-ExecutionPolicy", "Bypass", "&('d:\dev\Vagrant\embedded\gems\gems\vagrant-1.6.2\plugins\prov
iders\hyperv\scripts\check_hyperv.ps1')", "-ErrorAction", "Stop"]
DEBUG subprocess: Selecting on IO
DEBUG subprocess: stderr: The term 'ConvertTo-Json' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path i
s correct and try again.
At D:\dev\Vagrant\embedded\gems\gems\vagrant-1.6.2\plugins\providers\hyperv\scripts\check_hyperv.ps1:10 char:38

Write-Output-Message $(ConvertTo-Json <<<< $result)
- CategoryInfo : ObjectNotFound: (ConvertTo-Json:String) [], CommandNotFoundException
- FullyQualifiedErrorId : CommandNotFoundException

DEBUG subprocess: stdout: ===Begin-Output===

===End-Output===

Can you help me make sense of this?
Thank you very much.

Regards,
Liviu

run dos2unix on config files to ensure proper eol?

First, thanks for putting this out there -- it has proven very handy.

Just thought I'd make a quick note that I ran into issues when I installed this onto a windows box. I think my git is set up to convert end of lines to windows format on checkout and this causes the provisioner to choke on those files and fail.

Not sure if anyone cares since this is as much an issue about folks' git configurations as anything else but if you wanted to ensure it worked on all platforms you could probably just run each of the unix files through dos2unix or something just to ensure unix EOLs... Or maybe just comment on the Readme?

please, explain, what login and password I should use for ssh

Please, explain, what login and password I should use for ssh.

This combination does not work:
ssh -p 2222 system@localhost
manager

Thank you

Oracle doesn't start after a VM halt - resume/suspend works

After halting my VM, Oracle doesn't seem to start back up after running "vagrant up" again. resume/suspend seems to work fine (which makes plenty of sense).

I can correct this temporarily by logging into the box and starting the service again.

vagrant@oracle:~$ sudo service oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.

It appears that I have corrected this permanently by issuing the following:

vagrant@oracle:~$ sudo chkconfig --list
 Adding system startup for /etc/init.d/oracle-xe ...
   /etc/rc0.d/K01oracle-xe -> ../init.d/oracle-xe
   /etc/rc1.d/K01oracle-xe -> ../init.d/oracle-xe
   /etc/rc6.d/K01oracle-xe -> ../init.d/oracle-xe
   /etc/rc2.d/S80oracle-xe -> ../init.d/oracle-xe
   /etc/rc3.d/S80oracle-xe -> ../init.d/oracle-xe
   /etc/rc4.d/S80oracle-xe -> ../init.d/oracle-xe
   /etc/rc5.d/S80oracle-xe -> ../init.d/oracle-xe

I'm still developing my puppet fu but I don't seem to see anything wrong at this point. If I find a resolution, I'll be sure to share and close this out. It seems that this should make sure that oracle-xe is running:

...
  service {
    "oracle-xe":
      ensure => "running",
...

Maybe someone already knows the answer to this. Any thoughts/ideas?

https://asciinema.org/a/8243

i wanna this cast put in readme markdown file.. ;)

Should chose a close apt mirror

See this thread:
http://askubuntu.com/questions/37753/how-can-i-get-apt-to-use-a-mirror-close-to-me-or-choose-a-faster-mirror

it would be good if the apt.sources used a close mirror.