我已经创建用户oracle 19c
并授予权限,但我无法使用该用户登录,并出现登录被拒绝错误。
我已经从命令提示符登录 sqlplus / as sysdba
然后我创建了用户
create user "c##keyan" identified by "keyan123";
我授予以下权限
grant connect to "c##keyan";
grant dba to "c##keyan";
grant resource to "c##keyan";
grant create session to "c##keyan";
我的 listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = H:\WINDOWS.X64_193000_db_home)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = H:\WINDOWS.X64_193000_db_home)
)
)
我的 tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
此后我退出 sql 提示符并再次从命令提示符登录 sqlplus c##keyan/keyan123@//localhost:1521/orcl
我收到此错误 错误:
ORA-01017: invalid username/password; logon denied
我是否遗漏了什么?请提供建议。