Message-Id: <10602.115630@fatcity.com> From: Rajesh Dayal Date: Mon, 28 Aug 2000 14:18:53 +0400 Subject: 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. ------ =_NextPart_001_01C010D9.5E4234DE Content-Type: text/plain; charset="iso-2022-jp" 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@fatcity.com [mailto:root@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 ----- 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_001_01C010D9.5E4234DE Content-Type: text/html; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable

Hi Magesh,

Just replace the = word REUSE=20 with SET in the CREATE CONTROLFILE

command. e.g the command shd look=20 like:

CREATE CONTROLFILE set DATABASE "ORA8"=20 RESETLOGS.........

HTH ,

Rajesh

-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of magesh
Sent: = Monday,=20 August 28, 2000 2:30 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: Re: How to run the Trace file In=20 oracle

Hi Gopal,

Thanx for you suggestion .You = are=20 right i am trying to recreate the control file.

While running the .sql = file , i am=20 getting errors like this ....

ORA-01503 : Create controlfile = failed

ORA-01161 :database name ORCL = in file=20 header 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=20 recipients of list ORACLE-L

Sent: Monday, August 28, = 2000 5:53=20 PM

Subject: Re: How to run the = Trace file=20 In 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=20 to run the trace file.

Thanx

Magesh