Stack Overflow
Stack Overflow

Questions tagged [ora-01017]

ORA-01017: invalid username/password; logon denied

ORA-01017 is the error code shown by Oracle when a login attempt to the database was not successful.

The full text of the error code is:

ORA-01017: invalid username/password; logon denied

Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.

Action: Enter a valid username and password combination in the correct format.

DBA-Oracle has a checklist for ORA-0107 errors. Though the core problem is incorrect credentials, the reason for incorrect credentials may be one of the below:

  • The user id may not be present in the target system
  • $ORACLE_SID maybe incorrectly defined, leading to a connection attempt to a wrong system
  • tnanames.ora points to an incorrect instance

Also, if you upgraded a pre-Oracle 11g instance to Oracle 11g & above, you might start encountering ORA-0107 messages. The reason is Oracle 11g & above, by default support case sensitive passwords, as opposed to previous versions where all passwords were set to upper case.

This behavior can be set to status quo by using SEC_CASE_SENSITIVE_LOGON parameter, as explained by Mark Williams.

41 questions
16
votes
9 answers

Oracle.ManagedDataAccess and ORA-01017: invalid username/password; logon denied

I have a challenging situation on one of our servers. I have an ASP.NET MVC 3 application that needs to connect to an Oracle 12c database. It does so using the following connection string: User ID=myuserid;Password=mypass;Data…
DerHaifisch
  • 394
  • 1
  • 5
  • 14
9
votes
6 answers

WebSphere to Oracle - doesn't accept correct password

In WebSphere 6.1 I have created a datasource to an Oracle 11g instance using the thin JDBC client. In Oracle I have two users, one existing and another newly created. My websphere datasource is OK if I use the component-managed authentication alias…
Synesso
  • 37,610
  • 35
  • 136
  • 207
8
votes
1 answer

Oracle database link

I'm currently using Windows Authentication with 2 Oracle servers - SP3DSMP1 & SP3DSMP4. I created a database link on SMP1 to connect to SMP4 as: SQL> create public database link LINK_SMP4 2 connect to CURRENT_USER 3 using 'SP3DSMP4'; Database…
Sunit
  • 519
  • 1
  • 8
  • 20
5
votes
4 answers

Oracle JDBC : invalid username/password (ora-01017)

I have a strange problem with jdbc connection to an oracle database server. We've applications on a tomcat server running. These application use an oracle database. All applications use the same credentials. Applications running fine the whole day.…
Hajo Thelen
  • 1,095
  • 1
  • 11
  • 16
4
votes
4 answers

Sqlplus login error when using bash variables: SP2-0306: Invalid option

I have a bash script that connects to an oracle 10g database. In a first step it takes some variables from a "config" file with the following command . /path/to/my/configfile.ini In the config file there are some variables: export…
rsinuhe
  • 177
  • 1
  • 2
  • 9
4
votes
3 answers

Connecting to Oracle19C Server using Oracle11g client

all I'm trying to connect to an Oracle 19C database. I have installed two Oracle Clients (11g and 12c) because we need to support legacy programs. I can connect with no issue with any user using sqlplus through the 12c client. But if I use the 11g…
Carlos S. Na
  • 63
  • 1
  • 2
  • 7
3
votes
3 answers

How can I connect to an Oracle database as SYSDBA using dbExpress?

I have a Delphi application that connects to an oracle database. When I try to log in as SYSDBA, I get the error: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER When I try to log in with a user of "SYS AS SYSDBA", I get the…
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
3
votes
2 answers

Ant task to check if a database (connection) exists?

is there a possibility in ANT to check whether a database (connection) exists or not without failing the build? For example:
Peter
  • 439
  • 3
  • 7
  • 12
3
votes
3 answers

oracle express sytem Invalid Login Credentials

I just installed oracle express, I'm trying to login at database homepage. trying with user sys and system with the password I gave at the installation but I cant log in. message: Invalid Login Credentials at SQL command line trying to connect…
azevik
  • 31
  • 1
  • 1
  • 2
3
votes
3 answers

ORA-01017: invalid username/password; logon denied when using wss4j

I have many tests which access our Oracle DB without a problem, however when I run these tests along with other tests in our codebase which use a keystore, the tests that interact with the DB are no longer able to connect. Here is the exception…
jjathman
  • 12,536
  • 8
  • 29
  • 33
2
votes
0 answers

Weblogic 10.3.1 + Oracle DB 10g : Invalid username / password on LOB insert

i am working on a project using Hibernate 3.3.SP1 + Spring 1.2.6 on Weblogic 10.3.1 with Oracle DB 10g. Recently, we migrated Hibernate from v3.0.5 to 3.3.SP1.A strange error occurs (that did not happen before) when trying to insert LOB (BLOB or…
Teo
  • 21
  • 1
  • 3
2
votes
0 answers

Oracle 12.2: Reset user password is not working

I have tried to import a database-dump that was created with Oracle 12.1 (12c Release 1) into my Oracle 12.2. There was some problem due to a false or invalid authentication protocol: ORA-28040: No matching authentication protocol I found some…
jkbx
  • 21
  • 4
2
votes
4 answers

Oracle XE - Just can't login after install

That sounds really stupid. On Lubuntu 10.10, I did: echo "deb http://oss.oracle.com/debian unstable main non-free" >> /etc/apt/sources.list apt-get update ; apt-get install oracle-xe That brings me Oracle XE 10.2.0.1. And…
vmassuchetto
  • 1,529
  • 1
  • 20
  • 44
2
votes
1 answer

Getting "ORA-01017: invalid username/password; logon denied" when trying to create a data source in Tomcat 6

Been pulling my hair trying to set up a data source in in Tomcat for an application. The steps I've taken are Create a META-INF/context.xml with the following content
duvo
  • 1,634
  • 2
  • 18
  • 30
1
vote
0 answers

Oracle connection string provider error from OraOLEDB.Oracle to MSDAORA.1

When I change my Oracle connectionstring provider from "OraOLEDB.Oracle" to "MSDAORA.1" it's not connecting and giving "ORA-01017: invalid username/password; logon denied" error. For example: Provider=OraOLEDB.Oracle;Data Source=XXX;User…
Ömer Faruk Ocakoğlu
  • 27
  • 4
1
2 3