Solved

PB 10.5 login issue with Oracle 11

Posted on 2009-07-02
10
1,520 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

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
 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

690 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