windows下Oracle11G脚本建用户、表空间、表
@echo offset uname=%1%set pword=%2%echo %uname%echo %pword%echo @echo off>C:\createUser.sqlecho create temporary tablespace user_temp>>C:\createUser.sqlecho tempfile 'C:\app\Administrator\oradata\user_temp.dbf'>>C:\createUser.sqlecho size 50m>>C:\createUser.sqlecho autoextend on>>C:\createU...
windows下Oracle静默安装所需refhost.xml
<?xml version='1.0' encoding='windows-1252'?><!-- Copyright (c) 2004, Oracle. All Rights Reserved. --><!-- ref host for Windows --><HOST PLATID="233"> <SYSTEM> <MEMORY> <PHYSICAL_MEMORY VALUE="256" UNIT="MB"/> <!--AVAILABLE_MEMORY VAL...
windows下Oracle静默安装所需orcl.dbc-----之四
<RedoLogGroupAttributes id="2"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo02.log" file...
windows下Oracle静默安装所需orcl.dbc-----之三
<StorageAttributes> <DataFiles> <Location>{ORACLE_HOME}\assistants\dbca\templates\Seed_Database.dfb</Location> <SourceDBName>seeddata</SourceDBName> <Name id="1" Tablespace="SYS...
windows下Oracle静默安装所需orcl.dbc-----之二
<InitParams> <initParam name="diagnostic_dest" value="{ORACLE_BASE}"/> <initParam name="processes" value="150"/> <initParam name="db_recovery_file_dest_size" value="2048" unit="MB"/> &n...
windows静默安装Oracle11G脚本
@echo offcd c:\md Oracle"C:\Program Files (x86)\WinRAR\winrar.exe" x C:\win64_11gR1_database.zip C:\Oraclecopy /y c:\refhost.xml c:\Oracle\database\stage\prereq\dbecho wait.........echo %date% %time%echo "start setup Oracle..." >>LogInfo.txtcd c:\Oracle\databasesetup.exe -silent -forc...
windows下Oracle静默安装所需orcl.dbc-----之一
<?xml version = '1.0'?><DatabaseTemplate name="orcl" description="" version="11.1.0.0.0"> <CommonAttributes> <option name="ISEARCH" value="true"/> <option name="OMS" value="false"/> <option name="JSERVER" value="true"/>&nb...