Notes for manual Oracle database creation

Delete the Oracle database first ~~

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter system enable restricted session;

SQL> drop database;

Start manual Oracle database creation

Vi. bash_profile

Source. bash_profile (it is second in comparison and will not take effect immediately after modification, so reload it ......)

Vi $ ORACLE_HOME/dbs/init $ ORACLE_SID.ora (create an initialization file)

Orapwd file = $ ORACLE_HOME/dbs/orapw $ ORACLE_SID password = 123456 force = y (create a password file)

Create spfile

SQL> startup nomount

SQL> create spfile from pfile;

Vi/home/oracle/createDB. SQL (Create a database)

SQL> @/home/oracle/createDB. SQL

SQL> @ $ ORACLE_HOME/rdbms/admin/catalog. SQL (create a data dictionary view)

SQL> @ $ ORACLE_HOME/rdbms/admin/catproc. SQL (create a stored procedure package)

Success!