oracle使用sysdba登录不了，是怎么回事

counter1219 发表于 2013-01-18 10:10

oracle@linux:~> sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jan 18 10:08:44 2013

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

Connected.
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

SQL> show parameter;
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

SQL>

linux曾 发表于 2013-01-18 15:11

试试
ps -ef|grep ora_dbw0_$ORACLE_SID
kill-9 pid

重新启动oracle
sqlplus sys as sysdba
startup;

Jack_boo 发表于 2013-01-22 12:54

$ORACLE_SID没设置对或者Oracle实例出问题了
echo $ORACLE_SID 看看对不对
ps aux |grop ora看看oracle进程都在不在

页: [1]

Chinaunix's Archiver

oracle使用sysdba登录不了，是怎么回事