Core Issue
The 'full_path_for_tablespace' value is very important to know if the size of table space must be expanded in the Oracle database when the Service Agent (SA) 2.0 Master Provisioning Data Store (MPDS) is used.
Resolution
To query for 'full_path_for_tablespace' in both Oracle databases, perform these steps:
- Use the SQLPlus program to log into both Oracle databases as the "system" user.
- Run this command:
SQL> select tablespace_name, file_name from dba_data_files where tablespace_name = 'tablespace_name';
For example,
SQL> select tablespace_name, file_name from dba_data_files where tablespace_name = 'USERS';
SQL> /db002/oradata/database1/users01.dbf