Do not remove or modify the password file if you have a database or instance mounted using
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE (or SHARED). If you do, you will be unable to reconnect
remotely using the password file. Even if you replace it, you cannot use the new password
file, because the timestamps and checksums will be wrong.
>
grant connection to user
-----------------------------------------
connect 都不行怎么grant
connect / as sysdba
------------------------------------------
这样倒是可以,不过就是假设设置password认证的,否则这个问题还有什么意义
Do not remove or modify the password file if you have a database or instance mounted using
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE (or SHARED). If you do, you will be unable to reconnect
remotely using the password file. Even if you replace it, you cannot use the new password
file, because the timestamps and checksums will be wrong.
---------------------------------------------------------------------------------------------------------
你说的和最顶上的是不是正好相反阿,那个REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE到底什么时候设置阿,可不可以这么理解,在这个参数这样设置并且数据库open的时候,如果我用了orapwd就再也不能从远程登陆数据库了
但是我是在本机登陆的阿