extra provision not working

[daverod24]

Hello

I did the

git clone --recursive https://github.com/oravirt/vagrant-vbox-si-fs.git

after that

Execute vagrant up

I only run the basic provision

I think the provisioning that sees the extra provision is not running well

hosts.yml

...
  create_shared_disk: false
   provisioning: extra-provision / ansible-oracle / vbox-si-fs-install.yml
   provisioning_env_override: true

in the readme I see that by default is the oracle 18 which variables should be configured for an installation in 12.102

Thanks in advance

[oravirt]

Hi,

The documentation clearly states that you need to do:
setup=true vagrant up for the provisioning step to kick in.

What the documentation doesn't state (I've forgot to add that part) is that you can do this to override the default versions. It is described in 2 other configurations that uses the same procedure though (https://github.com/oravirt/vagrant-vbox-rac#modifying-the-oracle-installation-using-environment-variables & https://github.com/oravirt/vagrant-vbox-si-asm#modifying-the-oracle-installation-using-environment-variables)

setup=true dbver=12.2.0.1 vagrant up

I'll make sure to update the README properly.

[daverod24]

Hi, thanks for the help. @oravirt I am putting the comment here in the correct repo.

I apologize that I put it in ansible-oracle
Where do I assign the name of the orclpdb?
  I'm trying to do a test by changing the values in pdbs.yml

I have another little detail with that same thing I put in the file config.rb that is in vagrant-vbox-si-fs the names in capital letters of the cbd and pdb but I'm getting an error with the tablespace that the listener can not connect.

TASK [oradb-manage-tablespace : Manage tablespaces (pdb)] **********************
failed: [db-fs-1] (item=({u'users': [{u'state': u'present', u'grants': [u'approle1'], u'default_tablespace': u'appuser1_data', u'schema': u'appuser1'}], u'cdb': u'orclcdb', u'init_parameters': [{u'scope': u'both', u'state': u'present', u'name': u'db_create_file_dest', u'value': u'/u02/oradata/'}], u'pdb_name': u'orclpdb1', u'datafile_dest': u'/u02/oradata/', u'state': u'present', u'roles': [{u'state': u'present', u'grants': [u'create session', u'create table', u'select any table', u'select any dictionary'], u'name': u'approle1'}], u'services': [{u'state': u'started', u'name': u'app1_service'}], u'home': u'18300-base'}, {u'name': u'users', u'autoextend': False, u'state': u'present', u'next': u'5M', u'content': u'permanent', u'maxsize': u'500M', u'bigfile': True, u'size': u'10M'})) => {"changed": false, "item": [{"cdb": "orclcdb", "datafile_dest": "/u02/oradata/", "home": "18300-base", "init_parameters": [{"name": "db_create_file_dest", "scope": "both", "state": "present", "value": "/u02/oradata/"}], "pdb_name": "orclpdb1", "roles": [{"grants": ["create session", "create table", "select any table", "select any dictionary"], "name": "approle1", "state": "present"}], "services": [{"name": "app1_service", "state": "started"}], "state": "present", "users": [{"default_tablespace": "appuser1_data", "grants": ["approle1"], "schema": "appuser1", "state": "present"}]}, {"autoextend": false, "bigfile": true, "content": "permanent", "maxsize": "500M", "name": "users", "next": "5M", "size": "10M", "state": "present"}], "msg": "Could not connect to database - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor, connect descriptor: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db-fs-1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclpdb1)))"}
failed: [db-fs-1] (item=({u'users': [{u'state': u'present', u'grants': [u'approle1'], u'default_tablespace': u'appuser1_data', u'schema': u'appuser1'}], u'cdb': u'orclcdb', u'init_parameters': [{u'scope': u'both', u'state': u'present', u'name': u'db_create_file_dest', u'value': u'/u02/oradata/'}], u'pdb_name': u'orclpdb1', u'datafile_dest': u'/u02/oradata/', u'state': u'present', u'roles': [{u'state': u'present', u'grants': [u'create session', u'create table', u'select any table', u'select any dictionary'], u'name': u'approle1'}], u'services': [{u'state': u'started', u'name': u'app1_service'}], u'home': u'18300-base'}, {u'name': u'appuser1_data', u'autoextend': False, u'state': u'present', u'next': u'5M', u'content': u'permanent', u'maxsize': u'500M', u'bigfile': True, u'size': u'10M'})) => {"changed": false, "item": [{"cdb": "orclcdb", "datafile_dest": "/u02/oradata/", "home": "18300-base", "init_parameters": [{"name": "db_create_file_dest", "scope": "both", "state": "present", "value": "/u02/oradata/"}], "pdb_name": "orclpdb1", "roles": [{"grants": ["create session", "create table", "select any table", "select any dictionary"], "name": "approle1", "state": "present"}], "services": [{"name": "app1_service", "state": "started"}], "state": "present", "users": [{"default_tablespace": "appuser1_data", "grants": ["approle1"], "schema": "appuser1", "state": "present"}]}, {"autoextend": false, "bigfile": true, "content": "permanent", "maxsize": "500M", "name": "appuser1_data", "next": "5M", "size": "10M", "state": "present"}], "msg": "Could not connect to database - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor, connect descriptor: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db-fs-1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclpdb1)))"}

[daverod24]

thank you I made the changes you told me and it worked

modify the pds file and get up without problems

Thanks in advance for the help