net 8 assitant

[leonard905]

Hi,
I'm trying to connect to an oracle8 database using oracle 8i net 8 assitant but I get an error message saying that the service name mentioned in the connect descriptor is invalid. Can you help me resolve this problem.

Thanks.

[sreddy]

cut and paste the error message you are getting with your tnsnames.ora

[leonard905]

This is it. Thanks.
++++++++++++++++++++++++++++++++++++++++
Attempting to connect using userid: system
The test did not succeed.
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

There may be an error in the fields entered,
or the server may not be ready for a connection.

[sreddy]

I meant say what you have typed at SQLPLUS prompt with error message. I have got error message but, I dunno what you have typed in at the prompt.

I wanna have a look at the tnsnames.ora contents. could you post that please. Probebly with this information I would help you to resolve your problem.

[leonard905]

I'm using Net 8 not line command. Here is this Tnsnames.ora file
++++++++++++++++++++++++++++++++++++++++


# TNSNAMES.ORA Network Configuration File: C:\orant8i\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

BRDSLT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.71)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = brdslt)
)
)

LCOKER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lcoker)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = leo)
)
)

BRDNEW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.71)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ff201)
)
)

[sreddy]

Take Programs --> Net8 Configuration Assistant --> add --> local net8 service name configuration --> name of the service(say xyz.world) --> port #(1521,default) --> test --> finish

Thats will reflect in your tnsnames.ora

You can use that service name(xyz) which you hjave created thru net8 configuration assistant as connect_string for database connection.

Example: sqlplus system/manager@xyz

I don't know what you are trying to do, this is what you supposed to do to create a service name.