$result = $command.executereader() # getting same error here also $conn.open() # in this line I am getting error $nnectionstring = "data source=$datasource user id=/ " H:\kerberos\kinit.exe -f -k -t H:\kerberos\keytab\uat\abcd.keytab -path "C.\" Let me write my script here which is in Powershell. I am getting connection open error, like below In this tutorial, you have learned about the Oracle database link concept and how to use the Oracle CREATE DATABASE LINK to create a new database link to a remote Oracle Database server.How to connect to oracle server using kerberos account from Powershell. Use a service-specific entry in the tnsnames.ora instead of the database-specific alias so that you copy between product, test, and development environments, you don’t have to recreate the database link.If you don’t follow this, the database will not work when someone changes the password of the user or even delete it. In addition, you should not give this user to anyone else. Remote database users: you should create a user dedicated for a database link.For example, instead of naming a database link SALES_PRD, you name it as SALES. Naming convention: the name of the database links should reflect the nature of data, not the database server.Here are some best practices using the database links: The result set is as follows: Oracle Database Link best practices SELECT * FROM language: SQL (Structured Query Language) ( sql )
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |