메뉴 건너뛰기

Korea Oracle User Group

Security

TNS 정지시 패스워드지정 종료

우뽕 2020.01.17 09:15 조회 수 : 1002 추천:1

Deprecation of Listener Password in Oracle Database 11g Release 2 (11gR2) (문서 ID 1328725.1)

 

APPLIES TO:

Oracle Net Services - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]

Information in this document applies to any platform.

 

ACTIONS

When upgrading to Oracle Database 11g Release 2 (Patch Set 11.2.0.3 and later) , follow the steps below to migrate a

listener that has a set password:

1. Remove all PASSWORDS_listener_name entries from the listener.ora file.

2. Reload the listener using the following command: lsnrctl reload listener_name

If remote administration of a listener is required, then use one of the following methods to connect to and administer

the listener.

Connect to the host where listener is running using SSH or other secure method, and then perform local

administration. Local administration is enforced by the operating system authentication.

Use Oracle Enterprise Manager to administer the listener. Oracle Enterprise Manager uses HTTPS, which

ensures security.

 

Please note, that this feature will be de-supported in the next major Oracle Database version (currently called 12g)

and will then no longer be available.

 

추가 상세 설명.

https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG010

 

9 Configuring and Administering Oracle Net Listener

 

In Oracle Database 12c Release 1 (12.1), the listener password feature is no longer supported.

This does not cause a loss of security because authentication is enforced through local operating system authentication. 

Refer to Oracle Database Net Services Reference for additional information.

 

 

https://docs.oracle.com/cd/E11882_01/network.112/e10835/mignet.htm#NETRF369

--> B Upgrade Considerations for Oracle Net Services

 
 
os 상에서 oracle 과 같은 그룹에 속한  aaa 유저가 존재 합니다.
aaa 유저는 작업 실수로.. 오라클 리스너를 내리게 됩니다.
 
아래와 같은 명령어를 수행 합니다. 
==========================
kill -9 프로세스 id :  퍼미션 에러로 안 내려갑니다.
lsnrctl stop 리스너명 : TNS-01190  권한이 없어서 내리지 못 합니다.
 
안심 하고 버전에 맞게 대응 하시면 됩니다. 
  
 

 

 

위로