Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

How to query the database for 'full_path_for_tablespace' in SA 2.0 MPDS

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:

  1. Use the SQLPlus program to log into both Oracle databases as the "system" user.
  2. 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

435
Views
0
Helpful
0
Comments