oracle 配置监听 修改用户密码

配置监听

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

# 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>;