CentOS 7 - Oracle 12c 외부 접속 설정 - sqldeveloper

I 리눅스(Linux) CentOS 7 ─ Oracle 12c

 

Oracle VM VirtualBox

CentOS-7-x86_64-Minimal-1804.iso

Oracle JDK (jdk-8u251-linux-x64.tar.gz)

Oracle Database 12c Release 2 (12.2.0.1.0) for Linux x86-64

https://www.oracle.com/database/technologies/oracle12c-linux-12201-downloads.html

 

 

I CentOS 7 - Oracle 12c 외부 접속 설정 - sqldeveloper

1. 버추어박스 포트포워딩 설정

2. 오라클 네트워크 설정

    1) listener.ora

    2) tnsnames.ora

    3) sqlnet.ora

3. sqldeveloper 접속

    1) sqldeveloper 다운로드

    2) 사용자 생성 및 권한 부여

    3) sqldeveloper 접속

 

 

1. 버추어박스 포트포워딩 설정

 

 

 

 

 

2. 오라클 네트워크 설정

 

# su - 
# cd /u01/app/oracle/product/12.2.0/dbhome_1/network/admin
# vim listener.ora
# vim tnsnames.ora
# vim sqlnet.ora

 

    1) listener.ora

 

# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.15)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
 

 

 

 

    2) tnsnames.ora

 

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
 
orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.15)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
      (SID = orcl)
    )
  )
 

 

 

 

    3) sqlnet.ora

 

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
 
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
#ADR_BASE=/u01/app/oracle
 

 

 

 

3. sqldeveloper 접속

 

www.oracle.com/tools/downloads/sqldev-downloads.html

 

    1) sqldeveloper 다운로드

 

 

압축해제 후 sqldeveloper.exe 실행

 

 

    2) 오라클 사용자 생성 및 권한 부여

 

# sqlplus / as sysdba

 

CREATE USER ~ IDENTIFIED BY ~;
GRANT RESOURCE, CONNECT, DBA TO ~;

 

    ex.

CREATE USER TESTDB IDENTIFIED BY oracle;
GRANT RESOURCE, CONNECT, DBA TO TESTDB;

 

    3) sqldeveloper 접속