473,662 Members | 2,581 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

help needed: getting tns-could not resolve service name

1 New Member
dearest experts or whomever that can help

this error is making me crazy
.i cannot connect my database at TOAD and manually scott then password tiger, and host string=orcl --> will resulted error.

1.right username,right password,right host string --> tns error
2. right username,wrong password,no host string --> tns error

however when i put the scott/tiger at sqlplus it is ok.
in toad--> not ok
in developer --> same like 1,2 and again the scott/tiger ok

then another thing i cannot connect to the network(referin g other pc as server so we can access their db)

what did i do wrong??
please helppp...
Dec 12 '06 #1
1 2876
pragatiswain
96 Recognized Expert New Member
dearest experts or whomever that can help

this error is making me crazy
.i cannot connect my database at TOAD and manually scott then password tiger, and host string=orcl --> will resulted error.

1.right username,right password,right host string --> tns error
2. right username,wrong password,no host string --> tns error

however when i put the scott/tiger at sqlplus it is ok.
in toad--> not ok
in developer --> same like 1,2 and again the scott/tiger ok

then another thing i cannot connect to the network(referin g other pc as server so we can access their db)

what did i do wrong??
please helppp...
Please provide the "host string" and corresponding entry from tnsnames.ora
for my reference to analyze the problem.
Dec 13 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
5689
by: Aad Aldus | last post by:
How can I enable the trace functionality for the TNS listener on the server of the client. Aad.
1
8807
by: Swapnajit Mittra | last post by:
Hello all, I have oracle 9i installed on win2k. It works without problem most of the time, but once in a while I get TNS-12560:protocol adapter error --> during login <--. I know re-installation is probably one solution which I did earlier but seeing the mess it involves, I am not very inclined to do so.
5
13427
by: Axel Dachtler | last post by:
Hi, I have a listener problem. The listener cannot read SERVICE_NAME in TNS-Descriptor. The service-name I specified in Oracle Net Manager for this database is testdb as well. (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=axel-0560nntbn1) (PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testdb))) It is a local database so I tried testdb.localhost, but this didn't
4
10555
by: Axel Dachtler | last post by:
Hello, I am little bit confuseed about the meaning of TNS (Transparent Network Substrate). I know what it does: It enables Applications to communicate with different network protocols. But I don't know exactly what it is! What is it: - Oracle's networking architecture (or the core technology of it)
2
2197
by: Dave Bailey | last post by:
I am connecting to an Oracle database using ADO on a Webpage. When I run the program i get the following error when it gets to the oleDbConnection.Open command: ORA-12541: TNS:no listener Does anyone know how to handle this error? Thanks,
2
27544
by: hazz | last post by:
if I can ask that in this newsgroup? <input message="tns:addRestaurantIn"/> what is the tns used for here in this wsdl? Thank you thank you.. -hazz
1
19757
by: smita81 | last post by:
Hi, I have a problem while trying to login to toad. My operating system is WINDOWS XP. I have Oracle 9i at my system. I installed the Toad into the system.When I start the Toad "Toad Server Login Version 7.5.2.0" pop up opens. It asks to enter : Database or(user @database) User/Schema : Password : Connection as :,here three options given .They are NORMAL ,SYSDBA...
1
1952
by: abhu50 | last post by:
hiiiiiiiiii i was using my sql*plus in new user a/c that was member of users group on my pc now after some time i logged on admin a/c and change the login password my sql* plus using this alter user scott identified by abhu; table altered and i log in again in sql and easily logged on and then i made changes in new user,made it memeber of administrator and after this i logged on new user and tried to log on sql but i got error TNS...
4
1264
by: nomad | last post by:
Hi, I need to be able to edit an XML element so instead of it being <aggregateResponse></aggregateResponseit needs to be <tns:aggregateResponse></tns:aggregateResponse> Any help with this would be much appreciated.
1
2592
by: erbrose | last post by:
Hey all, So hopefully this is a quick fix but for the life of me I can't figure out how to get my results from a OracleDataReader record set. Just trying to get all the users for a specific TNS into an array. I was able to do this easily before with ADODB, but thought I would try using ODP.net. Here is what I have so far and it definitely gets all the USERs for a given TNS. its when I get to the READ() part where the syntax is ??? ...
0
8432
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8344
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8857
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8764
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8546
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6186
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5654
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4180
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2762
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.