Home > Oracle Database / Applications Tips > Oracle applications best practices > Validate or change Oracle Apps username and password
Oracle Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

ORACLE APPLICATIONS BEST PRACTICES

Validate or change Oracle Apps username and password


Pallavi Sharma
01.20.2004
Rating: -2.82- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


This script can be used for troubleshooting. In Oracle Applications there are two kinds of users -- the Oracle user and application user. The Oracle user password can be verified by direct login. But the applications login can't be directly verified by Oracle (SQLPlus) login. This is not possible because the application user is not created on the Oracle level or by login on self-service. You first have ...

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Oracle applications best practices
Where can I get more information on the Oracle CRM E-Business Suite?
Numbers to words in any language
Oracle vs. SAP
Oracle apps DBA interview questions
The BI application consolidation challenge
Upgrading PeopleSoft, part 3: Application-specific conversions and going live
Upgrading PeopleSoft, part 2: Installation and the move to production
Upgrading PeopleSoft, part 1: The first steps
Nine steps for successful CRM implementation: Check IT List
Keep downtime short on 11i migration: Reusing a prepared software stack

Oracle applications implementation and upgrades
Users caution to look before you leap with Oracle Fusion Applications
Oracle delivers database fixes in Critical Patch Update
Oracle opens up the product floodgates at OpenWorld
Oracle's PeopleSoft 9.1 has improved user productivity
Oracle updates Agile PLM for food and beverage compliance
Oracle OpenWorld 2009 Special Report
Oracle CRM On Demand data integration raises big issues
Oracle applications learning guide
Collect America chooses Oracle Fusion Middleware 11g over open source
Oracle raises prices on database management packs
Oracle applications implementation and upgrades Research

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


to verify that the guest password is good (it should match DBC file entry). This script will verify that. It has been tested in 11.5.7 and 8.1.7.4.

When running the following script, return Y password is correct. Otherwise change it to Using FNDCPASS.

Note: GUEST/ORACLE is defalt username/PASSWD

Change applications user password: This example shows how to change sysadmin user password.

Rate this Tip
To rate tips, you must be a member of SearchOracle.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



Oracle Development Solutions - SQL, J2EE, XML, SOA
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts