DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-00911: invalid character while typing select name from v$tempfile;

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57

    Question ORA-00911: invalid character while typing select name from v$tempfile;

    Hi,

    I am getting strange errors while accessing the V$ views each time I access them throws me some or the other error why Oracle behaves like this?

    Oracle: 9.2.0.7
    Unxi :Aix5.2

    SQL> select name from v$tempfile;
    select name from v$tempfile
    *
    ERROR at line 1:
    ORA-00911: invalid character


    SQL> select Name from v$tempfile;

    NAME
    --------------------------------------------------------------------------------
    /u07/oradata/sreport/wsadatatemp02.dbf
    /u06/oradata/srep/wsadatemp01.dbf
    /u10/oradata/sreport/wsadatatemp03.dbf.dbf

    SQL> select name from v$tempfile;
    select name from v$tempfile
    *
    ERROR at line 1:
    ORA-00911: invalid character


    DBAs> select any_idea " why it throws me error " from dba_support.com;

    no rows selected

  2. #2
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    After a while it works fine,

    SQL> select name from v$tempfile;

    NAME
    --------------------------------------------------------------------------------
    /u07/oradata/sreport/wsadatatemp02.dbf
    /u06/oradata/srep/wsadatemp01.dbf
    /u10/oradata/sreport/wsadatatemp03.dbf.dbf


    but why does this keeps hapening each time when I exit and login again with sqlplus "/ as sysdba" into oracle for the first time it throws me this kind of errors

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Something wicked about that case sensitivity? Name against name...
    Last edited by Tarry; 10-25-2005 at 05:43 PM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    Quote Originally Posted by Tarry
    Something wicked about that case sensitivity? Name against name...

    Again same issue:

    SQL> select username,account_status from dba_users;
    select username,account_status from dba_users
    *
    ERROR at line 1:
    ORA-00911: invalid character
    SQL> select username from dba_users;

    USERNAME
    ------------------------------
    SYSTEM
    DBSNMP
    CSG
    SYS
    OUTLN
    WMSYS

    6 rows selected.

    SQL> select username,account_status from dba_users;
    select username,account_status from dba_users
    *
    ERROR at line 1:
    ORA-00911: invalid character



    SQL> select username,account_status from dba_users;

    USERNAME ACCOUNT_STATUS
    ------------------------------ --------------------------------
    SYSTEM OPEN
    DBSNMP OPEN
    CSG OPEN
    SYS EXPIRED
    OUTLN EXPIRED & LOCKED
    WMSYS EXPIRED & LOCKED

    6 rows selected.

    sqlplus "/ as sysdba"

    SQL*Plus: Release 9.2.0.7.0 - Production on Wed Oct 26 09:43:01 2005

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.7.0 - Production

    NLS_LANG is
    NLS_LANG=AMERICAN_AMERICA.US7ASCII
    and the kernel version is : 32 bits
    #bootinfo –K

    32
    where as cpu version is : 64 bits
    #bootinfo –y

    64


    I installed the base 9.20.1 on aix and applied the patch 9.2.0.7 then created the db using dbca .I didnt had any probelms during this process:

    Any idea?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width