connect login puzzle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: connect login puzzle

  1. #1
    Join Date
    May 2002
    Posts
    7
    I have just installed a newOracle 9i database and have set up a new user with DBA role using Enterprise Manager.

    When I start SQL*PLUS, I can initially log in as the new user. If I use the command "CONNECT " and enter the password, it denies me access, saying "invalid username/password". Yet I initially logged in as that user.

    If I enter the CONNECT command to log in as system/manager, it connects fine.


    What could be going on here?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    connect password is not correct syntax. Try connect username/password.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    avoid use connect username/password, better connect username and enter the password when sql*plus asks you

  4. #4
    Join Date
    May 2002
    Posts
    7

    Solution

    It seems that I needed to supply the database name, it was trying to log me into the repository (I think), even though I originally logged into my database. When I used:

    CONNECT user/pw@database I logged in OK.

    Normally I don't need to do that. Not sure why this time.

    Thanks,

    -Randy

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    well is the repostory in the same server as your original database? is the repository in the same instance as your original database? you are connecting locally if you are not giving connect string
    the error is telling you it is trying to connect with local databaase if your repository is not there then obviously you get invalid password

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