Home » Infrastructure » Unix » ORA-04063: view "SYSTEM.V" has errors
ORA-04063: view "SYSTEM.V" has errors [message #266743] Tue, 11 September 2007 09:33 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member



Dear experts,


I have compiled the followin gquery in sql prompt:

Details:oracle 9i,version 9.2.0.7.0,OS :Redhat linux

system user;

>select c.value || '/' ||instance || '_ora_' || ltrim(to_char(a.spid,'fm99999')) ||'.trc' TRCLOC from

v$process a, v$session b,v$parameter c, v$thread d where a.addr = b.paddr and b.audsid =

userenv('sessionid') and c.name = 'user_dump_dest'


it shows output:

/mnt/ora_test/oracle/admin/test/udump/test_ora_11546.trc


But i have run the same query in script it show followin error:

system user:(same above query)


Output:

select c.value || '/' ||instance || '_ora_' || ltrim(to_char(a.spid,'fm99999')) ||'.trc' TRCLOC from v

a, v b,v c, v c where a.addr = b.paddr and b.audsid = userenv('sessionid') and c.name = 'user_dump_dest'


*
ERROR at line 1:
ORA-04063: view "SYSTEM.V" has errors

- Thanx.


Re: ORA-04063: view "SYSTEM.V" has errors [message #266747 is a reply to message #266743] Tue, 11 September 2007 09:39 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
$xxxx will be translated by sh or whatever shell you use.
You have to escape the $

By the way, if this is a production (or production-like) system, do not use SYSTEM for day-to-day work

[Updated on: Tue, 11 September 2007 09:40]

Report message to a moderator

Re: ORA-04063: view "SYSTEM.V" has errors [message #266779 is a reply to message #266747] Tue, 11 September 2007 11:19 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member


Thanx it works.


simply i have altered the view (v/$parameter insteed of v$parameter).


-Thanx
Previous Topic: SFTP from Solaris Server to Windows Server
Next Topic: use of EOF in scripting
Goto Forum:
  


Current Time: Thu Mar 28 15:05:30 CDT 2024