Banner / Guide: Manage your Oracle password

Objective

• To provide guidelines for managing your Oracle (Banner) password

User

• Miami University Client, Staff, Faculty, Student

Environment

• 10307: Oracle (Banner) Password Utility

Rationale

• Your Oracle (Banner) password protects important information about all University clients, faculty, staff and students, and is considered highly confidential. The Banner system and many other applications are secured by an Oracle (Banner) password. Because of the highly sensitive nature of your Oracle (Banner) password, the University auditor and the Security team have determined that Oracle (Banner) passwords should be changed at first login and every 90 days thereafter
• Your Oracle (Banner) password is not the same as your MUnet password, which is used for general Miami resources such as email, myMiami, and BannerWeb

Guidelines 

Oracle (Banner) password rules

• The rules that regulate the creation of an Oracle password are different from the rules for MUnet passwords. For your protection, the Oracle (Banner) password:
  • Must be changed every 90 days
  • Must be a minimum of eight characters and must include at least one letter and one number
  • Is not case-sensitive
  • Cannot be reused for six months
    • At least three letters must be different than password used in the past six months
  • Cannot be your UniqueID or other easy-to-guess words
  • Can contain underscores (_), but no other symbols or punctuation
  • Must use a letter as the first character 

Oracle password guidelines

• These guidelines will help you create a secure password:
  • Do not use commonly known information
  • Do not simply substitute numbers for letters
  • Never write down your password — write down a hint, if necessary
  • Never tell anyone your password, even support staff, under any circumstances
  • Always log out of computers when you are finished

Password expiration rules

• You will be prompted to change your password on the day that it expires
• ​If you have set an Oracle question/answer pair, you will be able to reset your password by using the Oracle Password Utility. If you have not set an Oracle question/answer pair, you must stop by your Campus Assistance location and present a photo ID to have your password reset
  • Learn how to request a password reset at your Campus Assistance location
• If your Oracle (Banner) password expires, you may receive an Oracle error ORA-28002 when using certain applications or systems. You need to change your password immediately to correct this problem. The error message may appear as any of the following messages:
  • (SQR5528) ORACLE OCISessionBegin (RDBMS) error 28002 in cursor 0: ORA-28002: the password will expire within 0 days
  • (SQR 4701) Cannot log on to the database

Associated Procedures

Change your Oracle password for any instance of Oracle with the Oracle Password Utility

1. Go to the Oracle Password Utility
2. Select I would like to change my Oracle Password
3. Log in with your UniqueID and MUnet password, if prompted
4. In the Instance drop-down menu, select the desired Oracle instance
   • Example: TEST Banner 9 Test Environment
5. Select Submit
6. Enter your new password in both boxes
7. Select Save

Change your Oracle password for PROD (Production) within Banner

1. Log in to Banner Production by entering your UniqueID, current MUNet password
2. Enter GUAPSWD in any Direct Access field to bring up the form
3. Enter you old Oracle password 
4. Enter your new Oracle password, and then enter it again to confirm your new password, and select Save

Note

• Learn more about resetting your Oracle (Banner) Password