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.
Main Topics
Browse All Topics





by: sandeep_patelPosted on 2009-07-02 at 08:41:45ID: 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