Oracle 9i Database For Windows 7
Initialization Parameter File OverviewAn is an ASCII text file containing parameters. By changing parameters and values in an initialization parameter file, you can specify, for example:.Amount of memory Oracle Database uses.Whether to archive filled online redo logs.Which currently existEvery database instance has a corresponding initialization parameter file and an ORACLESID parameter that points to the for the instance.The initialization parameter filename takes the form init.ora. A single instance might have several initialization parameter files, each having some differences that affect system performance.
Database Configuration Assistant Renames init.oraWhen you create a database using Database Configuration Assistant, a Server Parameter File (SPFILE) is created from the initialization parameter file, and the initialization parameter file is renamed. Oracle does not recognize the renamed file as an initialization parameter file, and it is not used after the instance is started.If you want to modify an instance created with Database Configuration Assistant after it starts up, you must use ALTER SYSTEM statements. You cannot change the Server Parameter File itself, because it is a binary file that cannot be browsed or edited using a text editor. The location of the newly-created Server Parameter File is ORACLEBASE ORACLEHOME database. The Server Parameter File filename is spfile SID.ora.
Oracle 9i Client Download
Sample FileOracle Database provides an annotated sample initialization parameter file with alternative values for initialization parameters. These values and annotations are preceded by comment signs ( #), which prevent them from being processed.
To activate a particular parameter, remove the preceding # sign. To de-activate a particular parameter, edit the initialization parameter file to add a comment sign. The sample file is called initsmpl.ora. And is located in ORACLEBASE ORACLEHOMEadminsamplepfile.If you installed a, the initialization parameter file used by the starter database is located in the same directory. You can use either initsmpl.ora or the starter database init.ora as a basis for creating a new Oracle Database initialization parameter file.To use sample file initsmpl.ora as part of database creation:.Rename the sample file init.ora.Edit this file to reflect the correct location of your database control files and the name of your database, as a minimum.Here are two examples of activation and de-activation of alternative parameters.
Outlook Express For Windows 7
Several initialization parameters are specified with three different values to create a small, medium, or large, respectively. The parameter that creates a small SGA is active in this first example:dbblockbuffers = 200 # SMALL# dbblockbuffers = 550 # MEDIUM# dbblockbuffers = 3200 # LARGETo create a medium-sized SGA, comment out the small parameter definition and activate the medium parameter definition. Edit the initialization parameter file as in this second example:# dbblockbuffers = 200 # SMALLdbblockbuffers = 550 # MEDIUM# dbblockbuffers = 3200 # LARGE. SGAMAXSIZE ParameterParameter SGAMAXSIZE holds the maximum size that System Global Area (SGA) can reach for a particular instance. Beginning with Oracle9 i release 1 (9.0.1), Oracle Database can change its SGA configuration while the instance is running.
This allows sizes of buffer cache, shared pool, and large pool to be changed without instance shutdown.Oracle Database can start instances underconfigured and allow the instance to use more memory by growing SGA up to a maximum of SGAMAXSIZE. If no SGAMAXSIZE value is specified, then Oracle Database selects a default value that is the sum of all components specified or defaulted at initialization time.
If SGAMAXSIZE specified in the initialization parameter file is less than the sum of all components specified or defaulted to at initialization time, then the setting of SGAMAXSIZE in the initialization parameter file serves as an upper bound. Table 14-2 Uneditable Database Initialization Parameters ParameterDescriptionCHARACTER SETSpecifies database character set to use. This parameter can be set only when you create the database.DBBLOCKSIZESpecifies size in bytes of standard Oracle Database blocks.DBNAMESpecifies name of the database to be created. Database name is a string of eight characters or less. You cannot change the name of a database.NoteNot an initialization parameter, but rather a clause in the CREATE DATABASE statement. See for an example of using this clause.
Oracle 9i won't install on Windows 7 or Vista - especially if its 64-bit.It's not compatible and will fail the pre-req checks every time. You haveto go to at least 10g to get Oracle to install on Windows 7. I have heardof some people hacking the installer to get it to work, but I'm not going torecommend it, as you won't have support and you'll run into more problemsthan you solve.Also, don't use this as a production system.
IMHO, it is a huge mistake totry and run a production instance on a workstation OS like Windows XP orWindows 7. It is worth it to get good hardware and a server OS. If you absolutely need to use Oracle 9i (though, as others have pointed out, you should go with 10g at the very least, if not 11g), and you have the Windows 7 Professional version (not Home edition), you can download & install from Microsoft the following two programs: Virtual PC and Windows XP Mode (there is also an update to Windows XP Mode to download and install).Install Virtual PC, then Windows XP Mode and the update. This will then create a virtual PC on your Windows 7 system, allowing you to open and install Oracle 9i (or 10g) inside that virtual PC. I recently did this for a different program that was not Windows 7 compatible (and I didn't want to pay $100/year to get the newest version, for something I use once a week or so), and it works great.
I would think Oracle would run fine in that environment as well, as it simulates a real Windows XP Pro system.