SQL> shutdownĭuring immediate shutdown, before the oracle database is shut down, oracle will rollback active transaction and disconnect all active users. As the parameter name (normal) suggest, use this option to shutdown the database under normal conditions.
ORACLE 10G DATABASE HOW TO
SQL> STARTUP PFILE=/u01/app/oracle/product/10.2.0/dbs/init.ora How To Shutdown Oracle Databaseįollowing three methods are available to shutdown the oracle database:ĭuring normal shutdown, before the oracle database is shut down, oracle will wait for all active users to disconnect their sessions. If you want to startup Oracle with PFILE, pass it as a parameter as shown below. Type “startup” at the SQL command prompt to startup the database as shown below. If any one of them exist, it will use that particular parameter file. Oracle will look for the parameter file in the following order under $ORACLE_HOME/dbs. Oracle will use this SPFILE during startup, if you don’t specify PFILE. The default SPFILE (server parameter file) is located under $ORACLE_HOME/dbs. With the Partitioning and Data Mining options Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production You can connect using either “/ as sysdba” or an oracle account that has DBA privilege. Make sure ORACLE_SID and ORACLE_HOME are set properly as shown below. On Linux, do su to oracle as shown below. Typical oracle installation will have oracle as username and dba as group. In this article, let us review how to start and stop an oracle database.
So, it is important for non-DBAs to understand some basic database administration activities. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. For a DBA, starting up and shutting down of oracle database is a routine and basic operation.
0 kommentar(er)
