oracle10g Usage Summary (i) Oracle installation ____oracle

First, installation oracle10g (hereinafter refers to oracle10g)
Most of the time Oracle installation is a headache, confusedly installed, the results can not be used, and then unloaded load loaded to install to feel the effect is getting worse, this may be a lot of students just started to use Oracle when the situation encountered.
In my experience, the following rules should be followed during installation and configuration of Oracle:
1, before installation, set up virtual memory, because in the installation process will be a lot of reading from memory files, if the virtual memory is not enough to cause some files do not copy success, it is too deficient. --Virtual memory settings method please refer to other documents ^_^
2, before installation, first find a disk with enough space, at least 3g of the remaining space, because after the installed, this location will also be used to store data.
3, remember to install the first step to let you choose the installation path, remember the global database name (if you change the more to remember), remember the SYS, system, Sysman password, we repeat two times the password is these users into the database management password. Note that the password as far as possible in English, why I also step to know, anyway, the effect is better.
4, you can always next down in the middle do not modify what, to a certain step of a user lock and password management, do not care about him. SYS, system, Sysman are not locked, and their passwords are all set up in the first step, just click OK. Next, wait for the installation to complete.
5, if there are errors or warnings in the middle, please do not panicked, with notes down, remember neat, complete, and so on after the completion of the solution. Because a lot of things can be reconfigured.
6, the entire installation process, do not open too many programs, because this thing will occupy a large amount of memory, if the memory is not enough or cause read and write confusion, the responsibility of the ego oh.
7, if you do not have the means to reload, please uninstall the software, delete all the files in the installation directory, clear the registry about Oracle, and then install ...
Second, after the installation is completed
After the installation is complete, do not pipe The jump out of the page (console), we can test ourselves:
1, NT services will be more out of several items:
(1) oraclrcsservice--
(2) Oracledbconsole***--oracle's console, * * refers to the SID.
(3) oraclejobscheduler***--Task Scheduler. Ditto.
(4) oracleoradb10g_home1isql*plus--provides an environment for editing, running SQL and Pl/sql, and providing an environment to interact with the database.
(5) oraclesnmppeermasteragent--Simple Network Management Protocol (easy Network Management PROTOCOL,SNMP), it is a standard Internet protocol.
(6) oraclesnmppeerencapsulator--This service requires a wrapper (Encapsulator) only if more than one SNMP deputy agent is configured and installed in the system.
(7) oracleoradb10g_home1tnslistener--Network Listener. Note: The service must be started before the user can connect to the database, but its shutdown does not affect the use of the database by users who have established a connection between the client and the database. If there is a connection problem, it is generally related to it.
(8) oracleservice***--Of course, this is the most basic service.

2, our program will also come out a lot of things, start--"all procedures-" oracle***, there are four main items
(1) Applicationdevelopment (application development), which includes a. NET,OLE,ODBC development document, the average person can not look ^_^
(2) Configuaration and migration tools--This is important and is a number of configuration and migration tools:
Administration Assistant for Windows, the Windows Oracle Management Assistant, this is a good point to see;
DB Configuaration Assistant, is the database configuration tool, inside I don't say, in short very good very important, we will also experience the installation of the database configuration, if the failure, here can be again, again n times;
Databaseupgradeassistant, this is used to upgrade the version;
Localebuilder, local settings, where you can set the character set, month, information, and so not much useful things;
MICROSOFTODBCADMINISTRATOR,ODBC data Source Manager, with data source, this very useful, but the time is not much;
NET Configuration Assistant, which can be used for listener configuration, named method configuration, local NET service name configuration, and so on.
NET Manager, which allows you to configure your network, such as the configuration of the database identification service, the naming method configuration, and the creation and configuration of listeners. The tool and net Configuration Assistant are the primary tools for network connection configuration.
(3) Integrated management of integrated management
(4) About unloading, not much to say.

3, of course, there are many things in the registry, the installation directory appears a lot of things, these we do not elaborate, use the time to mention.