Change Oracle Password for Banner

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

An email from "inbanreq" will be sent 14 days prior to your password expiration date. An Oracle password may be changed within a Banner Admin form or through a reporting tool, like SQL Developer. Instructions for each are below.

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) with your Lehigh network credentials: 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 in the form name "GUAPSWD".
   
   
   1. Optional: You can also navigate from the main page using the left-side 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 Password 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

1. Open SQL Developer and right-click on the database you want to reset the password for.
   1. In this example, we right-click on ecprod, which connects to the Banner PROD environment. This could be named something differently if you changed it, like "PROD" or "prod".
2. A menu will pop-out. Click on Reset Password...
    
3. A new window will pop-out to enter a new password.
   1. If the Username field is empty, enter your Oracle username (usually the same username you use to log onto the Lehigh network)
   2. Enter your current password in the Current Password box (outlined in gold in the image below)
   3. Enter a new password following the password criteria mentioned above, in both the New Password and Confirm Password boxes (outlined in green in the image below)
   4. Then hit OK.
      
4. You're done!