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

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

Something wicked about that case sensitivity? Name against name...

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?