Tuesday, November 08, 2022

Ora-12317 Logon to Database (link name string)

 ORA-12317 logon to database (link name string) denied

    Oracle Database Error Code Messages ORA-12317 Description Help About;

Logon to database (link name string) denied.

    Cause for Error and Problem;

There are several possible causes for this error. First, you can get this error if your username (and password, if you are using database instead of operating system authentication) in the secondary database are not identical to your username (and password) in the primary database. Second, you can get this error if your username in the secondary database is invalid (has not been created). Third, you can get this error if the username/password combination specified in the connect string of the database link definition is invalid (either not created or has an invalid password).

    How to Solve;ORA-12317 logon to database (link name string) denied?

    Action for Solve and Fix Ora-12317;

In the first case, ensure that the secondary database contains a username (and password, if you are using database authentication) identical to the one you are using in the primary database. In the second case, ensure that your username in the secondary database has been created. In the third case, ensure that the username specified in the connect string has been created in the secondary database.


Next Post Ora-12402;

Ora-12402 Invalid Format String: String

0 comments:

Post a Comment

Featured Post

Ora-00921 Unexpected end of SQL Command

 ORA-00921 unexpected end of SQL command     Oracle Database Error Code Messages ORA-00921 About Help Description; Unexpected end of SQL com...

Search This Blog