Solved

PB 10.5 login issue with Oracle 11

Posted on 2009-07-02
10
1,437 Views
Last Modified: 2013-12-20
I have an interesting problem.  I've developed a client/server application at Uni. of Maryland that is used at 12 of our campuses across the state.  The app is written in PB10.5 and has been run against an Oracle 9i db.  Recently we upgraded to Oracle 11 and I've had to add two new users at different campuses.  Here's the interesting problem.  Once I've loaded the deployment libs and PB application, loaded Oracle 8.7 client - to get the odbc for Oracle - and wrapped up the install, I always log in to see that the application works for the user.  Afterward I create the new user from sqlplus and send the user/pass to my new user.  But they can't log in using the new user/pass from the newly set up computer.  They can log in from an earlier set up on an older machine. These new machines are Dell running windows xp and nothing seems out of the ordinary. It's just weird that any user created before the Oracle 11 upgrade can log on these new machines, but new users can't, but they can log on machines set up prior to the O11 upgrade.  Has anyone seen this kind of behavior?
0
Comment
Question by:IrishPirate
  • 5
  • 3
  • 2
10 Comments
 
LVL 14

Expert Comment

by:sandeep_patel
ID: 24764578
I would recommend to test this...

1. Ask user to login from sqlplus on new machines and check if it works. until they are able to login thro sqlplus don't look at your PB code.
2. what is the database error they are receiving? ORA error code will help a lot to determine the exact problem.

Regards,
Sandeep
0
 

Author Comment

by:IrishPirate
ID: 24765324
The user could log into sqlplus.  I make sure each user has sqlplus on their machines just in case. As for the error, it's a typical ORA-01017: invalid username/password; login denied.  I've been scratching my head because we can log onto machines set up two-three years ago, but only I can log into the new one. My main problem is that my user is at a location 50 miles from my office so I can't get a peek.  We're trying to recreate the error on a new machine in my office  but probably won't get it ready until the weekend.  It's not pressing at the moment since I'm not adding many new users, but it's unique enough to present a challenge.  Thanks for your help.
0
 
LVL 14

Expert Comment

by:sandeep_patel
ID: 24773282
Ok Now I assume that you are using ODBC drivers for connectivity. Why don't you use Oracle Native Drivers for connectivity? can you please paste the code where are initializing SQLCA parameters?

For example:
// Profile Test
SQLCA.DBMS = "O90 Oracle9i (9.0.1)"
SQLCA.LogPass = <********>
SQLCA.ServerName = "TEST"
SQLCA.LogId = "scott"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PBCatalogOwner='scott',TableCriteria=',scott'"

Regards,
Sandeep
0
 

Author Comment

by:IrishPirate
ID: 24785212
Thanks Sandeep,
I'll be performing another set up today at one of the other campuses.  If I'm lucky the new user will have the same issue and I'll try your solution.  Hopefully I can report back Tuesday as to the success.  

Thanks,
Terry Byrnes
0
 
LVL 4

Expert Comment

by:Lordain
ID: 24915989
Make sure the oracle home is set properly on each client.
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:IrishPirate
ID: 24917453
Thanks Lordain, but that isn't the problem.  The user can log in using a user/pass combination created when we were using Oracle 8.  Both old and new Users can log into Sqlplus.  It has something to do with the Powerbuilder app and I'm leaning toward one of the ini files and how they refer to various database types.  
0
 
LVL 4

Expert Comment

by:Lordain
ID: 24917574
I also know something we encountered in the past when using oracle 8 DBMS drivers on an oracle 10 database.

You could also try to change the line:
SQLCA.DBMS = "O90 Oracle9i (9.0.1)"
TO:
SQLCA.DBMS = "O10 Oracle10g (10.1.0)"

I doubt it is your problem since it is working for some and not others unless they are using different operating systems but as long as it detects and WindowsNT!.

I know it is a long shot but something to rule out.
0
 

Author Comment

by:IrishPirate
ID: 24918841
I think I may have found the main clue.  In the Oracle table, dba_users, is the item password_versions.  Looking at the original users, simply have 10g listed as their value.  The new users with the problems have both 10g and 11g.  From what I can find out, it seems that a new encryption is used on the 11g users - they work fine through Oracle products like SQLPlus, but the problem occurs with other vendors products, though I only know that my powerbuilder app is affected.  I haven't confirmed this with other products.  I'll look for info regarding Oracle password protection and see if there is a parameter to specify between 11g and the other versions - I think that may solve the issue.

Thanks to everyone who contributed...I'll let you all know if this fixes it.
0
 

Accepted Solution

by:
IrishPirate earned 0 total points
ID: 24927944
Ah, dba_users password_versions was the correct clue.  Apparently with Oracle 11g, Oracle introduced case-sensitive passwords.  Hence, in the dba_users table the tag for password_versions contains the value "11g".  If the user was created on an earlier version then migrated to 11g, they'll contain the value "10g 11g" indicating that their user was created on an earlier version.  The problem occurs with those new users created on O11.  The easiest way to correct this problem is to run the following: ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

Once run, the new users work perfectly.

Thanks to those taking the time to reply...this wasn't very easy to locate.
0
 
LVL 4

Expert Comment

by:Lordain
ID: 24928250
Good to know as we plan to migrate to 11g in the near future.  I suspected a client issue but not a migration issue.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org (http://seleniumhq.org) Go to that link and select download selenium in the right hand columnThat will then direct you to their downlo…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now