Home » RDBMS Server » Server Administration » ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified [message #229322] Fri, 06 April 2007 11:23 Go to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
hello i have freshly install an Oracle XE Cool under ubuntu , but i got problem connect true sqlplus console :

Quote:

connect med/'mypass'@XE
ERROR:ORA-12154: TNS:could not resolve the connect identifier specified


SQL>



my tnsnames.ora appear to be ok
Quote:

# tnsnames.ora Network Configuration File:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = med-laptop)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


tnsping med-laptop give
Quote:

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 06-APR-2007 16:20:42

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1. 203)(PORT=1521)))
OK (10 msec)




and thanks

Sad
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229324 is a reply to message #229322] Fri, 06 April 2007 11:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
plz post contents of sqlnet.ora file

what is OS name & version?

>Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1. 203)(PORT=1521)))

HUH?
AFAIK, specifying TWO IP#s is not a Good Thing.

[Updated on: Fri, 06 April 2007 11:36] by Moderator

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229325 is a reply to message #229322] Fri, 06 April 2007 11:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You are supposed to get something like this
Used TNSNAMES adapter to resolve the alias

The rest issues already pointed by anacedant
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229326 is a reply to message #229324] Fri, 06 April 2007 11:37 Go to previous messageGo to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
i don't have that file in $ORACLE_HOME/network/admin

is he obligatory ????




and thanks
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229328 is a reply to message #229322] Fri, 06 April 2007 11:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>is he obligatory ????
No, but can cause problems with "wrong" information in it.
If the connection request is actually getting to the listener,
then entries in the listener.log file could contain clues WRT the specific failure.
12154, 00000, "TNS:could not resolve the connect identifier specified"
// *Cause:  A connection to a database or other service was requested using
// a connect identifier, and the connect identifier specified could not
// be resolved into a connect descriptor using one of the naming methods
// configured. For example, if the type of connect identifier used was a
// net service name then the net service name could not be found in a 
// naming method repository, or the repository could not be
// located or reached.
// *Action:
//   - If you are using local naming (TNSNAMES.ORA file):
//      - Make sure that "TNSNAMES" is listed as one of the values of the
//        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
//        (SQLNET.ORA)
//      - Verify that a TNSNAMES.ORA file exists and is in the proper
//        directory and is accessible.
//      - Check that the net service name used as the connect identifier
//        exists in the TNSNAMES.ORA file.
//      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
//        file.  Look for unmatched parentheses or stray characters. Errors
//        in a TNSNAMES.ORA file may make it unusable.
//   - If you are using directory naming:
//      - Verify that "LDAP" is listed as one of the values of the
//        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
//        (SQLNET.ORA).
//      - Verify that the LDAP directory server is up and that it is
//        accessible.
//      - Verify that the net service name or database name used as the
//        connect identifier is configured in the directory.
//      - Verify that the default context being used is correct by
//        specifying a fully qualified net service name or a full LDAP DN
//        as the connect identifier
//   - If you are using easy connect naming:
//      - Verify that "EZCONNECT" is listed as one of the values of the
//        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
//        (SQLNET.ORA).
//      - Make sure the host, port and service name specified
//        are correct.
//      - Try enclosing the connect identifier in quote marks.
// 
//   See the Oracle Net Services Administrators Guide or the Oracle
//   operating system specific guide for more information on naming.
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229342 is a reply to message #229328] Fri, 06 April 2007 18:47 Go to previous messageGo to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
Dead still having the same trouble
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229343 is a reply to message #229322] Fri, 06 April 2007 19:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
As previous stated & seemingly ignored.....
what is OS name & version?

If the connection request is actually getting to the listener, then entries in the listener.log file could contain clues WRT the specific failure.

If the listener log file contains connection attempts, then post them.

If the listener log file does NOT contain connection attempts, this means requets are going to a different host.

If you don't answer ALL questions posted, then you can solve your own problem(s).
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229344 is a reply to message #229343] Fri, 06 April 2007 20:01 Go to previous messageGo to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
"As previous stated & seemingly ignored....."
soryy...

"what is OS name & version?"
i'm under linux : ubuntu edgy

i just wanna add that i have access the web interface , just i still problem with connection fron SQLPLUS
here is the listener.log:

Quote:
cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 06-APR-2007 12:39:54

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=12809
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
06-APR-2007 12:39:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=med-laptop)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
06-APR-2007 12:40:02 * service_register * XE * 0
06-APR-2007 12:40:02 * service_update * XE * 0
06-APR-2007 12:41:51 * service_update * XE * 0
06-APR-2007 12:42:00 * service_update * XE * 0
06-APR-2007 12:42:02 * service_died * XE * 12537
06-APR-2007 12:42:08 * service_register * XE * 0
06-APR-2007 12:42:11 * service_update * XE * 0
06-APR-2007 12:42:41 * service_update * XE * 0
06-APR-2007 12:42:47 * service_update * XE * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
06-APR-2007 12:42:50 * service_update * XE * 0
06-APR-2007 12:42:53 * service_update * XE * 0
06-APR-2007 12:43:02 * service_update * XE * 0
06-APR-2007 12:43:11 * service_update * XE * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
06-APR-2007 12:43:21 * service_update * XE * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
06-APR-2007 12:43:21 * service_update * XE * 0
06-APR-2007 12:43:26 * service_update * XE * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
06-APR-2007 12:43:30 * service_died * XE * 12537
06-APR-2007 12:43:35 * service_register * XE * 0
06-APR-2007 12:43:35 * service_update * XE * 0
06-APR-2007 12:43:41 * service_update * XE * 0
06-APR-2007 12:43:47 * service_update * XE * 0
06-APR-2007 12:43:53 * service_update * XE * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
06-APR-2007 12:43:56 * service_update * XE * 0
06-APR-2007 12:43:59 * service_update * XE * 0
06-APR-2007 12:44:02 * service_update * XE * 0
06-APR-2007 12:44:05 * service_update * XE * 0
06-APR-2007 12:44:11 * service_update * XE * 0
06-APR-2007 12:44:14 * service_update * XE * 0
06-APR-2007 12:45:02 * service_update * XE * 0
06-APR-2007 12:45:24 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59523)) * handoff * http * 0
06-APR-2007 12:45:38 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59525)) * handoff * http * 0
06-APR-2007 12:45:45 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59526)) * handoff * http * 0
06-APR-2007 12:45:47 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59527)) * handoff * http * 0
06-APR-2007 12:45:54 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59528)) * handoff * http * 0
06-APR-2007 12:46:03 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59529)) * handoff * http * 0
06-APR-2007 12:46:48 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59530)) * handoff * http * 0
06-APR-2007 12:46:48 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59531)) * handoff * http * 0
06-APR-2007 12:47:34 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59533)) * handoff * http * 0
06-APR-2007 12:49:32 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59541)) * handoff * http * 0
06-APR-2007 12:49:37 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59542)) * handoff * http * 0
06-APR-2007 12:49:44 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59543)) * handoff * http * 0
06-APR-2007 12:49:53 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=59544)) * handoff * http * 0
06-APR-2007 12:50:24 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44921)) * handoff * http * 0
06-APR-2007 12:50:28 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44922)) * handoff * http * 0
06-APR-2007 12:52:45 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44923)) * handoff * http * 0
06-APR-2007 12:52:47 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44924)) * handoff * http * 0
06-APR-2007 12:52:57 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44925)) * handoff * http * 0
06-APR-2007 12:53:01 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44926)) * handoff * http * 0
06-APR-2007 12:53:03 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44927)) * handoff * http * 0
06-APR-2007 12:53:20 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44928)) * handoff * http * 0
06-APR-2007 12:53:21 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44929)) * handoff * http * 0
06-APR-2007 12:53:29 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44930)) * handoff * http * 0
06-APR-2007 12:53:31 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=44931)) * handoff * http * 0
06-APR-2007 12:55:02 * service_update * XE * 0
06-APR-2007 12:55:05 * service_update * XE * 0
06-APR-2007 12:55:44 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2396)) * handoff * http * 0
06-APR-2007 12:55:50 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2397)) * handoff * http * 0
06-APR-2007 12:55:52 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2398)) * handoff * http * 0
06-APR-2007 12:56:37 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2399)) * handoff * http * 0
06-APR-2007 12:56:40 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2400)) * handoff * http * 0
06-APR-2007 13:05:05 * service_update * XE * 0
06-APR-2007 13:15:05 * service_update * XE * 0
06-APR-2007 13:15:14 * service_update * XE * 0
06-APR-2007 13:25:14 * service_update * XE * 0
06-APR-2007 13:35:15 * service_update * XE * 0
06-APR-2007 13:35:21 * service_update * XE * 0
06-APR-2007 13:43:48 * service_update * XE * 0
06-APR-2007 13:45:27 * service_update * XE * 0
06-APR-2007 13:55:27 * service_update * XE * 0
06-APR-2007 14:00:24 * service_update * XE * 0
06-APR-2007 14:10:24 * service_update * XE * 0
06-APR-2007 14:15:42 * service_update * XE * 0
06-APR-2007 14:25:42 * service_update * XE * 0
06-APR-2007 14:34:24 * service_update * XE * 0
06-APR-2007 14:36:36 * service_update * XE * 0
06-APR-2007 14:45:57 * service_update * XE * 0
06-APR-2007 14:55:57 * service_update * XE * 0
06-APR-2007 15:00:54 * service_update * XE * 0
06-APR-2007 15:06:06 * service_update * XE * 0
06-APR-2007 15:12:02 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19701)) * handoff * http * 0
06-APR-2007 15:12:04 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19702)) * handoff * http * 0
06-APR-2007 15:12:08 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19703)) * handoff * http * 0
06-APR-2007 15:12:16 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19704)) * handoff * http * 0
06-APR-2007 15:12:19 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19705)) * handoff * http * 0
06-APR-2007 15:12:24 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19706)) * handoff * http * 0
06-APR-2007 15:12:26 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19707)) * handoff * http * 0
06-APR-2007 15:12:41 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19708)) * handoff * http * 0
06-APR-2007 15:12:43 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=19709)) * handoff * http * 0
06-APR-2007 15:16:07 * service_update * XE * 0
06-APR-2007 15:20:28 * ping * 0
06-APR-2007 15:20:39 * ping * 0
06-APR-2007 15:26:07 * service_update * XE * 0
06-APR-2007 15:26:19 * service_update * XE * 0
06-APR-2007 15:36:19 * service_update * XE * 0
06-APR-2007 15:46:19 * service_update * XE * 0
06-APR-2007 15:46:28 * service_update * XE * 0
06-APR-2007 15:56:28 * service_update * XE * 0
06-APR-2007 16:00:31 * service_update * XE * 0
06-APR-2007 16:09:30 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=13164)) * handoff * http * 0
06-APR-2007 16:10:31 * service_update * XE * 0
06-APR-2007 16:14:04 * service_update * XE * 0
06-APR-2007 16:16:43 * service_update * XE * 0
06-APR-2007 16:20:42 * ping * 0
06-APR-2007 16:26:43 * service_update * XE * 0
06-APR-2007 16:26:49 * service_update * XE * 0
06-APR-2007 16:36:49 * service_update * XE * 0
06-APR-2007 16:46:49 * service_update * XE * 0
06-APR-2007 16:47:01 * service_update * XE * 0
06-APR-2007 16:57:01 * service_update * XE * 0
06-APR-2007 17:00:58 * service_update * XE * 0
06-APR-2007 17:02:30 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=6579)) * handoff * http * 0
06-APR-2007 17:07:10 * service_update * XE * 0
06-APR-2007 17:17:10 * service_update * XE * 0
06-APR-2007 17:27:10 * service_update * XE * 0
06-APR-2007 17:27:22 * service_update * XE * 0
06-APR-2007 17:37:22 * service_update * XE * 0
06-APR-2007 17:47:22 * service_update * XE * 0
06-APR-2007 17:47:31 * service_update * XE * 0
06-APR-2007 17:57:31 * service_update * XE * 0
06-APR-2007 18:00:28 * service_update * XE * 0
06-APR-2007 18:10:28 * service_update * XE * 0
06-APR-2007 18:17:46 * service_update * XE * 0
06-APR-2007 18:17:47 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=31460)) * handoff * http * 0
06-APR-2007 18:27:47 * service_update * XE * 0
06-APR-2007 18:37:47 * service_update * XE * 0
06-APR-2007 18:37:56 * service_update * XE * 0
06-APR-2007 18:47:56 * service_update * XE * 0
06-APR-2007 18:57:56 * service_update * XE * 0
06-APR-2007 18:58:08 * service_update * XE * 0
06-APR-2007 19:00:59 * service_update * XE * 0
06-APR-2007 19:08:14 * service_update * XE * 0
06-APR-2007 19:18:14 * service_update * XE * 0
06-APR-2007 19:28:14 * service_update * XE * 0
06-APR-2007 19:28:23 * service_update * XE * 0
06-APR-2007 19:38:23 * service_update * XE * 0
06-APR-2007 19:48:23 * service_update * XE * 0
06-APR-2007 19:48:32 * service_update * XE * 0
06-APR-2007 19:58:32 * service_update * XE * 0
06-APR-2007 20:00:26 * service_update * XE * 0
06-APR-2007 20:01:08 * service_update * XE * 0
06-APR-2007 20:02:14 * service_update * XE * 0
06-APR-2007 20:08:44 * service_update * XE * 0
06-APR-2007 20:18:44 * service_update * XE * 0
06-APR-2007 20:28:44 * service_update * XE * 0
06-APR-2007 20:28:56 * service_update * XE * 0
06-APR-2007 20:38:56 * service_update * XE * 0
06-APR-2007 20:45:05 * service_update * XE * 0
06-APR-2007 20:55:05 * service_update * XE * 0
06-APR-2007 20:59:11 * service_update * XE * 0
06-APR-2007 21:01:02 * service_update * XE * 0
06-APR-2007 21:09:14 * service_update * XE * 0
06-APR-2007 21:19:14 * service_update * XE * 0
06-APR-2007 21:29:14 * service_update * XE * 0
06-APR-2007 21:29:20 * service_update * XE * 0
06-APR-2007 21:39:20 * service_update * XE * 0
06-APR-2007 21:49:20 * service_update * XE * 0
06-APR-2007 21:49:29 * service_update * XE * 0
06-APR-2007 21:59:29 * service_update * XE * 0
06-APR-2007 22:00:29 * service_update * XE * 0
06-APR-2007 22:00:32 * service_update * XE * 0
06-APR-2007 22:01:44 * service_update * XE * 0
06-APR-2007 22:11:45 * service_update * XE * 0
06-APR-2007 22:19:45 * service_update * XE * 0
06-APR-2007 22:29:45 * service_update * XE * 0
06-APR-2007 22:39:45 * service_update * XE * 0
06-APR-2007 22:39:57 * service_update * XE * 0
06-APR-2007 22:49:57 * service_update * XE * 0
06-APR-2007 22:59:57 * service_update * XE * 0
06-APR-2007 23:00:06 * service_update * XE * 0
06-APR-2007 23:01:15 * service_update * XE * 0
06-APR-2007 23:10:12 * service_update * XE * 0
06-APR-2007 23:20:12 * service_update * XE * 0
06-APR-2007 23:30:12 * service_update * XE * 0
06-APR-2007 23:30:21 * service_update * XE * 0
06-APR-2007 23:40:21 * service_update * XE * 0
06-APR-2007 23:46:06 * service_update * XE * 0
06-APR-2007 23:48:51 * service_update * XE * 0
06-APR-2007 23:56:23 * ping * 0
06-APR-2007 23:58:51 * service_update * XE * 0
07-APR-2007 00:00:27 * service_update * XE * 0
07-APR-2007 00:00:30 * service_update * XE * 0
07-APR-2007 00:00:33 * service_update * XE * 0
07-APR-2007 00:10:33 * service_update * XE * 0
07-APR-2007 00:20:33 * service_update * XE * 0
07-APR-2007 00:20:42 * service_update * XE * 0
07-APR-2007 00:30:42 * service_update * XE * 0
07-APR-2007 00:40:16 * ping * 0
07-APR-2007 00:40:43 * service_update * XE * 0
07-APR-2007 00:40:52 * service_update * XE * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=1521)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Listener completed notification to CRS on stop
07-APR-2007 00:41:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=med-laptop)(USER=root))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 07-APR-2007 00:46:23

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=15642
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop.globe-consulting.co.ma)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
07-APR-2007 00:46:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=med-laptop)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
07-APR-2007 00:46:45 * ping * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop.globe-consulting.co.ma)(PORT=1521)))
Listener completed notification to CRS on stop
07-APR-2007 00:46:49 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=med-laptop)(USER=root))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 07-APR-2007 00:46:51

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=15650
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop.globe-consulting.co.ma)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
07-APR-2007 00:46:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=med-laptop)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop.globe-consulting.co.ma)(PORT=8080))(Presentation=HTTP)(Session=RAW))
07-APR-2007 00:47:15 * service_register * XE * 0
07-APR-2007 00:47:17 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=48975)) * handoff * http * 0
07-APR-2007 00:47:18 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=48977)) * handoff * http * 0
07-APR-2007 00:47:32 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41587)) * handoff * http * 0
07-APR-2007 00:47:39 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41588)) * handoff * http * 0
07-APR-2007 00:47:45 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41589)) * handoff * http * 0
07-APR-2007 00:47:52 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41590)) * handoff * http * 0
07-APR-2007 00:47:59 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41591)) * handoff * http * 0
07-APR-2007 00:48:00 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41592)) * handoff * http * 0
07-APR-2007 00:48:01 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41593)) * handoff * http * 0
07-APR-2007 00:48:16 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41594)) * handoff * http * 0
07-APR-2007 00:48:18 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41595)) * handoff * http * 0
07-APR-2007 00:48:48 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41596)) * handoff * http * 0
07-APR-2007 00:48:49 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41597)) * handoff * http * 0
07-APR-2007 00:49:03 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41598)) * handoff * http * 0
07-APR-2007 00:49:06 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41599)) * handoff * http * 0
07-APR-2007 00:49:34 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41600)) * handoff * http * 0
07-APR-2007 00:49:36 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41601)) * handoff * http * 0
07-APR-2007 00:49:40 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41602)) * handoff * http * 0
07-APR-2007 00:49:42 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41603)) * handoff * http * 0
07-APR-2007 00:49:43 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41604)) * handoff * http * 0
07-APR-2007 00:49:51 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41605)) * handoff * http * 0
07-APR-2007 00:49:52 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41606)) * handoff * http * 0
07-APR-2007 00:49:56 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41607)) * handoff * http * 0
07-APR-2007 00:49:58 * service_update * XE * 0
07-APR-2007 00:49:58 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41608)) * handoff * http * 0
07-APR-2007 00:50:05 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41609)) * handoff * http * 0
07-APR-2007 00:50:06 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41610)) * handoff * http * 0
07-APR-2007 00:50:11 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41611)) * handoff * http * 0
07-APR-2007 00:50:14 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=41612)) * handoff * http * 0




there is a bizarre thing too i noticed that the listner were using (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))

i have change it with (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=IPCKEY)))
but he still using the wrong parameter:d and when i tried to restart oracle xe :
Quote:
/etc/init.d/oracle-xe restart/etc/init.d/oracle-xe: line 68: /etc/init.d/functions: No such file or directory
Oracle Database 10g Express Edition is not configured. You must run
'/etc/init.d/oracle-xe configure' as the root user to configure the database.


and thanks

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229345 is a reply to message #229322] Fri, 06 April 2007 20:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
please post content of listener.ora
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229346 is a reply to message #229345] Fri, 06 April 2007 20:24 Go to previous messageGo to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
sorry i forget completely about that file !

Quote:
# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = med-laptop)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229347 is a reply to message #229322] Fri, 06 April 2007 20:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
please post contents of /etc/hosts file
please post output from
$ env | sort
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229348 is a reply to message #229347] Fri, 06 April 2007 20:45 Go to previous messageGo to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
/etc/hosts :
Quote:
cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
192.168.1.203 med-laptop.obe-consulting.dyndns.org med-laptop




for the oracle user
Quote:

env | sort
COLORTERM=Terminal
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-cqlVoeS7us,guid=6fb514467119c20d67b453313b003f00
DESKTOP_SESSION=xfce4
DISPLAY=:0.0
GDMSESSION=xfce4
GDM_XSERVER_LOCATION=local
GNOME_KEYRING_SOCKET=/tmp/keyring-ILrRGi/socket
HISTCONTROL=ignoredups
HOME=/home/oracle
JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun/
LANG=fr_FR.UTF-8
LANGUAGE=fr_FR:fr:en_GB:en
LESSCLOSE=/usr/bin/lesspipe %s %s
LESSOPEN=| /usr/bin/lesspipe %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:tw=30;42:ow= 34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2= 01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga= 01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl= 01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.flac=01;35:*.mp3=01;35:*.mpc=01;35:*.ogg=01;35:*.wav=01;35:
MAIL=/var/mail/oracle
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/bin/X11:/usr/games
PWD=/home/mohammed
SESSION_MANAGER=local/med-laptop:/tmp/.ICE-unix/4373
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=4360
SSH_AUTH_SOCK=/tmp/ssh-Xdkkct4325/agent.4325
TERM=xterm
TNS_ADMIN=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/
USERNAME=mohammed
USER=oracle
_=/usr/bin/env
WINDOWID=33665324
XAUTHORITY=/home/mohammed/.Xauthority
XDG_DATA_DIRS=/etc/xdg/xubuntu:/usr/share:/usr/local/share:/usr/share



for root user
Quote:
env | sort
COLORTERM=Terminal
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-cqlVoeS7us,guid=6fb514467119c20d67b453313b003f00
DESKTOP_SESSION=xfce4
DISPLAY=:0.0
GDMSESSION=xfce4
GDM_XSERVER_LOCATION=local
GNOME_KEYRING_SOCKET=/tmp/keyring-ILrRGi/socket
HISTCONTROL=ignoredups
HOME=/root
JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun/
LANG=fr_FR.UTF-8
LANGUAGE=fr_FR:fr:en_GB:en
LESSCLOSE=/usr/bin/lesspipe %s %s
LESSOPEN=| /usr/bin/lesspipe %s
LOGNAME=root
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:tw=30;42:ow= 34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2= 01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga= 01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.avi=01;35:*.fli=01;35:*.gl= 01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.flac=01;35:*.mp3=01;35:*.mpc=01;35:*.ogg=01;35:*.wav=01;35:
MAIL=/var/mail/root
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/bin/X11:/usr/games
PWD=/home/mohammed
SESSION_MANAGER=local/med-laptop:/tmp/.ICE-unix/4373
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=4360
SSH_AUTH_SOCK=/tmp/ssh-Xdkkct4325/agent.4325
SUDO_COMMAND=/bin/su
SUDO_GID=1002
SUDO_UID=1000
SUDO_USER=mohammed
TERM=xterm
USERNAME=mohammed
USER=root
_=/usr/bin/env
WINDOWID=33900947
XAUTHORITY=/home/mohammed/.Xauthority
XDG_DATA_DIRS=/etc/xdg/xubuntu:/usr/share:/usr/local/share:/usr/share





Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229349 is a reply to message #229322] Fri, 06 April 2007 21:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=med-laptop.globe-consulting.co.ma)(PORT=1521)))

Please NOTE that this host name does NOT match what is in /etc/hosts; which could be problematic.

My gut says that this problems involves some sort or hostname mismatch.

[Updated on: Fri, 06 April 2007 21:19] by Moderator

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229350 is a reply to message #229349] Fri, 06 April 2007 21:07 Go to previous messageGo to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE))) sould be ??(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=IPCKEY)))

right?
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229351 is a reply to message #229322] Fri, 06 April 2007 21:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I don't think the problem involves the IPC protocol but TCP hostname resolution
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229364 is a reply to message #229351] Fri, 06 April 2007 23:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,

i don't have that file in $ORACLE_HOME/network/admin



You should create first SQLNET.ORA file through NETCA then try to connect... and follow "anacedent" suggestion.


Regards
Taj
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229400 is a reply to message #229364] Sat, 07 April 2007 05:52 Go to previous messageGo to next message
b_52globemaster
Messages: 51
Registered: July 2005
Member
i already have sqlnet.ora :
Quote:
names.directory_path=(NONE)



in tnsnames.ora and listener.ora i change med-laptop and put , 127.0.0.1 ' the second time i tried 192.168.1.203 but still got the same error
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #229414 is a reply to message #229400] Sat, 07 April 2007 11:25 Go to previous message
b_52globemaster
Messages: 51
Registered: July 2005
Member
Quote:
SQL> connect med/pass@127.0.0.1
Connected
SQL>




anacedent , Mohammad Taj THANKS a lot for yur help
Previous Topic: service name and sid
Next Topic: help in handle of archive log files.
Goto Forum:
  


Current Time: Fri Sep 20 05:00:27 CDT 2024