• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • 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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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