How do I change my Oracle password using SQL*Plus?
Using SQL*Plus in Oracle 11g
- From the
Start
menu, select All Programs
, and then select your Oracle Home group (e.g., Oracle - OraClient11g_home1
).
- 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.
- 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.
- Click
Enter
. When prompted with Enter password:
, enter your Oracle password, and then click Enter
.
- At the prompt, to change your password, use the following command: password
- 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