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>