sid in 12.2

[pmpetit]

Hello, if you create a database 12.2 for example (SID=MYDB01) (hostname=MYSERVER01) then in the oratb file, instead of

MYDB01:/u01/app/oracle/product/12.2/db12c02:Y you will see MYDB01MYSERV:/u01/app/oracle/product/12.2/db12c02:Y

i am testing executing dbca with -sid parameter:

-sid ${db_name}

i keep you informed

[pmpetit]

i can confirm that executing /u01/app/oracle/product/12.2/db12c02/bin/dbca -silent -createDatabase -templateName /u01/app/stage/oracle/db/mytemplate.dbt -gdbname dkt122.preprod.org -characterSet AL32UTF8 -responseFile NO_VALUE -sysPassword xxxxxx -systemPassword xxxxxx -dbsnmpPassword xxxxx -asmsnmpPassword Welcome01 -emConfiguration NONE -variables dummy=/tmp -initParams DB_UNIQUE_NAME=MYDB01_MYSERVER01,sga_target=1024M,sga_max_size=1024M will produce

MYDB01MYSERV:/u01/app/oracle/product/12.2/db12c02:Y

but executing /u01/app/oracle/product/12.2/db12c02/bin/dbca -silent -createDatabase -templateName /u01/app/stage/oracle/db/mytemplate.dbt -gdbname dkt122.preprod.org -characterSet AL32UTF8 -responseFile NO_VALUE -sysPassword xxxxxx -systemPassword xxxxxx -dbsnmpPassword xxxxx -asmsnmpPassword Welcome01 -emConfiguration NONE -variables dummy=/tmp -initParams DB_UNIQUE_NAME=MYDB01_MYSERVER01,sga_target=1024M,sga_max_size=1024M -sid MYDB01

will produce MYDB01:/u01/app/oracle/product/12.2/db12c02:Y

in the oratab

[biemond]

Thanks

So what do you suggest, Should I add the sid parameter and will this also works for 12.1 or 11g

[pmpetit]

hi, yes, i have tested adding -sid for all version and it is ok there is no regression ... so you should add - sid param thanks

Envoyé de mon iPhone

Le 27 mars 2017 à 21:24, Edwin Biemond [email protected] a écrit :

Thanks

So what do you suggest, Should I add the sid parameter and will this also works for 12.1 or 11g

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[biemond]

Perfect, I will add this.

I guess I can use db_name for this sid param https://github.com/biemond/biemond-oradb/blob/master/manifests/database.pp#L107

Also I can replace template_variables with init_params.

thanks

[biemond]

So I changed this

3.0.7

• database.pp now also use init_params for dbt templates
• database.pp set sid with db_name on dbt templates
• database.pp changed template_variables for dbt templates to a hash

I had to use variablesFile else I will get some strange NPE exception

[pmpetit]

Ok, i will check asap

thanks

2017-03-29 22:23 GMT+02:00 Edwin Biemond [email protected]:

So I changed this 3.0.7

• database.pp now also use init_params for dbt templates
• database.pp set sid with db_name on dbt templates
• database.pp changed template_variables for dbt templates to a hash

I had to use variablesFile else I will get some strange NPE exception

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/biemond/biemond-oradb/issues/156#issuecomment-290214362, or mute the thread https://github.com/notifications/unsubscribe-auth/AD3wMTVb9iJJ7ntMLdXiTjSFpSA3ehfxks5rqr3PgaJpZM4MqcEO .

[pmpetit]

I am working on a version that will build a dataguard configuration....

2017-03-30 8:46 GMT+02:00 Petit Pierre-Marie [email protected]:

Ok, i will check asap

thanks

2017-03-29 22:23 GMT+02:00 Edwin Biemond [email protected]:

So I changed this 3.0.7

• database.pp now also use init_params for dbt templates
• database.pp set sid with db_name on dbt templates
• database.pp changed template_variables for dbt templates to a hash

I had to use variablesFile else I will get some strange NPE exception

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/biemond/biemond-oradb/issues/156#issuecomment-290214362, or mute the thread https://github.com/notifications/unsubscribe-auth/AD3wMTVb9iJJ7ntMLdXiTjSFpSA3ehfxks5rqr3PgaJpZM4MqcEO .