Forms Builder, no consigo depurar

He instalado la "Base de Datos oracle 9i" y también he instalado "Oracle 9i Developer" en un directorio diferente (no me dejaba instalarlo en el mismo directorio). Arranco Forms Builder, doy a depurar. Me pregunta que si antes de depurar quiero conectarme:
- Le doy a que SI, pongo el nombre SYSTEM y la contraseña, tambien pongo el nombre de la Base de datos y me sale un error: TNS: no se ha podido resolver el problema del servicio.
- Le doy a que NO, y me sale un error: "The HTTP Listener is not running on maximo at port 8888. Please strat the listener or check your runtime preferences".
Con el SQL si que puedo conectarme. Por favor, ¿pueden decirme como conseguir depurar un programa en Forms Builder? Si necesitan algún dato más no duden en preguntar.

1 respuesta

Respuesta
1
Ve al regedit de windows
Y el
La seccion
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
Alli debe haber una variable NET80
La cual tiene un valor y es la ruta que toa developer para buscar el archivo tnsnames. Ora!
Verificate y el archivo tnsnames que tienes debe estar en la carpeta que alli te indique y si no esta la puedes crear!
Bajo que sistema operativo lo tienes!
Y cuando te refieres a la base de datos es personal o enterprise!
?
la BD es personal y el sistema operativo es windows 2000
Debes verificar el archivo tnsnames. Ora en tu maquina y debe haber una cadena de conexion de la siguiente forma
y
verifica que la base de datos este levantada!
BARUTA_LINUX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = informatica0)(PORT = 1521))
(CONNECT_DATA = (SID = or9i))
)
Perdoname pero creo que esta correctamente el archivo tnsnames.ora; te lo escribo aquí:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = maximo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = maximo)(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)
)
)
Si ves alguna cosa que no este clara dimelo.
Y otra cosa, ¿cómno puedo saber si la BD está conectada? Siento que te haga perder tanto tiempo, pero por favor es importante para mí.Por favor contesta.
MUCHAS GRACIAS
Primero debo saber cual es el nombre del oracle_sid de la instancia de la base de datos instalada y porque puerto fue configurado, para verificar con los parametros del archivo y ver si hay algun detalle
y para saber csi esta o no levantada la base de datos
te vas a modo caracter
Y
Escriber lo siguiente
SQLPLUS /NOLOG
LUEGO QUE ENTRES AL PROMPT DE SQL
TYPEAS
CONNECT / AS SYSDBA
Y SI ESTA ABAJO AUTOMATICAMENTE TE DICE INSTANCIA DE BASE DE DATOS ABAJO
DE LO CONTRARIO NO SALE NADA
Y LA PRUEBA MAS PRACTICA ES
HACER EL SIGUIENTE SELECT
SELECT *
FROM DUAL;
Y debe traer como reguistro una "x"
Y hay otro comando que puedes usar para saber los parametros de la base de datos levantada!
Ejemplo:
show parameters oracle_sid
La Base de Datos SI esta levantada. El puerto es 1521, el nombre de la BD Global es: orcl y el SID es: orcl.
te vuelvo a adjuntar el tnsnames.ora para que lo puedas comprobar:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = maximo)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = maximo)(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)
)
)
Se recomeinda poner en el parametro host la direccion ip de la maquina!
Ya que si colocas el host con el nombre de la maquina debes configurar el archivos de hosts de windows!
ya he puesto en host la ip.
He vuelto a intentar conectar me y me pone: TNS: no se ha podido resolver el nombre de servicio
Gracias por todo
El archivo tnsnames. Ora
Colocalo en las siguientes carpetas ya que oracle usa dos carpetas
todo depende del momento de la instalacion!
Primero que nada debe estar en el directorio donde se instalo el developer
\network\admin\tnsnames.ora
Y en este otro tambien dentro de la carpeta donde se instalo todo lo de developer!
Mas no en el de la base de datos!
\net80\admin\tnsnames.ora
No existe una carpeta o archivo con el nombre net80 (/net80/admin) por lo que no puedo copiar en él el archivo tnsnames.ora
Aqui esta la solucion a tu problema!
Estoy mas que seguro!
Displayed below are the messages of the selected thread.
Thread Status: Closed
From: Pavel Elisseeff 09-Jul-02 06:11
Subject: FRM-10142 Forms 9i Win NT
FRM-10142 Forms 9i Win NT
Hi,
When I am starting any form (9i Developer on Win NT) I get a message:
FRM-10142 The HTTP Listener is not running on a2 at port 8888. Please start the listener or check your runtime preferences.
Best regards.
--------------------------------------------------------------------------------
From: Oracle, Raghavendra Lokhande 09-Jul-02 10:29
Subject: Re : FRM-10142 Forms 9i Win NT
Hi Pavel,
¿Have you started the OC4J component on your machine?
To start the same:
Click on start --> Programs -> Oracle Developer Suite
--> Forms Developer --> Start OC4J Instance
After the OC4J instance has started , you can run your form on the
browser just by clicking the run form button in the Form Builder.
Hope this helps.
Best Regards
Raghu
Displayed below are the messages of the selected thread.
Thread Status: Closed
From: Mark Sastry 21-Aug-02 20:21
Subject: FRM-10142 HTTP Listener is not running
FRM-10142 HTTP Listener is not running
I'm trying to run Forms on XP professional. I got FRM-10142 HTTP Listener is not running. I went to start -> programs -> Oracle9i Developer Suite -> forms Developer -> Start OC4J Instance. I got a command prompt window with a message 'Containers for J2EE initialized.' I still get FRM-10142. What needs to be checked?
Mark Sastry
--------------------------------------------------------------------------------
From: [email protected] 22-Aug-02 20:40
Subject: Re : FRM-10142 HTTP Listener is not running
You must leave the OC4J window open. When you close it you bring down the instance hard.
--------------------------------------------------------------------------------
From: Mark Sastry 22-Aug-02 23:20
Subject: Re : FRM-10142 HTTP Listener is not running
The command prompt window is left open with the message "'Containers for J2EE initialized" but I still get the message "FRM-10142 HTTP Listener is not running". How do I check whether HTTP listener is running on XP Professional. Thanks.
Mark Sastry
--------------------------------------------------------------------------------
From: Oracle, Tejinder Sammi 23-Aug-02 13:07
Subject: Re : FRM-10142 HTTP Listener is not running
Hi,
Only OC4J can be used to run the form.
Go to Tools -> Preferences . Runtime Tab, there set the Application URL as
http://<hostname.domainName>:8888/servlet/f90servlet
Then run the form.
I assume that OC4J runs at 8888. if you can't run on 8888 then you can try at 8889 port.
Hope this directs to some extent.
Regards,
Teji.
--------------------------------------------------------------------------------
From: Mark Sastry 02-Sep-02 17:32
Subject: Re : FRM-10142 HTTP Listener is not running
I'm still getting FRM-10142 error message.
I started the OC4J and the Forms Builder. In Forms Builder, edit -> Preferences -> Runtime Tab, there I set the Application runtime as
http://pb600.isi.local:8888/servlet/f90servlet
Then I ran the form, I got FRM-10142 message. I changed 8888 to 8889 in Preferences and then ran the form. I got the same message. I've 9iDS on Windows XP professional. I appreciate any help you could offer. Thanks.
Mark Sastry
--------------------------------------------------------------------------------
From: Oracle, Tejinder Sammi 02-Sep-02 18:23
Subject: Re : FRM-10142 HTTP Listener is not running
Hi Mark,
Please write here the full Error message that you get.
Thanks,
Teji
--------------------------------------------------------------------------------
From: Mark Sastry 02-Sep-02 18:53
Subject: Re : FRM-10142 HTTP Listener is not running
FRM-10142 message "The HTTP Listner is not running on pb600.isi.local at port 8888. Please start the listner..." This is after starting OC4J instance. In the command prompt, "Oracle9iAS <9.0.2.0.0> Containers for J2EE initialized." is displayed. This command prompt is sitting there doing nothing. Any ideas?
--------------------------------------------------------------------------------
From: Oracle, Tejinder Sammi 02-Sep-02 20:21
Subject: Re : FRM-10142 HTTP Listener is not running
Hi Mark,
Do the following 2 steps
1) Go to Tools -> Preferences . Runtime Tab, there set the Application URL by clicking the button "Set as Default" (This button is just beside the text feild)
2) Then go to start -> programs -> Oracle9i Developer Suite -> forms
Developer -> Start OC4J Instance. Ensure that a command prompt window with a message 'Containers for J2EE initialized.' is shown.
Your Form should Run then.
Regards,
Teji
--------------------------------------------------------------------------------
From: Alex Ofenberg 05-Sep-02 12:55
Subject: FRM-10142 HTTP Listener is not running
Hello,
I'm getting the same error message on my UNIX SUN system.
The window whith a message 'OC4J Instance for Oracle9iDS Started'
appears.
¿What can I do?
Regards,
Alex.
--------------------------------------------------------------------------------
From: Oracle, Tejinder Sammi 05-Sep-02 16:00
Subject: Re : FRM-10142 HTTP Listener is not running
Hi,
On the Unix machine, running the Form from the builder is not supported. This is because the JVM pluggin is not supported for the Linux/Unix machines.
Generally it asks for the Pluggin download and directs you to the Sun site. Then after download and install, the forms runs up fine.
Still try the following
=======================
1) Using the
$ netstat -n | grep
To find the exact port of OC4J engine.
When you are ablw to fine one. Then a way of cheking is by entering
http://machine.domain:port/
should show up home page of OC4J engine
Regards,
Teji
--------------------------------------------------------------------------------
From: Mark Sastry 02-Oct-02 05:21
Subject: Re : FRM-10142 HTTP Listener is not running
Hi Teji,
Thanks for your reply. I set the application URL on Runtime tab to set as default. Now, the 9iAS Forms services started. In fact, I see the following in the Start OC4J Instance window:
FormsServlet init():
configFileName: C:\OraHome1/forms90/server/formsweb.cfg
testMode: false
ListenerServlet init()
I get blank screen in Oracle9iAS Forms Services - Microsoft Internet Explorer. No data is displayed. ¿Is there anything I missed? Please Advise. Thanks.
Mark Sastry
--------------------------------------------------------------------------------
From: Oracle, Tejinder Sammi 03-Oct-02 07:10
Subject: Re : FRM-10142 HTTP Listener is not running
Hi Mark,
Delete all the files cached on the disk by the Browser.
Try using the Netscape and IE both. Does any work?
Thanks,
Teji
he creado la variable NET80 que no existia y ahora al intentar conectarme desde Oracle Forms me pone:
"FRM-10142: The HTTP Listener is not running on maximo at port 8888. Please start the listener or check your runtime preferences"
y he vuelto a comprobar que estoy conectado a la Base de Datos.
Displayed below are the messages of the selected thread.
Thread Status: Closed
From: Douglas Nyarko 10-Apr-03 11:32
Subject: Problem running form - Forms9i
Problem running form - Forms9i
Hi everyone,
i recently moved to Oracle Forms 9i. I created a form with one block based on a table.
when i tried running the form, i had a FRM-10142 error saying
'http listener is not running on steve at port 8889. Please start
listener or check your runtime preferences.'
i have examined the formsweb.cfg, default.env and registry.dat files but frankly speaking, i really do not know how to configure them appropriately.
I have a service name that connects to a database on another machine. This machine also has the application server running on it. However i intend to use 9iAS Forms services in 9iDS for testing my application.
Thanks.
--------------------------------------------------------------------------------
From: Oracle, Murali Balappa 10-Apr-03 21:44
Subject: Re : Problem running form - Forms9i
Hi,
You need to 'Start OC4J Instance' to run the Forms.
You will find this service under
Forms Developer > Start OC4J Instance
Start this service then run the Forms.
Best Regards..
Murali D B,
Oracle
Te mandare una serie de documentos tecnicos de oracle support on line!
Displayed below are the messages of the selected thread.
Thread Status: Active
From: Gary Assa 07-Apr-03 14:09
Subject: Forms9i error: HTTP Listerner is not running on {host} at port 8889
Forms9i error: HTTP Listerner is not running on {host} at port 8889
I posted in Forms forum, but was told to post it here. Here is my original posting from that group:
I am getting the message FRM-10142 HTTP Listerner is not running on {host} at port 8889.
I was able to start the instance from the ../j2ee directory, but I still get the message FRM-10142 HTTP Listerner is not running on {host} at port 8889. Doing a netstat shows listening at post 8889.
I started up my browser and put {host}:8889 into the address line and it brings up the Oracle 9iAS page locally, but running the form doesn't seem to work. I did setup the default browser in preferences.

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas