| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to run the Trace file In oracle
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi Magesh,
Just replace the word REUSE with SET in the CREATE CONTROLFILE command. e.g the command shd look like:
CREATE CONTROLFILE set DATABASE "ORA8" RESETLOGS.........
HTH ,
Rajesh
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of magesh
Sent: Monday, August 28, 2000 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: How to run the Trace file In oracle
Hi Gopal,
Thanx for you suggestion .You are right i am trying to recreate the
control file.
While running the .sql file , i am getting errors like this ....
ORA-01503 : Create controlfile failed
ORA-01161 :database name ORCL in file header does not match given name
of ORA8.
ORA-01110 : datafile 1 : '/u01/oradata/ORCL/system01.dbf '
Actually ..I am trying to do renaming the oracle Instance of
development database.
from ORCL to ORA8 ,
Any suggestion please
Thanx
Magesh
Hi !
What trace file?
What do you want to do?
Are you trying to recreate the control file? If YES edit the trace file (remove the comments and save as .sql) and run from SVRMGR or SQL Plus
K Gopalakrishnan
Bangalore, INDIA
Hi all
I am started my database with nomount option , Now i want to run the Trace file , Any one help me , how to run the trace file.
Thanx
Magesh
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Dus-ascii">
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20class=3D341002010-28082000>Hi Magesh,</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20 class=3D341002010-28082000></SPAN></FONT> </DIV> <DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20 class=3D341002010-28082000> Just replace the = word REUSE=20
August 28, 2000 2:30 PM<BR><B>To:</B> Multiple recipients of list=20 ORACLE-L<BR><B>Subject:</B> Re: How to run the Trace file In=20 oracle<BR><BR></DIV></FONT><DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Hi Gopal,</FONT></DIV>
failed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ORA-01161 :database name ORCL =
in file=20
header does not match given name of ORA8.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ORA-01110 : datafile 1 :=20
'/u01/oradata/ORCL/system01.dbf '</FONT></DIV>
<DIV> </DIV>
<DIV> <FONT face=3DArial size=3D2>Actually ..I am trying to do =
renaming the=20
oracle Instance of development database.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>from ORCL to ORA8 , </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestion please</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanx</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Magesh</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; =
MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:kaygopal_at_yahoo.com" title=3Dkaygopal_at_yahoo.com>K=20
Gopalakrishnan</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:ORACLE-L_at_fatcity.com" =
title=3DORACLE-L_at_fatcity.com>Multiple=20
recipients of list ORACLE-L</A> </DIV> <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, August 28, = 2000 5:53=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: How to run the =
Trace file=20
In oracle</DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DArial size=3D2>Hi !</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>What trace file?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>What do you want to =
do?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Are you trying to recreate the =
control=20
file?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>If YES edit the trace file (remove =
the comments=20
and save as .sql)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and run from SVRMGR or SQL =
Plus</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>K Gopalakrishnan</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bangalore, INDIA</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- = </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:magesh_at_garoo.ne.jp" =
title=3Dmagesh_at_garoo.ne.jp>magesh</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:ORACLE-L_at_fatcity.com" =
title=3DORACLE-L_at_fatcity.com>Multiple=20
recipients of list ORACLE-L</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, August 28, =
2000 9:03=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> How to run the =
Trace file In=20
oracle</DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DArial size=3D2>Hi all</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2> I am started my =
database with=20
nomount option , Now i want to run the Trace file , Any one help =
me , how=20
to run the trace file.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanx </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Magesh</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
Received on Mon Aug 28 2000 - 05:18:53 CDT
 |
 |