jupyter 安装oracle客户端及测试

(base) root@a707c5c19bfe:~# apt-get install alien -y
sudo apt-get install libaio1
 export ORACLE_SID=LEI

create user C##zhangjinyu identified by "zhangjinyu"; 
alter user C##zhangjinyu account unlock;
grant dba to C##zhangjinyu;
grant create session to C##zhangjinyu;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA,CONNECT,RESOURCE,CREATE SESSION TO C##zhangjinyu;
create sequence JJDBH_ID_SEQ start with 1 increment by 1 nomaxvalue nominvalue nocycle nocache;

ubuntu jupyter安装oracle客户端
[root@hadoop ~]# ls instantclient-*
instantclient-basic-linux.x64-19.9.0.0.0dbru.zip  instantclient-sqlplus-linux.x64-19.9.0.0.0dbru.zip
[root@hadoop ~]# unzip instantclient-basic-linux.x64-19.9.0.0.0dbru.zip 
[root@hadoop ~]# unzip instantclient-sqlplus-linux.x64-19.9.0.0.0dbru.zip 
[root@hadoop /]# mkdir -p /spark
  [root@hadoop ~]# cp -r instantclient_19_9 /spark/
[root@hadoop ~]# 

export ORACLE_HOME=/spark/instantclient_19_9  # 解压目录
export TNS_ADMIN=$ORACLE_HOME/network/admin  
export LD_LIBRARY_PATH=$ORACLE_HOME
export PATH=$ORACLE_HOME:$PATH

(base) root@a1abcec66114:~# apt-get install libaio1 libaio-dev -y
[oracle@84f648ce5aba ~]$ sqlplus sys/admin as sysdba;

SQL> quit

创建用户
[oracle@84f648ce5aba ~]$ export ORACLE_SID=LEI
[oracle@84f648ce5aba ~]$ sqlplus / as sysdba
SQL> create user C##zhang identified by "zhang";
SQL> grant  connect ,resource,dba  to C##zhang;
SQL> grant sysdba to C##zhang;
GRANT CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE, ALTER ANY TABLE, ALTER ANY PROCEDURE, DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE, SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO C##zhang;
SQL> 

(base) jovyan@fce83c2b3590:~$ sqlplus C##zhang/zhang@192.168.229.133:1521/LEI