TNS-03505 : Failed to resolve name

Hi all,
i would need a clue for the following:
I have to implement functions to check db-users for several DB`s.
So, i got some scripts to implement.
creating user.............. blablabla.....

BUT, when i tried to check the connection to the remote-DB, i got some problems like the following:


SVRMGR> create public database link ORASID.world@nt4_ORASID
     2> connect to bpauser identified by bpauser
     3> using 'nt4_ORASID';
Statement processed.
SVRMGR> commit
Statement processed.
SVRMGR> select count(*) from bbausers@ORASID.world@nt4_ORASID;

select count(*) from bbausers@ORASID.world@nt4_ORASID
                                           *
ORA-12154: TNS:could not resolve service name



-----------------------------------------------------------
tnsnames.ora
################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 4.0A
# Name..........:
# Date..........:
################

nt4_ORASID=
  (DESCRIPTION =
    (ADDRESS =
        (PROTOCOL= TCP)
        (Host= xxxxxxxx.com)
        (Port= 1521)
        )
    )
    (CONNECT_DATA =
        (SID = ORASID)
       (GLOBAL_NAME = ORASID.WORLD)
    )
  )

BPA.WORLD=
  (DESCRIPTION =
    (SDU = 32768)
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = SAP.WORLD)
          (PROTOCOL = TCP)
          (HOST = yyyyyyyy)
          (PORT = 1527)
        )
    )
    (CONNECT_DATA =
       (SID = BPA)
       (GLOBAL_NAME = BPA.WORLD)
    )
  )


tnsping to remote host xxxxxxxx
---------------------------------------------------------
orabpa 59> tnsping xxxxxxxx.com

TNS Ping Utility for DEC OSF/1 AXP: Version 8.0.6.2.0 - Production on 19-NOV-2002 13:58:12

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxx.com)(PORT=1521))
OK (690 msec)
orabpa 60>
---------------------------------------------------------




tnsping to tnsname-global
-------------------
orabpa 60> tnsping  ORASID  # or ORASID.WORLD  

TNS Ping Utility for DEC OSF/1 AXP: Version 8.0.6.2.0 - Production on 19-NOV-2002 14:02:48

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

TNS-03505: Failed to resolve name


---------------------------------------------------------
tnsping to tnsname

orabpa 61> tnsping nt4_ORASID  # or nt4_ORASID .WORLD

TNS Ping Utility for DEC OSF/1 AXP: Version 8.0.6.2.0 - Production on 19-NOV-2002 14:03:54

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

TNS-03505: Failed to resolve name
------------------------------------------------------------




because i`m not a deep-DBA i would be pleased for any ideas,


kindest regards
gusie Start Free Trial