2021年9月30日 星期四

Oracle Instant Client with Oracle Sql Developer ,PL/Sql Developer Setup SOP

 

Oracle Instant Client with Oracle Sql Developer ,PL/Sql Developer

1. Download Oracle Instant Client 

https://www.oracle.com/tw/database/technologies/instant-client/downloads.html

and unzip the file in the path with D:\temp\oracle\instantclient_19_11-64

2.SET ENVIRONMENT 

2.1 Set the PATH on the Top Level

PATH=D:\temp\oracle\instantclient_19_11-64

2.2 Set the DB Char Set

NLS_LANG=TRADITIONAL CHINESE_TAIWAN.UTF8

[select userenv('language') from dual]

2.3 Set the TNS Path

TNS_ADMIN=D:\temp\oracle\instantclient_19_11-64

copy files sqlnet.ora tnsnames.ora in the path


Setting Up Service Names With a TNSNAMES file

<net_service_name> = (DESCRIPTION =  
    (ADDRESS_LIST =   
        (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <1521>))  
    )  
    (CONNECT_DATA =(SERVICE_NAME=<oracle_sid>)        
    )
)


(DESCRIPTION=    (ADDRESS=(PROTOCOL=TCPS)(HOST=192.168.1.111)(PORT=1522))    (CONNECT_DATA=      (SERVER = DEDICATED)      (SERVICE_NAME=DB)    )  )

標籤： , ,