Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: Difference between connecting to an instance using sqlplus and the applilcation

    Hi

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
    SQL*Plus: Release 11.2.0.3.0

    Hope someone can help me understand the difference between connecting to a db instance using different sqlplus and an application.

    I can connect to the db instance using a pair of user credentials using sqlplus but not via the application.

    sqlplus username/password

    Ironically, I have a second pair of user credentials which I can use to connecto to the db instance using the application but not using sqlplus.

    sqlplus second username/password

    (Note: sqlplus second username/password@hostnameB port/SID works!!)

    What could be different between the 2 user credentials?

    How can I troubleshoot why I can't connect to the DB instance using the application using the first pair of credentials??

    I get ORA 01017.

    Thanks
    Shajju
    Last edited by shajju; 03-25-16 at 14:06.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,088
    Provided Answers: 4
    Maybe username/password you use when logging to the application don't belong to an Oracle user (the one you create using CREATE USER statement), but represent an application user (and are, therefore, stored in one of the application tables).

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    Thanks Littlefoot but the users were created in exactly the same manner i.e., using an application.

  4. #4
    Join Date
    Jun 2004
    Posts
    793
    Provided Answers: 1
    Is the application expecting/using upper & lowercase usernames and/or passwords? Is the database expecting/using upper & lowercase usernames & passwords?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,503
    Check the TNSNAMES.ora file. If you have to use the port and SID information, I suspect that it is not in the file.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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