Hi!
I am trying to setup kerberos connection in VS code extension. First thing to mention is that standalone java SQL Developer work no problem. However oracle command line tools do not work. I cannot connect with sqlplus no matter what i do.
I also able to establish connection from .Net apps with MIT. Go figure… So frustrating.
With VS code extension it is somewhere half way…
In the output i can see that connection attempted, but failing with
"errorCode": "DBTS-02000",
"message": "An error occurred when attempting to connect to the database",
"cause": "The following error occurred: ORA-18923: The service in process is not supported: No valid credentials provided (Mechanism level: Server not found in Kerberos database (7)) (CONNECTION_ID=TgSw8ScRTqyj1dbABvu2qw==)\r\nhttps://docs.oracle.com/error-help/db/ora-18923/",
"action": "Consult your database documentation for information on how to resolve the specified error code"
}
Deeper in the stack trace i can see:
Caused by: GSSException: No valid credentials provided (Mechanism level: Server not found in Kerberos database (7))
In standalone version I have specified password and checked ‘Save password’, so effectively it does cache refresh.
In extension version this does not work, as kinit manually does not work either.
I have made sure i have environment variables and on top of this also tried to set java properties, but may be i still missing something?
oracle.net.kerberos5_cc_name: c:\users\…
oracle.net.tns_admin: h:\tnsnames
oracle.net.authentication_services: (KERBEROS5) // BTW looks like this is case sensitive!!!
oracle.net.kerberos5_confd:…
java.security.krb5.conf:…
Any suggestions will be appreciated!