Home » SQL & PL/SQL » Client Tools » unable to connect to database (Oracle 10g, windows 7)
unable to connect to database [message #597442] Fri, 04 October 2013 12:08 Go to next message
thelearner
Messages: 110
Registered: April 2013
Location: INDIA
Senior Member
Hi,
I am getting error in my database....
SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


I tried shutdown and startup

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 4 22:31:06 2013

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

SQL> connect /as sysdba
Connected.
SQL> shutdown;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area  805306368 bytes
Fixed Size                  1289996 bytes
Variable Size             209715444 bytes
Database Buffers          591396864 bytes
Redo Buffers                2904064 bytes
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [617],
[614], [0x0], [], [], [], []


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


SQL> SELECT * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> startup force;
ORACLE instance started.

Total System Global Area  805306368 bytes
Fixed Size                  1289996 bytes
Variable Size             209715444 bytes
Database Buffers          591396864 bytes
Redo Buffers                2904064 bytes
ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [617],
[614], [0x0], [], [], [], []


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


SQL>



Please give suggestions
Re: unable to connect to database [message #597444 is a reply to message #597442] Fri, 04 October 2013 12:12 Go to previous message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First hit from Google
http://halimdba.blogspot.com/2011/04/ora-00600-internal-error-code-arguments.html
Previous Topic: sqlplus command execution
Next Topic: Restricting User from login to DB
Goto Forum:
  


Current Time: Sat Aug 02 00:14:59 CDT 2014

Total time taken to generate the page: 0.08453 seconds