[oracle@HE3 ~]美元vi . bash_profile
exportPATH exportEDITOR=六世 exportORACLE_SID=orcl exportORACLE_BASE=/u01/app/oracle exportORACLE_HOME=$ ORACLE_BASE/产品/11.2.0/dbhome_1 exportnls_date_format=" yyyy-mm-dd hh34: mi: ss” exportPATH=/u01/app/oracle/产品/11.2.0/dbhome_1/bin:美元的道路 exportLD_LIBRARY_PATH=$ ORACLE_HOME/lib:/usr/lib # aliassqlplus=' rlwrap sqlplus ' # aliasrman=' rlwrap rman ' exportNLS_LANG=AMERICAN_AMERICA。ZHS16GBK
[oracle@HE3 ~] $ source . bash_profile
[oracle@HE3 ~] $ cd $ ORACLE_HOME/dbs
[oracle@HE3dbs] $ ls
hc_orcl.dat init.ora initorcl.ora lkORCL
[oracle@HE3dbs]美元orapwd文件=orapwdorcl密码=甲骨文条目=30
[oracle@HE3dbs] $ ls
hc_orcl.dat init.ora initorcl.ora lkORCL orapwdorcl
diagnostic_dest='/u01/app/oracle ' , db_name=' orcl ' , memory_target=512 , 过程=150 , audit_file_dest='/u01/app/oracle/admin/orcl/adump” , audit_trail=笆菘狻? , db_block_size=8192 , db_domain=" , db_recovery_file_dest='/u01/app/oracle/flash_recovery_area” , db_recovery_file_dest_size=512 , diagnostic_dest='/u01/app/oracle ' , 判断=300 , remote_login_passwordfile=岸兰摇? , undo_tablespace=' UNDOTBS1 ' , control_files=(/u01/app/oracle/oradata/orcl/control01.ctl/u01/app/oracle/oradata/orcl/control02.ctl) , 兼容=' 11.2.0 '
[oracle@HE3dbs]美元mkdir - p/u01/app/oracle/admin/orcl/adump/
[oracle@HE3dbs]美元mkdir - p/u01/app/oracle/flash_recovery_area
[oracle@HE3dbs]美元mkdir - p/u01/app/oracle/oradata orcl
[oracle@HE3dbs] $ ls
hc_orcl.dat init.ora initorcl.ora lkORCL orapwdorcl
[oracle@ENMOEDU ENMOEDU],美元sqlplus /, as sysdba
,
SQL * +:, Release 11.2.0.3.0 Production 提醒Mon Feb 10, 00:39:10 2014年
,
Copyright (c), 1982年,2011年,甲骨文只All rights 保留。
,
,
Connected :
Oracle Database 11 g Enterprise Edition Release 11.2.0.3.0 作用;生产
With 从而分区,,OLAP,, Data Mining 以及Real Application Testing 选择
完成,startup nomount
Oracle instance 开始。
,
Total System Global Area 1071333376,字节
Fixed Size ,,,,,,,,,,,,,,,,, 1349732,
字节Variable Size ,,,,,,,,,,,, 620758940,
字节Database Buffers ,,,,,,,,, 444596224,
字节Redo Buffers ,,,,,,,,,,,,,,, 4628480, bytes ,,,,,,,,,,,,,,,,,
[oracle@HE3 ~] vi create_db美元。sql
oracle11g手工建库