root用户怎么用oracle？

Question

root用户怎么用oracle

Answer 1

在安装oracle时，安装向导会提示你创建一个oracle用户，来管理oracle。这个用户一般都叫‘oracle’。
root下无法登陆oracle，需要进入oracle用户，才能连接数据库
su - oracle
sqlplus / as sysdba --以管理员身份登陆oracle

Answer 2

[root@oel51 ~]# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[root@oel51 ~]# /u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus dexter/xxxx@127.0.0.1:1521/ggdb2

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 30 13:38:18 2015

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Answer 3

方法一：
[root@ogg1 ~]$ cat /home/oracle/.bash_profile |grep SID
export ORACLE_SID=ogg1
方法二：
查看oracle任意一个后台进程，例如lgwr,ora_lgwr_ogg1其中ogg1就是sid
[oracle@ogg1 ~]$ ps -ef|grep lgwr
oracle 4864 1 0 11:30 ? 00:00:00 ora_lgwr_ogg1
oracle 5442 2329 0 12:18 pts/0 00:00:00 grep lgwr