linux下启动oracle服务和监听程序（Start Oracle service and monitor program under Linux）.doc

linux下启动oracle服务和监听程序(Start Oracle service and monitor program under Linux)
Start Oracle service and monitor program under Linux
Classification: operating system
Oracle database is a heavyweight, and its management is plex, the Linux platform on the start and close steps to sort out.
After installing Oracle, you need to create Oracle system users and add several environment variables in /home/oracle : ORACLE_SID, ORACLE_BASE, ORACLE_HOME. For example:
Export ORACLE_SID=test export ORACLE_BASE=oracle_install_dir export ORACLE_HOME=xxx
Startup steps: note that $represents the mand prompt, where the Oracle is more than 9.
$Su - Oracle
$sqlplus /nolog
Sql> conn / as SYSDBA
Sql> startup (generally no need to add parameters, just set the environment variables)
Sql> quit (quit SQL mode)
$lsnrctl start (boot listener) closes Oracle
$lsnrctl stop (close the listener, before then, the application should be closed)
$sqlplus /nolog
Sql>shutdown its parameters: shutdown has four parameters, and the meaning of the four parameters is as follows:
Normal needs to wait for all users to disconnect
Immediate waits for the user plete the current statement
Transactional waits for the user plete the current transaction
Abort doesn't do any waiting and closes the database directly
Normal needs to shut down database tasks until all of the connection users are disconnected, so sometimes it looks as if mand is not running! No new connection is allowed after mand is executed
Immediate disconnects user connections after the user has executed the executed statements, and does not allow new users to connect.
Transactional does not allow new users to connect to the database after supporting the execution of the current thing.
Abort performs a forced disconnection and closes the database directly.
The first three methods do not lose user data. The fourth is not mended in the absence of the case!
Frequently encountered problems:
1) permissions issues, solu