Dba studio ORA - 12154 - help!!!
I have sorted the connection problem via sqlplus but still not via Dba Studio.
All I did to rid the error TNS - 03505 Failed to resolve service_name is : - I went into Net 8 assitant and created a service. This then created a tnsnames.ora in the network/admin directory for oracle with
AWGCDP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2.mag.co.uk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = awgcdp1.mag.co.uk)
)
this was the old one
AWGCDP1.MAG.CO.UK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = awgcdp1)
)
)