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) |