User Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: User Problem

Hybrid View

  1. #1
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41

    Hello Guys
    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
    invalid user/password

    Guys help me in this

    Thanks
    BJ

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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.
    example:
    orapwd file=/u01/app/oracle/product/805/dbs/pwdSID.ora \
    password=yourpwd entries=5

    if you need to login from remote, edit REMOTE_LOGIN_PASSWORDFILE=shared /* exclusive */
    in your initSID.ora file.
    and restart your db.


  3. #3
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41

    Thanks reydp

    I did what is suggested then also I cannot retain the user internal same error message its displaying

    Invalid user/Password

    Thanks in advance

    regards
    BJ

  4. #4
    Join Date
    Oct 2000
    Posts
    76
    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.
    J.T.

  5. #5
    Join Date
    Apr 2001
    Posts
    20
    REMOVE SQLNET.AUTHENTICATION_SERVICES=xxx from sqlnet.ora
    and try to login in again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width