Oracle以DBA方式登陆

时间:2022-11-03 07:46:26

最近遇到不少人为了sysdba怎么登陆恼火,我这里提供一种简单的登陆方式-以root登陆到unix系统
  bash-2.03$ su - oracle   
   
  bash-2.03$ sqlplus
  SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚËÄ 3ÔÂ 30 11:09:07 2006
  Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
  请输入用户名:  bms
  请输入口令: 
  连接到:
  Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
  With the Partitioning, OLAP and Oracle Data Mining options
  JServer Release 9.2.0.1.0 - Production
  SQL>
  SQL> show user
  USER 为"BMS"
  SQL> conn /as sysdba
  已连接
  SQL> show user
  USER 为"SYS"

  //这就已经是sys用户了,简单吧

 

  //当然还有很多方法了,比如
  bash-2.03$ sqlplus "as sysdba"
  SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚËÄ 3ÔÂ 30 11:13:13 2006
  Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
  请输入用户名:  bms
  请输入口令: 
  连接到:
  Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
  With the Partitioning, OLAP and Oracle Data Mining options
  JServer Release 9.2.0.1.0 - Production
  SQL> show user
  USER 为"SYS"
  SQL>