-
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...
Last edited by Tarry; 10-25-2005 at 05:43 PM.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|