init.ora file location

[OracleDoc]

I'd rather start my database by using STARTUP instead of the 3 commands:STARTUP NOMOUNT PFILE=..., ALTER DATABASE MOUNT, ALTER DATABASE OPEN.

Where in the hell did you come up with that?

You people really need to sit down and read the manual.

[reydp]

Originally posted by OracleDoc
Where in the hell did you come up with that?

You people really need to sit down and read the manual.

I could probably be wrong but isn't it with the case of 9i?
you have the option to create an spfile.ora which is basically derive from init.ora?

[OracleDoc]

Originally posted by reydp
I could probably be wrong but isn't it with the case of 9i?
you have the option to create an spfile.ora which is basically derive from init.ora?

You guys are purposely doing this in an effort to spin me up aren't you? Come on tell me the truth.

[reydp]

Originally posted by OracleDoc
You guys are purposely doing this in an effort to spin me up aren't you? Come on tell me the truth.

no( ) really...
that is what as far as I can remember, my production DBs right now are 8is( boring... )... we're still on the stage of planning to migrate to 10g.

[OracleDoc]

You know this is pretty good comedy between this thread and that Ora-600 thread, the office is getting a pretty good chuckle out of this.

Ok look (Reydp) there is no spfile in 8i only in 9i and above. At the command prompt when the database is down you type in create spfile from pfile. Once that spfile is created Oracle will automatically use that instead of the init.ora. Therefore making it possible to change things dynamically.

[reydp]

Originally posted by OracleDoc
You know this is pretty good comedy between this thread and that Ora-600 thread, the office is getting a pretty good chuckle out of this.

Ok look (Reydp) there is no spfile in 8i only in 9i and above. At the command prompt when the database is down you type in create spfile from pfile. Once that spfile is created Oracle will automatically use that instead of the init.ora. Therefore making it possible to change things dynamically.

The original poster(ptrieves) originally ask the init.ora file for his 9i db because he have something to alter one/more of the parameters. Even if he can successfully start the db with the new init.ora file, he could be wondering later-on when he stops and starts the db if the init.ora that he made take effect. That is why I did advancely inform him to create spfile.
I was not talking about the dynamic parameters that could be change even the db is alive.

[reydp]

Originally posted by OracleDoc
You know this is pretty good comedy between this thread and that Ora-600 thread, the office is getting a pretty good chuckle out of this.

At the command prompt when the database is down you type in create spfile from pfile.

you can only create spfile when db is up.

[DaPi]

Originally posted by reydp
I'd rather start my database by using STARTUP instead of the 3 commands:STARTUP NOMOUNT PFILE=..., ALTER DATABASE MOUNT, ALTER DATABASE OPEN.

Now, if you're paid by line of code . . .

[OracleDoc]

Originally posted by reydp
you can only create spfile when db is up.

Wanna bet?

[reydp]

Originally posted by DaPi
Now, if you're paid by line of code . . .

Though I'm only paid(monthly) probably equivalent to what you recieve daily(or maybe even less), I still made my works easy..

you are urging me to say this Dapi aren't you?