Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01017: invalid username/password; with Oracle Database 19c Standard Edition

user7093660May 2 2023 — edited May 2 2023

After installing Oracle Database 19c on my Windows Server, I created a database with the following tnsnames.ora (I customized the listening port).

DBNAME =
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 3496))
            (CONNECT_DATA =
                (SERVER = SHARED)
                (SERVICE_NAME = dbname.domainname.com)
        )
    )

LISTENER_DBNAME = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 3496))

When connecting to the database with the SYS user I can connect without problem :

sqlplus SYS/"sysTstPwd"@DBNAME as SYSDBA

for creating my USER I do this :

--Create USER only works if the container is set to PDB
alter session set container=PDB;


CREATE USER TSTUSER IDENTIFIED BY "tstPwd99";

grant connect to TSTUSER;
grant resource to TSTUSER;

Then I try to connect with my new USER to the database :

sqlplus TSTUSER/"tstPwd99"@DBNAME

And I get the error :

ERROR:
ORA-01017: invalid username/password ; connection refused

Could anyone help with this?

Best Regards,

Thomas

Comments
Post Details
Added on May 2 2023
3 comments
17,664 views