More than 5 years have passed since last update.

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

oracle

Posted at 2016-01-01

前提

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])) 
 )

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up