topic DB-LINK in Operating System - HP-UX

DB-LINK

Erkan Durmus_1 — Fri, 08 Dec 2000 08:31:22 GMT

On a D380 server oracle 734 is used. I wanted to create a DB link to another DB(Oracle 8i). Strangely, oracle user couldn't connect to other DB, but the root user can connect to other DB using the same tnsnames.ora file. Owner of the tnsnames.file is oracle user. And oracle user can connect to other DB'es by using this tnsnmaes.ora file. What is the problem?

Re: DB-LINK

Alexander M. Ermes — Fri, 08 Dec 2000 08:46:01 GMT

Hi Erkan.
For problems like this please attach the file.
rgds
Alexander M. Ermes

Re: DB-LINK

Dan Hetzel — Fri, 08 Dec 2000 09:33:23 GMT

Hi,

As root can connect and not oracle, this looks like a unix permissions issue.

Who is the owner of the new Oracle 8 ?
What are the permissions settings of the new oracle 8 directory?

Dan

Re: DB-LINK

John Palmer — Fri, 08 Dec 2000 10:55:46 GMT

Hi,

Is this a true Oracle link created with 'create database link' or simply a TNS setup so that you can do 'sqlplus /@' ?

What error message do you get from Oracle?

Regards,
John

Re: DB-LINK

John Palmer — Fri, 08 Dec 2000 11:28:19 GMT

Another thought...

Are you absolutely sure that root and oracle are both using the same tnsnames.ora file?

Oracle will source the file from:-

TNS_ADMIN variable if defined
ORACLE_HOME/network/admin
/etc

Look for differences between root's and oracle's environment.

Regards,
John

Re: DB-LINK

Erkan Durmus_1 — Mon, 11 Dec 2000 06:41:36 GMT

Thanks for all replays. I solved the problem. While working with security checks accedentaly only root user is set to access /etc/hosts file. And if I write IP address into tnsnames.ora file this did not worked with both users. Then I tried with servername in it. This time root worked but oracle user didn't. After giving u+g access on hosts file the problem is solved.