Post Closed as "Needs more focus" by mustaccio, John K. N., Erik Reasonable Rates Darling, RDFozz, Mr.Brownstone

occurred Nov 28, 2017 at 21:56

added 84 characters in body

Source Link

edited Nov 28, 2017 at 10:19

user1822

This is what happens when I try to query as DBA:

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from dba_users;

select count(*) from dba_users
*
ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> alter database open;

alter database open
*
ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], []

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

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

Enter user-name: sys as sysdba  
Enter password:

Connected to:  
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from dba_users;

select count(*) from dba_users  
                     *   
ERROR at line 1:   ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> alter database open;

alter database open  
*   
ERROR at line 1:   ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [],
> [], [], []

please help to restore my db...

This is what happens when I try to query as DBA:

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from dba_users;

select count(*) from dba_users
*
ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> alter database open;

alter database open
*
ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], []

please help to restore my db...

This is what happens when I try to query as DBA:

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

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

Enter user-name: sys as sysdba  
Enter password:

Connected to:  
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from dba_users;

select count(*) from dba_users  
                     *   
ERROR at line 1:   ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> alter database open;

alter database open  
*   
ERROR at line 1:   ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [],
> [], [], []

please help to restore my db...

tag, and format correction

Source Link

edit approved Nov 11, 2014 at 7:49

Aasim Abdullah

3k
4
25
40

thisThis is what happens when I try to query as DBA:

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count() from dba_users; select count() from dba_users * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views onlyselect count(*) from dba_users;

select count(*) from dba_users
*
ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], []alter database open;

alter database open
*
ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], []

please help to restore my db...

this is what happens when I try to query as DBA:

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

Enter user-name: sys as sysdba Enter password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count() from dba_users; select count() from dba_users * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], []

please help to restore my db...

This is what happens when I try to query as DBA:

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from dba_users;

select count(*) from dba_users
*
ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> alter database open;

alter database open
*
ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], []

please help to restore my db...

oracle restore

Source Link

asked Nov 11, 2014 at 3:35

goodluck247

1
1

my oracle db won't open please help

this is what happens when I try to query as DBA:

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014

Enter user-name: sys as sysdba Enter password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count() from dba_users; select count() from dba_users * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], []

please help to restore my db...

restore

Stack Exchange Network

Return to Question

my oracle db won't open please help