| ORA-12154 : TNS : Could not resolve Service name [message #66854] |
Thu, 06 February 2003 11:16  |
Fred Haraux
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
Hello, i'm a newbie of Oracle.
I installed Oracle 8.0.5 on my Windows 2000 machine.
I used Net8 Assistant to create a service name called
"test_service".
I created a listener with Net8 Assistant using TCP protocol, the hostname of my computer, and the port 1521.
I created a DSN user "oracle_link", using Oracle ODBC Driver with
the service name "test_service" and nothing for USERID.
When i try to connect to Oracle on the same computer with SQLplus using "system/manager" and the host-string "oracle_link" : I had :
ORA-12154 : TNS : Could not resolve Service name
Using Oracle ODBC Test with "test_service" and "system/manager", I had the same error.
What can i do ?
I tried to change the hostname of the Service name with IP adress, "localhost", complete name of the computer (with the domain name)
Allways the same error.
I don't know if the listener is activated.
How can i do for activating it ?
Please help me, i don't know how i can resolve it.
|
|
|
|
| Re: ORA-12154 : TNS : Could not resolve Service name [message #66872 is a reply to message #66854] |
Thu, 20 February 2003 16:16  |
Orlando Pena
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
I have the same problem. You can check the following: Go to Control Panel Settings->Administrative Tools-> Services, and you will find a service something like OracleServiceDatabase_Name, start the service from manual to automatic, and check if the service starts...sometimes it works...
Good Luck
|
|
|
|
| Re: ORA-12154 : TNS : Could not resolve Service name [message #117950 is a reply to message #66854] |
Mon, 02 May 2005 01:51 |
naina0602
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
i'm too a newbie of Oracle.
I installed Oracle 9i on my Windows XP machine.
(it was earlier present, so i deinstaiied it & again intalled.
i deleted the earlier services also.)
During installation itself it asked for SID and the password for sys and system.
SID is tctent40
password for sys is adminidam
When i try to connect to Oracle on the same computer with SQLplus using "sys/adminidam" and the host-string "sysdba" : I had :
ORA-12154 : TNS : Could not resolve Service name
i had also checked in the Net Manager and the service(tctent40) is present with correct hostname (my pc no),TCP protocol,and the port 1521.
In the services tab also i checked & the services are started.
but then also i got the same problem
|
|
|
|
| Re: ORA-12154 : TNS : Could not resolve Service name [message #117958 is a reply to message #117950] |
Mon, 02 May 2005 02:45 |
realsoft
Messages: 9
Registered: May 2005
Location: Oman
|
Junior Member |
|
|
hi
1- you can go to tnsnames.ora and check what the Tns name is , then when you connect via SQL/PLS put that Name in Host String
2- also you can make New one :-
ORA9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost or your pc ip address)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = your SID)
)
)
Best Wishes
RealSoft
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
