ICT블로그

<Getting Started with Database Administration>

- SQL Plus를 사용하는 법 (connect remotely)

(1) Oracle DB 설치 (엔진 + Client)

(2) Oracle Client 설치

(3) Instant Client 설치

- Instant ID = System ID = SID

For a local connection, you identify the instance by setting operating system environment variables.

For a remote connection, you identify the instance by specifying a network address and a database 

service name. For both local and remote connections, you must set environment 

variables to help the operating system find the SQL*Plus executable and to provide the 

executable with a path to its support files and scripts. 

- environment variables

1)ORACLE_HOME

2)ORACLE_SID

3)ORACLE_HOME/bin