OraFAQ Forum: Server Utilities » Modifying the init.ora file whilst the db is up.

Home » RDBMS Server » Server Utilities » Modifying the init.ora file whilst the db is up.

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

Modifying the init.ora file whilst the db is up. [message #71615]

Tue, 03 December 2002 10:23

James McDougall
Messages: 1
Registered: December 2002

Junior Member

Hello,

Can anyone help me? I need to update the processes parameter in the init.ora file. Can this be done without shutting down the db and manually editing the ora file?

Thanks in advance

James

Report message to a moderator

Re: Modifying the init.ora file whilst the db is up. [message #71622 is a reply to message #71615]

Wed, 04 December 2002 19:22

Helena
Messages: 42
Registered: February 2002

Member

When ever you need to touch the init.ora always oracle needs to be re started in order for those changes to be affective. Hope this helps

Helena

Report message to a moderator

Re: Modifying the init.ora file whilst the db is up. [message #71624 is a reply to message #71615]

Thu, 05 December 2002 03:36

B
Messages: 327
Registered: August 1999

Senior Member

No U can't ... U must shut and restart DB ....

Report message to a moderator

Re: Modifying the init.ora file whilst the db is up. [message #71632 is a reply to message #71615]

Fri, 06 December 2002 08:21

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

Senior Member
Account Moderator

There are CERTAIN init.ora parameters that can be changed dynamically. But NOT ALL.
And i beleive, PROCESSES is one of them

Report message to a moderator

Re: Modifying the init.ora file whilst the db is up. [message #71641 is a reply to message #71622]

Sun, 08 December 2002 12:47

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

I have learnt from some where that in oracle 9i u need not restart the Db after the modifications in init.ora
is it true?

sai

Report message to a moderator

Re: Modifying the init.ora file whilst the db is up. [message #71648 is a reply to message #71622]

Mon, 09 December 2002 12:19

mimi
Messages: 11
Registered: August 2000

Junior Member

If you use oracle 9i, you can do this. Alter........
Scope = Both.
This means, the change with take place both in the current session and the SPFILE level. Spfile is the binary version of init.ora

Report message to a moderator

Previous Topic:	Multiple sql loaders at a time.
Next Topic:	SqlLoader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 21:45:16 CST 2025