4/30/12

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


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: Example : username@dev.company.comNote: 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.

0 comments:

Post a Comment