I cannot get trace file with sql command

[Former Member]

Hi,

When I am executing the below command in SQLPLUS I could not find trace files in /oracle/(sid)/sap trace/ user trace directory. The command is

>alter database backup control file to trace;

I have executed this command with (sid)adm and ora(sid) .

Our oracle version is 9.2.0.

Please help on this

Regards

Nani

[Former Member]

without additional parameters oracle will dump the trace information to this directory in a file with generated filename.

look at dir /s (on Windows) or ls -ltr for the file generated at the time you run the statement.

peter

[Former Member]

Hi Nani,

Look for it at <b>/oracle/.../sapreorg/</b> dir.

Regards,

JC Llanes.

[Former Member]

HI,

SQLPLUS /NOLOG

Sql> connect /as sysdba

sql>alter database backup controlfile to 'd:\backup_control.trc' ;

thats it . it will generate the trc in the above mentioned path

and for u prblm chkt the value of user dump test in init.ora

regards

Umesh K

[Former Member]

Hi

our OS is HP unix.db is oracle 9.2.0.I have executed the sql command fron sys user.

the parameter USER_DUMP_DEST=/oracle/(sid)/saptrace/usertrace.

I cannot fin the trace file in any directory.

Regards

Nani

[Former Member]

Hi,

Yes, you're right. The trace must be at /oracle/.../usertrace, and generated with orasid.

There's nothing into this directory? Can you check the dir. permissions?

When running this command there must be some lines at the alert file. Can you check it?

Regards,

JC Llanes.

[Former Member]

Hi

The file under /oracle/SDB/saptrace/usertrace showing below error

1. pg sdb_ora_24618.trc

/oracle/SDB/saptrace/usertrace/sdb_ora_24618.trc

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.7.0 - Production

ORACLE_HOME = /oracle/SDB/920_64

System name: HP-UX

Node name: sandbox

Release: B.11.23

Version: U

Machine: ia64

Instance name: SDB

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

24618

Ioctl ASYNC_CONFIG error, errno = 1

#

Regards

Nani

[Former Member]

Hi,

Please, can you answer the rest of my questions? Specially permissions and alert file traces.

Best Regards,

JC Llanes.