C: \ Users \ Administrator> LSNRCTL status

LSNRCTL for 32 - bit Windows: Version 10.2.0.1.0 23:0 - Production on November 14 - to - 2017
Even

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

Is connected to the (DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=))
The STATUS of the LISTENER
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
The alias LISTENER
Version TNSLSNR for 32 - bit Windows: Version 10.2.0.1.0 - Produ
Ction
Start date of November 14 - to - 2017 23:07:01
Uptime zero day 0 hours 2 minutes and 10 seconds
The trace level off
Security ON: the Local OS Authentication
SNMP OFF
Listener parameter file E: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ listener o
Ra
Listener log file E: \ oracle \ product \ 10.2.0 \ db_1/network/log/listener. Log

Monitor the endpoint profile...
(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=))
(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=WIN - BSI97G8IA37) (1521) PORT=))
The service..
Service "PLSExtProc" contains 1 routines,
Routine PLSExtProc, UNKNOWN, containing the services of a handler...
Service "former" contains 1 routines,
Routine "former", BLOCKED, containing the services of a handler...
Service "orcl_XPT" contains 1 routines,
Routine "former", BLOCKED, containing the services of a handler...
Command execution success

C: \ Users \ Administrator>

CodePudding user response:

Which master to help take a look at how to return a responsibility

CodePudding user response:

Using NETCA configuration listeners,

CodePudding user response:

Can specific point is not

CodePudding user response:

Pl/SQL or I can't login configuration

CodePudding user response:

The building Lord, your instance is supposed to be launched, but not open the database, is still in nomount stage, make sure the:

CMD
The set is=former
Up sqlplus "/as sysdba"
Select the status from v $instance; - if not open, then the database is unable to provide services, you this case, the query of the output should be started, continue to the following:
The alter database mount;
The alter database open; - this step may be an error, if error, post the complete error, can solve, to see what error,

CodePudding user response:

reference 5 floor minsic78 reply:

the building Lord, your instance is supposed to be launched, but not open the database, is still in nomount stage, make sure the:

CMD
The set is=former
Up sqlplus "/as sysdba"
Select the status from v $instance; - if not open, then the database is unable to provide services, you this case, the query of the output should be started, continue to the following:
The alter database mount;
The alter database open; - this step may be an error, if error, post the full error, can solve, to see what error,

Head er, just didn't turn around, if that is normal, you may be in the alter database mount; This one phase encountered an error message, what control file can't find such as ~