Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

How do I change my Oracle password using SQL*Plus?

Oracle passwords must contain 6 to 30 characters and begin with an alphabetic character. They can contain only alphanumeric characters and the characters  _ ,  $ , and  # .

Although best practices for passwords call for the use of passphrases with spaces, such use can create a variety of problems for Oracle database account holders. A passphrase containing spaces can still work with Oracle, but requires more planning and precision, depending on the platform or particular Oracle client software product. Unfortunately, passphrases containing spaces cannot be provided in a simple, consistent manner as can be done with an Oracle password that does not contain spaces.

To change your Oracle password, see the appropriate instructions below.

Using SQL*Plus in Oracle 11g

  1. From the Start menu, select All Programs, and then select your Oracle Home group (e.g., Oracle - OraClient11g_home1).

  2. Click Application Development, and then click SQL Plus.

    When you launch SQL Plus in the Oracle 11g client, you will get the command shell version of SQL*Plus.

  3. When prompted with Enter user-name: , enter your Oracle username, then  @ , and then the net service name of the Oracle database; for example: username@oed1prd.world

    Note: In the STCs, the full Oracle net service name is oed1prd.world . Oracle net service names configured on your computer may differ from the STC names, since these can be arbitrarily assigned.

  4. Click Enter. When prompted with Enter password: , enter your Oracle password, and then click Enter.

  5. At the prompt, to change your password, use the following command: password
  6. When prompted, enter your old password, then your new password, and then retype your new password. SQL*Plus will indicate a successful password change.

Using the SQL*Plus GUI in Oracle versions earlier than 11g

  1. From the Start menu, select All Programs, then your Oracle Home group (e.g., Oracle - OraClient10g_home).

  2. Click Application Development, and then click SQL Plus.

  3. In the window that appears, enter your Oracle username and password in the appropriate spaces.

  4. Next to "Host String", enter the net service name of the Oracle database (such as oed1prd.world  or  oed1prd.uits.indiana.edu ).

    Note: In the STCs, the full Oracle net service name is oed1prd.world . Oracle net service names configured on your computer may differ from the STC names, since these can be arbitrarily assigned.

  5. You should now be in the SQL*Plus GUI. To change your password, use the following command: password
  6. When prompted, enter your old password, then your new password, and then retype your new password. SQL*Plus will indicate a successful password change.
This is document anja in domain all.
Last modified on August 05, 2011.

I need help with a computing problem

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.



Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

I have a comment for the Knowledge Base

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.