解决scott用户登录不了问题
报错信息如下:
[oracle@localhost 10g]$ sqlplus scott/tiger
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 13 10:24:51 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
解决如下:
[oracle@localhost 10g]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 13 10:26:04 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn sys/sys as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 92277380 bytes
Database Buffers 188743680 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL> SQL>
SQL> conn scott/tiger
Connected.
SQL>