Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

starting DB instance

Ramesh RAug 3 2010 — edited Aug 3 2010

Hi ,
Yesterday i had a problem to stop one database instance immediately. I used kill like shown below

[oracle@rac1 backup]$ ps -eaf | grep smon
oracle 7882 1 0 16:14 ? 00:00:06 asm_smon_+ASM1
oracle 8553 1 0 16:15 ? 00:00:15 ora_smon_rock1
oracle 23324 1 0 16:39 ? 00:00:06 ora_smon_TESTDB
oracle 15916 21301 0 17:17 pts/3 00:00:00 grep smon
[oracle@rac1 backup]$kill -9 23324

to kill my TESTDB.

Now i need to start the instance. How to do that?
when i issued

sqlplus / as sydba

i got the below error

[oracle@ABC /]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 3 11:17:30 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-07446: Message 7446 not found; No message file for product=RDBMS,
facility=ORA; arguments: [appl/oracle/product/10.2.0_db/rdbms/log]
[user_dump_dest]
ORA-07446: Message 7446 not found; No message file for product=RDBMS,
facility=ORA; arguments: [appl/oracle/product/10.2.0_db/rdbms/log]
[user_dump_dest]

What would be the reason and what should i do for the same?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2010

Added on Aug 3 2010

#db, #general-database-discussions

24 comments

2,550 views