Code Monkey home page Code Monkey logo

Comments (7)

biemond avatar biemond commented on June 19, 2024

Hi,

it should work, you can take a look at https://github.com/biemond/biemond-oradb-vagrant-12.1-CDB/blob/master/puppet/manifests/site.pp#L149

but it is very sensitive for oracle versions and how much memory you assign to the VM, I tested it on 12.1.0.1 with the EE enterprise edition option.
I will also test it on 12.1.0.2 and let you know.

oradb::database{ 'oraDb':
  oracle_base               => hiera('oracle_base_dir'),
  oracle_home               => hiera('oracle_home_dir'),
  version                   => hiera('dbinstance_version'),
  user                      => hiera('oracle_os_user'),
  group                     => hiera('oracle_os_group'),
  download_dir              => hiera('oracle_download_dir'),
  action                    => 'create',
  db_name                   => hiera('oracle_database_name'),
  db_domain                 => hiera('oracle_database_domain_name'),
  sys_password              => hiera('oracle_database_sys_password'),
  system_password           => hiera('oracle_database_system_password'),
  template                  => 'dbtemplate_12.1',
  character_set             => 'AL32UTF8',
  nationalcharacter_set     => 'UTF8',
  sample_schema             => 'TRUE',
  memory_percentage         => '40',
  memory_total              => '800',
  database_type             => 'MULTIPURPOSE',
  em_configuration          => 'NONE',
  data_file_destination     => hiera('oracle_database_file_dest'),
  recovery_area_destination => hiera('oracle_database_recovery_dest'),
  init_params               => {'open_cursors'        => '1000',
                                'processes'           => '600',
                                'job_queue_processes' => '4' },
  container_database        => true,
  require                   => Db_listener['startlistener'],
}

from biemond-oradb.

biemond avatar biemond commented on June 19, 2024

it seems it only worked for 12.1.0.1, I am now changing and testing the template so it also works for 12.1.0.2

from biemond-oradb.

biemond avatar biemond commented on June 19, 2024

Got it,

you can use the latest version from github

Thanks

from biemond-oradb.

dbarkin avatar dbarkin commented on June 19, 2024

Thanks a lot will test it tonight
Dmitri

On Wednesday, February 3, 2016 7:26 PM, Edwin Biemond <[email protected]> wrote:

Got it, you can use the latest version from githubThanks—
Reply to this email directly or view it on GitHub.

from biemond-oradb.

dbarkin avatar dbarkin commented on June 19, 2024

DB creation works. What I've noticed, doesn't matter how I change options in dbtemplate_12.1 oracle dbca always installs all options except sample schemas. Don't think it is oradb module issue. Found several metalink communities articles about similar issues. It is possible to workaround it by providing response file during db creation, but I don't see that option in oradb module.

Dmitri

from biemond-oradb.

biemond avatar biemond commented on June 19, 2024

yep it is , that is because of this https://github.com/biemond/biemond-oradb/blob/master/templates/dbtemplate_12.1.dbt.erb#L17

you can remove the template param from database.pp manifest then it will use the rsp file instead of using a template or we need to replace it with this line

  <option name="SAMPLE_SCHEMA" value="<%= @sample_schema %>"/>

from biemond-oradb.

dbarkin avatar dbarkin commented on June 19, 2024

Thanks, works

from biemond-oradb.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.