Re: How to run the Trace file In oracle

From: magesh <magesh_at_garoo.ne.jp>
Date: Mon, 28 Aug 2000 18:26:26 +0900
Message-Id: <10602.115628@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0013_01C0111D.79D1F2E0 Content-Type: text/plain;

charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit

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

Original Message ----- From: K Gopalakrishnan To: Multiple recipients of list ORACLE-L Sent: Monday, August 28, 2000 5:53 PM Subject: Re: How to run the Trace file In oracle

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

Original Message ----- From: magesh To: Multiple recipients of list ORACLE-L Sent: Monday, August 28, 2000 9:03 AM Subject: How to run the Trace file In oracle

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

------=_NextPart_000_0013_01C0111D.79D1F2E0 Content-Type: text/html;

charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-2022-jp" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Gopal,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanx for you  suggestion .You are =
right =20
i am trying to recreate the control file.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>While running the  .sql file =
, i am=20
getting errors like this ....</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>ORA-01503  : Create controlfile=20
failed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ORA-01161  :database name ORCL in =
file header=20
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 = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple 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 In=20
  oracle</DIV>

  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>Hi !</FONT></DIV>
  <DIV>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>K Gopalakrishnan</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>Bangalore, INDIA</FONT></DIV>
  <DIV>&nbsp;</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: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>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; I am started my =

database with=20

nomount option , Now i want to run the Trace file , Any one help me = , how to=20

run the trace file.</FONT></DIV>

    <DIV>&nbsp;</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>&nbsp;</DIV>
    <DIV>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

Received on Mon Aug 28 2000 - 04:26:26 CDT