Message-Id: <10602.115628@fatcity.com> From: "magesh" Date: Mon, 28 Aug 2000 18:26:26 +0900 Subject: Re: How to run the Trace file In oracle 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
Hi Gopal,
 
Thanx for you  suggestion .You are = right =20 i am trying to recreate the control file.
While running the  .sql file = , i am=20 getting errors like this ....
 
ORA-01503  : Create controlfile=20 failed
ORA-01161  :database name ORCL in = file header=20 does not match given name of ORA8.
ORA-01110 : datafile 1 :=20 '/u01/oradata/ORCL/system01.dbf '
 
 Actually ..I am trying to do = renaming the=20 oracle Instance of development database.
from ORCL to ORA8 ,
 
Any suggestion please
 
Thanx
Magesh
 
 
----- Original Message -----
From:=20 K=20 Gopalakrishnan
To: Multiple recipients of list ORACLE-L =
Sent: Monday, August 28, 2000 = 5:53=20 PM
Subject: Re: How to run the = Trace file In=20 oracle

Hi !
 
What trace file?
What do you want to do?
 
Are you trying to recreate the = control=20 file?
If YES edit the trace file (remove = the comments=20 and save as .sql)
and run from SVRMGR or SQL = Plus
 
 
K Gopalakrishnan
Bangalore, INDIA
 
----- Original Message -----
From:=20 magesh=20
To: Multiple=20 recipients of list ORACLE-L
Sent: Monday, August 28, 2000 = 9:03=20 AM
Subject: How to run the Trace = file In=20 oracle

Hi all
 
   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.
 
Thanx
Magesh