-
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.
leonard905
leonard905@yahoo.com
-
cut and paste the error message you are getting with your tnsnames.ora
Reddy,Sam
-
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.
leonard905
leonard905@yahoo.com
-
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.
Reddy,Sam
-
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)
)
)
leonard905
leonard905@yahoo.com
-
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.
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|