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

Administrative tools 1 sqlplus

Sqlplus account name / password as role name

Login of administrator-> sys system

1 sys login

Sqlplus sys/oracle as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 11 14:47:07 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

And Real Application Testing options

How to judge whether a user has logged in successfully?

SQL > show user

USER is "SYS" successfully connects to the database

Exit exit

[oracle@yutianedu ~] $sqlplus / nolog just opens the sqlplus tool and does not connect

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 11 14:48:14 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL > show user

USER is "" has no user connection

Exit

Which database did you log in to?

Standard practice; specify which database you want to log in to before logging in

Method: specify which database you want to log in to through the variable ORACLE_SID

Export ORACLE_SID= instance name (case sensitive)

Sys logs in to orcl database

1 export ORACLE_SID=orcl

2 sqlplus sys/oracle as sysdba

SQL > show parameter instance

NAME TYPE VALUE

-

Active_instance_count integer

Cluster_database_instances integer 1

Instance_groups string

Instance_name string orcl

Note: sys users can log in locally without a password-"sys authentication is operating system authentication."

If you log in to the operating system of the database server, then you don't need a password to log in

Sqlplus / as sysdba (after logging in to the server with oracle)

System administrator login

Sqlplus system/oracle

SQL > show user

USER is "SYSTEM"

Ordinary user login-> password authentication-"Database-> you must ensure that the database is open before ordinary users can log in.

How to tell if the database is open or not?

1 administrator login

Export ORACLE_SID=orcl

Sqlplus / as sysdba

SQL > select status from v$instance

STATUS

-

OPEN

If not, you need to use startup to start the database

Shutdown immediate; shut down the database

2 after database open, ordinary users can log in

Note: ordinary users are locked by default and must be unlocked before logging in.

Administrators can unlock and re-give users a new password

Unlock scott

Alter user scott account unlock

Give the new password.

Alter user scott identified by oracle

Unlock the hr user and change the password to hr

Alter user hr account unlock

Alter user hr identified by hr

The above statement merges one statement

Alter user hr account unlock identified by hr

Scott login

Sqlplus scott/oracle

Hr login

Sqlplus hr/hr

SQL > show user

USER is "HR"

Summary:

Sys must be as sysdba-- > operating system Certification sqlplus / as sysdba

Ordinary users must first open the database-"password authentication -" sqlplus account name / password

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.