Oracle reset password file

xiaoxiao2021-03-06  40

Machine: Sun sparc Ultra60

Operating system: Solaris 9

Oracle: 9.2.0.1

Question: Before you don't build a library, log in to the idle routine, there is enough permissions.

SQLPlus / NOLOG

SQL> SQLPLUS / AS SYSDBA

Solve: Reset the Oracle's SYS user password, reset the password file.

Steps: CD $ ORACLE_HOME / DBS

ORAPWD File = $ ORACLE_HOME / DBS / ORAPWSID Password = Abc Entries = 20

Will build a file in the current directory: ORAPWSID

Then: SQLPLUS SYS / ABC AS SYSDBA logs in the idle routine.

Note: If you manually exit during the construction of the library, or if the library is unsuccessful, you need to turn off all Oracle services to reset your password files to continue to log in with the SYS user, otherwise there is no permission.

转载请注明原文地址:https://www.9cbs.com/read-86083.html

New Post(0)