Oracle Database User Login Related

installation of Oracle database :

One:

Install the time can be set to unlock the user generally by default is to unlock SOCTT users and HR users;

Oracle's Super User is SYSDBA This user can also set a password when installing, a

You can set the password directly when you use it, so that you will log in with the Super user later.

There is no need to enter the password again. However, when used in enterprise development, it must not be set

placed password, enter the password when you log in with the Superuser!

Login for Oracle Database:

One:

1. Sqlplus username/password (e.g. login Soctt:sqlplus SCOTT/11)

　　2. Login as Administrator: Sqlplus/as sysdba (Login password when Oracle database is installed )

3. Unlock users:sql> alter user Scott account unlock (logged in as an administrator and unlock the Scott user.) User default Lock)

4. Modify user password:sql> alter users Scott identified by xxx (XXX is the new password to be changed) (Login as Administrator , change Password to Scott user)

5. View the current locale:sql> select Userenv (' language ') from dual

Considerations for operating Oracle databases under Liunx:

1. Start the Oracle database:

To turn off and turn on Oracle services:
Open:
Step one: Log in to the database with an administrator Sqlplus/as sysdba (log in to the database with Superuser)
Step Two: Enter command startup (start database)

Shut down:
Step one: Log in to the database with an administrator Sqlplus/as sysdba (log in to the database with Superuser)
Step Two: Enter the command shutdown immediate (close the database)

2. Shut down and open the monitoring service for the Oracle database:

Turn on the listening service and you can operate the database remotely.
　　　　

Open:
Input command: Lsnrctl start
Shut down:
Input command: Lsnrctl stop

3. If you want to log in to a database under another user, you should use:

s　　　 qlplus user name/password @ database name (example Scott/[email protected])

Win under Operation Oracle database also to open the corresponding service:

1 Control Panel → management tools → service →oracleserviceorcl→ Automatic (manual) (must start this first)

2 Control Panel → management tools → service →...home1tnslistener→ Automatic (manual) (start to finish the first one in the Open this service)

Oracle Database User Login Related