pdm_configure fails with remote Oracle database

book

Article ID: 49671

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

When the Oracle database that is used by Service Desk Manager (SDM) is running on machine that is remote to the SDM servers, pdm_configure may fail during the database connection step. In that case, the following message may be written to the configure.log file: "Process sqlplus completed with exit code 1".

However, when using the same underlying connection syntax from the command line, "sqlplus -L SYS/[email protected]_service_name AS SYSDBA", the connection is successful.

Solution:

The connection fails because, within the pdm_configure form, when the checkbox that confirms that the database is a remote database is checked, the field containing the password value for SYS is empty and is greyed out. The result is that no password is used by pdm_configure to connect to the remote database.

To resolve this you'll have to unmark the "Remote Database" checkbox in the configuration screen during the "Oracle Database Config" phase, enter the password for SYS (the DBA User Name), and then mark again the "Remote Database" box. See Figure 1 below.

Figure 1. The page presented during the Oracle Database Config phase of pdm_configure

<Please see attached file for image>

Figure 1

Environment

Release:
Component: ARGIS

Attachments

1558712160096000049671_sktwi1f5rjvs16siy.gif get_app