手工创建数据库步骤:
Step 1: Specify an Instance Identifier (SID)
Step 2: Ensure That the Required Environment Variables Are Set
Step 3: Choose a Database Administrator Authentication Method
Step 4: Create the Initialization Parameter File
Step 5: (Windows Only) Create an Instance
Step 6: Connect to the Instance
Step 7: Create a Server Parameter File
Step 8: Start the Instance
Step 9: Issue the CREATE DATABASE Statement
Step 10: Create Additional Tablespaces
Step 11: Run Scripts to Build Data Dictionary Views
Step 12: (Optional) Run Scripts to Install Additional Options
Step 13: Back Up the Database.
Step 14: (Optional) Enable Automatic Instance Startup
Step 1: Specify an Instance Identifier (SID)
先确认一个唯一的sid
export ORACLE_SID=myoracle
Step 2: Ensure That the Required Environment Variables Are Set
设置环境变量
su - oracle
vi .bash_profile
添加对应的环境变量(主要是ORACLE_BASE,ORACLE_HOME ,sid也要以在这设置)
PATH= PATH: HOME/bin
export PATH
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME= ORACLE