修改密码: alter user system identified by system; alter user sys identified by sys; ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 创建用户 create user test identified by test; 并给用户赋予权限
grant connect,resource,dba to test;
过程中出现的报错需要输入以下内容:
输入:alter database mount; 输入 :alter database open;
修改完, 默认的不是ORCL, 是helowinXDB, 自己修改一下。
查看当前服务名:SQL> show parameter service_name
修改服务名:SQL> alter system set service_names=‘orcl’ scope=both;