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
10-09-2001, 06:06 AM
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.
10-09-2001, 08:21 AM
I did what is suggested then also I cannot retain the user internal same error message its displaying
Thanks in advance
10-09-2001, 12:04 PM
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.
10-09-2001, 03:03 PM
REMOVE SQLNET.AUTHENTICATION_SERVICES=xxx from sqlnet.ora
and try to login in again.