织梦CMS - 轻松建站从此开始!

罗索实验室

当前位置: 主页 > 基础技术 > 数据库开发 >

ORA-01034: ORACLE not available

罗索客 发布于 2007-10-16 18:15 点击:次 
solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory [message #116555 is a reply to message #116254 ] Wed, 20 April 2005 10:59 Go to previous messageGo to next message sunil_v_mishra Messages: 413 Registered: March 2005 Senior
TAG:

solution of Error - ORA-01034: ORACLE not available ORA-27101: shared memory [message #116555 is a reply to message #116254 ] Wed, 20 April 2005 10:59 Go to previous messageGo to next message
sunil_v_mishra
Messages: 413
Registered: March 2005
Senior Member

hi

most of time people get problem coz there database is not started so they get error ora-01034

u can see the thing below
------------------------------

SQL> connect sys as sysdba
Enter password:change_on_install
Connected.

SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01034: ORACLE not available


SQL> startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 778212 bytes
Variable Size 61874204 bytes
Database Buffers 104857600 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.

SQL> desc v$parameter;
Name Null? Type
------------------------ -------- ----------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(512)
DISPLAY_VALUE VARCHAR2(512)
ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(10)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT VARCHAR2(255)
HASH NUMBER

SQL> desc v$pwfile_users;
Name Null? Type
----------------------------------------- -------- -------------
USERNAME VARCHAR2(30)
SYSDBA VARCHAR2(5)
SYSOPER VARCHAR2(5)


now u can see work .... if some one is trying to start database by connecting as scott/tiger then he should know that scott is user he dont have right to startup the database so dba can start the database, sys is a user with DBA right he is the owner of data dictionary

from :- sunil (iwgh)
本站文章除注明转载外,均为本站原创或编译欢迎任何形式的转载,但请务必注明出处,尊重他人劳动,同学习共成长。转载请注明:文章转载自:罗索实验室 [http://www1.rosoo.net/a/200710/6831.html]
本文出处: 作者:iwgh
顶一下
(1)
25%
踩一下
(3)
75%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 验证码:点击我更换图片
栏目列表
将本文分享到微信
织梦二维码生成器
推荐内容