oracle-instantclient11.2-sqlplus for linux

https://3.jetbra.in/

big.yjsec.com:1521
sid: helowin
service_name：helowin
sys
Xww1q2w3e

Driver：Thin、OCI



wget 10.20.0.201/dd6300/soft/Oracle/oracle-rpm/oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
wget 10.20.0.201/dd6300/soft/Oracle/oracle-rpm/oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG='simplified chinese_china'.ZHS16GBK

setx -m TNS_ADMIN C:\instantclient_19_18
setx -m ORACLE_HOME C:\instantclient_19_18

vim ~/.bash_profile

mkdir network/admin -p
cd network/admin/
cat /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora 
helowin =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = big.yjsec.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = helowin)
    )
  )

sqlplus sys@helowin as sysdba

create user xww identified by Xww1q2w3e;
grant dba, connect, resource to xww;
grant create session to xww