RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
My guess is that a binary SPFILE is expected to look the same whether it is a Raw Device [non-CFS RAC] or on a File System [CFS RAC or Single Instance database]. You should be able to do a dd of the SPFILE to move it between Raw and FileSystems. Thus you can take the SPFILE of a non-CFS RAC and plug it directly into use for CFS RAC or Single Database Instance. Hemant At 06:44 AM 17-07-03 -0800, you wrote: I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
SPFILE is instance specific, modified by alter system, not by alter database. That means that RAC doesn't affect it. You can try with raw device for the pfile, if you can do something like vi /dev/rdsk/c0d1s2 (I hate [EMAIL PROTECTED] Emacs). If you can, please let me know which system allows that. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, July 18, 2003 11:15 AM To: Multiple recipients of list ORACLE-L My guess is that a binary SPFILE is expected to look the same whether it is a Raw Device [non-CFS RAC] or on a File System [CFS RAC or Single Instance database]. You should be able to do a dd of the SPFILE to move it between Raw and FileSystems. Thus you can take the SPFILE of a non-CFS RAC and plug it directly into use for CFS RAC or Single Database Instance. Hemant At 06:44 AM 17-07-03 -0800, you wrote: I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE Our spfile is shared by all instances in the RAC ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 18, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE SPFILE is instance specific, modified by alter system, not by alter database. That means that RAC doesn't affect it. You can try with raw device for the pfile, if you can do something like vi /dev/rdsk/c0d1s2 (I hate [EMAIL PROTECTED] Emacs). If you can, please let me know which system allows that. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
Title: Message one spfile for all instances. you use alter system but there is a sid= parameter that allows for instance granularity. For example, to affect all instances: alter system set db_cache_size = 500m scope=both sid=*; or to affect one: alter system set db_cache_size = 500m scope=both sid=instance_1; You can also specify a list of instances. If you don't specify any sid, then I believe it affects instance you're connected to only. Gerardo -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE Our spfile is shared by all instances in the RAC ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 18, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE SPFILE is instance specific, modified by "alter system", not by "alter database". That means that RAC doesn't affect it. You can try with raw device for the pfile, if you can do something like "vi /dev/rdsk/c0d1s2" (I hate [EMAIL PROTECTED] Emacs). If you can, please let me know which system allows that. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED]
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
Title: Message We never have specified sid= option ... because we always use spfile. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Molina, Gerardo [mailto:[EMAIL PROTECTED]Sent: Friday, July 18, 2003 12:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE one spfile for all instances. you use alter system but there is a sid= parameter that allows for instance granularity. For example, to affect all instances: alter system set db_cache_size = 500m scope=both sid=*; or to affect one: alter system set db_cache_size = 500m scope=both sid=instance_1; You can also specify a list of instances. If you don't specify any sid, then I believe it affects instance you're connected to only. Gerardo -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE Our spfile is shared by all instances in the RAC ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 18, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE SPFILE is instance specific, modified by "alter system", not by "alter database". That means that RAC doesn't affect it. You can try with raw device for the pfile, if you can do something like "vi /dev/rdsk/c0d1s2" (I hate [EMAIL PROTECTED] Emacs). If you can, please let me know which system allows that. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)
Roy, I imagine its so that it can only be changed by someone who is validated against the database with the correct permissions. Kind Regards, Adrian -Original Message- Sent: 16 July 2003 23:40 To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, July 16, 2003 3:00 PM To: Multiple recipients of list ORACLE-L This can be solved by creating the PFILE again from the SPFILE; and this doesn't need the instance to be up. However, you did drive the nail home, Niall, with this example. Part of the problem could be avoided by restricting the ALTER SYSTEM, SYSDBA or SYSOPER privileges; but in a large shop with a lot of production support DBAS!! Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:59 PM Not only that but this sort of thing should be avoidable. SQL alter system set db_cache_size=10m scope=both; System altered. time passes SQL alter system set db_block_buffers=1000 scope=spfile; System altered. SQL shutdown; Database closed. Database dismounted. ORACLE instance shut down. SQL startup ORA-00381: cannot use both new and old parameters for buffer cache size specific ation SQL What do you do if you didn't have an old fashioned text file? I'd also like to know how spfile changes get documented, it scares me enough that someone can change parameters on the fly, let alone that that can be done without comment or recording who did it. I'll admit thugh that this last is actually a failure of management and not technology. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arup Nanda Sent: 16 July 2003 06:09 To: Multiple recipients of list ORACLE-L Subject: Re: How to make SPFILE in sync with INIT.ORA ? Dennis, My understanding is that Oracle felt if it was going to be a 24x7x365 database, it had to have more parameters that could be changed online I couldn't agree more. 9i had more parameters that can be changed online; hope there are more in line. it doesn't make sense to rely on the DBA to remember to also update the init.ora file. You should be able to just make the change once. Absolutely. That's the point I was trying to raise. Oracle did provide the spfile route to make _persistent_ changes on the fly, but for only those parameters that can be changed through alter system set ... The problem was there is a different file that needs to be updated when making those other parameter changes. There should be only one place to change - hopefully spfile - either through the alter system command or othe editing. This editing could be done through a GUI interface, too, if needed; although, call me old-fashioned (and I am old, anyway, at least in IT timeline), personally I prefer the vi editor. And this is not an impossible idea. I gave the example of the listener.ora file. It can be edited (so old fashioned), through the lsntctl SAVE_CONFIG command (so spfile-like) or through Net Assistant (so GUI-friendly). The end result is the same - one file - regardless of how you modify a parameter. The same approach could have been done in pfile-spfile case. I think with the pfile and spfile, Oracle was trying to give us the best of both worlds. Hmm! You think so? I think they just gave us a half-cooked hair-brained split-pea honey-mustard-ketchup-coated germ of a solution - sort of like Oracle 6 _without_ the Transaction Processing Option, if anyone remembers that. After you wipe off all those condiments, you find a Dr. Jekyll Mr. Hyde parameter file(s)! Regards, Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 12:24 AM Arup My understanding is that Oracle felt if it was going to be a 24x7x365 database, it had to have more parameters that could be changed online. Some parameters were made changeable in Oracle9i, with hints of more to come. If the future is online changes, it doesn't make sense to rely on the DBA to remember to also update the init.ora file. You should be able to just make the change once. Also, there is a new generation of I.S. people coming along that doesn't think you can operate a
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: it isn't binary on solaris ... pure text ... Raj -Original Message- Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it. Kirtikumar DeshpandeTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kirtikumar_desh cc: pandeSubject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in @yahoo.com Sent by: ml-errors 07/16/2003 11:24 PM Please respond to ORACLE-L Keeping them binary gives them power I guses... On most platforms there is just a hashed value on the first line. In 9i R1 (9.0.1), I was able to replace some param value without changing number of chars on the line, and the changes were taken without any problem (HP-UX 11, it was I think). Could not believe that it worked. No such luck in 9i R2... Binary, text, whatever, I will just stay away from him till pfile really goes away :) - Kirti --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: it isn't binary on solaris ... pure text ... Raj -Original Message- Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Hey, don't blame oracle for that ... did you complain to Microsoft when they created that Registry hive cr*p ?? Oracle is stepping on the same line ... Lemmings ... g Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Questin is why do you want to mess with it? That's not exactly my idea of fun ... I'd still use alter system, alter database commands to change whatever. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Why would you want to do that? You can always re-create the file from your PFILE. Oracle should have encrypted it. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L in That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Editing spfile is not supported by Oracle. And I think it is documented as such. You can just view it, copy it and play with the copied version what whatever... One thing to remeber is to always hold on to the init.ora version. No matter what. Or at least until Oracle completely removes init.ora file when the Oracle RDBMS software becomes smarter than human brain ;) - Kirti -Original Message- Sent: Thursday, July 17, 2003 10:54 AM To: Multiple recipients of list ORACLE-L in My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Of course you are right that no one should use it as the right way to change parameters. I will admit playing with binary file some times is my idea of fun. Hey, you never know, you might learn something from it. To see the data structure gives me idea of how things work. And it might come in handy some day in a recovery situation. Best regards Richard Ji -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in Questin is why do you want to mess with it? That's not exactly my idea of fun ... I'd still use alter system, alter database commands to change whatever. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 17, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in That's a good point. Someone should try a binary editor instead, like bvi and see what happens. -Original Message- Sent: Thursday, July 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L in I wonder if it is something built into the file or something that vi (or whatever editor you are using) does to the file when you save it. I say that because, if you edit the text part of an export file with vi, you get an unusable file. But the text part of an export file can be edited by other means and it will work -- for example, by running it through a C or Perl program and editing the stream as it flows through the program; and I think, if the export file is not too big ( 2 gig I think ) emacs (with certain options??) can be used. The official word in the 9i new features class at the ivory tower in Colorado Springs is that all the new features are wonderful, and you should be using them. -Original Message- it's a fake sort of binary -- try editing it with vi and then try opening your database with the spfile... but first make an init.ora copy of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?) it isn't binary on solaris ... pure text ... Raj -Original Message- From: Pardee, Roy E [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L Subject: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?) Not true; it's binary, on both Solaris 8 and 9. By the most of the file (regardless of the OS) is still text; the non-ascii chars are present at the beginning of the file. Arup Nanda - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 10:44 PM Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in it isn't binary on solaris ... pure text ... Raj -Original Message- From: Pardee, Roy E [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L Subject: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy
RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in
Keeping them binary gives them power I guses... On most platforms there is just a hashed value on the first line. In 9i R1 (9.0.1), I was able to replace some param value without changing number of chars on the line, and the changes were taken without any problem (HP-UX 11, it was I think). Could not believe that it worked. No such luck in 9i R2... Binary, text, whatever, I will just stay away from him till pfile really goes away :) - Kirti --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: it isn't binary on solaris ... pure text ... Raj -Original Message- Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles. But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead? Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
