Troubleshooting
Problem
When attempting to connect to an Oracle Pluggable Database (PDB) instance using any NCP processes (e.g.,
ncp_oql), the connection fails with the following error:Cannot connect to database : CNcpOracleSth.cc line 381: (Error 1435) ORA-01435: user does not exist
Symptom
Here is an example of the error when trying to connect to database named 'NCIMDB':
#ncp_oql -domain ITNMDOMAIN -service dbId -dbId NCIMDB -username netcool -password netcool
ncp_oql ( IBM Tivoli Network Manager OQL Interface )
Copyright (C) 1997 - 2020 By IBM Corporation. All Rights Reserved. See product license for details.
IBM Tivoli Network Manager Version 4.2 (Build 311) 64 bit created by build at 06:51:00 Tue Jan 21 GMT 2025
ncp_oql ( IBM Tivoli Network Manager OQL Interface )
Copyright (C) 1997 - 2020 By IBM Corporation. All Rights Reserved. See product license for details.
IBM Tivoli Network Manager Version 4.2 (Build 311) 64 bit created by build at 06:51:00 Tue Jan 21 GMT 2025
2025-07-03T14:04:15: Warning: W-RIV-002-209: [3545626496t] CRivOQLDbClient.cc(165) Cannot connect to database : CNcpOracleSth.cc line 381: (Error 1435) ORA-01435: user does not exist
dbId: NCIMDB
dbId: NCIMDB
Cause
This indicates that the specified database user is not recognized within the target PDB, preventing successful authentication and connection.
Resolving The Problem
If you are using a Pluggable Database (PDB) as the ITNM NCIM database—which was introduced in Oracle 12c as part of the Multitenant Architecture—you should first verify the PDB name, then configure DbLogins.DOMAIN.cfg to reflect the correct value.
You could run following to know the PDB name:
SELECT name FROM v$pdbs;
SELECT name FROM v$pdbs;
Next, ensure that you have the correct schema name. In Oracle, each schema is associated with a user—so every USERNAME in the list represents a schema. To list schema names within a PDB, you can run the following query:
SELECT username FROM dba_users ORDER BY username;
SELECT username FROM dba_users ORDER BY username;
After completing the above steps, update DbLogins.DOMAIN.cfg with the correct values to ensure a successful connection.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"ARM Category":[{"code":"a8m50000000L24HAAS","label":"ITNCM-\u003EITNCM-Base-\u003EDatabase-\u003EOracle"}],"ARM Case Number":"TS019362354","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.2.0"}]
Was this topic helpful?
Document Information
Modified date:
16 July 2025
UID
ibm17239859