Oracle site recently launched for vista version, can also be installed to windows7 above. I did not go out here and download for vista version, but with the previous version for xp to install.
Certainly can be installed successfully, there is the most widely used operation is in compatibility mode and run as administrator. This will ensure a smooth install. In installed, you can perform some black in the windows command. If you download for vista version, then you can directly open the black screen operation. If not, then best to use an administrator to open the black screen, or some commands can be executed. For example oradim command.
After installation is complete, we can install plsql plsql this popular development tools. Also in installed, also running as an administrator. Otherwise an error, but no error on the play a form, which have nothing.
After installation is complete, you can use dbca to build a database, configure the listener completed, you can use netca command to configure. Can also change the tnsname.ora file.
Is complete, start oracle, on my computer, management, service which can be seen as the oracle services.
windows following oracleService and TNSListerer two is a must start.
About oracleservice this service, the default is auto-started, it starts later, oracle database instance and also the corresponding started.
In the windows black screen below, you can perform shutdown immediate to close the database and routines. You can also perform
oradim-shutdown-sid mysid-shuttype srvc to close OracleService this service.
About this service, I understand that he represents the windows under the oracle instance and database.
For TNSListener this service, the default is automatically turned on, you can also use the windows black screen command lsnrctl stop / start / status to management
Start OracleOraDb10g_home1iSQL * Plus to use the service command
isqlplusctl start / stop
Start or stop the service using the command OracleDBConsoleora10gc
set oracle_sid = ora10gc
emctl start dbconsole
Introduced a simple form v $
1select * from v $ session: the link to view the current session.
2select * from V $ LOCKED_OBJECT
3kill session: alter system kill session 'sid, serival #' users need to have permission to alter system of systems