Monday, 7 April 2014

ORA-01109: database not open

Aloha!

I have created an instance on 11g R2 and about to import a dump. Upon creating a directory, I stumble upon this error;


[oracle@ole5 SBAtemp]$ sqlplus sys/Change12345@orc01 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 23 19:30:33 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create or replace directory BW_TEMP as '/u01/SBAtemp/';
create or replace directory BW_TEMP as '/u01/SBAtemp/'
*
ERROR at line 1:
ORA-01109: database not open


I'm facing a problem with the Oracle 10 database. This is a RAC configuration and live system. After restarting the CRS in both servers, the database does not go to OPEN:

ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> select status from V$instance;
STATUS
MOUNTED

If you run manually either:

SQL> alter database open;

or

SQL> startup force;

The instances go OPEN and everything works normally, but if you restart the CRS again, the same problem, the database does not go to OPEN.
I guess something is missing/wrong in an Oracle conf file...

a
This is the command to set the database to opened:

# srvctl config database -d -a

No comments:

Post a Comment