{"action":"created","issue":{"url":"https://api.github.com/repos/hajee/oracle/issues/63","labels_url":"https://api.github.com/repos/hajee/oracle/issues/63/labels{/name}","comments_url":"https://api.github.com/repos/hajee/oracle/issues/63/comments","events_url":"https://api.github.com/repos/hajee/oracle/issues/63/events","html_url":"https://github.com/hajee/oracle/issues/63","id":64760048,"number":63,"title":"ora_tablespace does not work for me","user":{"login":"awegmann","id":2790049,"avatar_url":"https://avatars.githubusercontent.com/u/2790049?v=3","gravatar_id":"","url":"https://api.github.com/users/awegmann","html_url":"https://github.com/awegmann","followers_url":"https://api.github.com/users/awegmann/followers","following_url":"https://api.github.com/users/awegmann/following{/other_user}","gists_url":"https://api.github.com/users/awegmann/gists{/gist_id}","starred_url":"https://api.github.com/users/awegmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/awegmann/subscriptions","organizations_url":"https://api.github.com/users/awegmann/orgs","repos_url":"https://api.github.com/users/awegmann/repos","events_url":"https://api.github.com/users/awegmann/events{/privacy}","received_events_url":"https://api.github.com/users/awegmann/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-03-27T13:15:24Z","updated_at":"2015-03-30T08:11:29Z","closed_at":null,"body":"I tried to increase the `system` tablespace on a Oracle XE. \r\nThe puppet code look like this:\r\n\r\n```\r\n ora_tablespace { 'SYSTEM@XE':\r\n    ensure   => present,\r\n    datafile => '/u01/app/oracle/oradata/XE/system.dbf',\r\n    max_size => '1500M',\r\n  }\r\n```\r\nThe `ora_tablespace` type does not work for me. The error message is \r\n```\r\n    Error: Could not prefetch ora_tablespace provider 'simple': Column BIG not found in results. Results contain FILE_NAME,SEGMENT_SPACE_MANA,BLOCK_SIZE,BYTES,CONTENTS,LOGGING,TABLESPACE_NAME,SID,AUTOEXTEN,MAX_SIZE,EXTENT_MANAGEMENT,INCREMENT_BY,BIGFILE\r\n```\r\n\r\nMy first try was without the `datafile` attribute, but was the same result. Currently I'm testing this puppet manifest in a Vagrant VM with CentOS. I increased the log level to `debug` and `trace`. A `vagrant provision` on my environment gives the following output (I cut of the not so interesting log messages at the beginning):\r\n\r\n```\r\n==> default: Debug: Prefetching simple resources for ora_tablespace\r\n==> default: Debug: executing select t.tablespace_name,\r\n==> default:        t.logging,\r\n==> default:        t.extent_management,\r\n==> default:        t.segment_space_management,\r\n==> default:        t.bigfile,\r\n==> default:        f.file_name,\r\n==> default:        t.contents,\r\n==> default:        to_char(f.increment_by, '9999999999999999999') as increment_by,\r\n==> default:        to_char(t.block_size, '9999999999999999999') as block_size,\r\n==> default:        f.autoextensible,\r\n==> default:        to_char(f.bytes, '9999999999999999999') as bytes,\r\n==> default:        to_char(f.maxbytes, '9999999999999999999') as max_size\r\n==> default: from   dba_tablespaces t, \r\n==> default:        dba_data_files f \r\n==> default: where  t.tablespace_name = f.tablespace_name\r\n==> default:  on XE\r\n==> default: Debug: Executing sql statement :\r\n==> default:  select t.tablespace_name,\r\n==> default:        t.logging,\r\n==> default:        t.extent_management,\r\n==> default:        t.segment_space_management,\r\n==> default:        t.bigfile,\r\n==> default:        f.file_name,\r\n==> default:        t.contents,\r\n==> default:        to_char(f.increment_by, '9999999999999999999') as increment_by,\r\n==> default:        to_char(t.block_size, '9999999999999999999') as block_size,\r\n==> default:        f.autoextensible,\r\n==> default:        to_char(f.bytes, '9999999999999999999') as bytes,\r\n==> default:        to_char(f.maxbytes, '9999999999999999999') as max_size\r\n==> default: from   dba_tablespaces t, \r\n==> default:        dba_data_files f \r\n==> default: where  t.tablespace_name = f.tablespace_name\r\n==> default: \r\n==> default: Debug: Executing sqlplus -S /nolog  command: @/tmp/command20150327-7125-4z8u9h-0.sql on XE as oracle, connected as sysdba\r\n==> default: Debug: Executing 'su - oracle -c \"export ORACLE_SID=XE;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog  @/tmp/command20150327-7125-4z8u9h-0.sql\"'\r\n==> default: Error: Could not prefetch ora_tablespace provider 'simple': Column BIG not found in results. Results contain FILE_NAME,SEGMENT_SPACE_MANA,BLOCK_SIZE,BYTES,CONTENTS,LOGGING,TABLESPACE_NAME,SID,AUTOEXTEN,MAX_SIZE,EXTENT_MANAGEMENT,INCREMENT_BY,BIGFILE\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/helpers.rb:34:in `column_data'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/helpers.rb:33:in `fetch'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/helpers.rb:33:in `column_data'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/puppet/type/ora_tablespace/bigfile.rb:8:in `translate_to_resource'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:207:in `map_raw_to_resource'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:206:in `each'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:206:in `map_raw_to_resource'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:180:in `instances'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:179:in `map'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:179:in `instances'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:193:in `prefetch'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:277:in `prefetch'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:167:in `prefetch_if_necessary'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:67:in `evaluate'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/graph/relationship_graph.rb:116:in `call'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/graph/relationship_graph.rb:116:in `traverse'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:108:in `evaluate'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:164:in `apply'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/log.rb:149:in `with_destination'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction/report.rb:108:in `as_logging_destination'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:163:in `apply'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/configurer.rb:125:in `apply_catalog'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:161:in `benchmark'\r\n==> default: /usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:160:in `benchmark'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/configurer.rb:124:in `apply_catalog'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/configurer.rb:192:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application/apply.rb:268:in `apply_catalog'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application/apply.rb:218:in `main'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application/apply.rb:146:in `run_command'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:364:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:470:in `plugin_hook'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:364:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:478:in `exit_on_fail'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:364:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/command_line.rb:137:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/command_line.rb:91:in `execute'\r\n==> default: /usr/bin/puppet:4\r\n==> default: Debug: Executing sql statement :\r\n==> default:  create   tablespace \"SYSTEM\"\r\n==> default: Debug: Executing sqlplus -S /nolog  command: @/tmp/command20150327-7125-whopz2-0.sql on XE as oracle, connected as sysdba\r\n==> default: Debug: Executing 'su - oracle -c \"export ORACLE_SID=XE;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog  @/tmp/command20150327-7125-whopz2-0.sql\"'\r\n==> default: Error: Execution of 'su - oracle -c \"export ORACLE_SID=XE;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog  @/tmp/command20150327-7125-whopz2-0.sql\"' returned 151: ORACLE_BASE environment variable is not being set since this\r\n==> default: information is not available for the current user ID oracle.\r\n==> default: You can set ORACLE_BASE manually if it is required.\r\n==> default: create\t tablespace \"SYSTEM\"\r\n==> default:                            *\r\n==> default: ERROR at line 1:\r\n==> default: ORA-02199: missing DATAFILE/TEMPFILE clause\r\n==> default: \r\n==> default: \r\n==> default: \r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/execution.rb:188:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sqlplus_command.rb:26:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/ora_command.rb:56:in `within_time'\r\n==> default: /usr/lib/ruby/1.8/timeout.rb:67:in `timeout'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/ora_command.rb:55:in `within_time'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sqlplus_command.rb:24:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sqlplus_command.rb:35:in `execute_sql_command'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sql.rb:22:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/oracle_access.rb:95:in `sql'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/command_entry.rb:25:in `send'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/command_entry.rb:25:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/blank_slate.rb:36:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/blank_slate.rb:35:in `each'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/blank_slate.rb:35:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/blank_slate.rb:34:in `each'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/blank_slate.rb:34:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/script_builder.rb:120:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/provider.rb:60:in `create'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/property/ensure.rb:16:in `set_present'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/property.rb:197:in `send'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/property.rb:197:in `call_valuemethod'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/property.rb:498:in `set'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/property.rb:581:in `sync'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction/resource_harness.rb:191:in `sync'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction/resource_harness.rb:128:in `sync_if_needed'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction/resource_harness.rb:81:in `perform_changes'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction/resource_harness.rb:20:in `evaluate'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:174:in `apply'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:187:in `eval_resource'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:117:in `call'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:117:in `evaluate'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:327:in `thinmark'\r\n==> default: /usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:326:in `thinmark'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:117:in `evaluate'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/graph/relationship_graph.rb:118:in `traverse'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction.rb:108:in `evaluate'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:164:in `apply'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/log.rb:149:in `with_destination'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/transaction/report.rb:108:in `as_logging_destination'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/resource/catalog.rb:163:in `apply'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/configurer.rb:125:in `apply_catalog'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:161:in `benchmark'\r\n==> default: /usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:160:in `benchmark'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/configurer.rb:124:in `apply_catalog'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/configurer.rb:192:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application/apply.rb:268:in `apply_catalog'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application/apply.rb:218:in `main'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application/apply.rb:146:in `run_command'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:364:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:470:in `plugin_hook'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:364:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util.rb:478:in `exit_on_fail'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/application.rb:364:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/command_line.rb:137:in `run'\r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/command_line.rb:91:in `execute'\r\n==> default: /usr/bin/puppet:4\r\n==> default: \r\n==> default: Error: /Stage[main]/Roles_ci::Profiles::Oracle/Ora_tablespace[SYSTEM@XE]/ensure: change from absent to present failed: Execution of 'su - oracle -c \"export ORACLE_SID=XE;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog  @/tmp/command20150327-7125-whopz2-0.sql\"' returned 151: ORACLE_BASE environment variable is not being set since this\r\n==> default: information is not available for the current user ID oracle.\r\n==> default: You can set ORACLE_BASE manually if it is required.\r\n==> default: create\t tablespace \"SYSTEM\"\r\n==> default:                            *\r\n==> default: ERROR at line 1:\r\n==> default: ORA-02199: missing DATAFILE/TEMPFILE clause\r\n==> default: \r\n==> default: \r\n==> default: \r\n==> default: Notice: /Stage[final]/Swarm::Service/Service[swarm]: Dependency Ora_tablespace[SYSTEM@XE] has failures: true\r\n==> default: \r\n==> default: Debug: Finishing transaction 69887129252140\r\n==> default: Debug: Storing state\r\n==> default: Warning: /Stage[final]/Swarm::Service/Service[swarm]: Skipping because of failed dependencies\r\n==> default: Debug: Stored state in 0.02 seconds\r\n```\r\n\r\nSo it looks like parsing the result from the SQL command has some problems. When I execute the SELECT statement in DbVisualizer with this DB I get the following results:\r\n\r\n```\r\nTABLESPACE_NAME LOGGING EXTENT_MANAGEMENT SEGMENT_SPACE_MANAGEMENT BIGFILE FILE_NAME                               CONTENTS  INCREMENT_BY         BLOCK_SIZE           AUTOEXTENSIBLE BYTES                MAX_SIZE             \r\n--------------- ------- ----------------- ------------------------ ------- --------------------------------------- --------- -------------------- -------------------- -------------- -------------------- -------------------- \r\nUSERS           LOGGING LOCAL             AUTO                     NO      /u01/app/oracle/oradata/XE/users.dbf    PERMANENT                 1280                 8192 YES                       104857600          11811160064 \r\nSYSAUX          LOGGING LOCAL             AUTO                     NO      /u01/app/oracle/oradata/XE/sysaux.dbf   PERMANENT                 1280                 8192 YES                       671088640          34359721984 \r\nUNDOTBS1        LOGGING LOCAL             MANUAL                   NO      /u01/app/oracle/oradata/XE/undotbs1.dbf UNDO                       640                 8192 YES                        26214400          34359721984 \r\nSYSTEM          LOGGING LOCAL             MANUAL                   NO      /u01/app/oracle/oradata/XE/system.dbf   PERMANENT                 1280                 8192 YES                       377487360            629145600 \r\n```\r\nIs it possible to change the `system` table space with the upper puppet code? It's again a lot of magic you do in your Ruby code ;-) so I would be happy to get a hint what to do. I even can try to fix the problem (maybe it's a Oracle XE issue again which does not happen on 'normal' Oracle) and provide you a pull request, but at the moment I don't know where to look at. \r\n\r\nRegards \r\n Andreas"},"comment":{"url":"https://api.github.com/repos/hajee/oracle/issues/comments/87585256","html_url":"https://github.com/hajee/oracle/issues/63#issuecomment-87585256","issue_url":"https://api.github.com/repos/hajee/oracle/issues/63","id":87585256,"user":{"login":"awegmann","id":2790049,"avatar_url":"https://avatars.githubusercontent.com/u/2790049?v=3","gravatar_id":"","url":"https://api.github.com/users/awegmann","html_url":"https://github.com/awegmann","followers_url":"https://api.github.com/users/awegmann/followers","following_url":"https://api.github.com/users/awegmann/following{/other_user}","gists_url":"https://api.github.com/users/awegmann/gists{/gist_id}","starred_url":"https://api.github.com/users/awegmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/awegmann/subscriptions","organizations_url":"https://api.github.com/users/awegmann/orgs","repos_url":"https://api.github.com/users/awegmann/repos","events_url":"https://api.github.com/users/awegmann/events{/privacy}","received_events_url":"https://api.github.com/users/awegmann/received_events","type":"User","site_admin":false},"created_at":"2015-03-30T08:11:29Z","updated_at":"2015-03-30T08:11:29Z","body":"After adding other columns to the SELECT statement I now get the following log messages:\r\n\r\n```\r\n==> default: Debug: Executing sqlplus -S /nolog  command: @/tmp/command20150330-7158-1a4sl5f-0.sql on XE as oracle, connected as sysdba\r\n==> default: Debug: Executing 'su - oracle -c \"export ORACLE_SID=XE;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog  @/tmp/command20150330-7158-1a4sl5f-0.sql\"'\r\n==> default: Notice: /Stage[main]/Roles_ci::Profiles::Oracle/Ora_tablespace[SYSTEM@XE]/size: size changed '377487360' to '1572864000'\r\n==> default: Debug: Executing sql statement :\r\n==> default:  alter tablespace \"SYSTEM\" resize 1572864000 \r\n==> default: Debug: Executing sqlplus -S /nolog  command: @/tmp/command20150330-7158-1thouac-0.sql on XE as oracle, connected as sysdba\r\n==> default: Debug: Executing 'su - oracle -c \"export ORACLE_SID=XE;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog  @/tmp/command20150330-7158-1thouac-0.sql\"'\r\n==> default: Error: /Stage[main]/Roles_ci::Profiles::Oracle/Ora_tablespace[SYSTEM@XE]: Could not evaluate: Execution of 'su - oracle -c \"export ORACLE_SID=XE;export ORAENV_ASK=NO;. oraenv; sqlplus -S /nolog  @/tmp/command20150330-7158-1thouac-0.sql\"' returned 5: ORACLE_BASE environment variable is not being set since this\r\n==> default: information is not available for the current user ID oracle.\r\n==> default: You can set ORACLE_BASE manually if it is required.\r\n==> default: alter tablespace \"SYSTEM\" resize 1572864000\r\n==> default: *\r\n==> default: ERROR at line 1:\r\n==> default: ORA-32773: operation not supported for smallfile tablespace SYSTEM\r\n==> default: \r\n==> default: \r\n==> default: \r\n==> default: /usr/lib/ruby/site_ruby/1.8/puppet/util/execution.rb:188:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sqlplus_command.rb:26:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/ora_command.rb:56:in `within_time'\r\n==> default: /usr/lib/ruby/1.8/timeout.rb:67:in `timeout'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/ora_command.rb:55:in `within_time'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sqlplus_command.rb:24:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sqlplus_command.rb:35:in `execute_sql_command'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/sql.rb:22:in `execute'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/oracle/lib/ora_utils/oracle_access.rb:95:in `sql'\r\n==> default: /tmp/vagrant-puppet/modules-23e45672cefa82348835335c4cc81070/easy_type/lib/easy_type/command_entry.rb:25:in `send'\r\n```\r\n\r\nAs far as I understand, the problem is that the `SYSTEM` tablespace is a `SMALLFILE` type, which cannot be changed with an `ALTER TABLESPACE` in this way. So, `SMALLFILE` databases seems to be \"traditional\" and `BIGFILE` databases seem to be newer file type (I'm not a Oracle DBA, sorry). \r\n\r\nI found several other postings and blog entries for this topic and maybe I can do this with the following statement: \r\n\r\n```SQL\r\nalter database datafile '/u01/app/oracle/oradata/XE/system.dbf' resize 1500M;\r\n```\r\n\r\nThe official [Oracle documentations](http://docs.oracle.com/cd/B19306_01/server.102/b14220/physical.htm#i14068) explains the SYSTEM dataspaces are `SMALLFILE` by default.\r\n\r\n> The system default is to create a smallfile tablespace, which is the traditional type of Oracle tablespace. The SYSTEM and SYSAUX tablespace types are always created using the system default type.\r\n\r\nMaybe therefor the `ALTER TABLESPACE` will not work out-of-the-box changing these tablespaces. \r\n\r\nI'm not sure if I tell you something new. Would it be a good idea to issue different statements according to the type of the tablespace? Shall we try to add this functionality to `ora_tablespace`?\r\n\r\nRegards\r\n Andreas \r\n\r\n\r\n\r\n"}}