Shulou(Shulou.com)06/01 Report--

1. Run CMD

Note the path of ORACLE

Orapwd file=C:\ oracle\ product\ 11.2.0\ dbhome_1\ database\ pwdctcsys.ora

After entering the above command, you will be prompted for your password-note that the password must start with a letter and contain at least 8 characters of uppercase and lowercase letters and numbers

2. Open SQL/PLUS (enter SQLPLUS/NOLOG under cmd) and log in with the newly changed password

CONN sys/password AS SYSDBA

Such as:

CONN sys/QAZwsx123 AS SYSDBA

3. Create a new user

CREATE USER username IDENTIFIED BY password

Create user test identified by Test123456

4. Unlock the newly created user

ALTER USER user name ACCOUNT UNLOCK

Alter user test account unlock

5. Grant creation rights to newly logged-in users

GRENT CREATE SESSION TO user name

CRANT DBA TO user name

Grant create session to test;grant dba to test

6. You can switch to the newly created user login test.

CONNECT username / password

Connect test/Test123456

Note that all operations must be followed by a ";" to perform successfully.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.