oracle 命令

🧙 Questions

• 安装访问工具
• 登录Oracle
• 创建用户

☄️ Ideas

安装访问工具

sudo yum install -y libaio
wget https://download.oracle.com/otn_software/linux/instantclient/213000/oracle-instantclient-basic-21.3.0.0.0-1.el8.x86_64.rpm
sudo rpm -ivh oracle-instantclient-basic-21.3.0.0.0-1.el8.x86_64.rpm
wget https://download.oracle.com/otn_software/linux/instantclient/213000/oracle-instantclient-sqlplus-21.3.0.0.0-1.el8.x86_64.rpm
sudo rpm -ivh oracle-instantclient-sqlplus-21.3.0.0.0-1.el8.x86_64.rpm

登录Oracle

Note:
默认账号密码 sys/oracle
jdbc:oracle:thin:@//isxcode:51952/EE.oracle.docker

-- 登录root用户
sqlplus sys/oracle as sysdba

-- 普通用户登录
-- sqlplus ispong/ispong123
-- sqlplus ispong/ispong123@isxcode:51952/EE.oracle.docker
sqlplus ${username}/${passwd}@${host}:${port}/${connect_identifier}

创建用户

-- 创建用户
create user ispong identified by ispong123;

-- 授权
grant connect,resource to ispong;

🔗 Links

• oracle website
• oracle tools website