Change Oracle Password for Banner

Lehigh University policy requires that all passwords expire twice a year. This policy includes the password used to run reports using tools such as SQL Developer, MS Access (e.g. Desktop Finance) or Crystal Reports.

An email from "inbanreq" will be sent 14 days prior to your password expiration date. An Oracle password may be changed within Internet Native Oracle or on a password change web page. Instructions for each are below.

Please note: Your password change will not be updated in the ecRPTP instance of Oracle until the following day. ecRPTP is used by the Desktop Finance database. Passwords for other instances of Oracle are not affected.

Password Criteria

• Must contain at least 8 characters
• Must have at least 1 alphabetic character (A-Z, a-z)
• Must have at least 1 numeric character (0-9)
• Must have at least 1 special character or symbol
  • Cannot use the following: $ % @ ' * / "
• Must have no more than 2 repeating characters (i.e. aaaaab or 111112)
• Cannot use all numbers
• Cannot be the same as your username
• Cannot "recycle" passwords.
  • For example, use one password for 6 months and then switch to a totally different password for the next 6 months and then reuse your first password. Oracle will keep a history of your passwords.

Change Your Oracle Password Using the Banner Form

1. Log into Banner Admin (AppNav): https://appnav-prod.ec.lehigh.edu/applicationNavigator
2. Go to the Oracle Password Change form, GUAPSWD. In the search box, you can either start typing "oracle password" or type the form in directly.
   
   
   1. Optional: You can also navigate from the main page using the left hand menu by following this path:
      Banner -> General -> System Functions/Administration -> Menu/Preference Maintenance -> Oracle Password Change
3. Once in the GUAPSWD form, you should see your username next to the Oracle User ID field.
   1. Enter your current Oracle password in the box next to Oracle Password* (outlined in gold in the image below)
   2. Leave the Database field blank
   3. Enter a new password following the password criteria mentioned above, in both the New Oracle and Verify Password boxes (outlined in green in the image below)
   4. Then hit Save and exit the form.
      
4. You're done!

Change Your Oracle Password Using SQL Developer