trx
Published on 2024-10-28 / 44 Visits
0

oracle相关

# 密码需要使用双引号,不能使用单引号,不能包含等号。
ALTER USER sys IDENTIFIED BY "123456";  

# 解锁锁定用户
ALTER USER sys account unlock;

# 查询pdb库
SELECT name, open_mode FROM v$pdbs;

# 启动pdb库
ALTER PLUGGABLE DATABASE pdb_name OPEN;

# 保存状态,开机自启pdb
alter pluggable database ORCLPDB save state;