仔细看了一下你的问题,OMS的帐号和实例帐号是两个帐号,OMS实例中登录时应该是可以使用其自身的System帐号,如果不可以说明权限不足。ORA-01031: insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. Action: Ask the database administrator to perform the operation or grant the required privileges.
connect / as sysdba
grant dba to sys;
grant dba to system;
c:\>sqlplus username/passwd;
然后
sql>conn sys/sys as sysdba /*假设sys用户口令为sys*/不知道行不行
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ????)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Orcl)
)
)-----------------
把上面的????修改成为127.0.0.1就可以了,监听器文件listener.ora也是一样
Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges.
Action: Ask the database administrator to perform the operation or grant the required privileges.