CCS Asset System: Oracle Server Database is not showing after running the import assets job
search cancel

CCS Asset System: Oracle Server Database is not showing after running the import assets job

book

Article ID: 155414

calendar_today

Updated On:

Products

Control Compliance Suite Windows

Issue/Introduction

You run the asset import job in CCS and the Oracle Server Database is not showing in Asset System.

The following errors may appear in the logs:

*** BVJobProcessor_xxxx.log ***

(...)
2AA|    1040|bvjobprocess|         OCCIConnection.cpp|   36|10/14/2011| 8:25:40:748|Critical Failure:ORA-28001: the password has expired
(...)
 
(...)
  48|    1CD8|bvjobprocess|         OCCIConnection.cpp|   36|10/14/2011| 8:20:38:818|Critical Failure:ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
(...)
 
(...)
  82|    1D94|bvjobprocess|BVOServerConfigurationDataS|  156|10/14/2011| 8:25:38:498|Critical Failure:Error interpreting SQLNET contents.
(...)

Resolution

According to the error messages there may be one or several of the following Oracle problems:
 
1. The Oracle Database user password has expired and needs to be changed
2. The Oracle Database is not started
3. The Oracle Listener is not started
4. The Oracle Listener is not able to identify the target Database