asked on

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

ASKER CERTIFIED SOLUTION

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nobleit

ASKER

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

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

type this - oradebug tracefile_name

what do you want to do with it?