You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I started using this module and so far it's been great but I'm having issues with making it work for getting the postscript running for pdbs.
Originally I've done it by shell and cmd:
cmd: |
{{ora_home}}/bin/sqlplus -S / as sysdba <<EOF
ALTER PLUGGABLE DATABASE {{ pdb_name }} OPEN READ WRITE;
ALTER PLUGGABLE DATABASE {{ pdb_name }} SAVE STATE;
alter session set container={{ pdb_name }};
@{{ home }}/dba/template/script/script_PDB_122_18_19.sql
EOF
My issue is to getting to run the same commands with this module since sql and sqlscript are mutually exclusive, I don't know how to get them to run together. Is anybody able to help me?
I have tried it with only sql:
sql: |
BEGIN
ALTER PLUGGABLE DATABASE {{ pdb_name }} OPEN READ WRITE;
ALTER PLUGGABLE DATABASE {{ pdb_name }} SAVE STATE;
alter session set container={{ pdb_name }};
@{{ home }}/dba/template/script/script_PDB_122_18_19.sql
END;
/
as well as having them seperated which doesn't work since the script needs to run with the alter pluggable... commands
Any help would be appreciated
The text was updated successfully, but these errors were encountered:
I started using this module and so far it's been great but I'm having issues with making it work for getting the postscript running for pdbs.
Originally I've done it by shell and cmd:
cmd: |
{{ora_home}}/bin/sqlplus -S / as sysdba <<EOF
ALTER PLUGGABLE DATABASE {{ pdb_name }} OPEN READ WRITE;
ALTER PLUGGABLE DATABASE {{ pdb_name }} SAVE STATE;
alter session set container={{ pdb_name }};
@{{ home }}/dba/template/script/script_PDB_122_18_19.sql
EOF
My issue is to getting to run the same commands with this module since sql and sqlscript are mutually exclusive, I don't know how to get them to run together. Is anybody able to help me?
I have tried it with only sql:
as well as having them seperated which doesn't work since the script needs to run with the alter pluggable... commands
Any help would be appreciated
The text was updated successfully, but these errors were encountered: