3 Replies Latest reply on Dec 3, 2012 5:48 PM by user6427417

    Query v$ views from shell script fail

    Aljaro
      Hi everybody,


      the query below is runing well with a SQL*PLUS (database is mounted and not open)

      SQL> SELECT member FROM v$logfile;

      MEMBER
      --------------------------------------------------------------------------------
      +DATA/testgfi/onlinelog/group_1.298.773871647
      +DATA/testgfi/onlinelog/group_2.294.773871647
      +DATA/testgfi/onlinelog/group_3.295.773871647



      But Giving error if I run it from Shell script ???

      $ sqlplus -s '/ as sysdba' << EOF
      SELECT member FROM v$logfile;
      EOF
      SELECT member FROM v
      *
      ERROR at line 1:
      ORA-01219: database not open: queries allowed on fixed tables/views only..


      Please help..

      Thanks..

      Aljaro