My Oracle Support Banner

OCI: Connection to On-Premise Database Fails with Error: No valid login method found (Doc ID 2811258.1)

Last updated on MARCH 01, 2022

Applies to:

OCI External Database Management - Version NA to NA [Release NA]
Information in this document applies to any platform.

Symptoms

OCI External Database.
Connecting to an on-premise database with a user- <USER> fails with an error -"No valid login method found"

<USER> has the following privileges:

GRANT CONNECT to <USER>;
GRANT CREATE PROCEDURE to <USER>;
GRANT SELECT ANY DICTIONARY, SELECT_CATALOG_ROLE to <USER>;
GRANT ALTER SYSTEM to <USER>;
GRANT ADVISOR to <USER>;
GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <USER>;

<USER> is able to connect via SQLPlus.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.