Home » RDBMS Server » Server Administration » Starting oracle instance (Oracle9i)
Starting oracle instance (Oracle9i) [message #50287] Fri, 08 March 2002 16:49 Go to next message
balu
Messages: 23
Registered: March 2001
Junior Member
Hello All,

Interesting problem....!

When a start the oracle instance I am getting the error
ORA-01092: ORACLE instance terminated. Disconnection forced.

What trace file says is...

ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [[kcoapl_blkchk]], [[1]], [[9]], [[2001]], [[]]
, [[]], [[]], [[]]

Note:HP-UX11i, oracle 9i

-Balu.
Re: Starting oracle instance (Oracle9i) [message #50289 is a reply to message #50287] Fri, 08 March 2002 20:39 Go to previous messageGo to next message
Radim
Messages: 5
Registered: March 2002
Junior Member
Hi,

have u started your instance before ?
I'm interested in, because I plan migration my DB 8i to 9i on HP11.

Radim
Re: Starting oracle instance (Oracle9i) [message #50327 is a reply to message #50287] Mon, 11 March 2002 12:36 Go to previous message
Wei Lang
Messages: 23
Registered: March 2002
Junior Member
Looks like your system tablespace corrupted. If your old version is 8.0.X to 8.1.5, your old database may had a slient corruption. Oracle9i check system tablespace corruption automatically when startup and fails. Your old database system did not do that.

Call Oracle and they have workaround.

Hope it helps.

Wei
Previous Topic: How do I get rid of a DEFAULT value on a column
Next Topic: Script To Export User Definitions
Goto Forum:
  


Current Time: Tue Dec 24 20:45:59 CST 2024