Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / April 2006

Tip: Looking for answers? Try searching our database.

ORA-01219: database not open

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BS - 28 Apr 2006 16:58 GMT
Hi,

Please help me resolve the error above. I'm new to the Oracle world and
not sure how to get this done.

Here are the results from the v$access view.

SVRMGR> select * from v$access;
SID        OWNER
   OBJECT
            TYPE
----------
----------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------
       10 SYS
   GV$ACCESS
            VIEW
       10 SYS
   V$ACCESS
            VIEW
       10 SYS
   X$KGLDP
            TABLE
       10 SYS
   X$KGLLK
            TABLE
       10 SYS
   X$KGLOB
            TABLE
       10 SYS
   X$KSUSE
            TABLE                  
6 rows selected.
BS - 28 Apr 2006 17:31 GMT
Never mind. I figured it out. Below are the steps that I did.

ALTER DATABASE RECOVER;
shutdown immediate;
startup;
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.