[ORACLE] local_listener

-- DB 접속이 안될 경우 local_listener parameter 확인 

SQL> select name, value from v$spparameter where name='local_listener';

NAME                VALUE ------------------------------- ---------- local_listener

SQL> alter system set local_listener = "(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.79.4)(PORT=1521))";

System altered.

 

SQL> alter system register;

System altered.

 

sqlplus system@orcl -> tns타고 접속!!

 

-- client 접속 안 될 시

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT) -> sqlnet.ora