LoginSignup
34

More than 5 years have passed since last update.

SQLPlusでOracleにリモート接続するメモ

Posted at

前提

Oracleクライアントがインストールされていること

基本

C:\ > sqlplus [username]/[passowrd]@[IP Addr]:[Port Number]/[Service Name]

tnsnames.oraを利用

C:\ > sqlplus [username]/[passowrd]@[net_service_name]

以下をカレントディレクトリに配置

tnsnames.ora
[net_service_name] = 
 ( DESCRIPTION= 
    ( ADDRESS=(PROTOCOL = [ex:TCP])(HOST = [IP Addr])(PORT = [Port Nuber])) 
    ( CONNECT_DATA= (SERVICE_NAME=[service_name])) 
 )

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
What you can do with signing up
34