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