Comments (7)
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.
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.
Got it,
you can use the latest version from github
Thanks
from biemond-oradb.
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.
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.
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.
Thanks, works
from biemond-oradb.
Related Issues (20)
- Any plans to support 19c database ? HOT 4
- Master branch HOT 1
- Any option to support custom string in listener.ora file ? HOT 1
- Hung on lsinv check by 2 processes simultaneously
- Install OGG on one host twice (2 locations) HOT 2
- using oradb::autostartdatabase for multiple databases per server failing HOT 7
- database 19c creation fails due to Automatic Memory Management option HOT 2
- Update metadata.json dependencies of stdlib and concat HOT 2
- Any plans to support for OEM 13.4 ? HOT 1
- oradb.opatch - OPatchauto and NApply HOT 4
- Any plans to support for RHEL 8? HOT 1
- Legacy facts used for operating system family
- Cut a new release and publish to forge HOT 3
- Run the sql for pdb database HOT 3
- Forge to Deinstall GG - golden gate
- Donate project to Voxpupuli
- How does one create multiple entries in the tnsnames.ora file?
- tnsnames.ora file doesn't identify itself with "Puppet Managed. Do not edit!" or similar HOT 1
- Add tnsnames.ora options
- PROTOCOL = for tnsnames.ora doesn't have a default value HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from biemond-oradb.