Solved

PB 10.5 login issue with Oracle 11

Posted on 2009-07-02
10
1,445 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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 how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

932 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

15 Experts available now in Live!

Get 1:1 Help Now