最近遇到不少人为了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>