No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

eSight V300R010C00SPC200, 300, and 500 Local HA System Software Installation Guide (SUSE Linux + Oracle + Veritas) 10

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
How Do I Change the Password of an Oracle Database User

How Do I Change the Password of an Oracle Database User

Question

I do not know how to change the password of an Oracle database user.

When eSight is installed, use the maintenance tool to change the database password. Otherwise, some problems may occur on eSight.

Answer

This operation is applicable only to the single-node system scenario.

  1. Log in to the SUSE Linux as user oracle.
  2. On the command line interface (CLI), run the following command to connect to the Oracle database:

    $ sqlplus / as sysdba

    The user name and password are required in remote login mode. The following describes how to use the command to connect the system user to the Oracle database with password testpwd.

    $ sqlplus system/testpwd as sysdba

    If the information similar to the following is displayed, the system user is connected to the Oracle database:

    SQL >

  3. Run the following command to change the password of the database user system:

    > alter user system identified by testpwd;

    The method of changing other Oracle user passwords is the same as the method of changing the password of the database user system. To be specific, system is the database user name to be changed, and testpwd is the password of the user-defined system user.

    If the return value is User altered, the password is successfully changed. Otherwise, locate the cause as prompted.

Translation
Download
Updated: 2019-10-30

Document ID: EDOC1100044372

Views: 33197

Downloads: 26

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Share
Previous Next