Skip to Main Content

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

database or pluggable database not open: queries allowed on fixed tables or views only

Anand_ReddyMay 25 2016 — edited Jun 1 2016

C:\Users\anand>sqlplus sys/abcd as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue May 24 21:23:09 2016 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt ions SQL> select * from all_users   2  / select * from all_users               * ERROR at line 1: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1694498816 bytes Fixed Size                  3046416 bytes Variable Size            1040188400 bytes Database Buffers          637534208 bytes Redo Buffers              13729792 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> $rman target Argument    Value          Description ----------------------------------------------------------------------------- target      quoted-string  connect-string for target database catalog      quoted-string  connect-string for recovery catalog auxiliary    quoted-string  connect-string for auxiliary database nocatalog    none          if specified, then no recovery catalog cmdfile      quoted-string  name of input command file log          quoted-string  name of output message log file trace        quoted-string  name of output debugging message log file append      none          if specified, log is opened in append mode debug        optional-args  activate debugging msgno        none          show RMAN-nnnn prefix for all messages send        quoted-string  send a command to the media manager pipe        string        building block for pipe names script      string        name of catalog script to execute using        list of args  arguments for rman variables timeout      integer        number of seconds to wait for pipe input checksyntax  none          check the command file for syntax errors ----------------------------------------------------------------------------- Both single and double quotes (' or ") are accepted for a quoted-string. Quotes are not required unless the string contains embedded white-space. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00552: syntax error in command line arguments RMAN-01009: syntax error: found "end-of-file": expecting one of: "double-quoted- string, identifier, single-quoted-string, " RMAN-01007: at line 0 column 0 file: command line arguments SQL> alter database open resetlogs   2  / alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: 'C:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF' SQL> select * from all_users   2  / select * from all_users               * ERROR at line 1: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

Comments

60437
Leigh - If you can put your application on apex.oracle.com, I will try it there and see what I can figure out. What version of Application Express are you using?

Scott
482478
Scott --

Thank you for the reply...We are currently using version 3.1.1.00.09 on an Oracle 10gR2 database. I will try to post the application to the hosted environment as requested, but it will be the first time I have done so, so be prepared for further questions...or if you guys have a document outlining the how's and "gotcha" that would be good too.

Thanks,
Leigh
482478
Scott --

I'm totally confused now....it usually doesn't take much especially on a Monday morning. I was able to export the three components without errors today. We have been seeing an extraordinarily high load on the system due to other testing and development going on. I'm wondering if the load issue may be related, though I don't see exactly how that could be.

Anyhow, I've attempted to upload my application to the hosted site numerous times now. It is a large application and is timing out during the install. I removed some of the pages and security functions, but it appears I probably removed too much, since I'm getting an Oracle error when installing now.

As the problem is intermittent, even in my environment, I'm going to guess that the issue isn't in APEX, but rather something in my environment.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 29 2016
Added on May 25 2016
6 comments
14,255 views