-
qq_遁去的一_1
在安装oracle时，安装向导会提示你创建一个oracle用户，来管理oracle。这个用户一般都叫‘oracle’。root下无法登陆oracle，需要进入oracle用户，才能连接数据库su - oraclesqlplus / as sysdba --以管理员身份登陆oracle
-
慕田峪4524236
[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/ggdb2SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 30 13:38:18 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>
-
梦里花落0921
方法一：[root@ogg1 ~]$ cat /home/oracle/.bash_profile |grep SIDexport ORACLE_SID=ogg1方法二：查看oracle任意一个后台进程，例如lgwr,ora_lgwr_ogg1其中ogg1就是sid[oracle@ogg1 ~]$ ps -ef|grep lgwroracle 4864 1 0 11:30 ? 00:00:00 ora_lgwr_ogg1oracle 5442 2329 0 12:18 pts/0 00:00:00 grep lgwr