using oradb::autostartdatabase for multiple databases per server failing

[sureshr7]

Hi,

oradb::autostartdatabase { 'DEV':
oracle_home => '/u01/oracle/product/12.1.0.2/db',
db_name => 'DEV',
user => 'oracle',
service_name => 'DEV',
}
oradb::autostartdatabase { 'STG':
oracle_home => '/u01/oracle/product/12.1.0.2/dbstage',
db_name => 'STG',
user => 'oracle',
service_name => 'STG',
}
Using above code on a single server fails with error message

Error while evaluating a Resource Statement, Duplicate declaration: Class[Oradb::Prepareautostart] is already declared at (file: modules/oradb/manifests/autostartdatabase.pp, line: 27); cannot redeclare (file:modules/oradb/manifests/autostartdatabase.pp, line: 27)

Thanks
Suresh

[sureshr7]

Looks like using virtual resource solves this problem. I will test and confirm

@oradb::autostartdatabase { 'DEV':
oracle_home => '/u01/oracle/product/12.1.0.2/db',
db_name => 'DEV',
user => 'oracle',
service_name => 'DEV',
}
@oradb::autostartdatabase { 'STG':
oracle_home => '/u01/oracle/product/12.1.0.2/dbstage',
db_name => 'STG',
user => 'oracle',
service_name => 'STG',
}

[sureshr7]

Still its failing with same error if i use realize in the class

[biemond]

yep, need to make a tempate Prepareautostart for this, class can only exists once.

[sureshr7]

Thanks for the quick ack Edwin. Any workarounds to handle this ?

[biemond]

I think I need to make this a define https://github.com/biemond/biemond-oradb/blob/puppet4_3_data/manifests/prepareautostart.pp
but maybe you only need to define it once and update oratab to y for the 2nd instance. I think the service will start both.

[sureshr7]

yes. You are correct.
making https://github.com/biemond/biemond-oradb/blob/puppet4_3_data/manifests/prepareautostart.pp as define and removing the class call in https://github.com/biemond/biemond-oradb/blob/puppet4_3_data/manifests/autostartdatabase.pp fixes the problem

Call both resources explicity
oradb::autostartdatabase { $db_name:
oracle_home => $oracle_home,
db_name => $db_name,
user => $user,
service_name => $db_name,
}

oradb::prepareautostart{ $db_name:
oracle_home => $oracle_home,
user => $user,
service_name => $db_name,
}

[sureshr7]

Hi Edwin,

Is it possible to push this fix ?

Thanks
Suresh