ORACLE_OCP之ORACLE基本命令

ORACLE_OCP之ORACLE基本命令

• 在日常工作中，关于数据库的启停：

  • 先关闭上层应用服务---->关闭监听---->关闭数据库
  • 启动数据库----->启动监听----->启动应用 进行相关的连接测试

• 操作系统重启命令 shutdown -r now

• 操作系统关闭命令 shudtown -h now

• 数据库关闭命令 shutdown immediate

• 数据库启动命令 startup

• 监听启动命令 lsnrctl start

• 监听关闭命令 lsnrctl stop

• 监听查看命令 lsnrctl status

//使用sqlplus工具
[oracle@oracle12 ~]$ sqlplus / as sysdba

解锁hr用户

SQL> alter user hr identified by hr;

User altered.

SQL> conn hr/hr
Connected.
SQL> select tname from tab;

TNAME
--------------------------------------------------------------------------------
COUNTRIES
DEPARTMENTS
EMPLOYEES
EMP_DETAILS_VIEW
JOBS
JOB_HISTORY
LOCATIONS
REGIONS

8 rows selected.

SQL> select * from job_history
  2  ;

EMPLOYEE_ID START_DATE          END_DATE            JOB_ID     DEPARTMENT_ID
----------- ------------------- ------------------- ---------- -------------
        102 2001-01-13 00:00:00 2006-07-24 00:00:00 IT_PROG               60
        101 1997-09-21 00:00:00 2001-10-27 00:00:00 AC_ACCOUNT           110
        101 2001-10-28 00:00:00 2005-03-15 00:00:00 AC_MGR               110
        201 2004-02-17 00:00:00 2007-12-19 00:00:00 MK_REP                20
        114 2006-03-24 00:00:00 2007-12-31 00:00:00 ST_CLERK              50
        122 2007-01-01 00:00:00 2007-12-31 00:00:00 ST_CLERK              50
        200 1995-09-17 00:00:00 2001-06-17 00:00:00 AD_ASST               90
        176 2006-03-24 00:00:00 2006-12-31 00:00:00 SA_REP                80
        176 2007-01-01 00:00:00 2007-12-31 00:00:00 SA_MAN                80
        200 2002-07-01 00:00:00 2006-12-31 00:00:00 AC_ACCOUNT            90

10 rows selected.