ORA - 12154 TNS: Could not resolve service name DBA Studio

[dps]

ORA - 12154 TNS: Could not resolve service name DBA Studio

I downloaded Personal Oracle 8.1.7 and extracted it to c drive on this windows 2000 pantium 4. I used the Database configuration Assistant to set up a database. I have checked my listener.ora and sqlnet.ora as well as tnsnames.ora - all seems fine. When I go into DBA Studio I cannot coonect to my database without having the TNS error.

I can connect system/manager in sqlplus ok.

pinged my machine ok.
net start showed me that listnere is running.

When I run tnsping service_name I get TNS - 03505 Failed to resolve service_name.

I have substituted the host with the actual ip address - no difference.

What is going on ??????

Help!!!!!!!!

 

[sem]

You must specify tns_alias rather then ip-address or service_name in connect string.
Your service_name may or may not be the same as tns_alias defined in tnsnames.ora file.

 

[dps]

I am not quite sure what you mean?

When I try to connect to the database node I have in DBA Studio I get presented with the Database Connect Information Window. In there you have


username
password
service
connect as

My Listner is :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = awgcdp1.mag.co.uk)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = awgcdp1)
(SERVICE_NAME = awgcdp1)
)
)
My Tnsnames is :

AWGCDP1.MAG.CO.UK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = awgcdp1)
)
)

INST1_HTTP.MAG.CO.UK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = awgcdp1.mag.co.uk)
(PRESENTATION =

http://admin)

)
)

I am not quite sure what you are suggesting.

 

[dps]

....when in sqlplus I connect as scott/tiger only then I get connected and select *
from global_name reveals Global_name = AWGCDP1.MAG.CO.UK

 

[sem]

I mean your TNS - 03505 error produced by tnsping utility. Unfortunately I have no idea about DBA Studio error. BTW what error have you got?

 

[dps]

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)
)

 

[dps]

I have sorted it!!!!

This is the "Working" tnsnames.ora -

AWGCDP1.mag.co.uk =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKP-WNXY3XG69G2.mag.co.uk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = awgcdp1.mag.co.uk)
)
)

Thank you all!!!!!!!