Backup Exec (BE) selection does not list out Oracle tablespaces. BE only lists out {ARCHIVED LOGFILES} and {DATABASE CONTROL FILE}.

Article:TECH67796  |  Created: 2009-01-12  |  Updated: 2011-08-02  |  Article URL http://www.symantec.com/docs/TECH67796
Article Type
Technical Solution


Issue



Backup Exec (BE) selection does not list out Oracle tablespaces. BE only lists out {ARCHIVED LOGFILES} and {DATABASE CONTROL FILE}.


Error



Backup Exec (BE) selection does not list out Oracle tablespaces. BE only lists out {ARCHIVED LOGFILES} and {DATABASE CONTROL FILE}. See figure 1.

Figure 1.
 


Solution



1. Run Oracle debug mode to generate debug log file NToDebug.log. Refer to document 230456 for details.

2. Open up the NToDebug.log with a Notepad. Locate if this SQL query exists.

SELECT TSV.TABLESPACE_NAME, TSV.STATUS FROM SYS.DBA_TABLESPACES TSV, SYS.TS$ TS WHERE ( TSV.CONTENTS='PERMANENT' OR TSV.CONTENTS='UNDO' OR TS.BITMAPPED=0 ) AND TS.NAME=TSV.TABLESPACE_NAME ORDER BY TSV.TABLESPACE_NAME ASC

3. Find out the Oracle account to be used by the Backup Exec Oracle agent. Refer to Figure 2.

Figure 2.
 

4. Log on to the Oracle server's SQL Plus with this Oracle account.

5. Run a SQL query with the SQL statement as found in step 2.

There should be error messages returned, which are starting with "ORA-xxxxx".

Resolve these error messages.Refer following document for permissions required.

http://www.symantec.com/docs/TECH7563

Common causes of the "ORA-xxxxx" error messages are due to the Oracle account not having all the necessary permissions

NOTE:
Contact Oracle support if the above statement returns error even after following above document.

After assigning proper permissions for Oracle Account, this SQL statement will return entries like below successfully.

ORAParseSQL: SELECT FILE_NAME FROM SYS.DBA_DATA_FILES WHERE TABLESPACE_NAME = 'SYSTEM'
ORAParseSQL: SELECT FILE_NAME FROM SYS.DBA_DATA_FILES WHERE TABLESPACE_NAME = 'UNDOTBS1'

 




Legacy ID



319396


Article URL http://www.symantec.com/docs/TECH67796


Terms of use for this information are found in Legal Notices