Funciona vez ou outra...

brunoabinfo
(usa Ubuntu)

Enviado em 11/05/2011 - 23:10h

Pessoal, boa noite...

Dá uma força pra esse pobre iniciante aqui rsrs, to ampanhando muito com o oracle no ubuntu, achava que era conflito de porta com o apache, mudei e nada...

O estranho é que vez ou outra ele acessa via browser, olha que doido, tentei conectar agora e deu erro, ai liguei minha wireless e entrei na net, dei um restart via terminal no oracle ai funcionou, to sem saber o que pode ser mas só pode ter alguma coisa a ver com a né, pq aqui em casa na maioria das vezes funciona, e sempre estou conectado na wireless, na faculdade nunca funcionou...(lá não uso wireless)

dei um status no terminal qdo estava com erro:

root@brunoabinfo:/etc/init.d# ./oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-MAY-2011 22:58:38

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 11-MAY-2011 22:56:57
Uptime 0 days 0 hr. 1 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=brunoabinfo)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
root@brunoabinfo:/etc/init.d#

Sinceramente? num sei quase nada dos serviços descritos ai, por isso to pedindo socorro.

A hora q está acessando como agora via browser o status é:

root@brunoabinfo:/etc/init.d# ./oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-MAY-2011 23:15:22

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 11-MAY-2011 22:59:57
Uptime 0 days 0 hr. 15 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=brunoabinfo)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=brunoabinfo)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
root@brunoabinfo:/etc/init.d#