Manually start an Oracle database instance __python
Source: Internet
Author: User
Manually start an ORACLE database instance assume that the instance name ORCL first export the environment variable in the configuration file or set ORACLE_SID=ORCL sqlplus Sys/password as Sysdba sql>startup; The startup command reads the Initorcl.ora file in the $oracle_home/dbs directory, which has some parameters configured for that database, if the instance of the database is named Test, then the corresponding profile is Inittest.ora If the configuration file does not exist in the directory, you can copy it according to the Init.ora in the directory, and then find the Db_name=default line, change the DEFAULT to the name of the database you want, and the name that ORACLE_SID represents. May be prompted shared_pool_size enough, you can modify the value of this parameter to close sql>shutdown;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service