Linux下安装了Oracle10g后重新启动的问题
在Fedora8下安装了Oracle10g之后,当再次重启电脑以后!使用"sqlplus system/mileschen"登录系统出现下面的错误信息:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
解决步骤如下:
用"oracle"用户登录到系统后,输入如下命令:
(1)[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 26
06:52:41 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
(2)SQL>connect / as sysdba
Connected to an idle instance.
(3)SQL>startup
Total System Global Area 268435456 bytes
Fixed Size 1218892 bytes
Variable Size 75499188 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
这样代表数据库例程已经启动了,然后输入下面命令登录用户
(4)[oracle@localhost ~]$ sqlplus system/mileschen
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 26 06:55:48
2008
copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Production
With the Partitioning, OLAP and Data Mining options
SQL>
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
解决步骤如下:
用"oracle"用户登录到系统后,输入如下命令:
(1)[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 26
06:52:41 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
(2)SQL>connect / as sysdba
Connected to an idle instance.
(3)SQL>startup
Total System Global Area 268435456 bytes
Fixed Size 1218892 bytes
Variable Size 75499188 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
这样代表数据库例程已经启动了,然后输入下面命令登录用户
(4)[oracle@localhost ~]$ sqlplus system/mileschen
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 26 06:55:48
2008
copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Production
With the Partitioning, OLAP and Data Mining options
SQL>