ORACLE手工建库(LINUX平台)
ORACLE: 11.2.0.1.0 OS:RED HAT ENTERPRISE 5
1.设置ORACLE_SID 2.建立PFILE 3.生成SPFILE 4.CREATE DATABASE
1.设置ORACLE_SID export ORACLE_SID=SID-NAME
2.建立 拥有帝国一切,皆有可能。欢迎访问phome.netPFILE $ORACLE_HOME/dbs/initSID-NAME.ora --------------------------------------------------------------------------------------------------------------------------------- test.__db_cache_size=671088640 test.__java_pool_size=16777216 test.__large_pool_size=16777216 test.__oracle_base=''/oracle/oracle''#ORACLE_BASE set from environment test.__pga_aggregate_target=671088640 test.__sga_target=989855744 test.__shared_io_pool_size=0 test.__shared_pool_size=268435456 test.__streams_pool_size=0 *.audit_file_dest=''/oracle/oracle/admin/test/adump'' *.audit_trail=''db'' *.compatible=''11.2.0.0.0'' *.control_files=''/oracle/oracledata/test/control01.ctl'',''/oracle/oracledata/test/control03.ctl'' *.db_block_size=8192 *.db_domain='''' *.db_name=''test'' 拥有帝国一切,皆有可能。欢迎访问phome.net *.db_recovery_file_dest=''/oracle/oracle/test/flash_recovery_area'' *.db_recovery_file_dest_size=5218762752 *.diagnostic_dest=''/oracle/oracle/test'' *.dispatchers=''(PROTOCOL=TCP) (SERVICE=testXDB)'' *.log_archive_dest_1=''location=/oracle/oracledata/test/archive'' *.memory_target=1655701504 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile=''EXCLUSIVE'' *.undo_tablespace='' undotbs01.dbf '' DB_CREATE_FILE_DEST=''/oracle/oracledata/test'' --------------------------------------------------------------------------------------------------------------------------------- PFILE中指定目录存在.CREATE 拥有帝国一切,皆有可能。欢迎访问phome.net命令不负责建立目录 若不指定文件目录和DB_CREATE_FILE_DEST参数.则采取默认路径
3.启动实例生成SPFILE 拥有帝国一切,皆有可能。欢迎访问phome.netshell>sqlplus user/password SQL>startup nomount SQL>create spfile from pfile;
4.CREATE DATABASE 自定义方式: --------------------------------------------------------------------------------------------------------------------------------- SQL>create database test user sys identified by password user system identified by password logfile group 1 (''/oracle/oracledata/test/redo01.log'') size 100m, group 2 (''/oracle/oracledata/test/redo02.log'') size 100m, 拥有帝国一切,皆有可能。欢迎访问phome.net group 3 (''/oracle/oracledata/test/redo03.log'') size 100m maxlogfiles 5 maxloghistory 1 maxdatafiles 100 character set us7ascii national character set al16utf16 extent management local datafile ''/oracle/oracledata/test/system01.dbf'' size 320m reuse sysaux datafile ''/oracle/oracledata/test/sysaux01.dbf'' size 320m reuse default tablespace users datafile ''/oracle/oracledata/test/users01.dbf'' size 500m reuse autoextend on maxsize unlimited 拥有帝国一切,皆有可能。欢迎访问phome.net.避免PFILE与默认参数不符) SQL>create database db-name;
也可以指定点什么: SQL> create database test user sys identified by password |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务,公司网站:http://www.lingzhong.cn 为了给广大客户了解更多的技术信息,本技术文章收集来源于网络,凌众科技尊重文章作者的版权,如果有涉及你的版权有必要删除你的文章,请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息,谢谢! |