OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » pfile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pfile [message #58305]

Wed, 13 August 2003 09:45

M. Khaled
Messages: 67
Registered: April 2002

Member

STARTUP PFILE=..... IS USED TO STARTUP MY DATABASE.IF I USE STARTUP THEN THE OTHER PARAMETER FILE IS STARTED. HOW COULD I SOLVE THIS PROBLEM. I WANT TO WRITE ONLY STARTUP TO START MY PARAMETER FILE.

THANKS

Report message to a moderator

Re: pfile [message #58308 is a reply to message #58305]

Wed, 13 August 2003 10:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

startup pfile='complete_path_of_yourPFILE'

Report message to a moderator

Re: pfile [message #58313 is a reply to message #58305]

Wed, 13 August 2003 12:49

Satish Shrikhande
Messages: 167
Registered: October 2001

Senior Member

Copy the init.ora file to the Oracle_homedatabase directory where from oracle pick up the init.ora file

Report message to a moderator

Re: pfile [message #58318 is a reply to message #58305]

Wed, 13 August 2003 20:24

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hello,

if u r on windows box, open the regedit and go to the oracle section and set the oracle_sid to the sid name which u want to start when u say startup..

hth
sai

Report message to a moderator

Re: pfile [message #58321 is a reply to message #58308]

Thu, 14 August 2003 03:40

M. Khaled
Messages: 67
Registered: April 2002

Member

My oracle is in Linux environment.I tried writing
startup pfile='full path' but could not solve the problem.Next time again require as above.I want to write only startup....

THANKS...

Report message to a moderator

Re: pfile [message #58339 is a reply to message #58308]

Sat, 16 August 2003 00:09

orak
Messages: 3
Registered: August 2003

Junior Member

THANKS MAHESH ,FINALLY I SOLVED THE PROBLEM .

Report message to a moderator

Previous Topic:	Oracle database/instance question
Next Topic:	loss of a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:44:46 CDT 2024