Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2321113
  • 博文数量: 535
  • 博客积分: 8689
  • 博客等级: 中将
  • 技术积分: 7066
  • 用 户 组: 普通用户
  • 注册时间: 2010-11-26 10:00
文章分类

全部博文(535)

文章存档

2024年(4)

2023年(4)

2022年(16)

2014年(90)

2013年(76)

2012年(125)

2011年(184)

2010年(37)

分类: Oracle

2012-11-07 19:20:03




--设置启动orcl数据库
[oracle@localhost dbs]$ export ORACLE_SID=orcl
SQL> conn /as sysdba ;   
Connected to an idle instance.
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> shutdown immediate ;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> select instance_name from v$instance ;
select instance_name from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> startup ;   
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initORCL.ora'
SQL> alter database mount ;
alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> select open_mode from v$database ;
select open_mode from v$database
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> create pfile from spfile ;
create pfile from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> host ;
[oracle@localhost ~]$ sqlplus "/as sysdba" 

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 18 23:04:03 2011

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

Connected to an idle instance.

SQL> create spfile from pfile ;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/u01/app/oracle/product/10.2.0/db_1/dbs/initORCL.ora'
SQL> host ;



阅读(3134) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~