{"action":"created","issue":{"url":"https://api.github.com/repos/biemond/biemond-oradb/issues/133","repository_url":"https://api.github.com/repos/biemond/biemond-oradb","labels_url":"https://api.github.com/repos/biemond/biemond-oradb/issues/133/labels{/name}","comments_url":"https://api.github.com/repos/biemond/biemond-oradb/issues/133/comments","events_url":"https://api.github.com/repos/biemond/biemond-oradb/issues/133/events","html_url":"https://github.com/biemond/biemond-oradb/issues/133","id":177348241,"number":133,"title":"Add ability to use ASM diskgroups for pluggable database","user":{"login":"Mortinke","id":11607896,"avatar_url":"https://avatars.githubusercontent.com/u/11607896?v=3","gravatar_id":"","url":"https://api.github.com/users/Mortinke","html_url":"https://github.com/Mortinke","followers_url":"https://api.github.com/users/Mortinke/followers","following_url":"https://api.github.com/users/Mortinke/following{/other_user}","gists_url":"https://api.github.com/users/Mortinke/gists{/gist_id}","starred_url":"https://api.github.com/users/Mortinke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mortinke/subscriptions","organizations_url":"https://api.github.com/users/Mortinke/orgs","repos_url":"https://api.github.com/users/Mortinke/repos","events_url":"https://api.github.com/users/Mortinke/events{/privacy}","received_events_url":"https://api.github.com/users/Mortinke/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-16T05:30:59Z","updated_at":"2016-09-16T08:01:38Z","closed_at":null,"body":"Currently, we use the _$pdb_datafile_destination_ parameter to verify that the pluggable database already exists. \r\n\r\n```\r\n    exec { \"dbca pdb execute ${title}\":\r\n      command   => $command,\r\n      timeout   => 0,\r\n      path      => $execPath,\r\n      cwd       => $oracle_home_dir,\r\n      user      => $user,\r\n      group     => $group,\r\n      creates   => $pdb_datafile_destination,\r\n      logoutput => $log_output,\r\n    }\r\n```\r\n\r\nIf I want use asm diskgroups for the _$pdb_datafile_destination_ parameter like '+DATA', i get the error, that the value for the _creates_ parameter from _exec_ must be a full qualified path. Thus, we can not use ASM disksgroups for pluggable databases."},"comment":{"url":"https://api.github.com/repos/biemond/biemond-oradb/issues/comments/247541595","html_url":"https://github.com/biemond/biemond-oradb/issues/133#issuecomment-247541595","issue_url":"https://api.github.com/repos/biemond/biemond-oradb/issues/133","id":247541595,"user":{"login":"Mortinke","id":11607896,"avatar_url":"https://avatars.githubusercontent.com/u/11607896?v=3","gravatar_id":"","url":"https://api.github.com/users/Mortinke","html_url":"https://github.com/Mortinke","followers_url":"https://api.github.com/users/Mortinke/followers","following_url":"https://api.github.com/users/Mortinke/following{/other_user}","gists_url":"https://api.github.com/users/Mortinke/gists{/gist_id}","starred_url":"https://api.github.com/users/Mortinke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mortinke/subscriptions","organizations_url":"https://api.github.com/users/Mortinke/orgs","repos_url":"https://api.github.com/users/Mortinke/repos","events_url":"https://api.github.com/users/Mortinke/events{/privacy}","received_events_url":"https://api.github.com/users/Mortinke/received_events","type":"User","site_admin":false},"created_at":"2016-09-16T08:01:38Z","updated_at":"2016-09-16T08:01:38Z","body":"One solution could be to use the _postPDBCreation.log_ or _plugDatabase.log_ file, which always created at the end of the creation process from the plugable database in the directory ${oracle_base}/cfgtoollogs/dbca/${source_db}/${pdb_name}.\r\n```\r\nls -lr /u01/app/oracle/cfgtoollogs/dbca/devdb/devpdb/\r\ntotal 12\r\n-rw-r-----. 1 oracle dba   7 Sep 16 01:02 postPDBCreation.log\r\n-rw-r-----. 1 oracle dba 251 Sep 16 01:02 plugDatabase.log\r\n-rw-r-----. 1 oracle dba 503 Sep 16 01:02 devdb.log \r\n```\r\nUnfortunately, this files are not delete if the plugable database is deleted.\r\n\r\nOnce a plugable database has been deleted, a deletePDB.log file is always created in the directory ${oracle_base}/cfgtoollogs/dbca/${source_db}/upcase(${pdb_name})/\r\n```\r\nls -ltr /u01/app/oracle/cfgtoollogs/dbca/devdb/DEVPDB\r\ntotal 0\r\n-rw-r-----. 1 oracle oinstall 0 Sep 16 06:52 deletePDB.log\r\n```\r\nPossibly we could use this file to check which file is older, the _postPDBCreation.log_ or the _deletePDB.log_ file.\r\n"}}
{"actor":{"display_login":"Mortinke"}}