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

[zakriyamhd]

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?