How to fix the Oracle error ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)?

In this post, you’ll learn more about the Oracle ErrorORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

Reason for the Error ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

There are several possible causes for this message: First, you will get this message if your username in the second database specified was not granted the CREATE SESSION system privilege. Second, you will get this message if the username specified in the connect string of the database link definition was not granted the CREATE SESSION system privilege.

How to fix the Error ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string) ?

You can fix this error in Oracle by following the below steps

The action you take depends upon the cause of the message: In the first case, ensure that your username in the secondary database was granted the CREATE SESSION system privilege. In the second case, ensure the username specified in the connect string of the database link definition was granted the CREATE SESSION system privilege in the secondary database.