My Journey to the cloud…

In pursuit of excellence….

ORA-01017 error while accessing DB link from 9i to 11g

Today I faced a strange issue. Support team needed to extract some data from PeopleSoft database ( via oracle ERP database ( A database links already exists between the 2 databases but when SELECT query is fired, we were getting below error.

ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from PEOPLESOFT.WORLD

Elapsed: 00:00:01.62

and I was pretty sure that the login credential for the remote database is perfectly correct. Even I was able to connect remote DB using the same credential.

SQL>conn <a href="mailto:EMP_EXTR@Remote_DB">EMP_EXTR@Remote_DB</a>
Enter password: *********
and ses.sid=(select sid from v$mystat where rownum=1)
ERROR at line 7:
ORA-00942: table or view does not exist
Elapsed: 00:00:00.57
SQL>show user

I tried dropping and then recreating the DB link but still got the same error. I searched the error in Metalink got one direct HIT – Note ID 473716.1.

This asks to create the database link with ‘double quotes’ around the password (IDENTIFIED by clause). I dropped and recreated the database link as advised. This is due to the fact that user passwords are case-sensitive by default from 11gR1 onwards.

This resolved the error.

SQL>select sysdate from <a href="mailto:dual@PEOPLESOFT.WORLD">dual@PEOPLESOFT.WORLD</a>;


Elapsed: 00:00:00.73




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

About Me

I’m a Hands-On Technical & Entrprise Solutions Architect based out of Houston, TX. I have been working on Oracle ERP, Oracle Database and Cloud technologies for over 20 years and still going strong for learning new things.

You can connect me on Linkedin and also reach out to me

I am certified for 8x AWS, OCP (Oracle Certified Professionals), PMP, ITTL and 6 Sigma.


This is a personal blog. Any views or opinions represented in this blog are personal and belong solely to the blog owner and do not represent those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.
All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site.

The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. Any script available on the blog post MUST be tested before they are run against Production environment.


%d bloggers like this: