data base link

[Himaja]

DEAR ALL,

IN OUR COMPANY
DB_NAME=ORCL,DB_DOMAIN=US.ACME.COM CONNECT STRING=ORACLE8I
FOR ORACLE8I SERVER

WHEN I CREATED DATA BASE LINK FROM ORACLE8 SERVER
USING THE FOLLOWING SYNTAX

SQL> CREATE DATABASE LINK ORCL.US.ACME.COM CONNECT TO SCOTT IDENTIFIED BY TIGER USING 'ORCLE8I'

THEN LINK IS SUCCESSFULLY CREATED.

BUT WHEN I AM ACCESSING THE DATA FROM ORACLE8I USING THE FOLLOWING SYNTAX

SQL>SELECT * FROM TAB@ORCL.US.ACME.COM

THEN THE ERROR
TNS:COULD NOT RESOLVE SERVICE NAMES
IS COMING

AND THE SAME ERROR IS COMING WHEN LINK IS CREATED BET. ORACLE8 TO ORACLE8.

BUT IAM ABLE TO ACCESS ORACLE8 DATA FROM ORACLE8I

BY READING UR MESG, I CHANGED TO SID TO SERVICENAME FOR ORACLE8 NETSERVICE WHICH HAS VALUE ORCL.

I MEAN FOR ORACLE8,ORACLE8I WE HAVE SAME DB_NAME=ORCL.

I CHANGED FROM SID TO SERVICENAME FOR NETSERVICE NAME THRU NET8 ASSISTANT AND SAVED BUT I DINT SHUTDOWN THE SYSTEM.

SO PLZ HELP ME..
THANKS IN ADVANCE

[akhadar]

Why don't u go through all discussions in this thread this is very similar to your question. One more thing is better put your questions in a new thread.

[abhaysk]

iN SQLNET.ora set the defualt domain as US.ACME.COM
i.e NAMES.DEFAULT_DOMAIN = US.ACME.COM

or

use the syntax as below to create DB link

CREATE DATABASE LINK ORCL.US.ACME.COM CONNECT TO SCOTT IDENTIFIED BY TIGER USING '%SID%.US.ACME.COM ';

or follow as amar said, i.e edit ur TNS names and put (in connect string) SID and not Service Name.

Abhay.

[abhaysk]

Originally posted by akhadar
Why don't u go through all discussions in this thread this is very similar to your question. One more thing is better put your questions in a new thread.

Akhadar :

I think he has read the thread, but quite really he didnt get it i suppose...coz in this post he said

BY READING UR MESG, I CHANGED TO SID TO SERVICENAME FOR ORACLE8 NETSERVICE WHICH HAS VALUE ORCL.

I MEAN FOR ORACLE8,ORACLE8I WE HAVE SAME DB_NAME=ORCL.

I CHANGED FROM SID TO SERVICENAME FOR NETSERVICE NAME THRU NET8 ASSISTANT AND SAVED BUT I DINT SHUTDOWN THE SYSTEM.

.


Abhay.

[akhadar]

Originally posted by abhaysk
Akhadar :

I think he has read the thread, but quite really he didnt get it i suppose...coz in this post he said

.


Abhay.

If iam right it is she not he

[abhaysk]

Originally posted by akhadar
If iam right it is she not he

watever, cant really make out from ID.

Abhay.

[Himaja]

hi all,

i tried all ways ,
but iam getting the same error:
ORA-12154: TNS:could not resolve service name

its happening only when accessing data from oracle8i to oracle8
and from oracle8 to oracle8

so plz help me to solve the problem

thanking u

[DaPi]

9 times out of 10 it is those d*****d domain names that get you - real head-banging stuff. When all fails, try debugging: put

TRACE_FILE_CLIENT=sqltrace
TRACE_DIRECTORY_CLIENT=C:\TEMP
TRACE_LEVEL_CLIENT=ADMIN

or similar in your sqlnet.ora on the "local" server and try to SQLPLUS from it to the other server (the one with the remote db).

If you use TAB@ORCL.US.ACME.COM then you will need a ORCL.US.ACME.COM= section in tnsnames.ora (I don't see this posted . . . )

[DaPi]

Originally posted by DaPi
If you use TAB@ORCL.US.ACME.COM then you will need a ORCL.US.ACME.COM= section in tnsnames.ora (I don't see this posted . . . )

This is CR*P - brain was switched off.