|
|
|
|
|
|
|
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 |
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 #229346 is a reply to message #229345] |
Fri, 06 April 2007 20:24 |
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 #229348 is a reply to message #229347] |
Fri, 06 April 2007 20:45 |
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
|
|
|
|
|
|
|
|
|
|