Error in oracle source system for DB Connect

[Former Member]

Hi

I am trying to create oracle source system in rsa1.

i am getting error as

ORA-12154: TNS:could not resolve the connect identifier

my tnsnames.ora file is working fine as i could able to tnsping with service name.

Here are the details .

in dbco connect info

SSID=TEST;SAPDBHOST=192.168.30.116;

my TNS  details are

TEST=
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = 192.168.30.116)
          (PORT = 1527)
        )
    )
    (CONNECT_DATA =
       (SID = SAP)
       (SERVER = SHARED)
    )
  )

Thanks & Regards

sateesh

[Former Member]

Hi Sateesh,

The SID = SAP looks a bit odd, should this not be the SID of the system you are trying to connect to?

Regards,

Graham

[Former Member]

Hi

its oracle SID of the system i am trying to connect.

(Infact in custom application they have maintained seperate database sid SAP)

Regards

sateesh

[Former Member]

Ok, but you are aware that SID "SAP" is reserved and no SAP system can be installed with the SID "SAP".  So you may be able to connect through Oracle, but I'm not sure that SAP will like it very much. This may be a red herring though and it might be something completely different.

Regards,

Graham