[Oracle Use (2)] Simple use of Oracle

1:oracle's Services

Oracleservice + SID                    # database service Oracleoradb10g_home1listener           # Database listener service.

2: Start the native database:

Start Oracleservice + SID: Database service

Log in to Oracle using the Sqlplus tool

Sys/tiger System Super Administrator (All rights to start/close/backup/restore/database management)

System/tiger Administrator (Create/modify/delete weights for individual Scheam objects)

Scott/tiger Test Users

Sqlplus 3 ways to sign in: Command Window

A: Direct input: Sqlplus
User name: Sys
Password: Tiger as Sysdba

B: Enter sqlplus directly specify user name and password

Sqlplus Sys/tiger as Sysdba

Sqlplus Sytem/tiger

C: Start sqlplus without logging in

Sqlplus/nolog

Connect System/tiger;

Conn (abbreviated) Sys/tiger as SYSDBA

3: Connect to the network database

3.1: Network database to open (database service) and monitoring services.

Read the Listener.ora file.

LISTENER =  (description_list = (    DESCRIPTION = (      address_list = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))      )      (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 11-55) (PORT = 1521))))  

Through the TCP/IP protocol, listen for 1521 of the ports on the 11-55 host.

3.2: The source client configures the host string information to be connected via Tnsname.ora.

Orcl_xxx =  (DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = 11-55) (PORT = 1521))    (Connect_data =      (SERV ER = dedicated)      (service_name = ORCL)    )  )

ORCL_XXX: Host string.

3.3: Use the source client's sqlplus to connect to the edge.

Sqlplus the user name/target server password @ host string for the target server.

Sqlplus System/[email protected]_xxx

Sqlplus Sys/[email protected]_xxx as Sysdba

4: Authorization Authentication for database connections

Sqlnet.ora file
Sqlnet. Authentication_services= (NONE)

NTS: Authorized authentication of the operating system

NONE: Authorized authentication of the database

5: Start monitoring and shutdown monitoring

Operating system commands: NET Start/stop oralceora10g_home1tnslistener

Oracle Commands: Lsnrctl start/stop (Listenercontrol)

6: Start the database and close the database

    Operating system commands: NET Start/stop oracleserviceorcl Oracle Commands: Startup/shudown (is sqlplus command)
Shutdown # normal shutdown shutdown immedate     # shut down now startup               # Normal startup startup Nomount       # Boot to not load database state startup mount         # Boot to load database file state ALTER DATABASE open   # to get the databases started.

　　

7: Verify that the Listener and database are starting normally.

Lsnrctl start net start ORACLESERVICEORCL Sqlplus/nolog Conn Sys/tiger as SYSDBA shutdown immediate startup

8:oracle instances with Oracle databases.

Oracle instances: Memory management + process management (process re-processing threads)

Oracle Database: Data files + log files + control files.

The Oracle instance loads the database.

Startup Nomount: Booting to the stage of loading the control file

Startup mount: Booting to the stage of loading the data file

ALTER DATABASE open: Changes the databases to a startup state.

Rman/dabase Recover/flash Recover

9:sqlplus Tools:

A: Use in DOS

2 Types of statements:

SQL statement: Insert/update/delete/select/create, you must end with a semicolon.

Common commands:

　　　　　　　　          DESC table name                connect        setspool Help Index  --view Sql*plus can statement @--Execute SQL script file. @@--executes another script in one script/ends and executes the SQL statement. Column Field name format A20 set field format connect connect user name edit the last SQL statement in the buffer. When the edit is complete, exit the host invoke operating system (DOS) command with/to execute exit. Prompt output content (script comment hint) set settings Oracle environment variable set time onset server_output onalter session set nls_date_format= ' YYYY-MM-DD '; show User;spool file path; Spool OFF: Logs the process performed by Sqlplus to a file.

B:oracle's SQL Plus interface

10: Writing Database Scripts

Create a user. If the password is numeric, create user java1411 identified by "123" with double quotation marks: System permissions: System_privilege_mapgrant create session to java1411; Object permissions: Select |insert|update|delete Grant Select on Scott.dept to java1411; role permissions grant connect to java1411;grant resource to J ava1411; grant permission to user; Reclaim permissions revoke permissions from user;

　　

[Oracle Use (2)] Simple use of Oracle