Home » RDBMS Server » Server Administration » init.ora file on Oracle 9.2
init.ora file on Oracle 9.2 [message #8913] Thu, 02 October 2003 19:46 Go to next message
Derren Seah
Messages: 6
Registered: September 2003
Junior Member
In Oracle versions 7 and 8 there was an init<sid>.ora file where I could modify system parameters, and when I stopped and restarted the database, it would run with the new parameters. How do I do this in Oracle version 9? I cannot find this file, and similiar looking files cannot be opened properly in notepad - I get control characters. Is it done differently in V9 ?

Report message to a moderator

Re: init.ora file on Oracle 9.2 [message #8917 is a reply to message #8913] Fri, 03 October 2003 06:19 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
by default in 9i the server uses the spfile< sid >.ora.
you can create a pfile from spfile and vice versa.
so look into documentation for usage of spfile.

Report message to a moderator

Previous Topic: partitioning not enabled
Next Topic: Big Trouble!! Pls. Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:24:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.