The following is the procedure to mount a database.ġ. Syntax: STARTUP NOMOUNT PFILE = 'initORCL.ora' If the file in the Step 1 is not present then look for spfile.ora.Īnd if both files are not present then search for initORCL.ora that contains initialization parameters for the instance also specifying the PFILE parameter during startup and change the default behavior.Īlert_ORCL.log files and trace files are created. Look for the spfileORCL.ora that is present at $ORACLE_HOME/DB. Note: SID is the system identifier, by default it is ORCL. The instance startup includes the following steps. Only during the database creation, recreation of control files, backups and recovery. Let us see how it is done.ĭatabase instance startup in NOMOUNT mode Briefly, this can be done through the three modes NOMOUNT, MOUNT and OPEN. ORACLE_HOME=/u01/app/oracle/product/11.2.This article describes how to start up a shutdown database in Oracle 11g.Īssuming you have installed Oracle for the first time and are about to start the database instance. # Change the value of ORACLE_HOME to specify the correct Oracle home Change the value of the ORACLE environment variable to the user name of the owner of the database installed in the Oracle home directory (typically, oracle). These values specify that dbstart auto-starts the database only after the Automatic Storage Management instance is started.Ĭhange the value of the ORACLE_HOME environment variable to an Oracle home directory for the installation. To do this, you must change the oratab entry of the database and the Automatic Storage Management installation to use a third field with the value W and N, respectively. This is the default behavior for an Automatic Storage Management cluster. You can set dbstart to autostart a single-instance database that uses an Automatic Storage Management installation that is auto-started by Oracle Clusterware. Then, change the last field for each to Y. For each database for which you want to automate shutdown and startup, first determine the instance identifier (SID) for that database, which is identified by the SID in the first field. In this example, the values Y and N specify whether you want the scripts to start up or shut down the database, respectively. On AIX, HP-UX, and Linux: # vi /etc/oratabĭatabase entries in the oratab file are displayed in the following format: SID:ORACLE_HOME: To open the file, use one of the following commands: To automate database startup and shutdown by using the dbstart and dbshut scripts: Run the following command to start Oracle Management Agent: $ $ORACLE_HOME/agent/bin/emctl start agentĢ.2.1 Automating Database Startup and Shutdown on Other Operating Systems If required, set the ORACLE_HOME environment variable to specify the appropriate Oracle home directory for Oracle Management Agent: Run the following command to stop Oracle Management Agent: $ $ORACLE_HOME/agent/bin/emctl stop agent If required, set the ORACLE_HOME environment variable to specify the appropriate Oracle home directory for the Oracle Management Agent: ![]() The output of this command is similar to the following: 94248 ? I 0:00.18 oracle_home/agent/bin/emagent. This command displays information about the Oracle Management Agent processes. Run the following command to determine the Oracle home directory for Oracle Management Agent: $ ps -ef | grep emagent This section describes how to stop and start Oracle Management Agent. Typically, the Oracle Management Agent is installed in its own Oracle home directory. If you are using Oracle Enterprise Manager Grid Control to manage multiple Oracle products from a central location, then you must have an Oracle Management Agent installed on each host system. Run the following command to start the Database Control: $ $ORACLE_HOME/bin/emctl start dbconsoleĢ.1.4 Stopping and Starting Oracle Management Agent Set the ORACLE_SID and ORACLE_HOME environment variables to identify the SID and Oracle home directory for the database control that you want to start:īourne, Bash, or Korn shell: $ ORACLE_HOME= oracle_homeĬ shell: % setenv ORACLE_HOME oracle_home Starting Oracle Enterprise Manager Database Control Run the following command to stop the Database Control: $ $ORACLE_HOME/bin/emctl stop dbconsole To stop Oracle Enterprise Manager Database Control:ĭepending on the default shell, run the oraenv or coraenv script to set the environment for the database managed by the Database Control that you want to stop:Ĭoraenv script: % source /usr/local/bin/coraenv Stopping Oracle Enterprise Manager Database Control This section describes how to stop and start Oracle Enterprise Manager Database Control. 2.1.3 Stopping and Starting Oracle Enterprise Manager Database Control
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |