Microsoft Windows [Версия 6.0.6002]
(C) Корпорация Майкрософт, 2006. Все права защищены.
C:\Users\Администратор>echo %ORACLE_SID%
%ORACLE_SID%
C:\Users\Администратор>set ORACLE_SID=AUTOSPRUT
C:\Users\Администратор>echo %ORACLE_SID%
AUTOSPRUT
C:\Users\Администратор>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on TЁ Tхэ 23 12:45:53 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:ю°шсър рфряЄхЁр яЁюЄюъюыр
Enter user-name:
C:\Users\Администратор>lsnrctl
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 23-T+=-2015 14:00
:03
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
TNS-01106: Listener using listener name LISTENER has already been started
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.230)(PORT=152
1)))
The command completed successfully
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is D:\app\product\11.2.0\dbhome_1\network\admin\listener.o
ra
Log messages written to d:\app\diag\tnslsnr\AUTOSERV\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.30.230)(PORT=152
1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.230)(PORT=152
1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 23-T+=-2015 14:02:11
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\product\11.2.0\dbhome_1\network\admin\listener.
ora
Listener Log File d:\app\diag\tnslsnr\AUTOSERV\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.30.230)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit