oracle 配置监听 修改用户密码

配置监听

D:\Oracle\app\Administrator\virtual\product\12.2.0\dbhome_1\network\admin\listener.ora

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

# listener.ora Network Configuration File: D:\Oracle\app\Administrator\virtual\product\12.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools.   SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = CLRExtProc)       (ORACLE_HOME = D:\Oracle\app\Administrator\virtual\product\12.2.0\dbhome_1)       (PROGRAM = extproc)       (ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle\app\Administrator\virtual\product\12.2.0\dbhome_1\bin\oraclr12.dll")     )     (SID_DESC =       (SID_NAME = orcl)       (ORACLE_HOME = D:\Oracle\app\Administrator\virtual\product\12.2.0\dbhome_1)     )   )   LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.242)(PORT = 1521))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))     )   )

　　

重启listener服务

 

 

 安装instant-client

https://www.oracle.com/database/technologies/instant-client/downloads.html

配置客户端软件 注意重启

 

修改用户密码

打开sqlplus 输入 conn /as sysdba 

alter user system identified by 111111;

 

 创建用户

create user c##wolbo identified by 111111;

CDB PDB 参考:https://www.cnblogs.com/fzj16888/p/5538137.html

 

授予dba权限

grant sysdba to c##wolbo container=all;

grant connect, create session, imp_full_database to <user>;