ORA-01017 Invalid Username Password when connecting to 11g database from 9i client

0 votes
Have been trying to connect to a schema in 11g (v11.2.0.1.0) from a PC with a 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error every time. The username and password are DEFINITELY correct - can anyone think of a reason why this wouldn't work? Are there any fundamental incompatibilities between 9i and 11g?
Feb 22, 2022 in Others by Rahul
• 9,680 points
1,586 views

1 answer to this question.

0 votes

The user and password are DEFINITELY incorrect and additionally, the Oracle 11g credentials are case sensitive. Try to ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; and alter password by clicking on the link below:-

http://oracle-base.com/articles/11g/case-sensitive-passwords-11gr1.php

answered Feb 22, 2022 by Aditya
• 7,680 points

Related Questions In Others

0 votes
0 answers

AWS: can't connect to RDS database from my machine

When I tried to debug the code ...READ MORE

Apr 9, 2022 in Others by Kichu
• 19,040 points
825 views
0 votes
0 answers

How to drop all tables from a database with one SQL query?

What if we don't want to type ...READ MORE

May 28, 2022 in Others by Sohail
• 3,040 points
389 views
0 votes
0 answers

How to drop all tables from a database with one SQL query?

drop all tables without typing name. Is ...READ MORE

Jun 7, 2022 in Others by polo
• 1,480 points
294 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

A combination of IF(), ISNUMBER(SEARCH()), and OR() ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,600 points
1,209 views
0 votes
0 answers

Display names of all constraints for a table in Oracle SQL

I have given each constraint a name ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
• 38,000 points
876 views
0 votes
0 answers

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I am getting this error: DECLARE * ERROR at line ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
• 38,000 points
1,130 views
0 votes
0 answers

Convert timestamp to date in Oracle SQL

How can we convert timestamp to date? READ MORE

Aug 29, 2022 in Database by Kithuzzz
• 38,000 points
930 views
0 votes
0 answers

SQL Error: ORA-00942 table or view does not exist

I'm using SQL Developer, and after creating ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
• 38,000 points
1,065 views
0 votes
1 answer

error: ORA-65096: invalid common user or role name in oracle

To start with, the oerr utility is ...READ MORE

answered Feb 16, 2022 in Others by Aditya
• 7,680 points
23,974 views
0 votes
1 answer

How to get Bitmap from an Uri?

Try using the following lines of code ...READ MORE

answered Feb 18, 2022 in Others by Aditya
• 7,680 points
12,064 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP