-
Starting up Database - Table or view does not exist
Oracle Version: 10.2.0.1.0
tried to startup my database - got this error
Total System Global Area 1073741824 bytes
Fixed Size 1999160 bytes
Variable Size 352325320 bytes
Database Buffers 713031680 bytes
Redo Buffers 6385664 bytes
Database mounted.
ORA-00942: table or view does not exist
surprisngly, when I do ps-ef|grep smon - my database was running fine
even I tried to connect from different machine using tnsentry - its connecting - very weird -
any comment ?
-
Have you bothered in checking Alert Log?... what's the error that comes alongside ORA-00942?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
do you have some after database startup triggers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|