using oradb::autostartdatabase for multiple databases per server failing about biemond-oradb HOT 7 OPEN

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',
}

from biemond-oradb.

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

from biemond-oradb.

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

from biemond-oradb.

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

from biemond-oradb.

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.

from biemond-oradb.

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,
}

from biemond-oradb.

Hi Edwin,

Is it possible to push this fix ?

Thanks
Suresh

from biemond-oradb.