oracle 계정에서

---------------------------------
$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 10-APR-2014 20:36:19

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

Starting /exlibris/app/oracle/product/11r2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /exlibris/app/oracle/product/11r2/network/admin/listener.ora
Log messages written to /exlibris/app/oracle/diag/tnslsnr/<server_name>/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<server_name>)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation

Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...
---------------------------------



해결방법 root 권한으로 고긴후 아래 구문 실행

$ rm -Rf /var/tmp/.oracle



$ lsnrctl start


LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 12-JUL-2017 12:37:40


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


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


TNSLSNR for Linux: Version 12.2.0.1.0 - Production

System parameter file is ...network/admin/listener.ora

Log messages written to ...listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date                12-JUL-2017 12:37:42

Uptime                    0 days 0 hr. 0 min. 10 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   ...network/admin/listener.ora

Listener Log File         ...listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully

$ sqlplus / as sysdba


SQL*Plus: Release 12.2.0.1.0 Production on Wed Jul 12 12:39:47 2017


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


Connected to an idle instance.


SQL> startup

ORACLE instance started.


Total System Global Area 2.0267E+10 bytes

Fixed Size                 19420048 bytes

Variable Size            3355446384 bytes

Database Buffers         1.6844E+10 bytes

Redo Buffers               47685632 bytes

Database mounted.

Database opened.

SQL>


번호 제목 글쓴이 날짜 조회 수
공지 IE에서 영상 또는 슬라이드 반응속도가 느린경우 해결방법 Study4U 2012.09.22 2514
81 USB 지정된 파일을 찾을 수 없습니다 file Study4U 2017.09.23 1398
80 PHP 환경값 재설정 - for QNAP Study4U 2017.08.29 559
» Oracle 12c 설치시 문제 해결 - 리눅스버전 Study4U 2017.07.01 637
78 redmoon DB 설치 file Study4U 2017.06.06 2148
77 CENTOS 7 초기 설정 가이드 Study4U 2016.07.24 2303
76 USB 메모리 인식불량일때 Study4U 2016.07.23 1013
75 "web" 공유 폴더에 있는 내 폴더를 권한없는 액세스로부터 어떻게 보호합니까? file Study4U 2016.06.08 675
74 icecast & ices0 in 'synology' ? synices : icestation Study4U 2016.06.04 939
73 웹브라우저에서 마우스 클릭시 팝업 광고 문제 해결방법 Study4U 2016.01.12 352
72 MySQL 사용자 권한 복구 file Study4U 2015.09.16 486
71 아피치에서 UserDir 설정 for QNAP Study4U 2015.08.13 162
70 Windows 8 에서 .net Framework 3.5 설치 오류 해결방법 file Study4U 2015.01.18 1012
69 Subversion 서버 설치하기 - for Mac Yosemite 10.10 Study4U 2014.12.06 2821
68 jQuery Ajax Call to PHP Script with JSON Return Study4U 2014.11.18 2037
67 자바스크립트 변수값 PHP로 전달 방법 Study4U 2014.09.16 8240
66 iframe 내용 가져오기 Study4U 2014.09.16 5193
65 구글 드라이브 API 활용 file Study4U 2014.08.18 7545
64 파워포인트에 포함된 오디오 추출하기 file Study4U 2014.07.04 726
63 Subversion 서버 설치하기 - for QNAP [2] file Study4U 2013.06.19 4185
62 FLASH에서 외부 parameters값 가져오기 Study4U 2013.02.25 1705