1、windows下登陆的时候输入正确的操作系统用户也不能登陆提示如下
"RemoteOperationException: ERROR: Wrong password for user"错误 解决方案
解决的方法就是在用户策略里面将你需要使用的用户授予Logon as a Batch Job的权限。
1. Click on START => Programs => Administrative Tools => Local Security Policy (or also via START => Settings => Control Panel => Administrative Tools) 打开控制面板中的管理工具中的本地安全策略
2. Under Local Policies on the left, select User Rights Assignment folder
然后是本地策略-用户权限分配
3. Look at the right side of the window and scroll down to the "Logon as Batch Job" privilege and select it. 然后找到Logon as a Batch Job(作为批处理作业登陆)这一项
4. Either select Action from the menu bar then Security or right-click on the "Logon as a Batch Job" privilege then Security.
5. Select the Add button which evokes a Select Users/Groups box.
6. From the "Look In" field, select the local workstation/server.
7. Select the User administrator.
8. Select Add then OK.
然后打开将administrator这个用户添加一下就ok了!
2、输入正确的用户名、密码后,登陆web oem提示“数据库状态当前不可用。可能是因为数据库的状态为装载或不装载”,但是登陆sqlplus启动数据库之后,
再次访问oem还是这么提示,经搜索,网上有两种比较通用的方案,第一种是dbsnmp、sysman两个用户被锁定,需要解锁,但是我的是解锁的,有的是通过emca -r
配置资料库解决的,我都试了没起作用,后来发现是监听的问题,因为我用9i的客户端连也连不上。10g oem的提示太烂了。于是检查了一下监听文件,发现默认的
是动态注册的,在监听文件里面没有我建的数据库的信息,如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora10)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wlp)(PORT = 1521))
)
)
)
于是尝试静态注册,修改如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora10)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora10)
(ORACLE_HOME = D:\oracle\ora10)
(SID_NAME = ora10)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wlp)(PORT = 1521))
)
)
)
重新启动监听程序,ok可以访问了。
"RemoteOperationException: ERROR: Wrong password for user"错误 解决方案
解决的方法就是在用户策略里面将你需要使用的用户授予Logon as a Batch Job的权限。
1. Click on START => Programs => Administrative Tools => Local Security Policy (or also via START => Settings => Control Panel => Administrative Tools) 打开控制面板中的管理工具中的本地安全策略
2. Under Local Policies on the left, select User Rights Assignment folder
然后是本地策略-用户权限分配
3. Look at the right side of the window and scroll down to the "Logon as Batch Job" privilege and select it. 然后找到Logon as a Batch Job(作为批处理作业登陆)这一项
4. Either select Action from the menu bar then Security or right-click on the "Logon as a Batch Job" privilege then Security.
5. Select the Add button which evokes a Select Users/Groups box.
6. From the "Look In" field, select the local workstation/server.
7. Select the User administrator.
8. Select Add then OK.
然后打开将administrator这个用户添加一下就ok了!
2、输入正确的用户名、密码后,登陆web oem提示“数据库状态当前不可用。可能是因为数据库的状态为装载或不装载”,但是登陆sqlplus启动数据库之后,
再次访问oem还是这么提示,经搜索,网上有两种比较通用的方案,第一种是dbsnmp、sysman两个用户被锁定,需要解锁,但是我的是解锁的,有的是通过emca -r
配置资料库解决的,我都试了没起作用,后来发现是监听的问题,因为我用9i的客户端连也连不上。10g oem的提示太烂了。于是检查了一下监听文件,发现默认的
是动态注册的,在监听文件里面没有我建的数据库的信息,如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora10)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wlp)(PORT = 1521))
)
)
)
于是尝试静态注册,修改如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora10)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora10)
(ORACLE_HOME = D:\oracle\ora10)
(SID_NAME = ora10)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wlp)(PORT = 1521))
)
)
)
重新启动监听程序,ok可以访问了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/79499/viewspace-417633/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/79499/viewspace-417633/