Oracle - problema con el lsnrctl

   
Vista:

problema con el lsnrctl

Publicado por zakariax (1 intervención) el 27/09/2007 11:57:02
Hola,
acabo de instalar una oracle 10g en un ubuntu 7.04 64b y
cuando intento arrancar el listener:
lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 27-SEP-2007 12:29:17

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

Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/config/10.1.0/listener.ora
Log messages written to /home/oracle/config/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.103)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 27-SEP-2007 12:29:17
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/config/10.1.0/listener.ora
Listener Log File /home/oracle/config/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.103)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test.DIOS" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

-----------------

tnsnames.ora

EXTPROC_CONNECTION_DATA.DIOS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC1)
)
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

TEST.DIOS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.0.103)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = TEST)
)
)

---------------------lsnrctl services

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 27-SEP-2007 12:32:34

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "test.DIOS" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:2
LOCAL SERVER
The command completed successfully

Muchas gracias.
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder

RE:problema con el lsnrctl

Publicado por zakariax (2 intervenciones) el 27/09/2007 14:43:14
si, lo siento...lo he dejado en el copy paste, pero no lo he indicado...sorry!!!

Service "test.DIOS" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...

el status deberia ser READY...no?

por lo que al hacer por ejemplo:
sqlplus scott/tiger@test

SQL*Plus: Release 10.2.0.1.0 - Production on Jue Sep 27 15:18:36 2007

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

ERROR:
ORA-12537: TNS:connection closed


por otro lado:
dbstart
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
logger: Can't find init file for Database instance "test".
logger: Error: Database instance "test" NOT started.

Gracias.
Valora esta respuesta
Me gusta: Está respuesta es útil y esta claraNo me gusta: Está respuesta no esta clara o no es útil
0
Comentar

RE:problema con el lsnrctl

Publicado por zakariax (2 intervenciones) el 28/09/2007 14:16:01
sorry, pensaba que el status UNKNOWN debia estar a READY y por eso me funcionaba. Mi problema es que no consigo arrancar la bbdd.
$ echo $ORACLE_SID
test
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Vie Sep 28 11:19:43 2007

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 159383552 bytes
Fixed Size 2019224 bytes
Variable Size 150995048 bytes
Database Buffers 4194304 bytes
Redo Buffers 2174976 bytes
ORA-00205: error in identifying control file, check alert log for more info

ademas:
$ more inittest.ora |grep 'control_files ='
control_files = (/u02/oradata/ora_control1, /u02/oradata/ora_control2)

inittest lo he creado a partir del init.oro. Como creo los control_files?esta base de datos deberia haberse creado en la instalación...

por cierto, cuando intento ejecutar dbca para crear una nueva me ocurre lo siguiente:
$ dbca
UnsatisfiedLinkError exception loading native library: njni10
Exception in thread "main" java.lang.UnsatisfiedLinkError: get
at oracle.net.common.NetGetEnv.get(Native Method)
at oracle.net.config.Config.getNetDir(Unknown Source)
at oracle.net.config.Config.initConfig(Unknown Source)
at oracle.net.config.Config.(Unknown Source)
at oracle.sysman.assistants.util.NetworkUtils.(NetworkUtils.java:222)
at oracle.sysman.assistants.util.step.StepContext.(StepContext.java:255)
at oracle.sysman.assistants.dbca.backend.Host.(Host.java:682)
at oracle.sysman.assistants.dbca.ui.UIHost.(UIHost.java:205)
at oracle.sysman.assistants.dbca.ui.InteractiveHost.(InteractiveHost.java:54)
at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:160)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:94)
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:180)
oracle@DIOS:/u01/app/oracle/product/10.1.0/db_1/bin$ locate njni10
/u01/app/oracle/product/10.1.0/db_1/lib32/libnjni10.so
/u01/app/oracle/product/10.1.0/db_1/lib/libnjni10.so
oracle@DIOS:/u01/app/oracle/product/10.1.0/db_1/bin$ echo $LD_LIBRARY_PATH
/u01/app/oracle/product/10.1.0/db_1/lib

muchas gracias
Valora esta respuesta
Me gusta: Está respuesta es útil y esta claraNo me gusta: Está respuesta no esta clara o no es útil
0
Comentar