| FORMS [message #634486] |
Tue, 10 March 2015 10:11  |
 |
GUPPY6970
Messages: 18
Registered: March 2015
|
Junior Member |
|
|
running Oracle in Windows XP mode thru Windows Virtual pc.
Installed Oracle db version 10. sqlplus no problem.
Installed Oracle Forms and reports - version 10.1.2.0
When I try to create a form and log in I get the message:
FRM-10142 The HTTP listener is not running.
If I check the status of the Listener, I get the following error:
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=152
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL>
If I stop and start the Listener, I get the following error:
LSNRCTL> stop
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL> start
Starting tnslsnr: please wait...
Failed to start service, error 2.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
LSNRCTL>
**********************************
If I go back to SQL PLUS and try to log in I get the following
ERROR: ORA-12541: TNS:no listener
Here is a copy of my TNSNAMES.ORA and Listener.ora file:
# tnsnames.ora Network Configuration File: C:\oracle\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = VirtualXP-20999)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora file
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = VirtualXP-20999)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VirtualXP-20999)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
[Updated on: Tue, 10 March 2015 10:14] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: FORMS [message #634656 is a reply to message #634513] |
Thu, 12 March 2015 10:58  |
|
GUPPY6970
Messages: 18
Registered: March 2015
|
Junior Member |
|
|
I went into ORA-12541 and tried the suggestions.
My SQLPLUS and Reportbuilder now works correctly.
When I go into forms I get the following error:
FRM-10142 Listener is not running at port 8889.
Please start the listener or check your runtime preferences.
My runtime preferences are set in the Application Server url and Web Browser Location
The only thing that I can not find in the General tab is the Color Palette- I can not fine the color directory.
********************************************************************
If I go to the Listener and check the status I get the following:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VirtualXP-20999)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 12-MAR-2015 11:06:26
Uptime 0 days 0 hr. 22 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VirtualXP-20999)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
****************************************************
If I stop the listener, I get:
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VirtualXP-20239)(PORT=1521)))
The command completed successfully
*****************************************************
When I start the Listener I get:
LSNRCTL> start
Starting tnslsnr: please wait...
Failed to start service, error 2.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
LSNRCTL>
|
|
|
|
| Re: FORMS [message #634658 is a reply to message #634656] |
Thu, 12 March 2015 11:33 |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
|
Senior Member |
|
|
You're confusing the Oracle Listener with the HTTP one. You stopped the Oracle listener here:
If I stop the listener, I get:
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VirtualXP-20239)(PORT=1521)))
The command completed successfully
Try starting the database listener using the Services applet under Control Panel.
|
|
|
|
| Re: FORMS [message #634668 is a reply to message #634658] |
Thu, 12 March 2015 13:33 |
|
GUPPY6970
Messages: 18
Registered: March 2015
|
Junior Member |
|
|
In services, I started OracleOradb10G_home1TNSListener and it shows STARTED.
There are 2 others, OracleDevSuiteHome1TNSListener and
OracleDevSuiteHome2TNSListener both show Automatic with no status.
If I try to start them I get the error:
Could not start the OracleDevSuiteHome1TNSListener service on the Local Computer. Error 2: The system cannot find the file specified:
Could not start the OracleDevSuiteHome2TNSListener service on the Local Computer. Error 2: The system cannot find the file specified:
When I go back into forms, I still get the error FRM:10142.
Should I delete OracleDevSuiteHome1TNSListener and OracleDevSuiteHome2TNSListener services?
[Updated on: Thu, 12 March 2015 13:47] Report message to a moderator |
|
|
|
| Re: FORMS [message #634690 is a reply to message #634668] |
Fri, 13 March 2015 05:24 |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
|
Senior Member |
|
|
|
What are the services starting with the word "Oracle" in the services applet, and what are their statuses?
|
|
|
|
|
|
|
|
| Re: FORMS [message #634700 is a reply to message #634699] |
Fri, 13 March 2015 09:10 |
|
GUPPY6970
Messages: 18
Registered: March 2015
|
Junior Member |
|
|
I did start the OC4J instance.
I loaded the form and logged in and got the error FRM-10142.
I checked the listener status and it shows:
C:\>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-MAR-2015 10:08:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 -Production
Start Date 12-MAR-2015 14:19:36
Uptime 0 days 19 hr. 49 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VirtualXP-20239)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\>
|
|
|
|
|
|
|
|
|
|
|
|
| Re: FORMS [message #634839 is a reply to message #634743] |
Mon, 16 March 2015 11:22 |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
|
Senior Member |
|
|
Quote:In the Windows Task Manager,TNSLSNR.EXE shows that it is running.
That is the Oracle database listener. It is unrelated to your HTTP listener.
Quote:
Should the OC4J instance show up in the Windows Task Manager?
No, it will be run as a java process. Does "java.exe" appear in your Task Manager?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
