DevOps, CI/CD and Automation

Hi !

I have two database once is oracle 10g and another is oracle 9i the user of oracle10g is hr/hr and user of oracle9i is oltpcmc/oltpcmc the host string of hr user is unix. I want to access data from 9i to 10g. For this purpose I create Database link in hr user with following script:

Create Database Linek inbot.nbotind.org
connect to oltpcmc identified by oltpcmc
using 'ulinux'

-- inbot.nbotind.org is name of service of oltpcmc user
also i define global_name parameter value is true of this database

when i run this script

select * from help@inbot.nbotind.org

-- where help is name of table of oltp user

then error occured

ERROR at line 1:
ORA-12154: TNS:could not resolve service name

I can't understand whts wrong with this script.

plz give me any suggestion if u have .. also u send mail me on sanjayverma022@gmail.com

thx in advance