*******ORACLE Apps DBA & ORACLE DBA Blog*******: After Upgrade to 19c database for my EBS environment getting invalid username/password error when opening forms.

Error:

ORA-1017 when opening Forms and ORA-1017 Invalid username/password; logon denied FRM-41352 failed to create a new session

Cause:

Mis-configuration with the listener and registration of services:

Refs:

19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1) - ORA-1017 when opening Forms and ORA-1017 Invalid username/password; logon denied FRM-41352 failed to create a new session

Connection Attempt to Pluggable Database PDB Fails with ORA-01017 (Doc ID 2169712.1)

Doc ID 2662860.1

Doc ID 2169712.1

Solution:

$. PRODCDB_proderpdb.env

$sqlplus / as sysdba

SQL>alter System set SERVICE_NAMES='PRODCDB' SCOPE=BOTH;

The ORA-44787: Service cannot be switched into error occurs because the desired pluggable database (PDB), PROD, either does not have a service running or

the default service has been inadvertently disabled or dropped.

The most straightforward way to resolve this issue is to restart the PDB.

Resolution Steps

Connect to the root container (CDB$ROOT) as a user with SYSDBA privileges:

sql

SQL>CONNECT sys/password@your_tns_alias AS SYSDBA;

SQL>CONNECT sys/oracle@PRODCDB AS SYSDBA;

SQL>ALTER SESSION SET CONTAINER=CDB$ROOT;

Close the target PDB immediately:

sql

SQL>ALTER PLUGGABLE DATABASE PROD CLOSE IMMEDIATE;

Reopen the PDB. This action automatically recreates and starts the default service associated with the PDB name:

sql

SQL>ALTER PLUGGABLE DATABASE PROD OPEN;

Verify the service is active by querying V$ACTIVE_SERVICES or CDB_SERVICES to confirm that PROD is listed as a running service:

sql

SQL>SELECT NAME FROM V$ACTIVE_SERVICES;

-- or

SELECT service_id, name, pdb, con_id FROM cdb_services ORDER BY con_id;

Switch the session into the PDB:

sql

SQL>ALTER SESSION SET CONTAINER=PROD;

SQL>exec dbms_service.create_service(service_name => 'PROD',network_name => 'PROD'); if not exist

SQL>exec dbms_service.start_service('PROD');

SQL>exec dbms_service.start_service('PROD_ebs_patch');

[oracle@proderpdb ~]$ lsnrctl status PRODCDB

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-FEB-2026 18:17:11

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=proderpdb.n.in)(PORT=1536)))

STATUS of the LISTENER

------------------------

Alias PRODCDB

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 03-FEB-2026 17:45:12

Uptime 0 days 0 hr. 31 min. 59 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oradata/prod/app/oracle/product/19.3.0/network/admin/listener.ora

Listener Log File /oradata/prod/app/oracle/product/19.3.0/log/diag/tnslsnr/proderpdb/prodcdb/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=proderpdb.n.in)(PORT=1536)))

Services Summary...

Service "45fdca432aea7f40e0632afc180a9d5a" has 1 instance(s).