Home » Infrastructure » Unix » Oradebug utility works but no trace file  () 1 Vote
Oradebug utility works but no trace file [message #147031] Tue, 15 November 2005 07:35 Go to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi,
I am using Solaris 9 and Oracle 9.2 .

I did this

-->
SQL> ! ps -ef | grep pmon
  oracle  4531  4529  0 08:15:41 pts/7    0:00 grep pmon
  oracle   556     1  0   Oct 19 ?        0:01 ora_pmon_testdb
SQL> oradebug setospid 564
Oracle pid: 6, Unix process pid: 564, image: oracle@dogmatix (SMON)
SQL> oradebug ipc
Information written to trace file.
SQL> !ls -lat $ORACLE_BASE/admin/testdb/udump |head
total 668
drwxr-xr-x   2 oracle   oinstall    2560 Oct 19 06:31 .
-rw-r-----   1 oracle   oinstall     695 Oct 19 06:31 testdb_ora_571.trc
-rw-r-----   1 oracle   oinstall     611 Oct 19 05:32 testdb_ora_679.trc


no new trace file created at udump location , so i tried this

-->
SQL> SELECT pid FROM v$process 
    WHERE addr = ( SELECT paddr FROM v$bgprocess
                 WHERE name = 'SMON');
       PID
----------
         6

SQL> oradebug setorapid 6
Unix process pid: 564, image: oracle@dogmatix (SMON)
SQL> oradebug ipc
Information written to trace file.
SQL> !ls -lat $ORACLE_BASE/admin/testdb/udump |head
total 668
drwxr-xr-x   2 oracle   oinstall    2560 Oct 19 06:31 .
-rw-r-----   1 oracle   oinstall     695 Oct 19 06:31 testdb_ora_571.trc
-rw-r-----   1 oracle   oinstall     611 Oct 19 05:32 testdb_ora_679.trc


then again, no new trace file found.

Am i missing something or doing something wrong.

thanks & regards,
tarun

[Updated on: Tue, 15 November 2005 07:37]

Report message to a moderator

Re: Oradebug utility works but no trace file [message #147367 is a reply to message #147031] Thu, 17 November 2005 07:02 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


No answer received yet. need expert comments .
Re: Oradebug utility works but no trace file [message #147500 is a reply to message #147367] Thu, 17 November 2005 22:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
sys@9i > !uname -a
SunOS mutation.xxxx 5.8 Generic_108528-15 sun4u sparc SUNW,Sun-Blade-100

sys@9i > select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE    9.2.0.3.0       Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

sys@9i > !pwd
/u01/app/oracle/admin/mutation/udump
sys@9i > !ls -lrt
total 0
sys@9i > oradebug setmypid
Statement processed.
sys@9i > oradebug ipc
Information written to trace file.
sys@9i > oradebug tracefile_name
/u01/app/oracle/admin/mutation/udump/mutation_ora_3554.trc
sys@9i > !ls -lrt
total 8
-rw-r-----   1 oracle   dba         3188 Nov 17 22:35 mutation_ora_3554.trc
Re: Oradebug utility works but no trace file [message #147505 is a reply to message #147500] Fri, 18 November 2005 00:07 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
hi mahesh,

Even i tried the same again, see this

SQL> select pid from v$process
  2  where addr = (select paddr from v$bgprocess
  3  where name='SMON');

       PID
----------
         6

SQL> oradebug setorapid 6
Unix process pid: 564, image: oracle@dogmatix (SMON)
SQL> ! ls -lrt $ORACLE_BASE/admin/testdb/udump
total 0

SQL> oradebug ipc
Information written to trace file.
SQL> ! ls -lrt $ORACLE_BASE/admin/testdb/udump
total 0


Why i am not getting any trace file??

[Edit: Sorry but its pointing to bdump location , i just checked]

SQL> oradebug tracefile_name
/data1/u01/app/oracle/admin/testdb/bdump/testdb_smon_564.trc

[Updated on: Fri, 18 November 2005 00:16]

Report message to a moderator

Previous Topic: df help
Next Topic: Migrating from 8.0.5 (Tru64 4.0f) to 10g (Tru64 5.1b)
Goto Forum:
  


Current Time: Mon Nov 25 10:27:58 CST 2024