Iniciar Oracle

-> lsnrctl

-> status

C:Documents and SettingsAdministrator>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 – Production on 16-MAR-2009 11:01
:24

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

Welcome to LSNRCTL, type «help» for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 – Produ
ction
Start Date 16-MAR-2009 10:39:19
Uptime 0 days 0 hr. 22 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File C:oracleproduct10.2.0db_2networkloglistener.log

Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wk3)(PORT=1521)))
The listener supports no services
The command completed successfully

*******************************************************
*( Aqui vemos que la base de datos no se ha iniciado )*
*******************************************************

-> cmd

-> sqlplus /nolog

-> connect / as sysdba;
Connect to an idle instance

-> startup

SQL> startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1247900 bytes
Variable Size 79693156 bytes
Database Buffers 83886080 bytes
Redo Buffers 2945024 bytes
Database mounted.
Database opened.

SQL> exit

C:Documents and SettingsAdministrator>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 – Production on 16-MAR-2009 11:01
:24

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

Welcome to LSNRCTL, type «help» for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER

Publicado por Luis Puente

Soy Luis Puente un consultor especialista HP Software con inquietudes en sistemas , hosting y desarrollo en WordPress

Dejar un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Este sitio usa Akismet para reducir el spam. Aprende cómo se procesan los datos de tus comentarios.