• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

oradebug

i did

alter database backup controlfile to trace;
database altered

my trace file is in C:\app\Mathew\diag\rdbms\orcl\orcl\trace
and name of trace file is orcl_ora_5756


but when I use
oradebug it is working..

SQL> oradebug orcl_ora_5756;
ORA-00070: command orcl_ora_5756 is not valid
SQL> oradebug C:\app\Mathew\diag\rdbms\orcl\orcl\traceorcl_ora_5756;
ORA-00070: command C:\app\Mathew\diag\rdbms\orcl\orcl\traceorcl_ora_5756 is not valid
SQL> oradebug 'C:\app\Mathew\diag\rdbms\orcl\orcl\traceorcl_ora_5756';
ORA-00070: command 'C:\app\Mathew\diag\rdbms\orcl\orcl\traceorcl_ora_5756' is not valid
 
0
nobleit
Asked:
nobleit
  • 2
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:

isn't it

oradebug C:\app\Mathew\diag\rdbms\orcl\orcl\trace\orcl_ora_5756
0
 
nobleitAuthor Commented:
SQL> alter database backup controlfile to trace;

Database altered.

SQL> select name from v$database;

NAME                                                                                                                    
---------                                                                                                                
JTAC                                                                                                                    

SQL> oradebug C:\app\Mathew\diag\rdbms\orcl\orcl\trace\jtac_ora_4596
ORA-00070: command C:\app\Mathew\diag\rdbms\orcl\orcl\trace\jtac_ora_4596 is not valid
SQL> oradebug C:\app\Mathew\diag\rdbms\orcl\orcl\trace\jtac_ora_4596;
ORA-00070: command C:\app\Mathew\diag\rdbms\orcl\orcl\trace\jtac_ora_4596 is not valid
SQL> oradebug 'C:\app\Mathew\diag\rdbms\orcl\orcl\trace\jtac_ora_4596';
ORA-00070: command 'C:\app\Mathew\diag\rdbms\orcl\orcl\trace\jtac_ora_4596' is not valid
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
type this - oradebug tracefile_name

what do you want to do with it?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now