| HTTP listener not running [message #61639] |
Wed, 12 May 2004 00:03  |
carly
Messages: 17
Registered: January 2004
|
Junior Member |
|
|
Hi everyone,
I have 9iAS and 9iDS on my machine for school. I can create forms, but after compiling I get frm -10142 error, "HTTP listener is not running in <HOST_NAME>@ port 1521. Please start listern or check your preferences." When I installed 9iDS, the net config asst. didn't test correctly. I am not sure how to config the listener. Could someone pls help.
Thank you
C
|
|
|
|
| Re: HTTP listener not running [message #61643 is a reply to message #61639] |
Wed, 12 May 2004 13:20  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Port 1521 is the default "sqlnet" listener. How many listeners do you have running? Can you connect to the 9iAS repository using something like:
sqlplus user/pass@iasdb ?
check which services the listener is listening for:
lsnrctl services
OR
lsnrctl stat
your listener.ora would need to have an http entry. It should be easy to see.
|
|
|
|
| Re: HTTP listener not running [message #61644 is a reply to message #61643] |
Wed, 12 May 2004 19:47 |
carly
Messages: 17
Registered: January 2004
|
Junior Member |
|
|
Yes, I can connect to sql+, I only have one listener running, the default "listener." The listener is listening for
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host_name>)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = <global_name>)
(ORACLE_HOME = C:oracleora92)
(SID_NAME = <global_name>)
)
) doesn't this mean it's listening for both?
Thanks Andrew
C
|
|
|
|
| Re: HTTP listener not running [message #61645 is a reply to message #61644] |
Wed, 12 May 2004 21:23 |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Well there' no http entry in your listener which is what I'd expect. If you search google for tnsnames.ora and GIOP you'll see some examples. I've never used it.
9ias will listen on it's own ports when you start OHS (Apache). By default I thibk your http port to either the middle or infrastructure tier will be http://localhost:7777 or 7778 (that's what it is on Solaris).
|
|
|
|
|
|
| Re: HTTP listener not running [message #61652 is a reply to message #61646] |
Thu, 13 May 2004 10:43 |
carly
Messages: 17
Registered: January 2004
|
Junior Member |
|
|
This is what I get in the log/cmd
C:Documents and Settings<host_name>>lsnrctl start
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 13-MAY-2004 14:18:
04
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is C:oracleora92networkadminlistener.ora
Log messages written to C:oracleora92networkloglistener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc
)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host_name>)(PORT=1521)
))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
Listener failed to start. See the error message(s) above...
C:Documents and Settings<host_name>>lsnrctl stat
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 13-MAY-2004 14:20:
52
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host_name>)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
C:Documents and Settings<host_name>>lsntrctl services
'lsntrctl' is not recognized as an internal or external command,
operable program or batch file.
C:Documents and Settings<host_name>>lsnrctl services
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 13-MAY-2004 14:23:
57
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host_name>)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
C:Documents and Settings<host_name>>lsnrctl start
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 13-MAY-2004 14:27:
07
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is C:oracleora92networkadminlistener.ora
Log messages written to C:oracleora92networkloglistener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc
)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host_name>)(PORT=1521)
))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
Listener failed to start. See the error message(s) above...
Which files are too long. I feel dense, but I cannot figure this out.
Thank you
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
