| ORA-12154: TNS:could not resolve service name [message #67152] |
Thu, 18 December 2003 05:25  |
mouar
Messages: 1
Registered: December 2003
|
Junior Member |
|
|
hi,
I installed Oracle 9i under W2K with preconfigured DB (SID=ORCL), after that I intalled Oracle developer suite and everything is OK but, When I created second DB (SID=SUMM), I get "ORA-12154: TNS:could not resolve service name" when I tried to connect with :
SQL> connect sys/oracle@summ as sysdba
NB: I have no problem when I use
SQL> connect sys/oracle@orcl as sysdba
any help is welcome
Below, are my SQLNET.ORA, TNSNAMES.ORA, LISTENER.ORA files
-------------------------------------------------
# SQLNET.ORA Network Configuration File: C:oracleora90networkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-------------------------------------------------
# TNSNAMES.ORA Network Configuration File: C:oracleora90NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pieix)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pieix)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
SUMM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pieix)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SUMM)
)
)
----------------------------------------------------
# LISTENER.ORA Network Configuration File: C:oracleora90NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pieix)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:oracleora90)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = SUMM)
(ORACLE_HOME = C:oracleora90)
(SID_NAME = SUMM)
)
)
--------------------------------------------------
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67165 is a reply to message #67152] |
Wed, 07 January 2004 23:12  |
dinesh pandian
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
Try this
# TNSNAMES.ORA Network Configuration File: D:oracleora81networkadmintnsnames.ora
# Generated by Oracle configuration tools.
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ctp-vi0241)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ctp-vi0241)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = test)
(PRESENTATION = http://admin)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
dusty =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ctp-vi0241)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dusty)
)
)
INST2_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ctp-vi0241)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = dusty)
(PRESENTATION = http://admin)
)
)
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67189 is a reply to message #67166] |
Sat, 24 January 2004 01:27 |
Mridul
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
Hi "Ken Montagna (207.93.240.2)" ..
Ur trick worked for me as well, if U cud just let me know or explain how did this work ?
I had installed Oracle 8i Personal Edition on Win2K and then D2K, I cud connect easily thru Oracle's SQL Plus, but when I created some service names in the tnsnames.ora file under the directory where D2K was installed, There was no way I cud connect to the Oracle database thru my D2K's SQL Plus ... I just have no idea how !!!
I really request u to tell me how did this stuff work !!!
Mridul
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67286 is a reply to message #67183] |
Fri, 02 April 2004 01:15 |
Mariola
Messages: 2
Registered: March 2004
|
Junior Member |
|
|
Hi,
We obtain the same message when we execute "sqlplus" comand, and we cann't connect to our Oracle DB Server (on Soaris 8 platform)with our Oracle client (on Soaris 8 platform to).
We have next configurtion files:
bash-2.03$ more sqlnet.ora
# SQLNET.ORA Network Configuration File: /export/home/oracle/OraHome1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
#NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DIRECTORY_PATH= (TNSNAMES)
bash-2.03$ more tnsname.ora
# TSNAMES.ORA Network Configuration File: /var/opt/oracle/OraHome1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
MONITOR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.190.123)(PORT = 1531))
)
(CONNECT_DATA =
(SID = MONITOR)
)
)
I try all you say, but unsuccessfully.
Can anybody help me?, please.
Thanks.
Best regardards:
Mariola
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67287 is a reply to message #67189] |
Sun, 04 April 2004 01:41 |
Chris
Messages: 128
Registered: November 1998
|
Senior Member |
|
|
Hi everyone *__8
I've installed Oracle 9i Standard Web Development
server application on my pc,using Win XP.
When i start SQL Plus it required user name and password...when i enter the user name and password keep on getting this error!!
I will appreciate all kind of help!
cheers
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67441 is a reply to message #67166] |
Tue, 27 July 2004 09:03 |
Qi
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
I got ORA-12154:TNS:could not resolve service name when I try to make a connection from asp.net application ( web server runs on my 2k pc). I used the same connection string I used in window application (in .net).
I tried to add <identity impersonate="true"/> in the web.config file for the application. But it is still not working.
Can anyone help?
Thanks.
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67452 is a reply to message #67152] |
Sun, 01 August 2004 12:41 |
Venkat
Messages: 110
Registered: February 2001
|
Senior Member |
|
|
Hi I am getting the same error. I am using oracle 8i on windows xp professional. I tried everything changing in the D:OraHome1networkADMINtnsnames file. checked everything, tested the database connection in net8 but i cannot connect to the database in forms. Also, Created different homes for oracle and developer still doest work. The same error
ORA-12154: TNS:could not resolve service name
comes up. Please help.
thanks,
Venkat.
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67471 is a reply to message #67452] |
Fri, 13 August 2004 00:11 |
Naveen
Messages: 75
Registered: June 2001
|
Member |
|
|
hi,
i have got problem with ora-12541 TNS no listener in my oracle 8i.I created a database and i changed my pc network name.after changing the name my database is not working.I tried to start lnsrctl through command window but it gives me error like no 125600 TNS PROTOCOL ADAPTER ERROR.
HELP ME
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67496 is a reply to message #67463] |
Fri, 27 August 2004 07:45 |
mikey
Messages: 4
Registered: March 2001
|
Junior Member |
|
|
Hi There,
I am having similar problem "...TNS:could not resolve service name", except that this problem only occures when I am trying to connect to Oracle using DBArtisan (v7). Otherwize I can connect using sqlPlus with no problem.
Any help appreciated.
Mike
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67512 is a reply to message #67464] |
Mon, 06 September 2004 01:23 |
sri
Messages: 154
Registered: February 2000
|
Senior Member |
|
|
Unable to establish a connection
Please ensure that the connection properties are correct and the source is available.
ADO Error Microsoft ODBS DRIVER FOR ORACLE [[ORCLE]] ORA 12154 : TNS COULD NOT RESOLVE SERVICE NAME.
[[MICROSOFT]] [[ODBC DRIVER MANAGER]] DRIVER SQLSET CONNECT ATTR FAILED
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #67550 is a reply to message #67152] |
Fri, 01 October 2004 23:46 |
Akinnurun Adedoyin
Messages: 1
Registered: October 2004
|
Junior Member |
|
|
Before using this approach make sure that you tnsnames.ora files are well set.
i had a similar problem too..especially when you have 2 oracle homes.
i set the TNS_ADMIN in the registry to point to the oracle home where the database resides.
i was able to C:tnsping <database>
but applications from my oracle suite 10g was still not connecting to database.
so i right clicked on each program and clicked on properties .. the start in text box..
i made it point to the oracle home which had the database..that solved the problem for all the applications in the suite.
And surprisingly that solved the puzzle
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
