I have a problem in logging in as internal
When i try to login as internal either in sqlplus or svrmgrl it shows invalid user/password but with others cooly its logging to the system (sys,system,scott ect...)
Also one more thing I noticed is that when I try to connect with
sys as sysdba/password its showing the same error message
Guys help me in this
Try invoking svrmgrl first at server site.
If it doesn't work, you need to create password authentication file by using orapwd(orapwd80/orapwd81 if nt)
do this when db is down.
orapwd file=/u01/app/oracle/product/805/dbs/pwdSID.ora \
if you need to login from remote, edit REMOTE_LOGIN_PASSWORDFILE=shared /* exclusive */
in your initSID.ora file.
and restart your db.
I did what is suggested then also I cannot retain the user internal same error message its displaying
Thanks in advance
I don't know wether this actually relates to your problem. But I got the same kind of errors once and the problem was due to a bad patch installation. It messed up the make file and I had to send the make.log to oracle support for them to figure this out. I had to reinstall everything. Just an idea, may or may not be your case here.
REMOVE SQLNET.AUTHENTICATION_SERVICES=xxx from sqlnet.ora
and try to login in again.
Click Here to Expand Forum to Full Width