login error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: login error

  1. #1
    Join Date
    Apr 2002
    Posts
    29
    i have got a strange problem
    when i try to login as usera in the database i get the following error

    ERROR:
    ORA-12535: TNSperation timed out


    Enter user-name: ERROR:
    ORA-01017: invalid username/password; logon denied


    but if i login as userb and then use conn userb/passwd it connects fine the password i am using in both the cases are same

    please give your suggestion

    thanks in avance


  2. #2
    Join Date
    Oct 2002
    Posts
    5
    Intermittent ora-12535 is usually an indication that the requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in the LISTENER.ORA file
    Mahesh Rajendran

  3. #3
    Join Date
    Apr 2002
    Posts
    29
    in this case that is not the problem because this is only happenng with one userid and it is happening every time

  4. #4
    Join Date
    Oct 2002
    Posts
    5
    did u check the log files and alert files for any ora-600 errors?
    Mahesh Rajendran

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Are user-A and User-B on the same client?
    Are you behind a firewall?
    Are you running the database server on the MTS mode?
    Can you ping from the client(s)?
    Did you check your tnsnames.ora file on the client?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Apr 2002
    Posts
    29
    i am trying to login from the database server itself ie from the solaris box where the database server is running and the database is not running in mts mode but i did not check the alert log i wil check and let u know

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