[VSCode] Remote SSH 에서 Python 개발 환경 Setting

원격개발 세번째 단계)

VSCode에서 접속한 Remote SSH (Oracle Cloud Server) 에서 Python 개발환경을 세팅하고  DB접속 테스트

 

-- #################################################
-- Oracle Cloud Server Python 개발환경 세팅
-- 
-- 1. Python
-- 2. Oracle Database (Oracle Cloud Autonomous DB)
-- #################################################
 
1. Install Python
sudo yum install python3
sudo yum install pip3
 
-- Alias Setting
alias python='python3'
alias pip='pip3'
 
-- Oracle DB 접속 모듈 설치 테스트
sudo pip3 install cx_Oracle
sudo pip3 install pandas
 
 
2. Install Oracle Instantclient
-- Install List Check
sudo yum list oracle-instantclient*
 
-- Install Oracle Client
sudo yum -y -q install oracle-instantclient-basic.x86_64
 
-- Default Path
/usr/lib/oracle/21/client64/lib/network/admin
 
-- Setting tnsnames.ora & Autonomous DB Wallet Upload
cwallet.sso  ewallet.p12  ewallet.pem  keystore.jks  ojdbc.properties  sqlnet.ora  tnsnames.ora  truststore.jks

 

오라클 접속 테스트

Python에서 Oracle Cloud DB 연결 (With VS Code)