create a database steps

tthero00boo發表於2013-11-19
Database






 






1.     ORACLE_SID=test




       export ORACLE_SID











       env | grep ORA











2.     orapwd FILE=$ORACLE_HOME/dbs/orapwtest password=asdjkl ENTRIES=10 force=y











3.     Create the Initialization Parameter File




        cd $ORACLE_HOME/dbs




        cat init.ora |grep -v ^# > ./inittest.ora




        vi inittest.ora




     change DB_NAME, CONTROL_FILES,MEMORY_TARGET











4.     copy  Step 9: Issue the CREATE DATABASE Statement




       There are 2 parameters need to be changed ( db_name , undotbs_name base on init.ora)




       also you can adjust your datafile location











5      sqlplus / as sysdba




       startup nomount




       execute create_db script











6.     @?/rdbms/admin/catalog.sql




       @?/rdbms/admin/catproc.sql




       conn system/system_passwd




       @?/sqlplus/admin/pupbld.sql




       EXIT




    







來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28859270/viewspace-776973/，如需轉載，請註明出處，否則將追究法律責任。







相關文章