Need to connect to database using kerberos account and run the sql query
how to connect to oracle server using kerberos account from Powershell.
I am getting connection open error, like below
let me write my script here which is in Powershell.
H:\kerberos\kinit.exe -f -k -t H:\kerberos\keytab\uat\abcd.keytab a_pday_b@exchad.abcd.net
add-type -path "C:............\oracle.manageddataaccess.dll"
$env = 'abcd' (abcd is the username)
$datasource = "here my hostname..."
$conn = new-object oracle.manageddataaccess.client.oracleconnection
$conn.connectionstring = "data source=$datasource;user id=/;"
$conn.open() # in this line I am getting error
$command = new-object oracle.manageddataaccess.client.oraclecommand
$command.connection = $conn
$command.commandtype = [system.data.commandtype]::text
$oraclequery = "select name from dual;"
$result = $command.commandtext = #oraclequery
$result = $command.executereader() # getting same error here also
write-host "done"
trying to executing above script in Powershell and I am getting below error:
exception calling "open" with "0" argument(s): "input string was not in a correct format."