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.
Printable View
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.
cut and paste the error message you are getting with your tnsnames.ora
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.
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.
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)
)
)
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.